topic Upload user data via QVW in QlikView

Upload user data via QVW

gmarshall — Sun, 10 Jun 2012 15:28:32 GMT

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

Upload user data via QVW

Siva_Sankar — Mon, 11 Jun 2012 05:53:44 GMT

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.

Upload user data via QVW

Mon, 11 Jun 2012 06:25:03 GMT

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.

Upload user data via QVW

Mon, 11 Jun 2012 06:43:29 GMT

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 🙂

Upload user data via QVW

Siva_Sankar — Mon, 11 Jun 2012 07:23:11 GMT

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

Upload user data via QVW

RSvebeck — Mon, 11 Jun 2012 07:27:01 GMT

How much data is it and for what purpose do they need to upload data?

Upload user data via QVW

Mon, 11 Jun 2012 07:43:49 GMT

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?

Upload user data via QVW

gmarshall — Mon, 11 Jun 2012 19:56:24 GMT

Thanks Silva - the file(s) would be on the user's PC

Upload user data via QVW

gmarshall — Mon, 11 Jun 2012 19:57:45 GMT

Single xls files each time representing perhaps 1000 rows of data with 10 columns each time.