Unable to import via csv file

Hi, this is still occurring, is anyone able to advise ? Regards, Dave

Hi @daveatcos,

Apologies for the delay here as we are experiencing a higher load in support.

We recently released version 6.0.1, could you try updating it and see if the issue still persists?

Moreover, I’m curious what plugin are you using to import Event Data?

Please do keep me posted.

Best,
Abz

Hi Abz, apologies for the delay in replying

We are now using 6.0.1.1 and the issue still exits.

As far as I can see the import is being done (or attempted) via The Events Calendar own import facility rather than a seperate plugin.

Regards
Dave

Hi @daveatcos, no worries, and sorry to hear about this. I see, the CSV Import tool is included with The Events Calendar.

The following fields are required for a successful import:
Event Start Date

I suspect it could be the format, would be good to retry the migration. I’d suggest reverting back to the old version of the plugin pre-v6.0 and then trying migrating it with the event data.

Please test it out on a staging site before trying it out on your main website.

Let me know how it goes.

Best,
Abz

Hi @daveatcos, I would also reach out to our team and check with them regarding this. I’d get back to you as soon as I hear from them.

Hang in there.

Best,
Abz

Hi Abz

I don’t believe it is a format issue as the same csv imports fine on our main site and has done so for all previous versions of The Events Calendar. Both sites are currently running 6.0.1.1

The site where the problem exists is our test site and I need to get a lot of data into it in order to test the migration to the new database. I have never tried a csv import into this site before recently, so I have to assume that it has probably never worked on this site.

I have retried the same csv and other csv files several times, the same result

Regards
Dave

Hi @daveatcos,

Thanks for confirming, it seems like you haven’t tried the CSV import before. Let’s see.

In the test site, could you try installing this extension and get the test data → https://theeventscalendar.com/extensions/test-data-generator/. This is an automated tool to generate high-quality, life-like data. In this way, you could test it out.

Let me know how it goes.

Best,
Abz

Hi Abz

I have used the test data generator and that was successful.

However, I have now found the cause of the problem. When I tried importing the csv files again, I noted in the preview window that some of the fields were set to “Do not import” at the dropdown and populating those fixed it.

Apologies for my not noticing this before and thank you for all your efforts in trying to help me fix the issue which can now be closed.

Best wishes
Dave

Hi @daveatcos, nice. I thought it was weird. Good to know that helped you identify and resolve the issue. Please do not worry about it we’re here to help.

If you have some time to review, that would be amazing!
https://www.ads-software.com/support/plugin/the-events-calendar/reviews/

I’d be closing this thread and please do not hesitate to bump a new ticket on our way. This is for us to track down topics/issues efficiently and for us to follow the WordPress Forum Guidelines.

Have a great day!

Best,
Abz