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.

 

Line that

Starts with

A blank

Cell is a comment

Line, and so

Will be

ignored

 
 

The

Following

Lines

Describe the

Channel

definition

   
 

Channel

Type

Link Order

Address fields

       

Channel

Input 01

Video

1

A1

       

Channel

Input 01

Audio

1

EMBEDDED

1

1

1

Stereo

Channel

Input 01

Audio

2

EMBEDDED

1

1

2

Stereo

Channel

Input 01

Audio

3

EMBEDDED

1

2

1

Stereo

Channel

Input 01

Audio

4

EMBEDDED

1

2

2

Stereo

Channel

Input 01

Audio

5

EMBEDDED

1

3

1

Stereo

Channel

Input 01

Audio

6

EMBEDDED

1

3

2

Stereo

Channel

Input 01

Audio

7

EMBEDDED

1

4

1

Stereo

Channel

Input 01

Audio

8

EMBEDDED

1

4

2

Stereo

Channel

Input 01

Audio

9

AUDIOCARD

15

Stereo

   

Channel

Input 01

Audio

10

STREAMING

10.6.7.8

c1

Monitoring

Stereo

Channel

Input 01

Text

1

Static

VTR Room 1

     

Channel

Input 01

Text

2

Dynamic

TSL

1

1

 

Channel

Input 01

Alarm

1

Freeze - Video 01

       

Channel

Input 01

Tally

1

GPI_01

       

Channel

Input 01

Timecode

1

1

       

Channel

Input 01

VBI

1

A

1

     

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.

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.

;Line that;Starts with;A blank;Cell is a comment;Line, and so;Will be;ignored;
;The;Following;Lines;Describe the;Channel;definition;;
;Channel;Type;Link Order;Address fields;;;;
Channel;Input 01;Video;1;A1;;;;
Channel;Input 01;Audio;1;EMBEDDED;1;1;1;Stereo
Channel;Input 01;Audio;2;EMBEDDED;1;1;2;Stereo
Channel;Input 01;Audio;3;EMBEDDED;1;2;1;Stereo
Channel;Input 01;Audio;4;EMBEDDED;1;2;2;Stereo
Channel;Input 01;Audio;5;EMBEDDED;1;3;1;Stereo
Channel;Input 01;Audio;6;EMBEDDED;1;3;2;Stereo
Channel;Input 01;Audio;7;EMBEDDED;1;4;1;Stereo
Channel;Input 01;Audio;8;EMBEDDED;1;4;2;Stereo
Channel;Input 01;Audio;9;AUDIOCARD;15;Stereo;;
Channel;Input 01;Audio;10;STREAMING;10.6.7.8;c1;Monitoring;Stereo
Channel;Input 01;Text;1;Static;VTR Room 1;;;
Channel;Input 01;Text;2;Dynamic;TSL;1;1;
Channel;Input 01;Alarm;1;Freeze - Video 01;;;;
Channel;Input 01;Tally;1;GPI_01;;;;
Channel;Input 01;Timecode;1;1;;;;
Channel;Input 01;VBI;1;A;1;;;

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
    techsupp@miranda.com
    Asia

    Technical Support
    Telephone (9:00-17:00 JST)

    +81-3-5730-2987
    Fax: +81-3-5730-2973
    asiatech@miranda.com
    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
    eurotech@miranda.com
    France


    Technical Support

    +33 1 55 86 87 88
    Fax: +33 1 55 86 00 29
    eurotech@miranda.com