Import - Multiple Barcodes to Items

Description

Datapel Inventory Controller XE supports a number of Data Exchange interfaces. Using the DataEx interface configuration information can be IMPORTED and EXPORTED from the ICXE database. 

This feature allow Administrators or Consultants to quickly configure the Inventory Management System Workspace with datasets already prepared in Excel or via export from other systems.

Likewise, information already entered or captured by an Inventory Controller workspace can be exported to provide External Systems indirect access to stock tracking datasets.

Import/Export Formats

The format supported is:

• CSV (Comma Separated Varriables)

The following support note describes how a ICXE multiple item barcode file should be formed and how it is imported into the ICXE.

1. Create a folder that will be used to hold Import/Export files.

It is recommended that .csv file be named by their import/export type. (Multipleitembarcodes, Transactions, Items, Suppliers, Customers, Shipping Methods, Custom Lists, Users)

2. Once preparations are complete within Excel save the transaction import file as a csv (Comma Delimited).

3. Within Item List Registry select any item and open the Inventory Detail screen.

4. Within Inventory Detail screen Select More Barcodes...

5. Select Import CSV Barcodes

6. Browse for the .csv file. Once selected Open File.

To check the system details of import the Status Report should be used.

Multiple Barcode HEADERS and FIELDS

Table below Provides an overview of the ITEM headers and a description on each field.

Attached is an example Multiple Barcode Import CSV File.

Related Information

None