Feature Request: Export Patchlist

Request a feature that you would like to see in QLC+.
Explain in details why you would need it and which is your usage case.
Post Reply
EvilMonkey
Posts: 1
Joined: Fri Jul 19, 2024 8:10 am
Real Name: Leon Patett

Hey,
It would be nice, to be able to export the patchlist into a .csv for example.
On the one hand-side it would be helpful, while installing a setup with a bigger group of people, so you can hand someone a patchlist on a piece of paper.
On the other hand-side, it could be useful for event planning or event prepairing, because you could print out labels for each device, so you could just look on a device and exactly know, which adress it has to be.
User avatar
edogawa
Posts: 631
Joined: Thu May 07, 2015 10:34 am
Real Name: Edgar Aichinger

Here's a simple python script to generate such a CSV - I've zipped it as I don't seem to be allowed to attach.py files ...

I've adapted a simple tutorial snippet I found on the net here https://www.pythonpool.com/python-xml-to-csv/.

just change "sample.qxw" to your actual filename and run "python3 qxw2csv.py".

EDIT: forgot an important detail: also change line 3 to simply <Workspace> - defining the namespace breaks the conversion for some reason I haven't investigated :/

This will result in a file "PatchData.csv", with header line, and universe/address counts increased by 1 (to start at 1)

Import this to e.g. Calc and edit it further to your liking...
Attachments
qxw2csv.zip
(571 Bytes) Downloaded 79 times
User avatar
sbenejam
Posts: 608
Joined: Sun Apr 12, 2015 6:28 pm
Real Name: Santiago Benejam Torres
Contact:

I made some modifications to get this script work.
qxw2csv_modified.zip
(674 Bytes) Downloaded 81 times
A few months ago I made a similar script to create a .txt file with the Fixtures, Channels list, etc.
FixtureList.zip
(819 Bytes) Downloaded 66 times
User avatar
edogawa
Posts: 631
Joined: Thu May 07, 2015 10:34 am
Real Name: Edgar Aichinger

Thank you Santiago!
User avatar
sbenejam
Posts: 608
Joined: Sun Apr 12, 2015 6:28 pm
Real Name: Santiago Benejam Torres
Contact:

I modified my script to save the data as CSV. Now you can put the script in any folder. Execute the script with the filename with path as a parameter. The script saves the CSV file in the same path as the original workspace file.

Code: Select all

FixtureListCsv.py PathToWorkspace/Workspace.qxw
FixtureListCsv.zip
(936 Bytes) Downloaded 65 times
Post Reply