Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

jjwallaby
New Contributor III

How to strip out the load scripts/hidden scripts for a qlikview qvw

Hi,

We have a old qlikview qvw design by not so great 'qlik' person developer.

When open it says 'Access denied to this QLIKView document'

So I am trying to find out what file.  Or if it has hidden scripts.  To dump out the scripts to

try and reverse engineer this.

Do you have a command line tool to strip out the scripts so it can be debugged why this message appears.

Possible it has HARD-CODED a file path which no longer exists.

Thanks

Regards

Justin

Tags (1)
7 Replies

Re: How to strip out the load scripts/hidden scripts for a qlikview qvw

Usually, When you talk about old and open - May be there has some security in that application. As far i know, That you can not open that restrict by Qlik.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
jjwallaby
New Contributor III

Re: How to strip out the load scripts/hidden scripts for a qlikview qvw

what a poor design..in qlikview.

MVP
MVP

Re: How to strip out the load scripts/hidden scripts for a qlikview qvw

Have you tried opening it without data? From the QV desktop start page, right click the file name in the Recents list and try "Open 'file' Without Data".

If the file is not in the recent list, create a text file with the line

"C:\Program Files\QlikView\qv.exe" /nodata %1


Store it on your desktop with a .bat extension. Then drag the file and drop it on the bat file.

Or, open a run command and enter

"C:\Program Files\QlikView\qv.exe" /nodata "your filepath and name"

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP & Luminary
MVP & Luminary

Re: How to strip out the load scripts/hidden scripts for a qlikview qvw

If there is any section access implemented it does what it should by deny the access for unauthorized persons. If there is no query for an user and a password the restrictions will probaly base on the NTNAME and/or your licence and/or your domain.

Within the xml-header of the qvw you might get some valuable hints from where the section access come from:

<LineageInfo>

   <Discriminator>\\YourServer\d\...\sectionaccess\sectionaccessrules.xlsx</Discriminator>

and which users are included:

<SectionAccessNames>

        <String>DOMAIN\USER1</String>

and with this knowledge and something from here: Bypassing QlikView Section Access – Infinity Insight Blog you might be lucky to get access again to this application.

- Marcus

Highlighted
jjwallaby
New Contributor III

Re: How to strip out the load scripts/hidden scripts for a qlikview qvw

Thanks Jonathan

Tried that sill same error 'Access denied to this QlikView document';

jjwallaby
New Contributor III

Re: How to strip out the load scripts/hidden scripts for a qlikview qvw

Thanks Marcus,

How would one get to the xml-header/extract xml-header from a binary file.

MVP & Luminary
MVP & Luminary

Re: How to strip out the load scripts/hidden scripts for a qlikview qvw

Just opening it within an editor like notepad++ and using CTRL + F with "sectionaccess" to find the mentioned xml-parts at the bottom of the file.

- Marcus