Dump of file prefix & file names

 4 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Karl Kemp
Basic Member
Posts: 20
Basic Member
    Is there a way to make a dump/report of the 3 letter file prefix's and file names? As an example, I'm talking about dumping info such as:

    Prefix File
    APP APPAYMENT
    PLI POLINE

    etc etc

    Thanks!
    John Henley
    Posts: 3353

      Yup. You can do it using rngdbdump--see this article:
      https://www.lawsonguru.co...ble-Field-Names.aspx

      You can also do it from web browser to dump into a CSV:
      http://<>/cgi-lawson/dme.exe?PROD=GEN&FILE=FILEDEF&FIELD=FILENAME;SYSTEMCODE;PREFIX&SELECT=PRODUCTLINE=DEV802&OUT=EXPORT

      Thanks for using the LawsonGuru.com forums!
      John
      Karl Kemp
      Basic Member
      Posts: 20
      Basic Member
        thanks! I'll give those a shot.
        k-rock
        Veteran Member
        Posts: 142
        Veteran Member
          I used Monarch to pull these out of the documentation from Lawson. Let me know if you would like any specific module.
          Greg Moeller
          Veteran Member
          Posts: 1498
          Veteran Member
            I wrote a script to create a web page containing this information. I'd be happy to share it off-line. We've got it linked under all users Help menu's now, as we do a lot of Crystal, Add-Ins, SQL querying, etc.

            Seems to work rather well.