Hello everyone,
Not so long ago, I was asked if it is possible to export all measures and dimensions from QS Enterprise to csv files. Since I learned a little Python, I decided to create a script that can do this.. A few evenings and I wrote a working prototype.
Changelog
2021-08-11
- export parents for each measure and dimension
- export parents for all app objects
- disable certificate validation for QS server
- fix filenames for dimensions and measures (was the opposite)
Setup
- Create a folder anywhere on the computer, - this will be the project folder
- Create a
certs
folder inside - export certificates from QS in pem format (without passwords) and copy them to the
certs
folder
qmc qs -> certificates (https://server.name/qmc/certificates) - install python (you can use the latest version 3.9. x)
In config.py
write your server name to the SERVER_HOSTNAME
variable
Project folder

Download all files here: master items extractor.7z (4 kb)
Install pip packages
Open cmd or PowerShell and go to your project folder, then type for install deps for this script
pip install -r requirements.txt

Run
After install, type
python extractor.py

Result
The result of the script execution will be saved in the temp folder as .csv-files

The main AppInfo.csv file contain information on applications and streams,
the other files have the following name format:
- [application guid]_measure.csv - for measures
- [application guid]_dimension.csv - for dimensions
- [application guid]_objects.csv - for items with parents


The key for linking the main AppInfo.csv file with the others is qDocId - this is the guid of the application

Questions
telegram : @chernov
mail: schernov1@gmail.com