IntelliTrack Inventory Management - Manual (Page 154)

I NTELLI T RACK I NVENTORY V 8.1
User Manual
128
990;5;Stapler;7.50;Office Supplies;5.00;2;10;3;990a
Tab Delimited File Example
For Tab delimited, the delimited file will look something like this:
901 5 Copy Paper 1.50 Office Supplies 1.00 10 13 20
901a
Import File
Structure
Integrity When not importing data to all of the import fields, please be aware of the
file structure requirements. The examples below are for a comma delimited
file.
1. When importing data to sequential fields beginning with Item#
(required field), the comma delimited file looks like the following:
12345-1343,32,TAPE DISPENSER
4314313-3AB,,PENCILS
AB3135332423,6,PAPER CLIPS
• No comma is required in the unused fields occurring after the first
three fields.
2. When importing data to non-sequential fields, such as Item# (required
field), Category, and Minimum Qty, the comma delimited file looks
like:
12345-1343,,,,HGR-9877,4
4314313-3AB,,,,BT-876,7
AB3135332423,,,,TA-987,2
3. Place a comma separator in the fields where there is no data to maintain
the integrity of the import file data structure.
Importing the Data from Another System
Import existing item information into the application with a delimited text
file.
2287.book Page 128 Thursday, July 7, 2011 4:45 PM