Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a requirement to allow a user to upload data via e.g. XLS spreadsheet. These users do not have access to a shared folder as they are external to our systems.
Is there any way that we can enable such functionality from within QlikView for the end user?
Once the user has uploaded the file then we would want to force a reload. Is this possible?
Thanks
Geoff
where the XLS spreadsheet will be? are they will be in user's computer or in the remote computer? Please explain with some more information to help on this.
Hi,
Even i dont think if thr is a way to do this automatically through qlik view. But i can suggest you can use a FileZilla FTP Server to upload Excel file(at Client End) and Fetch (at developer end) , as QV will fetch the File from FTP.
At client end FTP client needed to be installed and at QV Developer/Server end FTP server needed to be installed.
I hope this can help. Else Iam also waiting for reply if thr is any way to control all this through Qlik View.
Hii,
Can't you use EDX for your scenario??
to load excel from the user end and you can run from your end or ask them only to reload after upload..,
not sure ..,just a suggestion 🙂
You can write a code in macro to browse the file and select it by button and copy to another location. Then you re-load the copied file to the Qlikview. Regards. sivasankar
How much data is it and for what purpose do they need to upload data?
You could write a macro but this has the potential to be detrimental to server performance, what if multiple users upload at the same time, or even sequentially you have the potential for a non-stop load on the server.
An alternative is to schedule a reload every x minutes rather than forcing a reload and just include the spreadsheet?
Thanks Silva - the file(s) would be on the user's PC
Single xls files each time representing perhaps 1000 rows of data with 10 columns each time.