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 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.

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.

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 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 XcalibuR.

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.

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;Property

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

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.

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

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

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

This lets you chose the column separator.

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

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

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.