Importing Blank Fields into the ITEM Database – Problem Article

Summary

This Problem Article explains the issue of importing blank records into BACKTRACK with the BACKTRACK Import tool and explains what to do about it.

Symptoms

After a BACKTRACK Import, blank records appear in the database.  The records are assigned a unique Item No by BACKTRACK but there is no other data.

Explanation

The BACKTRACK import tool sees the carriage return / line feed as an indication of a new record.  This is true even if no data follows it.  The extra line triggered two messages:

  1. ‘Location is a required field for import…’ (since the record was blank, the location field was blank which throws an error)
  2. ‘Asset Number is required for import… ‘ (a blank key field, Item No, requires either BACKTRACK to generate the value or skip)

Solution

Care must be taken on inspecting the import file.  If using a simple text editor, like Notepad, go to the end of the data in the file and erase all carriage returns after the last data record.  The cursor should be blinking immediately after the last character of the last field of the last record.

Also, during the import, you can look for blank fields (typically at the end) of the data shown in the Import Data screen.  The Item_No field and Location_ID field MUST have a value for BACKTRACK to allow an import.

Additional Comments

None.

Updated on September 3, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support