Page 1 of 1
How to Export Equipment List
Posted: Thu Apr 13, 2023 10:09 am
by LLO62
Hello everybody,
I was trying to find a way to export/save/extract in some format the list of equipment I have loaded into QLC in order to keep my inventory aligned with what I have inside the program. I have also tried to search the forum with keywords like print, extract or excel with no success (maybe I am not searching with proper words...).
Could you please provide some help?
Many thanks.
Luca
Re: How to Export Equipment List
Posted: Thu Apr 13, 2023 12:12 pm
by GGGss
This is not a fixed solution but what if you open the project file with a text editor?
You will find all your fixtures in use.
Create a backup before editing - if you break the structure of the file, you break your QLC+ project.
Re: How to Export Equipment List
Posted: Thu Apr 13, 2023 12:27 pm
by LLO62
Thank you Fredje,
I have already followed this way:
- copied file to something else
- edit to remove all the xml tags
this took (more) than a while, the bad is that if you change something inside the original file you must re-do all the stuff
So this was the reason why I was looking for something already built...
Thanks
Luca
Re: How to Export Equipment List
Posted: Fri Apr 14, 2023 9:53 am
by edogawa
In a terminal, a command like
would print a tidy list of the names you gave your fixtures in yourfile.qxw.
Similarly you could grep for <Manufacturer> or <Model> to obtain these values as defined in the fixture files.
And that's without the need to make a copy to work from, or the risk to destroy your workspace file.
I totally suck at writing scripts, so I can't provide you one, nor do I know what OS you're on and if it were useful to you.
But it should be possible to write a shell script so that it outputs a structured list from those tags in one go.
Re: How to Export Equipment List
Posted: Fri Apr 14, 2023 1:13 pm
by Yestalgia
You can do this in QLC+5, just make a copy before you open it
Re: How to Export Equipment List
Posted: Fri Apr 14, 2023 3:28 pm
by sbenejam
In QLC+ 4 you can export your fixture list to a qxfl file that you can import in other projects. It's an xml file, take a look to this export feature.
Re: How to Export Equipment List
Posted: Sun Apr 16, 2023 4:52 pm
by LLO62
Dear all,
after thinking a lot, and trying to do script like the one suggested using grep (unfortunately I am on a windows machine...) I dusted off my old visual basic 6 and wrote the attached program, maybe someone could find it useful (all sources included).
It reads a QXW file, makes a copy, and create a new file with CSV extension that could be opened with excel.
Many thanks for all the good suggestion.
Regards
Luca
Re: How to Export Equipment List
Posted: Thu Jul 06, 2023 3:23 pm
by christianF
hello Luca, this is really helpful! thank you very much
Re: How to Export Equipment List
Posted: Sun Aug 13, 2023 10:02 am
by Trudel
Hi Luca,
this is super helpfull.
Thank you so much