topic Re: Script recovering in QlikView

Script recovering

Fri, 07 Dec 2012 09:15:57 GMT

Hello,

I had a transfer from Win XP to Win 7 and I was forced to instal qlikview again (private version). Now, I can not open any of my previous files. Layout, desing and data are NOT the problem, but I would like to get my load script. It is locked in those file and I do not have idea how to access to it.

In normal cases, I am backup freak, but last night... I just forgot to save code in some notepad file... I have many files but I would like to access to three...

Any help?

Re: Script recovering

Gysbert_Wassenaar — Fri, 07 Dec 2012 09:55:32 GMT

If it's only three files, they're not too big and you're willing to share them, post them here. If somebody doesn't beat me to it, I'll try to extract the scripts for you.

Re: Script recovering

Fri, 07 Dec 2012 10:12:33 GMT

It is not a problem, but I was not able to upload it on qlikview server. If you follow this link you will find one of them.

'LINK REMOVED BY AUTHOR'

The data is not important (it is not accurate). This file converts access database to qvd then group same data by some conditions and dimensions. The important part is "standardisation", because I have table names, paths, column names etc. in script.

This file is cca 2 MB. Second is cca 3MB and third is 26MB

Thank you very much for your help.

Re: Script recovering

Gysbert_Wassenaar — Fri, 07 Dec 2012 17:37:12 GMT

I've used Rob Wunderlich's Document Analyser to process your Qlikview document. The contents can be found in the attached zip file. It contains a bit more than just the script (see script.qvs). Maybe you can use some of it.

Re: Script recovering

Sat, 08 Dec 2012 12:56:45 GMT

Thank you

You saved my day. I can use this code for other files. I need to change few things and I do not want to bother you any more. Thanks a lot