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