Description

Datapel WMS supports several Data Exchange interfaces. For example, using the DataEx interface configuration information can be IMPORTED and EXPORTED from the WMS database. This feature allows 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 entered or captured by a WMS workspace can be exported to provide External Systems indirect access to stock tracking datasets.

Detail Steps

Import/Export Formats

The format supported is:

  • CSV (Comma Separated Variables)

 

The following support note describes how WMS multiple item barcode files should be formed and imported into the WMS.

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

It is recommended that their import/export type name .csv file. (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...

6. Clear Article code box.

7. Select Search.

8. Select export.

9. Save to preferred Location.

10. Open Microsoft Excel.

11. Import data from a Text file.

12. Select options, delimited, comma, columns all as text format.

13. Update excel file as required.

14. Save as CSV.

15. Backup WMS

16. Go to the Item list.

17. Double click item.

18. Select more barcodes on the bottom right. 

19. Select Import CSV Barcodes

20. 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

The table below provides an overview of the ITEM headers and a description of each field.

Attached is an example Multiple Barcode Import CSV File.

Field

Type

Max

Required

Notes

Item Number

AlphaNumeric

30

Y

Item Number of Item. Used to ID item product.

Barcode

Numeric

30

Y

Additional Barcode Number for item.

Scan Unit Quantity

Numeric

10

Y

Scan Unit Quantity of Measure for the additional barcode. One is default.

Comment

AlphaNumeric

30

N

Description of Additional Barcode


Related Information

Barcodes and Labels