Skip to main content
Skip table of contents

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:

  • @@

  • N/A..N/A

  • A valid GL Org Key

No

D

From GL Object Code: Enter one of the following:

  • @@

  • N/A..N/A

  • A valid GL Object

No

E

From JL Ledger Code: Enter a valid JL Ledger Code

Yes

F

From JL Org Key: Enter one of the following:

  • @@

  • N/A..N/A

  • A valid JL Org Key

No

G

From JL Object Code: Enter one of the following:

  • @@

  • N/A..N/A

  • A valid JL Object

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:

  • N/A..N/A

  • A valid GL Org Key

No

K

To GL Object Code: Enter one of the following:

  • N/A..N/A

  • A valid GL Object Code

No

L

To JL Ledger Code: Enter a valid JL Ledger Code

Yes

M

To JL Org Key: Enter one of the following:

  • N/A..N/A

  • A valid JL Org Key

No

N

To JL Object Code: Enter one of the following:

  • N/A..N/A

  • A valid JL Object Code

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

  1. Save the spreadsheet file to comma-delimited format (CSV). 

  2. 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). 

  3. 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).

  4. 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.

  5. You can use Test mode to validate but not perform database changes. Select Test mode only?

  6. If needed, enter the Number of header lines to skip before file processing begins. This question is optional.

  7. If desired, set a Job Priority, Job Run Schedule Date, and Job Run Schedule Time.

  8. 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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.