55
Views
8
Comments
Import CSV | Bulk Insert | How to?
Application Type
Traditional Web

Hi Team,

Note: Im working on Traditional Web App.

I want to import csv file & then insert into entity. ( I can upload as Excel )

And my record is bulky so I need to do Bulk Insert with some event.

I've treid all the related components suggested by FORGE. But it is not works for me. Bulk Insert, CSVUtil.

Do anyone have the solution for this?


Thanks in Advance,

NU

2024-07-16 17-36-51
Shradha Rawlani

Hi,

you can use timers for bulk insert

refer this

BulkInsert - Overview (O11) | OutSystems 

Regards

Shradha

2023-11-06 15-36-11
NU'k

Thanks @Shradha Rawlani 

I've treid this but struck at where to find physical table name.

Do you have any idea?

Sample file I attached here.

BulkUpload.oml
2024-07-16 17-36-51
Shradha Rawlani

You can find it in system database entity table physical table name 

2023-11-06 15-36-11
NU'k

Do you mind sharing the screenshot! I couldnt find

And am using an external entity

2024-10-12 12-11-20
Kerollos Adel
Champion

can you create C# extension to deal with insert part 

2023-11-06 15-36-11
NU'k

Unable to find that on forge.

Will you share me th component SS!

Thanks.


2023-11-06 15-36-11
NU'k

Even I use BulkInsert I could only upload less amount of records (Ex:1000rows)

Not able to upload huge data. When I try to upload am getting this error on page immediatly once action started 

"Error:The page was not displayed because the request entity is too large." 


I have tried to work with Timer also. But I couldnt.

Can anyone help me with update Timer functionality? I've attached .oml file below.


Action I used

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