Code Block | ||
---|---|---|
| ||
Introduction
Import Export Schemes are designed to replace the fixed import / export file structure in the jtel system.
They work on CSV style files which are separated by a fixed character (usually but not always semicolon). Import export schemes require CSV files with a header line to work correctly.
The import / export schemes mechanism provides a flexible way to specify:
...
An XML example definition is provided below, together with an example file, to illustrate the XML definition.
Code Block | ||
---|---|---|
| ||
<importExport2>
<import>
<type>CSV</type>
<encoding>UTF-8</encoding>
<delimiter>;</delimiter>
</import>
<export>
<type>CSV</type>
<encoding>UTF-8</encoding>
<bom>1</bom>
<delimiter>;</delimiter>
</export>
<fieldMappings>
<fieldMapping internalField="RandomSortOrder" externalField="Priority" externalType="INTEGER" importOnly="true"/>
<fieldMapping internalField="ReferenceNumber" externalField="RefNumber" externalType="VARCHAR"/>
<fieldMapping internalField="ExternalSystemLink" externalField="Hyperlink" externalType="VARCHAR"/>
<fieldMapping internalField="" externalField="EKCODE" externalType="VARCHAR"/>
<fieldMapping internalField="Salutation" externalField="Sal" externalType="VARCHAR"/>
<fieldMapping internalField="Name" externalField="Name" externalType="VARCHAR"/>
<fieldMapping internalField="FirstName" externalField="First" externalType="VARCHAR"/>
<fieldMapping internalField="Address" externalField="Addr" externalType="VARCHAR"/>
<fieldMapping internalField="Country" externalField="Country" externalType="VARCHAR"/>
<fieldMapping internalField="PostalCode" externalField="PostCode" externalType="VARCHAR"/>
<fieldMapping internalField="City" externalField="City" externalType="VARCHAR"/>
<fieldMapping internalField="PhoneNumber1" externalField="Tel1" externalType="TEL:49"/>
<fieldMapping internalField="PhoneNumber2" externalField="Tel2" externalType="TEL:49"/>
<fieldMapping internalField="Email" externalField="Mail" externalType="VARCHAR"/>
<fieldMapping internalField="Tag" externalField="DataIdentifier" externalType="VARCHAR"/>
<fieldMapping internalField="UserData" externalField="CustomerNumber" externalType="VARCHAR"/>
<fieldMapping internalField="dtBeginDate" externalField="StartDate" externalType="DATETIME:dd.MM.yyyy"/>
<fieldMapping internalField="dtEndDate" externalField="EndDate" externalType="DATETIME:yyyyMMdd"/>
<fieldMapping internalField="Client" externalField="ClientName" externalType="VARCHAR"/>
<fieldMapping internalField="" externalField="NotImported1" externalType="VARCHAR"/>
<fieldMapping internalField="" externalField="NotImported2" externalType="VARCHAR"/>
<fieldMapping internalField="" externalField="NotImported2" externalType="VARCHAR"/>
</fieldMappings>
</importExport2>
|