CSV import
Importing a .CSV
Innobrix also supports reading option list data from external systems using the
Comma- Separated Values (.CSV)
file format.
This is a commonly used comma-separated file, where instead of a comma, it is also allowed to use
another separator, such as a semicolon.
Go to the Downloads-page to download an example of a valid CSV file.
How to import a .CSV file?
You can import the CSV option list by going to the Configurable-Editor
and in the Content Browser
choose
Option Lists
. Then click on Actions
and choose Option list from CSV
. Navigate to the location of your CSV
file
on your device and select the file. Finally, choose Open
. The option list has now been imported into Innobrix Studio and
can now be applied to a corresponding model by dragging the file into the 3D environment of your model.
Note that if an option list is already associated with the model, it will be overwritten during linking.
What does the file format of the .CSV file look like?
Innobrix requires the following columns:
The column names are in English and must exactly match for a successful import (i.e. including the '_____').
The column price_with_taxes
is used to populate the 'Price' field of an option in Innobrix.
Check here whether your CSV file would be accepted by Innobrix!
You can upload your own CSV file here to check if it is valid. Should errors occur in the file, the incorrect lines will be displayed. (If everything is OK, you will also see this)
Updating a (CSV) option list
Updating an option list can be done by right-clicking in the Configurable-Editor
under Scene on
clicking on Option List Name-
(under Configurable) and choosing Update via CSV
.
The columns category_code
, header_code
and option_code
are very important when updating because they are used for
matching between what is in Innobrix and what is read in from the CSV
.
If an option in the Innobrix option list no longer exists as a buyers` choice in the CSV file, then the option in the Innobrix option list will not be deleted.
If the data of an option has been modified in Innobrix, for example the price, this price will be overwritten if the data is updated with the latest data in the CSV file.