<< Click to Display Table of Contents >> Navigation:  FILE Tab and Database Actions > FILE Menu > Import & Export Page > Import Load List

File - Import & Export - Import Load List

 

Cube-IQ gives you the option to import a simple comma-delimited file of 'Products to be loaded' In the Main Menu, select Import/ Load(s) from List.

An example Import Load List comma-delimited text file might look like this:

 

Load=qqq

Container=ccc

p1,8,2

p2,9

 

The 'Load=' line is optional. If not present, the Products will be added to the current Load. If present, a new Load called 'qqq' will be created.

 

The 'Container=' line is also optional. If present, the Container called 'ccc' will be added to the list of available Containers. The Container called ccc must exist in the Cube-IQ database.

 

All other lines are Products (p1, p2) with quantities (8, 9). The '2' in the first Products line is a sequence number (again optional).

 

So, in its simplest form you can add a series of (pre-existing) Products to the current Load by importing a Load list text file like this:

 

p1,11

p2,8

p3,44

 

etc.

 

Even though the file is called 'comma delimited', the field values in each line should be separated by the List Separator from the Windows Regional and Language Options ). Such a text file can be created in for example Excel. Enter the data in various columns (one row for each Product), making sure that the List Separator (comma or semi-colon) does not occur in any text values ('Product id' or 'description'). Then save the file as type 'CSV (MS-DOS) (*.csv)', which is the 'comma-delimited' format.