Import Inventory

Overview

The Import dialog provides the ability to import data stored either in ASCII or CSV format.

Actions

Execute - Executes the current import.

This option is available once the definition section is completed and a data file is selected.

Close - Closes the Import dialog.

Help - Displays the help menu (see Help Menu).

Tool Tips - Hover the mouse cursor over any field descriptor to display a brief description.

Fields

File Type - ASCII or CSV (Comma Separated Values),

Definition - The layout definition to be used when transforming the data.

·For ASCII Files this includes a Start and Length Column for the data fields being imported.

Example of Data File:

....|....1....|....2....|....3....|....4....|....5....|....6....|....7....

051000000118 Campbell's Tomato Soup 01024011.4001001.29

644209410002 Duncan Hines White Cake Mix 01024014.0201001.49

Corresponding Definition:

Column Name Start Length

----------- ----- ------

PLU Number 1 14

Long Description 15 30

Short Description

Item Number

Department Number 45 2

Pack Size 47 3

Case Cost 50 6

Mp 56 2

Price 58 6

·For CSV Files the definition requires only an ordinal for the data to import.

Example of Data File:

051000000118,Campbell's Tomato Soup,01,024,011.40,01,001.29

644209410002,Duncan Hines White Cake Mix,01,024,014.02,01,001.49

Corresponding Definition:

Column Name Ordinal

----------- -------

PLU Number 1

Long Description 2

Short Description

Item Number

Department Number 3

Pack Size 4

Case Cost 5

Mp 6

Price 7

Data File - Selects the appropriate data file to import data from.

Preview - Allows previewing the imported data before committing to file. Click the button below Preview to view.