Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Upload user data via QVW

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

8 Replies
Highlighted
Master II
Master II

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.

Highlighted
Not applicable

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.

Highlighted
Not applicable

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 🙂

Highlighted
Master II
Master II

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

Highlighted
Specialist
Specialist

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

Svebeck Consulting AB
Highlighted
Not applicable

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?

Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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