Support » Fixing WordPress » Export Posts then Re-import with changes, possible?

  • Resolved MCM


    I would like to export all my posts (custom posts actually) as say CSV FILE FORMAT, including there custom fields, I would like to then MASS EDIT them.

    On importing them, I would like it to UPDATE (the existing posts) with the data changes and possibly one or two more custom fields.

    Is this even possible?

Viewing 8 replies - 1 through 8 (of 8 total)
  • It is possible but may not be a ‘beginner’ project, especially the part about adding custom fields. Can yo tell me exactly what you need to edit and why?

    Definitely not a beginner project. Probably possible using mysql. Can’t help you with this but one advice: take back-up before doing anything.

    Actually, I think there may be a couple of circumstances/techniques that might allow a beginner to pull this off. I have to test my suspicions before suggesting anything though. I’d rather see if there is a better way though– like MySQL replace() or something.

    Thanks, well in short I have hundreds – actually I think thousands) of custom posts that have geo_address field (post_meta) populated.

    However, I do not have the lat/long and to manually update these would be a nightmare.

    1. I found this great plugin that can geocode these posts for me, so I played around and figured that if I could just have a copy of my posts in a CSV format,

    2. I could import into this plugin (simplemap locations) and then have it geocode then upload again to my website with those two extra fields (geo_latititude and geo_longitude),


    3. geomashup can update its fields and bang the maps work.

    I have tried and tested steps 2 and 3 as I am about to upload a CSV file now that I prepared but these posts are not on the website so it is new.

    I would like to export my current posts, perform steps 2 and re-load then do step 3.

    What kind of plugin does the geocoding? A WordPress plugin? If that is the case you could probably do this in place, either by

    1. Building a loop that runs once, checks your posts, geocodes and adds the fields via the plugin.
    2. Or checks the post on page load (front end and/or backend) and adds the geocoding information if and only if the post doesn’t already have it.

    I’d favor the first option but you could get execution timeouts.

    IF I come with something, will post here.

    IF I come with something, will post here.

    Never found a way to do this, thanks all.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Export Posts then Re-import with changes, possible?’ is closed to new replies.