Importing inventory data – IntelliTrack Inventory Shipping Receiving Picking (ISRP) User Manual
Page 203
Chapter 10
Import and Export Utility
175
Filter Inventory dialog example above. You are able to specify the fol-
lowing data:
•
Site: To filter Inventory by a specific site, click the drop-down arrow
in this field and select a Site from the list that appears.
•
Location: Becomes enabled if you choose a Site for filtering. To fil-
ter inventory by a specific site location, click the drop-down arrow
in this field and select a location from the list that appears.
•
Item: To filter inventory by a specific item, click the drop-down
arrow and select an item from the list that appears.
Click the Apply button to apply the filter settings to the Inventory
Export Interface template and close the Filter Inventory dialog.
Click the Clear button to clear the filter settings in the Filter Inventory
dialog.
Click the Save button to apply the filter settings to the Inventory Export
Interface template and close the Filter Inventory dialog.
Click the Cancel button to cancel the filter settings you have chosen
and close the Filter Inventory dialog (the system will revert back to the
filtering from your previous session).
4.
Select the ellipsis (...) button in the Export filename field. The Open
window appears. Navigate to the export file location to enter it in the
Export filename field. Or, manually enter the export file name and
location in the Export filename field. (By default the file will be
exported to your Program Files\IntelliTrack\ISRP\Utility\Export
folder.) The exported file is a text file.
5.
Next, select the file type by clicking the Fixed Width or Tab Delim-
ited radio button.
If Fixed Width is selected, you must enter a character Length entry for
each selected field in the Length field of the template grid.
6.
Enter the position of each field that is to be included. Enter a zero (0) to
exclude a field. Verify the order by clicking on the Position column
heading. Sites, UOM, Serial Number and Expiration Date selections
are available based on application option settings.
7.
Select the Do It button to export the inventory data. If the export is
unsuccessful, the Error log displays.
8.
Select the View/Preview button to display the exported file.
Importing
Inventory Data
To add inventory data from an external file to the IntelliTrack ISRP data-
base:
1.
Click the drop-down arrow in the Interface field and select Inventory
Import from the list that appears: