AnsweredAssumed Answered

Fastest way to add new record

Question asked by nexgen on Jun 2, 2017
Latest reply on Jun 4, 2017 by beverly

I'm currently parsing a csv file using scripts but it's taking too long time to import. (the csv files contains about 100,000 records)

 

How can I improve the speed of import?

 

The way I'm currently doing it is:

* store whole csv data in a variable

* loop

* getvalue to get the current line

* break the current line by replacing "," with ¶

* new record request

* set field (9 fields)

* end loop

Outcomes