QVW's drive change issue.

[#1]

Hi,

I have changed my qvw file folder from C-Drive to E-Drive in my laptop.

It do not get open when i try to open those files which are in E-Drive now.

How to solve this issue...

[Chanty4u]

hi,

u can change the path address in script level aswell den only it will open the qvw.

hope this helps u

Thanks

Suresh

[Gysbert_Wassenaar]

Open each qlikview .qvw document and open the script editor. There change all the file references from c-drive to e-drive. Then save the document and reload it.

[Anonymous]

What message you get when you open your file from E drive?

Do you have access to E drive?

You might be restrcited to access E drive...

[nigel987]

Hi Narsig,

if you want to have a more generic solution and save yourself the trouble of having to change the file locations in the script for each load, you can create a text file which contains the path to your source documents.

This is how I solved this:

• Create a document called 'Expressions.txt'
• This document contains the path to your source documents, e.g.

        set pathSource = '..\SourceDocuments\';

The pathSource is the name of the variable which you can choose yourself.

The '..\SourceDocuments\' is the path from the .qvw file to the folder which contains the source files. I always use the same folder structure, so that I do not need to change to script when using the same qvw on different sytems (prod, test, local).

• Now you need to include the content of this text in your qvw, by writing in your script

        $(Must_Include=..\Documents\Expressions.txt);

Again, ..\Documents\Expressions.txt) is the path from the qvw to the Expressions.txt file.

• Now you can use the source variable in your load statements in the scipt:

        LOAD UserID,

                   Address

        FROM

        $(pathSource)UserAddress.qvd

        (qvd);

Hope this helps,

KR Nigel

[#6]

It shows 'Failed to open the Document'.