====== Import/Commercial/CSV ======

The IG.Creator supports minimal commercial information that is required for the graphical mapping. Such information is:
  * Product Numbers
  * Properties
  * Property Values

Additional, optional information is:
  * Property-to-Product Mapping
  * Value-to-Property Mapping

This information comes typically from an external commercial system or service, and the IG.Creator implements special modules to import from/sync against them, such as the [[ig.creator:import:commercial:xcalibur|XcalibuR Import]]. Sometimes, however, it might be useful to create such data in MS Excel, for instance. This page implements the import of such XLS sheets, where each sheet is exported to a separate CSV file.

Note. This content is also named as **SimpleCom** format in some places in the IG.Creator, or in this Wiki.

===== CSV Files =====

The following files are supported. They can be uploaded separately and asynchronously. The files need a Separator between the columns and may optionally start with a header row.

==== Products ====

//Product;Description;NativeId//

The first column defines a Product by a Key. No spaces, dots, commas, special characters, umlauts, etc. are allowed. The Key _Master defines a pseudo product for inheritance of Property mappings (see [[ig.creator:products:commercial|Products/Commercial]]).

The second column defines an informal description of the Product. Watch out for separator characters!

The third column defines an optional native commercial ID, such as a Guid in the context of [[ig.creator:index#Xcalibur|XcalibuR]].

==== Properties ====

//Property;Description//

The first column defines a Property by a Key. Same syntactical restrictions as described for the Product Key.

The second column defines an informal description of the Property.

==== Property Values ====

//Value;Description//

The first column defines a Property Value by a Key. Same syntactical restrictions as described for the Product Key.

The second column defines an informal description of the Property Value.

==== Product Mapping ====

//Product;Property//

The first column references to a Product, the second to a Property, which makes this Property available for the given Product.

==== Property Mapping ====

//Property;Value//

The first column references to a Property, the second to a Property Value, which makes this Property Value available for the given Property.

===== Options =====

There are a number of options to be set for the CSV upload:

==== Reset Table(s) ====

If set, the corresponding table(s) will be reset before starting the upload. Otherwise the data will be merged.

==== Header Row ====

If selected, the first row will be considered as Header row and thus ignored.

==== Separator ====

This lets you chose the column separator.

==== Quoting ====

This lets you select optional quoting characters, to be removed from the beginning/end of each column content.

==== Encoding ====

Especially if you're descriptions may contain umlauts, it's important to select the corresponding coding.

==== Null Value ====

Optionally, you may setup a Null value. Any field content that is equal to the Null value (if defined), will be ignored and an empty field will be created in the database.