The CSV import lets you create or update many displays at once. In a single file, you can set each display's name, serial number, regional settings, location and profile, and place it in its screen groups. Access rights can be set for the whole file.
Prepare your file
Start from the provided template, or use your own file. Only the Name column is required. Use the header names below to have the columns mapped automatically.
Name (required): display name.
Serial number: serial number found on the player. If the player is new, the display is associated with it. If a display of your space already uses this serial number, that display is updated (see Update existing displays).
Timezone: time zone of the display, for example Europe/Paris.
Clock format:
12hor24h.Unit system:
metricorimperial.Language: display language, as a two-letter code, for example
en.Profile ID: the ID or the name of a display profile.
Screen group IDs or Screen group names: the screen groups of the display, separated by
;Latitude and Longitude: location of the display, for example
48.8566and2.3522.
ā¹ļø The file must be a .csv file of up to 5 MB and 2,000 rows. Larger imports can be split into several files.
Import your displays
Go to Displays.
Click Import from a CSV.
Click Choose File or drag and drop your file, then check the CSV reading options (separator, first row, headers).
Check that each display attribute is mapped to the right column of your file. Set an attribute to Ignore to leave it out of the import.
If needed, open the Advanced tab to apply settings to every display of the file:
Profile: the profile of displays that have no profile in the file. A profile set in the file always takes precedence.
Screen groups: groups added to every imported display (see Place displays in screen groups).
Access rights: who can access the imported displays. If you leave it empty, new displays get the default access rights of your space and existing displays keep theirs.
Preview the data to confirm it is correct.
Click Import as displays. If the import changes screen groups or existing displays, a confirmation window opens first (see below).
Once the import is done, a message shows how many displays were created and updated, and the displays appear in the Displays list.
Update existing displays
A row whose serial number matches a display of your space updates that display instead of creating a new one. Before importing, the Warning - Display update window tells you how many displays will be updated and created. Click Apply to confirm.
Only the mapped columns that have a value are updated. An empty cell keeps the current value of the display.
Access rights selected in the Advanced tab replace the current access rights of the existing displays.
Each update is recorded in the history of the display.
š” Tip: to update many displays at once (for example to change their time zone or profile), import a file with only their Name, Serial number and the columns to change.
Place displays in screen groups
You can place the imported displays in their screen groups during the import, in two ways that can be combined:
Per row: add a Screen group IDs or Screen group names column. To place a display in several groups, separate them with
;in the same cell (up to 20 groups per cell).For the whole file: select groups in the Screen groups section of the Advanced tab. They are added to the groups of each row.
ā ļø Groups are replaced, not added. When a group column is mapped or groups are selected in the Advanced tab, each imported display belongs to exactly these groups. An existing display is removed from its other groups, and stops playing the playlists of those groups. An empty cell removes the display from all its groups. To add a display to a group without removing it from the others, enter its current groups and the new one in the cell.
Example
Name,Serial number,Screen group IDs
Paris Reception,ABC123,12;45
Lyon Cafeteria,DEF456,45
Lille Break Room,GHI789,
Paris Reception will belong to groups 12 and 45, Lyon Cafeteria to group 45 only, and Lille Break Room will be removed from all its groups.
Good to know
Group IDs are the most reliable. The ID of a group is in the URL of its page: in
ā¦/display-groups/45, the ID is 45. Group names are not case-sensitive, but a name shared by several groups is rejected.Review the summary. Before the import, the Warning - Screen groups replaced window shows how many displays will gain a group, lose one, or stay unchanged. Click Apply to confirm, or close the window to go back without importing.
Groups must already exist. The import does not create groups.
Groups you cannot access are kept. Only the groups you can manage are added or removed.
Displays refresh automatically and play the playlists of their new groups. Each change appears in the history of the display and of the group.
An import without a group column or selected group leaves groups untouched.
ā¹ļø Permission required: the group columns and the Screen groups section are only visible to users whose role includes Can manage screen groups. Without Can manage screen groups among all groups, you can only use the groups you have access to.
If the import fails
The whole file is checked before anything is imported. If it contains errors, nothing is imported and every error is listed with its row number. Fix your file and import it again. The most common errors are:
The display name is required: a row has no name.
Validation failed: a value has the wrong format (time zone, clock format, unit system, language, latitude or longitude).
The serial number is already used on rowā¦: the same serial number appears twice in the file.
The serial number is already used by a display in another space: this player is already associated elsewhere.
The profile does not exist: check the profile ID or name.
The group does not exist / No group is namedā¦ / Several groups are namedā¦: check the group IDs or names, and use IDs when names are shared.
You are not allowed to update the display / to change the groups of the display: you do not have the rights needed on an existing display.
The import would exceed the display limit of your space: the new displays with a serial number exceed your license. Contact your account manager to increase it.
If some rows fail while they are being saved, the other rows are imported. The failed rows are shown again with a summary (new, updated, errors) so you can import them again.
FAQ
Can I import displays without a serial number?
Yes. The display is created without a player. You can associate it later: see How to associate a new display.
How do I add existing displays to a new group without removing them from their current groups?
Enter the IDs of their current groups and the ID of the new group in the cell, separated by ;. For a few displays, you can also add them from the group page: see Add a display to a screen group.
Can I use profiles or groups from another space?
No. Only the profiles and groups of the space you are importing into are recognized.