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 Send Private Message
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
Send Private Message
Posts: 3351

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 Send Private Message
Posts: 20
Basic Member
thanks! I'll give those a shot.
k-rock
Veteran Member Send Private Message
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 Send Private Message
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.