Bulk Insert with validations

Hi All, 

I'm trying to implement bulk upload from an excel which will have approximately 20,000-30,000 records. Few data at each row needs to be modified before it is inserted into the DB. I was checking the Bulkinsert Forge component and yet to check on the feasibility of data modification before using bulk insert. Kindly let me know if any other solution is best suited for this purpose.

Thanks and Regards,



As far as I know, in OutSystems, there is nothing redy for what you need. 

You probably will have to:

1. Upload the excel and store the binary in database (or in server) 

2. Trugget a timer that will call a server action

3. The server action will than check where to start (which excel line), start processing the lines and before timeout, awake the timer and finish. When there are no more lines to process, finish without awaking the timer. 

Another option wild be to process the lines first and save in excel and than bulk insert, but I never tried this approach. 

Hope this helps.