Who's On?

	Membership:
	Latest: Elia Kfouri
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5214

	People Online:
	Visitors: 0
	Members: 0
	Total: 0

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Dump of file prefix & file names

4 Replies

0 Subscribed to this topic

28 Subscribed to this forum

Sort:

Author

Messages

Karl Kemp

Basic Member

Posts: 20

5/10/2007 7:23 PM

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: 3364

New Poster

Engaged Reader

Avid Reader

5/10/2007 7:57 PM

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

Karl Kemp

Basic Member

Posts: 20

5/10/2007 11:48 PM

thanks! I'll give those a shot.

k-rock

Veteran Member

Posts: 142

5/21/2007 4:45 PM

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

MVP

New Poster

Engaged Reader

Avid Reader

10/2/2007 5:48 PM

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.