Can I run the STORE command on qlikview server

[#1]

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);

[Anil_Babu_Samineni]

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

[devarasu07]

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

[Digvijay_Singh]

What error it gives, can you please share.

[marcus_sommer · Accepted solution]

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

[#6]

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.