Import CSV with existing ID

[Massimiliano Sgarra]

Hi, we have about 300 WordPress article on our site. We want this article will be transformed in “Events” managed by your great plugin.

We already have a CSV with all the info required but also we have on this CSV the ACTUAL ID of every article. For many SEO reason we need that the import create the events with the same id set on CSV.

It’s possible with your PRO version ??? Have you an another tips for us ?? An add-onn ???

Tnx a lot, reply ASAP PLS.
Max

[Josh]

Hey Max,

Thanks for reaching out to us!

This is definitely an interesting question. By default, our importer doesn’t take event ID into account when importing from a CSV file. You could potentially manipulate the import code to make it work for this scenario but that type of customization would be beyond the scope of what we would be able to provide here in support.

An alternative may be to manually change the “post_type” of all the posts in your database to be “tribe_events” and then use the “add_post_meta” function to add all the necessary details for the event without having to manually update every single event.

Let me know if this helps.

Thank!

[simon]

“to add all the necessary details for the event without having to manually update every single event.”

please can you expand on how this works in more plain english (i’ve read the linked wordpress page) but it’s still not clear to me

ie – could this function be used to create a template style event page where event data could imported via csv? And the data appears in set positions on the event page. Thus saving the need to go through and manually adjust each event entry?

[Massimiliano Sgarra]

Great, tnx a lot…just last question…

Instead if i need to import also the “slug” of an event is possible in any mode ????

Tnx a lot,
Max

[Josh]

Hey Simon,

The “add_post_meta()” function allows you to take all the necessary key/value pairs for the meta data and import them directly rather than having to go to the post and manually set all the information. However, you are still dealing with a limited efficiency with this approach. I’m not sure I’m fully following the scenario you’re describing in your example.

Also, if you have a follow up, we ask that you open a new thread. This allows us to give each user and issue the full attention it deserves.

Massimiliano,

An alternative would be to use another CSV import tool such as http://wphostreviews.com/product/turbocsv. I’m not sure when this plugin was last updated, however the last time I used it I know it did have an option for recognizing the post ID and updating those posts rather than overwriting them.

You can set the post slug by using the “post_name” meta, however it won’t work as an alternative to using the ID with the built in importer.

Let me know if this helps.

Thanks!

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts