CSV to QLAB

To run on mac:

• download csv_to_qlab.dmg from the latest release
• unzip the foder
• open the app
  • qlab must be open on the recieving computer in order for the messages to be recieved.

Please note that I do not currently have an Apple Developer Certificate and therefore there will be some scary warnings when trying to run this application locally. It is entirely up to you to decide to run this application. If you have concerns with the bundled application releases, I suggest cloning or forking the repository.

How to format your csv file:

Some columns are required, some are optional.

Required columns

• Number
• Type
• Name

Number	Type	Name
12	start	Cue 12 GO

Optional Columns

• Notes
• Follow
• 0 - No Follow
• 1 - Auto-Continue
• 2 - Auto-Follow
• Color (Options)
• Target
• File Target
• Columns available for "midi" cue type:
• MIDI Q Number
• MIDI Device ID
• MIDI Message Type
• 1 - MIDI Voice Message ("Musical MIDI")
• 2 - MIDI Show Control Message (MSC)
• 3 - MIDI SysEx Message
• MIDI Control Number
• MIDI Control Value
• MIDI Patch Channel
• MIDI Patch Number
• MIDI Q List
• MIDI Command Format (Options)
• MIDI Command (Options)
• Columns available for "network" cue type:
• QLab 5
• Network Patch Number
• Network Patch Channel
• Custom String
• QLab 4
• Message Type (Options)
• OSC Cue Number (Only if using QLab Message Type)
• Command
  • For QLab Messages (Options)
  • For an OSC message, you may now include a raw string in this column

Examples

• Full Example Spreadsheet

• Simple Example Spreadsheet

To run in development:

• clone or fork repository
• create virtual environment
• Install dependencies:

python3 -m pip install --upgrade pip
python3 -m pip install -r requirements.txt

• Run:

python3 application.py

• The application was bundled for distribution using pyinstaller. To re-bundle, install pyinstaller:

python3 -m pip install pyinstaller

• Then run:

pyinstaller application.spec

If you want to run some tests:

• Install Pytest

pip install pytest

• Run Pytest

pytest

Recomendations for future features are very welcome!