Skip to main content
Skip table of contents

Convert to Object Groups - GLUTRIRLOG

The Key/Objects Rollover utilities take a comma-delimited file to creates a new, separate file that can be loaded into BusinessPlus. The GLUTRIRLOG utility creates a new file with the converted Object Groups in it. The file will be in GLO-GRP-MSTR-REC format.

Name of the file to be converted: Most input files come from a spreadsheet. The spreadsheet column order from left to right must correspond to the field order defined in the Rollover Conversion and Interface Planner from top to bottom. In other words, if the KY menu option is being used, the left-most column on the spreadsheet should only have the value to be moved into the GL-GR field in the data set GLK-KEY-MSTR. The next column to the right should only have the value to be moved into the GLK-KEY field, column three will be moved into GLK-GRP-PART 1, column four to GLKGRP- PART 2, etc.

The other menu options work in the same fashion. Save the spreadsheet file to comma-delimited format, and 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 in the spreadsheet before it was saved as a comma delimited file). For each menu option, the input file must have fixed length records of length 420 bytes.

Filter out duplicates? If you answer Y to the question Filter out duplicates?, a file containing duplicates is generated only during Insert mode. It is named DUPLICTS and is put in the DATA directory. One original record will be in the output file you specify, but any successive records that have the same values in the key fields as the original record will be written to the DUPLICTS file.
Each record for data set must be unique by these fields (concatenated):
GLK-KEY-MSTR (Org Keys) GL-GR, GLK-KEY
GLK-GRP-MSTR (Key Parts) GL-GR, GLK-GRP-ID, GLK-GRP
GLO-OBJ-MSTR (Object Codes) GL-GR, GLO-OBJ
GLO-GRP-MSTR (Object Groups) GL-GR, GLO-GRP-ID, GLO-GRP

JavaScript errors detected

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

If this problem persists, please contact our support.