How to Export Equipment List

[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

[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.

[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

[edogawa]

In a terminal, a command like

Code: Select all

grep \<Name\> yourfile.qxw

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.

[Yestalgia]

You can do this in QLC+5, just make a copy before you open it

[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.

[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

[christianF]

hello Luca, this is really helpful! thank you very much

[Trudel]

Hi Luca,
this is super helpfull.
Thank you so much