DESCRIPTION
...
Description
The Datapel Inventory Controller Series 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 Format
The format supported is:
- TSV (Tab Separated Variables)
IMPORT HEADERImport Header
- XE import recognises and skips header record.
- All Headers must be kept in a particular sequence (refer to table below and sample attachment file).
...
Detail Steps
The following support note describes how the ICXE files should be formed and how they are imported into the ICXE.
...
4.Select Import Users... and browse for the .txt file. Once selected Open File.
To check the system details of import the Status Report should be used.
USERS HEADERS
Table below Provides an overview of ICXE Users headers and a description on each field.
...
| Field | Type | Max | Required | Notes |
| Co./Last Name | AlphaNumeric | 52 | Y | If the card is a generic company login give generic login title, Otherwise thelast name if an individual employee |
| First Name | AlphaNumeric | 20 | N | Blank if the card record represents a generic company login, Otherwise the first name of the individual employee |
| Username | AlphaNumeric | 16 | Y | User defined name for logging into ICXE |
Related
...
Information
None
| Page Properties | ||
|---|---|---|
| ||
|
...