I want auto import the Excel file in a specific folder in backend .If there is any solution for that.
what do you mean by Auto Import. Can you tell me your use case.
My use case is to import Excel File automatically in backend. For Example I have Some Existing Excel Files in folder. If new file comes into that same folder that new file should be import automatically
Do you need to execute the process as soon as the file was put into the folder? If not. you can use a scheduled Timer so you can check and process if there is a new File in a folder.
Yes I need to import the file When put into the folder Automatically. can you explain the process
Do you manage adding the files to the folder? or it is coming from a 3rd party system?
Yes I am
Then You can use Processes for your use case. Just trigger it upon creation of a record. basically you will save the file path,name,etc in the database and upon creation of that record you should be able to have an automatic activity
Hello Tamilarasan.
You can use FileSystem component to reach folders on the server.
But is that a one time thing? I don't recommend using the server as a destination to upload files.
You can use shared folders or FTP for that and the actions can also reach those.
I want to upload file in our system storage
Hey @Tamilarasan S
Please refer to my solution on this
https://www.outsystems.com/forums/discussion/84646/how-to-download-all-images-from-database-in-one-go/#Post355842
in the solution instead of image its the excel file that will get converted into binary.
Thanks
Shlok Agrawal.
Hello @Tamilarasan S
Your question lacks some vital information (even if it does not make a difference).
1. Where are the "new" files been put in the first place?
I am assuming they are being placed in a LOCAL folder on the client machine, and you want to automatically upload them to the server and save them in a shared network folder on the server.
The answer to that is: That is not possible with OutSystems Reactive Web Applications.
The reason is simple. A Web Application runs over a browser. In order to be able to automatically detect that a file is in the folder, you need an Operating System (Windows or other) service, that is constantly running and listening to changes in the folder.
You simply can't do this with a web application running from a browser. It would be a huge security risk to allow this behaviour.
The same is valid for the file appearing on the server for the first time.
The only way to upload a file from the local folder (client machine) to the server, using a Web Application (no matter if it is an OutSystems reactive app or anything else), is for the user manually start the process by clicking a button/link that will have the code to ask for the file and upload it to the server.
If you need to do this "automatically", you will have to create a "native" (Windows or whatever) application that will run as a service and will be able to do this.
Hope I have helped.
Cheers.