topic Create user upload panel in QlikView

Create user upload panel

Anonymous — Fri, 02 Oct 2015 17:29:12 GMT

Hi All,

I have a requirement to allow users to upload data via spreadsheets from their local systems.

Once the user has uploaded the spreadsheets then we would want to force a reload. Is this possible

Via macro ? If yes please let me the code.

Thanks

Krishna.

Re: Create user upload panel

Fri, 02 Oct 2015 17:37:45 GMT

can you be a little more specific

what do you mean when you say 'allow users to upload data via spreadsheets from their local systems' - are they loading this data into a qlikview application - is this qpplicaiton on their desk top

once the spreadhseet is uploaded, you want a reload of the qlikview application performed on accesspoint? - where is the accesspoint application getting the data from?

Re: Create user upload panel

Anonymous — Fri, 02 Oct 2015 18:32:06 GMT

Hi Adam,

users upload spreadsheets into shard folder. That shard folder data to should be updated in report dynamically.

Thanks,

Krishna.

Re: Create user upload panel

diego_a_barboza — Fri, 02 Oct 2015 19:03:08 GMT

If I am correct, the idea would be that the dashboard should be reloaded whenever one of the spreadsheets (that are the datasource) are updated.

There are two ways to do this (at least, that I can think of): The first one would involve the following steps

Install and set up EDX on your QV Server, you can check this guide: Using EDX in QlikView 11
Create a batch file that detect the modified date of the file and triggers using the EDX if the file is new.
Set up the EDX parameters on your QMC for the document task.

The second option would be a bit more lazy and less efficient, but still effective:

Set up the reload task to run every 5 minutes (or more, depending on the QV Application you are working with)
Include a part of the script that verifies the date and time of the last time each of the files were updated: if it is more recent than the last record, the conditional will active the reload for that file. Otherwise, it does nothing.

The script that you could use would be something like this:

let vCurrentModDate = filetime(<filename.xls>);

if vCurrentModDate <> vOldModDate then

tablename: LOAD * FROM <filename.xls>;

set vOldModDate = vCurrentModDate;

end if

As a personal note, I think that the first option is the more elegant and efficient, since the reload task will only launch whenever the datasources are ready, for that reason your client may prefer it. However, it also implies knowledge in fields that are not exclusive from QlikView, so that may be a problem for you (depending on your skills, of course) . It is also to take into accont the workload that you have in your server.