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?
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.
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?