Import file type examples – IntelliTrack Stockroom Inventory User Manual
Page 168
I
NTELLI
T
RACK
S
TOCKROOM
V
7.0
User Manual
140
imported, a quantity of one (1) is assumed. The fields should meet the fol-
lowing requirements:
Import File Type Examples
When you import files into IntelliTrack via the standard import function,
make sure that the file consistently follows the selected format. It is a good
idea to test your file format with a small file containing one or two lines
before importing a large amount of data; that way if you have any issues
with the file format, you can identify them and fix them. The sections that
follow discuss the four delimited file types (comma delimited only, quote
comma quote delimited, semicolon delimited only, tab delimited only)
supported in a standard IntelliTrack import.
Note: Field headings are not required for delimited files. IntelliTrack
Stockroom assumes the order of the fields is: ITEM#, QTY, DESC, as
defined in the Import Specifications table above. If the fields are not in
TABLE 7.
Import and Export Fields
Field
Order
Field Name
Required
Data
Type
Field
Size
Description
1
ITEM#
Yes
Text
25
Item Number
2
QTY
No
Currency
8
Quantity on
Hand
(Total all sites)
3
DESC
No
Text
32
Description
4
UNIT COST
No
Currency
8
Cost Per Unit
5
CATE-
GORY
No
Text
15
Category
6
MINIMUM
QTY
No
Currency
8
Minimum
Quantity on
Hand
7
MAXIMUM
QTY
No
Currency
8
Maximum
Quantity on
Hand
8
REORDER
QTY
No
Currency
8
Reorder Quan-
tity
9
ALT_NO
No
Text
25
Alternate Part
Number
2289.book Page 140 Thursday, July 9, 2009 2:35 PM