Data access

genemegio — Wed, 25 Nov 2020 16:16:04 GMT

I have this route to Access data from Excel file, but this file is in the Novell File Server, and drive maped is:

\\10.10.100.1\shared\4_Mercadotecnia\Coordinadora_de_Mercadotecnia\ISO\Qlik view

or using the letter as a disk is:

S:\4_Mercadotecnia\Coordinadora_de_Mercadotecnia\ISO\Qlik view

If I reload the scrip to generate a qvd using the script pannel, it's woking, but when run the reload process using QlikView Manager Console, appear an error and I think this is due permits, how I can give the user and password on the script or in QMC to avoid this error?.

This is the part of the scrip to call the load:

"FROM
[\\10.10.100.1\shared\4_Mercadotecnia\Coordinadora_de_Mercadotecnia\ISO\Qlik view\Base de datos de encuestas 2017.xlsx]
(ooxml, embedded labels, header is 1 lines, table is COMPRAS); "

Re: Data access

tincholiver — Fri, 22 Feb 2019 23:37:54 GMT

you should give the permissions to the server, when you execute scripts manually you are doing it with the user that you are connected to, when the QMC executes the user is qlik

Re: Data access

genemegio — Mon, 25 Feb 2019 14:56:40 GMT

Thank you for your answer, let me review the permissions.

topic Data access in QlikView

Data access

Re: Data access

Re: Data access