Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.?
Hi @daveatkins ,
If you just want to convert Script from Qlikview to Qliksense then I will suggest to use qliksense converter functionality from DevHub.
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.
Maybe this thread will help:
https://community.qlik.com/t5/QlikView-App-Dev/Export-Scripts-from-multiple-QVW-files/m-p/1520023