Page 1 of 1
Feature Request: Export Patchlist
Posted: Fri Jul 19, 2024 8:18 am
by EvilMonkey
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.
Re: Feature Request: Export Patchlist
Posted: Sat Jul 20, 2024 9:22 pm
by edogawa
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...
Re: Feature Request: Export Patchlist
Posted: Sun Jul 21, 2024 7:16 am
by sbenejam
I made some modifications to get this script work.
A few months ago I made a similar script to create a .txt file with the Fixtures, Channels list, etc.
Re: Feature Request: Export Patchlist
Posted: Sun Jul 21, 2024 7:28 am
by edogawa
Thank you Santiago!
Re: Feature Request: Export Patchlist
Posted: Sun Jul 21, 2024 7:30 pm
by sbenejam
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