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.
Feature Request: Export Patchlist
- 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...
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
- 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.
A few months ago I made a similar script to create a .txt file with the Fixtures, Channels list, etc.
- 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