Hi,

I have requirement some excel files comes  in server particular local location(Ex:D:/JobFile/text.xlsx)

i need to process these files using any  schedule job using outsystem timer and added into database

,how can i achieve this requirement.

Hello Himanshu.

You can have a Timer calling an action that will load the files from the server (it need to be a folder that the application have access, like a shared folder and so on).

To load the file into memory to process, you can use something like the FileSystem component.

Cheers.

Hi there,


You can use filesystem to get the file from the directory, save the binary in your DB and then process the entire excel, all of it at, at least, one timer.


Kind regards,

Hugo