Importing Event regularly using WP All-Import

[Nickolas]

Greetings

I followed the development here : https://theeventscalendar.com/support/forums/topic/show-all-events-calendar-community-events-fields/#dl_post-990277
and I have a question…

I am also using WP all import (for multiple reasons, schedule imports being one, easy mapping of XML incoming data another, downloading of images a third…) to import my events that comes from a third party. I use my own PHP script to parse out the incoming data (that are JSON formatted) and keep what I want and output me a nice XML import-friendly file.

From what I could understand, you need to import Venues separately from Events (in order for Events to have a “VenuesID” set in their custom fields). I did that and the Venues import worked fine (at least, from what I could see).

I am currently stuck on a weird issue. I want to schedule a cron job to update the list of events, but the importation seems to update only a single event instead of going through the list.

tl;dr: I know you cannot support third parties, and I understand this part. But is there a specific format for importing properly? I have mapped my XML fields to the meta (https://theeventscalendar.com/knowledgebase/wordpress-post-meta-data/)…
Should I try using the Importer addon instead?

[Brian]

Hi,

Thanks for using our plugins. I can try to help out, but I am limited as you said.

What is the cron running to import the xml file?

Is that the standard WordPress import with xml?

Let me know and I can try to help out.

Thanks

[Nickolas]

I’ll be using the cron provided with WP All import docs when you want to schedule it. Basically a ‘wget -q -O /dev/null “http://mywebsite.com/wp-cron.php?import_key=KEYHERE&import_id=2&action=trigger”‘. Nothing much there.

I’m thinking it may be the XML file. I’m not using the WordPress standard Import XML. I can give you a link to it if you want. I’ll look up WordPress “standards” and see if I’m missing any important stuff… though from the test I made, it could be having to do with custom fields – without any fields, the import worked fine, but importing an event with no dates makes no sense.

[Nickolas]

This reply is private.

[Brian]

Ok so it is the WordPress Cron.

I think it could be the XML format, however, I am not really sure as we have not tried to do it this way.

Our CSV importer does update existing events, but that is a manual process.

The iCal Importer does update events too in the recurring imports.

However, I do not have much else for WP All-Import.

Not sure what else I can provide, but let me know.

[Nickolas]

Upon contact of WP All Import, and not changing anything, it suddenly started working and I could no longer replicate that 4 day issue. I still have no clue as of why it suddenly got to work… Hopefully it will keep working without failing.

From there, I could confirm that the mapping (using meta’s and custom fields) worked fine. I still need a way to figure out how to get the Venue’s Post ID within the XML generation (suggestion anyone?) but that’s my side of the problem! 😛

Thanks for looking up the XML for me.

• This reply was modified 10 years, 7 months ago by Nickolas.

[Brian]

Great glad it is working now for whatever you did.

Since this is marked resolved I am going to close this ticket, but if you need anything else related to this topic or another please post a new topic on the forum and we can help you out.

Thanks

[Author]

Posts