IntelliTrack Check In/Out - Manual (Page 260)

I NTELLI T RACK C HECK I N -O UT V 8.1
User Manual
230
Comma Delimited File Example
For CommaOnly, the delimited file will look something like this:
12345-1343,45,tape dispenser,8.00,Office Supplies,5,20,7,12345-1344
Quote Comma Quote Delimited File Example
For QuoteCommaQuote, the delimited file will look something like this:
"23345-6789","77","Paper Clips","0.50","Office Sup-
plies","2","10","3","23345-6788"
Semicolon Delimited File Example
For Semicolon Only, the delimited file will look something like this:
990; 5; Stapler;7.50;Office Supplies;5.00;2;10;3;990a
Tab Delimited File Example
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
2283.book Page 230 Thursday, July 7, 2011 2:29 PM