How can I get the record layout for form PR514? I essentially want the similar report I can get for table layouts...??
(From "Lawson 4GL for Dummies" copyright © 2007 by Olim Fforkust, page UW-43)
CREATING THE LAWSON LOAD FILE
With What Will We Load, Dear Martha, With What?
To obtain the load format for the data file for a load program, look at the definitions for the Work Files. For an example, say we want to find the data load file format for screen PR514, "Employee Deduction Master Load".
First we go to the Work File Definition:
> workdef prod pr pr514
Now we have to look up the work file that is used for uploading data. The cursor will start in the field marked "File Name". Hitting F4 for "Select" brings up the list of workfile names: Dedloadcsv, Dedoutcsv and Errors
It looks like Dedloadcsv is the file that we want. Select it, and voila, the definition pops into view down below!
+ Illustration here +
* TECHY SHORTCUT * Use the transfer utility metadumpwrk:
> metadumpwrk ProductLine ProgramName WorkFileName
This creates the text file PROGRAMNAME_WORKFILENAME.wrk.
For our example PR514 and work file dedloadcsv, the command will be:
> metadumpwrk prod PR514 DEDLOADCSV
and the text file created will be PR514_DEDLOADCSV.wrk.
The output file can be imported into Excel. Expand the "Record Type: Program" section using "Text to Columns". Check off "Delimited" and choose as Delimiters "Comma". Finish it. This gives you a nice quick listing of the fields you have to place into your load file.
* LAWSON WIERDNESS * The type of field is not spelled out. Instead, you have to translate the field type by looking up the value in the "Type" column in this table:
0 - Alpha
1 - Numeric
2 - Signed
5 - Date - yyyymmdd
30 - AlphaLC
etc.
----- end snippet --------------------------------
I hope that this helps a bit.
The support site also has file layouts for all of the available conversions - what I like about them is they also provide an explanation of the field, and also point out which fields are required - a huge time saver! Good luck
The support site also has the file layouts in an Excel format and allow you to create the header that can be used for the conversion.
:whip:
Very cool! Thanks everyone! :thumb: