topic Re: How to Connect Local Excels files in Qlik sense Cloud. in Connectivity & Data Prep

How to Connect Local Excels files in Qlik sense Cloud.

RDBVAM — Thu, 17 Apr 2025 05:17:41 GMT

I have a virtual machine with some Excel (.xls) files saved in a local folder.
I manually upload these files using the Data Manager in Qlik Sense to create an app.

However, when I reload the app, it fetches data from the uploaded file stored under 'Data Files' within Qlik Sense, rather than from the original source file in the local folder.

As a result, any changes made to the original Excel file (or if I replace it with a new version) are not reflected in the app after a reload.

I would like the app to always load the most recent data from the source Excel file in the local folder on the VM.
How can I achieve this?

-I also install Qlik Gateway- Direct access
-Also try to achieve this Using Qlik Data Transfer but not able to achieve

Re: How to Connect Local Excels files in Qlik sense Cloud.

VBD — Thu, 17 Apr 2025 06:31:51 GMT

Hi, these are the correct methods for accessing files via qlik cloud.
The best is the gateway https://help.qlik.com/en-US/cloud-services/Subsystems/Web_Storage_Provider_Connectors_help/Content/Connectors_StorageProvider/Storage%20provider%20connectors/File-DG-storage-provider-connector.htm

Do you have any error ?

Regards,

Re: How to Connect Local Excels files in Qlik sense Cloud.

RDBVAM — Thu, 17 Apr 2025 07:16:46 GMT

Thanks for reply

I installed Qlik gateway Direct Access. I am not able to find Config-file-Connector.Properties.

Re: How to Connect Local Excels files in Qlik sense Cloud.

RDBVAM — Thu, 17 Apr 2025 07:19:38 GMT

when we select File connector (Direct access) in qlik cloud we can see the gateway but in folder path we not seeing anything its empty

Re: How to Connect Local Excels files in Qlik sense Cloud.

VBD — Thu, 17 Apr 2025 07:36:45 GMT

Maybe try to update or install Qlik Data Gateway,

You should see this file :

Re: How to Connect Local Excels files in Qlik sense Cloud.

RDBVAM — Thu, 17 Apr 2025 10:01:55 GMT

I am getting above files. Do i need to install gateway again.
How can i uninstall it ?

Re: How to Connect Local Excels files in Qlik sense Cloud.

RDBVAM — Thu, 17 Apr 2025 13:15:28 GMT

i am getting file configuration-file-connector.properties and i added folder path for local folder in it.
Also i checked for security on folders.

I am able to see Gateway name but not able to see folder path.

Re: How to Connect Local Excels files in Qlik sense Cloud.

VBD — Thu, 17 Apr 2025 13:21:32 GMT

Does the gateway appear online in the administration console on qlik cloud ? :

Re: How to Connect Local Excels files in Qlik sense Cloud.

RDBVAM — Thu, 17 Apr 2025 14:00:51 GMT

yes

Re: How to Connect Local Excels files in Qlik sense Cloud.

VBD — Thu, 17 Apr 2025 14:48:19 GMT

Can you send a screen of your file configuration-file-connector.properties ?

Re: How to Connect Local Excels files in Qlik sense Cloud.

VBD — Fri, 18 Apr 2025 08:24:42 GMT

hi thinks it's ok

Re: How to Connect Local Excels files in Qlik sense Cloud.

RDBVAM — Fri, 18 Apr 2025 11:35:13 GMT

Re: How to Connect Local Excels files in Qlik sense Cloud.

VBD — Fri, 18 Apr 2025 11:42:39 GMT

when you click on the arrow in the grey area of the ‘Path’, it doesn't appear?

Re: How to Connect Local Excels files in Qlik sense Cloud.

RDBVAM — Fri, 18 Apr 2025 12:28:33 GMT

Yes. Path not appearing in path dropdown

Re: How to Connect Local Excels files in Qlik sense Cloud.

VBD — Fri, 18 Apr 2025 12:33:55 GMT

Do you have some logs in :

Re: How to Connect Local Excels files in Qlik sense Cloud.

VBD — Fri, 18 Apr 2025 12:35:24 GMT

and on your server do you have any errors on the C:\Program Files\Qlik\ConnectorAgent\data\logs\file_connectors_logs :

Re: How to Connect Local Excels files in Qlik sense Cloud.

RDBVAM — Fri, 18 Apr 2025 12:47:58 GMT

yes having some logs in Gatway

Re: How to Connect Local Excels files in Qlik sense Cloud.

VBD — Fri, 18 Apr 2025 12:50:21 GMT

and on your server do you have any errors on the C:\Program Files\Qlik\ConnectorAgent\data\logs\file_connectors_logs :

Re: How to Connect Local Excels files in Qlik sense Cloud.

RDBVAM — Fri, 18 Apr 2025 12:51:04 GMT

yes

Re: How to Connect Local Excels files in Qlik sense Cloud.

VBD — Fri, 18 Apr 2025 12:52:58 GMT

the file_connectors_logs file like on my screenshot