1. IWD Support
  2. Content management
  3. Data imports

Import & Export of market.csv

Rules on markets

Import

Export

Data dictionary

 

Just like in real life, guidelines, items, and users are linked to one or multiple specific market(s) on the IWD Platform. Markets can be managed manually, but thanks to the IMPORT & EXPORT features, it is also possible to create/update markets on the platform in bulk, allowing you to save a lot of time! 

Rules on markets

Linking guidelines, items, and users to markets

Several rules must be followed to link guidelines, items, and users to markets:

  • A user must be linked to at least one market. This will consequently restrict their access to the content linked to their markets everywhere in the application.
  • Items and guidelines must also be linked to at least one market.

Creating new markets

When a new market is created, it is automatically linked to all:

  • Campaigns
  • Items
  • Users who have the right to be automatically linked to new markets

Note that individual markets can be grouped into groups of markets e.g. in “Europe/France”, “Europe” is a group of markets, and “France” is a market.

Good to know: It is highly recommended to avoid using identical names for both the market group and the markets included in it.

Import

DATA IMPORT PROCESS

Please refer to this article for the step-by-step import process, including how to download the template and how to set up your *.csv file. It is essential to follow this process for the import to be successful.

RULES FOR IMPORT:

  • We recommend you name this file with a prefix and a suffix e.g. xxx-market-2023-02.csv
  • The first line contains the names of the columns, please refer to the Data dictionary below to help you fill in the information. Make sure to fill in the mandatory fields for the import to be successful. 
  • The following characters are not authorized in the import: [:] and [EOL ↵]
  • You can import using commas or semicolons as separators but you can't use both in the same file.
  • ⚠️ Important: The file imported must be in valid UTF-8 format for the import to be successful.

Export

On the EXPORT modal, the user can export a market.csv file containing all the markets and groups of markets. The first line of the file contains the name of the columns, as described in the Data dictionary below.

Data dictionary

uuid UUID of the market. Has to be extracted from the platform.
      • If filled, its content must be a valid existing UUID and it’s an update.
      • If empty, it’s a creation.
Optional
name

Name of the market.

      • Its content must be between 1 and 64 characters.
      • Multiple markets can have the same name but not in the same group of markets. 

It is case and accent insensitive: if a market is named “Loe”, another one can't be named “LoE” or “Loé” for example.
Mandatory
group Name of the group of markets.
Its content must be between 1 and 64 characters.
Mandatory

 

Articles in this section