The IG.Creator supports minimal commercial information that is required for the graphical mapping. Such information is:
Additional, optional information is:
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.