Event import only 41 events

Hi!

The import tool itself have no limits. Probably your server quits so you may want to check with your hosting provider if it’s possible to increase PHP max upload limit, execution time and memory limit

Kind Regards,
-Roch

Thanks Roch,

I have modified PHP.ini so that

max_execution_time = 300
memory_limit = 128M
post_max_size = 32M
upload_max_filesize = 32M

and confirmed that is this now active, but I still cannot import more than 41 events.

Do you have any other suggestions?

Some extra info:

There is no problem uploading the full file, all events are displayed in the import event table.

However, once I click on Import Events, only the first 83 lines are read from the csv file (including the header line). This means that the maximum number of games able to be imported is 41, less games are imported if any of the games have players stats included.

Can anyone else replicate this issue? I don’t think this is a server config problem.

Hi!

That’s a rather weird issue. I’m thinking now that this could be an issue with the file itself. Could you upload it in your site and send us a link to it?

Kind Regards,
-Roch

I’ve tried it with a few different files, including just copying down the sample file a few times to bump over the limit.

I can see in Developer Tools that the entire table and all lines are POSTED to the import function.

It may still be a server issue, but I can’t see where.

I can only import the first 29 games from this file.
https://s3-ap-southeast-2.amazonaws.com/sydney-downloads/FutsalOz/tmp/events-sample1.csv

Roch, FYI.

It was a PHP.ini config issue,

max_input_vars was set to 1000 which limited the size of the array that could be passed from the input table.

Increasing max_input_vars to some larger number fixes the problem.

Hi

Oh, I missed the input vars indeed. Thanks a lot for sharing, I’ll make sure to add this to our checklist next time!

I’m glad it’s resolved!

Please, let us know if you need anything else.

Kind Regards,
-Roch

Just closing this one!

Kind Regards,
-Roch

Hi,
I’m having the same challenge with my league. I have a CSV file of 81 lines – 40 games and a header. The file itself is only 3kb in size. When I import the file, all the 81 lines show up in the preview but after choosing the Competition and Season, only 20 games show up. It actually only pulls the first 40 lines of the CSV file so the 20th game only shows 1 team instead of 2.

I’ve never dealt with the php.ini file before. Found some videos online but can’t seem to get it right.

I’ve added php.ini in my wp-admin folder and the file says

max_input_vars = 5000;

I’ve got back to import the schedule again but it still only imports 20 games even though it gives me the preview for all of them. I figured it didn’t make sense to start a new thread for the exact same problem but hoped getting the answer here would also help others who might have the same challenge.

The site is currently here while I’m building it. You see the schedule on page 2 only lists 1 team for the last game
https://eagleeyeearl.com/softball/schedule/

Thanks