extracting the load script from QlikSense and QlikView

[daveatkins]

I need to write a script to identify all the data elements that are used in our QlikView and QlikSense deployments. I have done this in a way that works manually; i.e. I can open up qlikview and export the load script to a .qvs text file and then read that file into my script and it will generate a list of each connection, followed by the database tables referenced in SQL.

However, I need to do this for hundreds of files (QlikView) and I have not yet looked at how to export the QlikSense load script.

I am aware of the approach of creating prj folders for QV; not really feasible to go down that path with the size of our deployment.

Is there a way to pull the load script out of .qvw files and out of the QlikSense applications from a python script or powershell, etc.?

[abhijitnalekar]

Hi @daveatkins ,

If you just want to convert Script from Qlikview to Qliksense then I will suggest to use qliksense converter functionality from DevHub.

[daveatkins]

not what I am looking to do. I need to get the load script out of QlikSense into a text file so I can parse it with a python script to generate a list of all the database connections, tables, and columns so we can map them to a new data warehouse and rewrite the load script to use that.

[Frank_Hartmann]

Maybe this thread will help:

https://community.qlik.com/t5/QlikView-App-Dev/Export-Scripts-from-multiple-QVW-files/m-p/1520023

[nammahesh]

Hi @daveatkins , I have similar requirement. Can you please help what library in python can be used to parse load script and convert to some other format like SQL?