topic Re: Can I run the STORE command on qlikview server in QlikView

Can I run the STORE command on qlikview server

Wed, 25 Nov 2020 16:16:04 GMT

Good Afternoon,

I am very new to QlikView and I have been using it to extract data from a database via ODBC. I have been using the STORE command to produce a table in csv format that is produced when a reload my data.

However, when I schedule the script to reload on qlikview server, my script fails.

Is there any advice anyone can give me as to what I might be doing wrong?

This is my script

STAFFEXPORT:
LOAD Forename, Surname, GeogRestriction, Status, StartDate, UniqueID, RegisteredDate, Reference, PositionCode, JobCode001, JobDescription, EndDate, CreationDate
WHERE Status = 'PERM';
SQL SELECT * FROM ENIDTAB0009;

STORE STAFFEXPORT INTO '\\MSIFP01\Secure Data\Accounts (New)\Management Information (Analysis)\Phil Hanmore - Analysis\QlikView\QlikViewExports\tblStaffExport.csv' (txt);

Re: Can I run the STORE command on qlikview server

Anil_Babu_Samineni — Tue, 20 Sep 2016 17:08:03 GMT

Your expression seems correct to me

Try this

STORE STAFFEXPORT INTO '..\..\MSIFP01\Secure Data\Accounts (New)\Management Information (Analysis)\Phil Hanmore - Analysis\QlikView\QlikViewExports\tblStaffExport.csv' (txt);

Does your path is correct. Can you please share the screen shot where do you copy this path

Re: Can I run the STORE command on qlikview server

devarasu07 — Tue, 20 Sep 2016 17:10:49 GMT

Hi Phil,

Syntax:

Store[ *fieldlist from] table into filename [ format-spec ];

in your case,

STORE STAFFEXPORT INTO \\MSIFP01\Secure Data\Accounts (New)\Management Information (Analysis)\Phil Hanmore - Analysis\QlikView\QlikViewExports\tblStaffExport.qvd (QVD);

Regatds,

Dev

Re: Can I run the STORE command on qlikview server

Digvijay_Singh — Tue, 20 Sep 2016 17:12:38 GMT

What error it gives, can you please share.

Re: Can I run the STORE command on qlikview server

marcus_sommer — Tue, 20 Sep 2016 17:41:24 GMT

It sounds more like an issue with the access rights within the file-system. The user who runs the qlikview server services has quite probably different access rights within your network as you. In this case you would need to adjust the access rights or changing your path.

- Marcus

Re: Can I run the STORE command on qlikview server

Wed, 21 Sep 2016 09:16:13 GMT

Thanks everyone for your input.

It was a read/write issue. Once I changed the network location to a that was writable the script ran fine.

Thank you for your help.