Skip to main content

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.

Voorbeeld CSV

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.

warning

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:

CSV file

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.