Wiki 1stAnswer Help

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
===== Generic configuration of customer- and configurationItemImport =====

==== Configuration of CSV-PreProcessor ====

In Version 5.5.0.0 the preprocessor has been redesigned. Company- and contact person data are in one single file. Furthermore it is possible to import customAttributes.\\

Sample data: 
  * {{:standardimport:import.txt|import.csv}} CSV-File. 
  * {{:standardimport:template.xml|}} Template-XML, defines the XML-Format-files structure.
\\
Sample configuration: 

<code xml>
<preProcessorSettings encoding="UTF-8" key="default" delimiter=";" sourceDirectory="ConfigurationItemImport\preProcessDir" fileMask="*.csv" templateFilePath="ConfigurationItemImport\format.xml" useHeaders="true" quote="QuotationMark" />
</code>

**encoding:** The Encoding of the csv file. E.g. "Unicode" or "UTF-8" possible. [[Import Encpdings]]\\
**delimiter:** Das separator of the values. \\
**sourceDirectory:** The folder, from which the files are imported. \\
**fileMask:** A filter, to allow just "*.csv" files. \\
**templateFilePath:** A Template-XML-File. \\
**useHeaders:** Defines if column headers are used (in the template file) othewise the culumns are named as following: column1, column2, columnN, ...\\
**quote:** (5.5.17.0+)Defines the signs, that surround the value of a field in CSV file (before and after delimeter) Possible values: 
^quote^Sample^Default value^
|NoQuotationMark|foo;bar;foo;bar oder foo;"ba"r;f"o"o;bar| |
|QuotationMark|"foo";"bar";"foo";"bar"|x|
|SingleQuotationMark|'foo';'bar';'foo';'bar'| | 
==== Field mapping on XML-Import (Customer- and ConfigurationItemImport) ====

All field values can be modified before saving the data on importing an xml-file.

=== Configuration ===

The mapping can be configured via database table "tbImportMapping". The table has the following structure:

^Fieldname^Function^
|importName|The name of the import. e.g. "CustomerImport" or "ConfigurationItemImport"|
|fieldName|The name of the field. (see below)|
|currentValue|The fields current value.|
|nextValue|The fields new value.|

== How to create a correct FieldNames ==

The "fieldName" is structured like the xml document.\\
Exception: The XML-Node "contactperson" is named "CustomerContactPerson".

Examples:
  CustomerContactPerson.attributes.test
  CustomerContactPerson.name
  status
Wiki 1stAnswer Help

User Tools

Site Tools

Page Tools
