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