This project is designed to take a list of cues from a spreadsheet (in CSV format) and populate a QLab cue list with them using OSC. QLab from CSV is not associated with Figure 53.
Xcode
for compiling the project.QLab 3
(tested with 3.1.6
).
1) Compile the source code using Xcode and run it. 2) In the "Server" drop-down box, select the machine which you want to connect to. 3) In the "Workspace" drop-down box, select the QLab workspace on that machine. 4) Click "Connect" 5) Select any "Cue List" (not yet functional) 6) In QLab, navigate to the cue list you want to append to (clear any previously generated cues). 7) Click "Browse" and locate the CSV input file (see below, "CSV Syntax") 8) Click "Append"
All cues will then be appended to the cue list.
The CSV file should be UTF-8 encoded and have the following columns (the order doesn't matter):
QLab
- The unique cue number for the cue in QLab. Required.LX
- The cue number to trigger on an Eos desk.Sound
/Video
- The cue number of the cue to start in QLab (starts cue number prefixed by S
or V
respectively).Comment
- Comment to add to the description of the cue.Page
- Page number to add to the description of the cue.There should be a header row with the column names (as above) at the top of the file.
The LX
/Sound
/Video
accepts instructions which conform to the following rules:
1.32a_v2
).1,2
fires 1
and 2
at the same time).1, 2
is identical to 1,2
)./dX
(where X is the number of seconds to pre-wait) to a cue number (e.g., 1/d5
fires 1
after 5 seconds).For example, 1, 2/d3.2
fires 1
immediately then 2
after 3.2 seconds.
As a regular expression:
^(\s[\w.]+(/d[\d.]+)?\s(,\s[\w.]+(/d[\d.]+)?\s)*)?$
An example of a valid file is sample_cues.csv
in this repository.