topic Scanning QVWs for text in QlikView

Scanning QVWs for text

jliotine — Fri, 15 Nov 2024 23:52:15 GMT

We are moving tow of our databases to a new server. I have about 400 QVWS that I need to scan to see if they reference the databases that are moving. Anyone know of a way I can do this without having to open each one at a time? I think it can be done with the governance dashboard, but I cant Figure out how.

Re: Scanning QVWs for text

marcus_sommer — Fri, 02 Oct 2020 10:45:52 GMT

Open the qvw with an editor like notepad++ and then search for your database - I assume that you find this information by LineageInfo --> Discriminator. If the approach worked you may create an appropriate batch (or adjust something similar which you will probably find with google). Maybe easier could be to use Qlik which could read these information if the qvw is read as xml - for an appropriate loop-logic with dirlist/filelist take a look on the help by for each ...

- Marcus

Re: Scanning QVWs for text

Brett_Bleess — Thu, 22 Oct 2020 14:21:52 GMT

The only other option would potentially be the Governance Dashboard:

https://help.qlik.com/en-US/governance-dashboard/Content/QV_GovDashboard/What.htm

Regards,
Brett