Hi Priya,

Taking proper approach in development is more important in order to keep application performance fast.

if you have excel file and you want to process the data so there are many ways to handle this scenario.

1. you can directly upload and process the file in action. But if file contains huge no of records so this might not work and end user has to wait until the process complete.

2. Upload the file from the widget and save the file in db and then you can run a timer to process that file. it can able to handle big file.

3. you can also run the process and process the file.

Hope this helps.

Hello @Priya Jhode ,

Agreed with Shoaib, but if you wan to step wise step process to How to upload and process an excel file to create records in OutSystems?

You can refer this Videos 

https://www.youtube.com/watch?v=0NVHxmiPGDs

I hope this will help you.

Thanks & Regards

Navneet Sharma

Hi Priya, 

Please check this link and ZIP File

https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Bootstrap_an_Entity_Using_an_Excel_File?_gl=1*oa4tms*_ga*MjIzNTk1NzE2LjE2MzczODgzODU.*_ga_ZD4DTMHWR2*MTY2NDAxMzQ1NC4zNDUuMS4xNjY0MDEzNjM5LjQ2LjAuMA..

Thanks,

Ramesh

Hello @Priya 

When we need to process a bulk of data, according to  best practice this has to be done in a background asynchronously in background with heavy timers . A Heavy Timer is used to process heavy operations. Some time we don't know the amount of data we want to process,

There are some points we should keep in mind when doing this

• There should be no time out( when your timer reaches its timeout and your execution is still running the you will get a time out error.
• Once our data is been created into our entity make sure you are not repeating the same thing with the records( use some flags to identify it )
• Once completed make sure there must be some notification kind of something that will let you know that your work is done
•  Commit a transaction at the end of the cycle.

 You can also refer to this post for the Solutions available , different approaches 

https://www.outsystems.com/forums/discussion/81684/best-solution-of-timer/

I hope this information will be helpful.

Best Regards

Tousif Khan