Load Default Mapping from File - GLUTRILD
Use this function to add Default Mapping entries to the database in batch format. The utility accepts a comma-delimited file created by the user and loads the information into the default mapping definitions table.
Input files should be created using a spreadsheet application. The spreadsheet column order from left to right must correspond to the following field order:
Column | Field | Required |
|---|---|---|
A | User ID: Enter @@ for all or a specific IFAS User ID | Yes |
B | From GL Ledger Code: Enter a valid GL Ledger Code | Yes |
C | From GL Org Key: Enter one of the following:
| No |
D | From GL Object Code: Enter one of the following:
| No |
E | From JL Ledger Code: Enter a valid JL Ledger Code | Yes |
F | From JL Org Key: Enter one of the following:
| No |
G | From JL Object Code: Enter one of the following:
| No |
H | From Work Order: Leave blank or enter a valid Work Order Number | No |
I | To GL Ledger Code: Enter a valid GL Ledger Code | Yes |
J | To GL Org Key: Enter one of the following:
| No |
K | To GL Object Code: Enter one of the following:
| No |
L | To JL Ledger Code: Enter a valid JL Ledger Code | Yes |
M | To JL Org Key: Enter one of the following:
| No |
N | To JL Object Code: Enter one of the following:
| No |
O | To Work Order: Leave blank or enter a valid Work Order Number | No |
P | Subsystem: Leave blank for all or enter a specific subsystem | No |
Save the spreadsheet file to comma-delimited format (CSV).
Use a simple text editor to verify that the comma-delimited field order matches the spreadsheet order (this is to make sure there were no hidden columns or headers in the spreadsheet before it was saved as a comma-delimited file).
Transfer the file from your PC to the box that BusinessPlus runs on.
If BusinessPlus runs on a MPE box, the file should be transferred with a record length of 420 bytes.
If BusinessPlus runs on a UNIX box, the pad command should be executed after the file has been transferred (pad 420 filename).
When you run the utility, enter the name of the file to load. The file name must be all capital letters, eight characters or fewer, and have no file extensions (for example, ABCDEFG). New default mapping definitions will be added and existing mappings will be updated.
You can use Test mode to validate but not perform database changes. Select Test mode only?
If needed, enter the Number of header lines to skip before file processing begins. This question is optional.
If desired, set a Job Priority, Job Run Schedule Date, and Job Run Schedule Time.
Click Submit.
For Advanced Users: The format of the file to be loaded may be modified. The definition file is DGLDEF and the mapping file is MGLDEF. Refer to File Conversion or Filter - SYUTFC for more information on modifying these files.