Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
RDBVAM
Partner - Contributor II

How to Connect Local Excels files in Qlik sense Cloud.

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

 

Labels (1)
23 Replies
VBD
Partner - Creator II

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/C...

Do you have any error ? 

Regards,

Valentin Billaud
Next Decision
RDBVAM
Partner - Contributor II
Author

Thanks for reply

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

RDBVAM_0-1744873818000.png

 

RDBVAM
Partner - Contributor II
Author

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

VBD
Partner - Creator II

Maybe try to update or install Qlik Data Gateway,

You should see this file : 

VBD_0-1744875395902.png

 

Valentin Billaud
Next Decision
RDBVAM
Partner - Contributor II
Author

RDBVAM_0-1744884066689.png

 

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

 

RDBVAM
Partner - Contributor II
Author

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.

RDBVAM_0-1744895717477.png

 

 

VBD
Partner - Creator II

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

VBD_0-1744896045392.png

 

Valentin Billaud
Next Decision
RDBVAM
Partner - Contributor II
Author

yes

RDBVAM_0-1744898434537.png

 

VBD
Partner - Creator II

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

Valentin Billaud
Next Decision