Help needed: data won't reload since qlikview app's location on server was moved

[#1]

Hello

I know I should have anticipated this, but since re-organising and tidying up our server files, I’ve not been able to reload data on our Qlikview application (the file sits on our network, we’ll be relocating to a cloud environment soon).  Our application currently reloads data from a set of QVD files.

How do I fix this?

I did try replacing the old location of the QVD files with the new one but that didn’t work.

An example of the load script ( with original location of QVD files,  before the folder was moved) is below:

LOAD FLAGPVKEY, 
     FLAGTYPE, 
     MAILINGLIST, 
     ENEWSLETTER, 
     CHRISTMASCARDLIST,
     NEWBIZFLAG
FROM
[\\Signifyserver\hopehiv\Fundraising\Fundraising Channels\Companies\QlikTech - Joe Francis\QlikView\QlikView files for dashboard\FLAGS.QVD]
(qvd);

Files are now saved here:

\\Signifyserver\hopehiv\NEW HOPEHIV server\Systems & Admin\Qlikview\_HOPEHIV's QlikView App

Screen grab attached in case it helps,

Thanks

Lindsay

[Miguel_Angel_Baeyens · Accepted solution]

Hi Linsay,

Keep in mind that the account running the services (not the account that you use to develop and reload manually) must have the path accessible. The following code seems all right to me. Make sure this account can reach the UNC path. Apart from this, the only thing worth noting is that the path has several characters that might not be allowed or create an issue when reading from, such as "&", "'" (single quote).

LOAD FLAGPVKEY, 
     FLAGTYPE, 
     MAILINGLIST, 
     ENEWSLETTER, 
     CHRISTMASCARDLIST,
     NEWBIZFLAG
FROM
[\\Signifyserver\hopehiv\NEW HOPEHIV server\Systems & Admin\Qlikview\_HOPEHIV's QlikView App\FLAGS.QVD]
(qvd);

Hope that helps.

Miguel

[gandalfgray]

Hi

How did you change it?

Manually typing the string, or?

If you did, try instead to use the "Table Files..." button in the load script editor

and browse to the qvd file and click open - that way you get the correct pathname.

[#4]

Thank you so much - I removed the & and single quotation from the folder names and the data has loaded properly. So relieved.

Thanks both for your prompt feedback!!

Lindsay