User's that do not have permission to create channels will not be able to see or access the import section. |
Centrix allows channels to be exported to and imported from a CSV format file.
The export file is compatible with the import functionality, allowing channels to be copied between sites in bulk by exporting from one site and importing into another.
In Centrix, the Channels list displays all channels across multiple sites, the Import/Export button is in the controls for the list.
Import / Export requires that a site to be selected. |
Example
Exporting visible channels with the list filters set as above, all analogue channels excluding internal and archived will be exported.
Importing channels with names that match existing channels will result in the existing channels being overwritten. |
The imported file must contain the header row Name, Type, Units, Virtual Channel Expression, available in the downloadable CSV Template file.
The columns Name and Type must not be blank.
When an invalid CSV is uploaded an error message will pop up with information about what the error was and which line of the file it was caused by.
The following cases will cause the import to fail:
Example
The above message is the response for an invalid virtual channel expression. The message displays the virtual channel expression with any errors highlighted red, the exact error in the virtual channel and the line number of the csv file that the virtual channel expression is on.
Historically, some of our channels have a '+' character at the start. e.g. "+NoCommsTX".
If viewing a csv file in Excel, Excel converts names like this and adds an '=' character at the start e.g. "=+NoCommsTX".
This still confuses excel and so it then displays this as "#NAME?".
Similarly if you try to import a channel with a name like this in excel, the imported channel name will come through as "#NAME?".