Product: ImportOmatic

Description: Occurs when selecting to automatically add table entries during import processing

Environment: All

Version: All


Answer:


We do not recommend using the automatic table entry functionality for adding School Names/IDs to RE. We do not recommend this because RE Functionality will use the first six characters of the long description school name/ID to create the short description for the School Name/ID.

The example listed below will illustrate how the long description may appear and how the short description will be added to RE.

Long Description: College of Charleston
Short Description: COLLEG

If, later in the file you have another occurrence of a School Name/ID that begins with College, like the following:

Long Description: College of DuPage
Short Description: COLLEG

The value for the School Name/ID for College of DuPage will not be added because the short description will not be unique, as it was already utilized when College of Charleston was added in a previous row from the data file during the import. The same is true for any school that begins with 'University' or any similarly named schools as far as the first six characters of the name are concerned.

We do recommend adding School Name/ID values manually, prior to importing.