500 Error for CSV upload

Howdy Anne,

I would love to help you with this.

That is certainly strange, I can’t recall seeing that issue before.

Would you mind sharing the CSV file that you are trying to upload? Perhaps there is something in the CSV itself that is causing this glitch. If you would like to keep the CSV file just between you and my team, check the box “set as private reply” in your next response.

Are you able to upload this text CSV file without getting an error? This file was generated by a mock data program. There are three events, each in January 2017 and all have the event category “Test” assigned to them: the-events-calendar-mock-data-generator-events

With that info in hand I should be able to better understand this issue. Cheers!

– Brook

Howdy Anne Marie,

Sorry for the holiday delay. I hope you had a wonderful one. Our team is getting back and in full swing.

I just tried downloading that CSV, it said it was a private file. So I requested access. Once access is granted I can download and give it a whirl.

Cheers!

– Brook

Thank you very much!

I think I see the issue now. There is over 1 million rows in this CSV. There are 31 rows at the top with real venues, then 1,048,542 blank rows that look like this:

,,,,

Then one more row at the very bottom for Dover Downs.

Our importer is going to have trouble parsing 1 million venues at a time. But you probably only meant to import ~30, and it can handle 30 easily.

Are you exporting these from Excel? If so, could you try sorting the columns? This will move blanks rows to the bottom. Ordinarily Excel won’t output blank rows in a CSV, because it has a near infinite number of them. But, when there are a few blank rows, then some actual data, it will output any blank rows in between. Thus by simply sorting this, and moving all data to the top, it will only output the 32 actual rows.

Does that all make sense? Will that work for you? Please let me know.

Cheers!

– Brook

Howdy Again,

Good question. I am using Notepad++. It is ugly, but very useful. One of the benefits is that it can handle text files with hundreds of  thousands of lines. Most notepad programs are not designed to handle such monstrous files.

If you are not seeing the final line of the test file, I bet your notepad program halts long before hitting the real bottom of the CSV file. It thus stops your computer from crashing, but also means you will not see the full file.

Cheers!

– Brook

Excellent news! Thanks for getting back.

– Brook