Differences

This shows you the differences between two versions of the page.

--- ig.creator:import:commercial:simplecom [2014/09/14 21:05] – eb_ig
+++ ig.creator:import:commercial:simplecom [2024/04/04 08:04] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+====== 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.