23.1 Definition of the file format
The format of the .csv files that are used to import and export files from Kaleido is shown in a table for simplicity. If you are creating the file in a spreadsheet program such as Excel, then it will have this appearance. Save it using the type "CSV (comma delimited)"
NOTE: only COMMA [ , ] or SEMICOLON [ ; ] are accepted by Kaleido as delimiters in a CSV file. Kaleido cannot interpret CSV files using other delimiters such as period [ . [, slash [ / ] or backslash [ \ ]. Be sure the program that generates the CSV file uses one of the acceptable delimiters.
Note that a line starting with a blank cell is interpreted as a COMMENT line, and will be ignored.
The table contains 9 columns. The contents of columns 1 to 4 are strictly defined:
Column 1: data type
Column 2: the name of the channel
Column 3: the type of address that will be defined in this row
Column 4: the Link Order of the address defined in this row
Columns 5 to 9 contain the details of the address of this component within the channel. The contents vary with type (as given in column 3), as outlined in the following description.
- Video - column 5: the Input Number (including the system name if needed).
- Audio - column 5: EMBEDDED, AUDIOCARD or STREAMING
In case of EMBEDDED, we have:
- column 6: the video input (from 1 to 32).
- column 7: the group index (from 1 to 4)
- column 8: The AES (1 or 2)
- column 9: one of STEREO, LEFT or RIGHT
In case of AUDIOCARD, we have:- column 6: the audio input.
- column 7: one of STEREO, LEFT or RIGHT
In case of STREAMING, we have:- column 6: the IP Address
- column 7: the Feed Id
- column 8: the Usage - either MONITORING or METERING
- column 9: one of STEREO, LEFT or RIGHT
- Text - column 5: Static or Dynamic
In case of Static, we have:- Alarm - column 5: the name of the alarm.
- Tally - column 5: the name of the tally alarm.
- Timecode - column 5: the Video Input (between 1 and 32)
- VBI - column 5: the Service ID (or its alias)
The actual csv file corresponding to the above table will have the following appearance. Note that all data entries must be present on a line, so each table cell that is blank must be represented by a delimiter (comma or semicolon) in the .csv formatted file. In this example the fields are separated using semi-colons, but using commas is equally valid. No other delimiters are accepted.
Note:
- The content of the file is not case sensitive. - Any line containing an error will be ignored, but the file won't be ignored.
Americas
Technical Support
Telephone (9:00-17:00 EST)
+1-800-224-7882
Fax: +1-514-335-1614
|
Asia
Technical Support
Telephone (9:00-17:00 JST)
+81-3-5730-2987
Fax: +81-3-5730-2973
|
Europe,Middle East, Africa, UK
Technical Support
Telephone(9:00-18:00 GMT)
+44 (0) 1491 820222
24 Hour Reply +44 (0) 8700 660295 Fax: +44 (0) 1491 820002 |
France
Technical Support
+33 1 55 86 87 88
Fax: +33 1 55 86 00 29 |