topic Re: User Directory Connector - Excel in Management & Governance

User Directory Connector - Excel

KHSDM — Wed, 09 Nov 2022 03:50:32 GMT

Hi all,

I've an Excel containing the list of Qlik Sense users stored in a network shared folder. But I have problem with the setup the in QMC.

I try to use the connection string like below:-

DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=\\192.168.0.1\QSUsers\QS Users.xlsx

But I'm getting error:

ERROR [HY000] [Microsoft][ODBC Excel Driver] The Microsoft Access database engine cannot open or write to the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view and write its data.↵↓ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed↵↓ERROR [HY000] [Microsoft][ODBC Excel Driver] The Microsoft Access database engine cannot open or write to the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view and write its data.↵↓Exception when trying to connect to the data source. Edit the connection string in the user directory connector configuration

Is the network path method supported?

Re: User Directory Connector - Excel

Chip_Matejowsky — Wed, 09 Nov 2022 17:38:24 GMT

Hi @KHSDM,

Based upon the error you provided it seems the correct driver isn't installed. Have a look at the Qlik Knowledgebase article Example for Qlik Sense to synchronize users and attributes from excel, which shows how to connect to an Excel file for the User Directory Connector.

Best Regards

Re: User Directory Connector - Excel

KHSDM — Thu, 10 Nov 2022 06:10:40 GMT

hi @Chip_Matejowsky yup, checked, we have it installed. I also tried to load it from the local C drive, and it works. But it cannot work if it is loading from a network path (\\192.168.0.1) Not sure if the syntax/path that I'm using is correct.

Re: User Directory Connector - Excel

Chip_Matejowsky — Thu, 10 Nov 2022 12:37:44 GMT

Hi @KHSDM,

I just test this scenario in my lab and it worked as expected. Is there a particular reason why you're using IP address and not FQDN?

Best Regards

Re: User Directory Connector - Excel

KHSDM — Tue, 15 Nov 2022 00:46:41 GMT

I tried with DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=\\machinename\QSUsers\QS Users.xlsx it doesnt work as well.

Re: User Directory Connector - Excel

KHSDM — Tue, 15 Nov 2022 06:48:22 GMT

Finally manage to get it to work! Its due to the folder/file permission. It works after giving permission to the Qlik Sense service account.