Csv import - if more than 10k records i get error 500

Server Side Components
#1

Hi there,

I just created a csv import in server side components:

  • db connection
  • import csv with a direct path to a file on the server (had it as upload before, now it is directly linked because i want to be sure that it is not an upload limit)
  • repeat (of csv import)
    – database insert (inside the repeat)

everything works, but if there are more than about 10k rows in the csv I get error 500. the path is correct (checked it more than once), everything else seems also correct… the data should not be the problem (tested it from entries 1-9999 and also from 10000-19999). I also changed the script timeout in the settings to 500000. Are there any other settings (e.g. where I can set a limit of rows to be imported)???

What is kind of weird is the following: the error 500 pops up after about 1 second.

Thanks already for your help and best regards

Lara

#2

Hi,
Please check what’s the exact error returned as explained here:

#4

ini_set('memory_limit','16M');

You can increase memory limit (php)

1 Like
#5

oooooooooh daaaaaaaamn sorry for that x) x) x) and thanks :slight_smile:

2 Likes