Exporting data

[mcmsadmin]

Is it possible to export data from the organizer, venue, and event tables in CSV format?

[Barry]

Hi!

I’m afraid that – right now – there are no tools baked into the plugin itself to help with this, but you are certainly welcome to request this as a future feature (or add your support to any suitable existing requests along these lines):

tribe.uservoice.com

Thanks 🙂

[screenrage]

I was able to do this via the standard WordPress export function (under Tools). You can export to XML, then load the file into Excel to a database for further cleanup. You can specify if you want custom posts exported or standard post types.

In Excel I used a pivot table to get a list of all venues without doing any manipulation. I was also able to see all my venues and which ones were missing data (such as google maps coordinates etc).

This is not the best method but that is all we have really.

[screenrage]

correction;

…then load the file into Excel OR a database

[Barry]

Great to hear you figured out a solution, screenrage – even if it was slightly awkward. We’ll definitely look into building out better tools for this as more support for this is shown.

Thanks again!

[Author]

Posts