Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 recognizes and skips header record. 
  • All Headers must be kept in a particular sequence (refer to table below and sample attachment file). 

 DETAIL CUSTOMERS IMPORT STEPS

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 Customers... and browse for the .txt file. Once selected Open File.
importcustomers.jpgImage Removed 
Image Added

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


CUSTOMERS HEADERS and FIELDS

Table below Provides an overview of ICXE Customers headers and a description on each field.

...

It is recommended that the all customer imports be done in groups of 5,000 items or less.
Larger lists should be broken into lists of 5,000 items or less.. 

import customers
Filter by label (Content by label)
showLabelsfalse
max5
spacesICXE
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("import","customers") and type = "page" and space = "ICXE"
labels
View file
nameCUSTOMERSLIST.TXT
height250

Related Information

None


Page Properties
hiddentrue


Related issues 


...