Upload an Excel sheet automatically twice a day

Upload an Excel sheet automatically twice a day

  
I just created my first app (Phone Book) mainly based on an Excel sheet contains.

Supposed I got an operator filling automatically filling an Excel sheet before the end of each shift.

Is there a mecanism to upload the Excel sheet located in \Resources\ of my app ?

Regards,

Jean Trudeau

ps: I tried to manualy replace the "contact.xlsx" file manualy and republish it and the changed I made were not taken in consideration.
you should do that via a timer and a shared folder.
resources is part of the application.

-timer
-network-filesystem extension (or ftp etc)


Hi J,

Can you please demonstrate with an example?

Suppose I have stored an excel on D drive, everyday at 4:00 pm, I want o upload it's contetns to database.

Thanks and Regards,
Suraj Borade
Suraj Borade wrote:
Hi J,

Can you please demonstrate with an example?

Suppose I have stored an excel on D drive, everyday at 4:00 pm, I want o upload it's contetns to database.

Thanks and Regards,
Suraj Borade
 
 There's nothing you can do to automatically get a file from a user's hard drive. They need to manually upload it. Sounds like you need some automation on the user's computer (macros? Windows Scheduled Tasks?) to push the file (to a REST Service, FTP site, etc.) on a schedule.

J.Ja
There is no problem for me to set a macro or a task in Windows. I'll try to figure it out the rest !

Regards,

Jean Trudeau