72
Views
7
Comments
Solved
How to  do Auto Import and Export for the below scenario?

Scenario is as follows:

  • I want to download excel data from the Outsystem to a specific location in the local system and if I want to do any changes in the excel I need to do it.  Again need to auto import the updated excel into the Outsystem in a regular interval.
  • Both export and import should happen in regular intervals daily.

Thank you in advance.

2019-07-01 07-16-04
Vinod Patidar
Solution

Hi Banu,

I have created a sample for auto import products from FTP. Please find the attached sample app.

You can use below free FTP -

https://dlptest.com/ftp-test/

Please follow the below steps -

1. Upload the Sample_Products.xlsx file on FTP.

2. I have created a timer(ImportProductData) and its schedule is When Published. You can change  its schedule as per your requirements.

2. Publish this sample. Check the data in Sample_Products entity.

Thanks

Vinod


AutoImportFromFtp.oml
2019-07-01 07-16-04
Vinod Patidar

Hi Banu,

You can use timers to execute this task on daily but for import and export you need a shared location. Shared location might be FTP, Shared drive that is accessible from server and your system.

Thanks

Vinod

UserImage.jpg
Banu

Thank you for your reply.

My issue in auto import/ export is I cant able to fetch the file from the specific location. 

I can able to do import and export at run time but not able to do automatically. 

I have used FileSystem Plugin for it but  can't get the  result.

Can you explain the logic used to fetch/place the file from/to specific location? 

 

2019-07-01 07-16-04
Vinod Patidar

Do you have Ftp or shared location? 

UserImage.jpg
Banu


I am using Shared location. And can we store it in local device?

2019-07-01 07-16-04
Vinod Patidar

Shared location - Make sure that shared location is accessible from OutSystems front end server. I am assuming that you are using On-premise environment.

Local Device location is not accessible by OutSystems front end server.

2019-07-01 07-16-04
Vinod Patidar
Solution

Hi Banu,

I have created a sample for auto import products from FTP. Please find the attached sample app.

You can use below free FTP -

https://dlptest.com/ftp-test/

Please follow the below steps -

1. Upload the Sample_Products.xlsx file on FTP.

2. I have created a timer(ImportProductData) and its schedule is When Published. You can change  its schedule as per your requirements.

2. Publish this sample. Check the data in Sample_Products entity.

Thanks

Vinod


AutoImportFromFtp.oml
2019-07-01 07-16-04
Vinod Patidar

Please find the attached  Sample_Products.xlsx file as well.

Sample_Products.xlsx
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.