Data format and transfer help …

This topic contains 4 replies, has 2 voices, and was last updated by  Alex Rollin 5 years, 11 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • #433851

    Mical Johnson
    Expired Member
    Post count: 45

    Hi, we just became members. The objective was to redo our old site http://theinnkeeper.com/ using Geo Dir plugin and theme. Everything looks good on the plugin side. we are confused on how to transport our massive listing data over to the new site with Geo Directory and make it all work together.

    Our old site uses some old Dir management plugin which we are trying to replace. We have a custom post type called ‘Listings’. That’s where all the data is and that has lots and lots of custom fields. But Geo plugin works out of custom post type called ‘Places’ which has a different set of custom fields. Now the questions are:
    1. Is there a to replace ‘Places’ with our ‘Listings’?
    2. Or do we have to import all our ‘Listing’ data into you ‘Places’?
    3. If #2 is correct, then can you suggest how to import all the data into Places? Will it even work, cuz custom fields are not gonna match …?!
    4. if #1 is correct, which will be really great, and what the best way to do that?
    — Do we have to create an identical Custom Post Type as ‘Listings’ (our old one) and then transfer
    the data manually?
    — Or we have to implement Geo’s Custom Post Type extension to create an identical post like
    ‘Listings’ and then manually import the data.
    5. Geo plugin has GD import/export as a menu item. Can you plz explain how that can be helpful in the scenario above?

    Please excuse my ignorance, I’m truly baffled by this project. Any help towards the right direction would be extremely appreciated. I’m including our old site link here so that it gives you a better idea about the project. Also, including some screenshots from the backend. Thanx in advance.

    http://theinnkeeper.com/

    Moose

    #433904

    Alex Rollin
    Moderator
    Post count: 27815

    1. Is there a to replace ‘Places’ with our ‘Listings’?

    Use the options in Geodirectory – Custom Post Types – gd_places – Edit

    2. Or do we have to import all our ‘Listing’ data into you ‘Places’?

    Yes they need to be imported into a GD post type.

    3. If #2 is correct, then can you suggest how to import all the data into Places? Will it even work, cuz custom fields are not gonna match …?!

    The short rundown is:

    1. Configure place custom fields to have the fields you want
    2. Add sample listings with representative data
    3. Export places to places.csv
    4. Without changing the places.csv, merge your data into the places.csv sheet
    5. Check the sheet to make sure all required fields are populated
    6. Save as import.csv
    6. Import import.csv

    4. if #1 is correct, which will be really great, and what the best way to do that?
    — Do we have to create an identical Custom Post Type as ‘Listings’ (our old one) and then transfer
    the data manually?
    — Or we have to implement Geo’s Custom Post Type extension to create an identical post like
    ‘Listings’ and then manually import the data.

    see #3

    5. Geo plugin has GD import/export as a menu item. Can you plz explain how that can be helpful in the scenario above?

    see #3

    For reference:

    https://wpgeodirectory.com/docs/custom-post-types-add-on-overview/
    https://wpgeodirectory.com/docs/core-export/#import
    https://wpgeodirectory.com/docs/core-place-settings/#custom

    Expert help: https://geodirectoryexperts.com

    #434024

    Mical Johnson
    Expired Member
    Post count: 45

    Thanx Alex. Here are a few things I’m having problems with:

    1. What to use to export our Listing data to a .csv file? I mean, do you know of any tool that can do it in a way which is compatible with Geo?

    2. I understand exporting ‘Places’ data to .csv file. But how to merge that data with our data? We do have over 5000 listings with images … in that case, how to handle the images, manually?

    3. Our Listing data is also attached to membership info … not sure how to handle that either … but I guess, we need to handle one thing at a time. Any input on this will be helpful.

    4. Our listing data is from all over the U.S. and also have some global data. I guess we need a multi-location add-on?

    5. You mentioned that an expert can help us with that, but where to find the expert and how much that might cost us, any idea?

    Plz, help! Thanx in advance.

    Moose

    #434030

    Mical Johnson
    Expired Member
    Post count: 45

    Hi Alex,

    I was just looking into the Custom Post Type add-on. Do you think,

    1. It is possible to create a CPT which is identical to our ‘Listing’ and load up our data under that CPT?
    2. Does ‘Places’ always have to be primary in Geo Dir? Can a new CPT created by CPT addon be the primary post type?

    3. What you think about this idea … how about if we change the CPT ‘Places’ to look like our ‘Listing’, I mean by replacing all the taxonomies and custom fields and then load up some data to test it … how do you think that will impact the frontend look and feel … just brainstorming here … cuz I AM LOST!!

    #434035

    Alex Rollin
    Moderator
    Post count: 27815

    1. What to use to export our Listing data to a .csv file? I mean, do you know of any tool that can do it in a way which is compatible with Geo?

    You could try WP all import, or contact a developer to help with either another plugin or direct export from the database if necessary.

    2. I understand exporting ‘Places’ data to .csv file. But how to merge that data with our data? We do have over 5000 listings with images … in that case, how to handle the images, manually?

    Copy/paste from your source into the correct columns in the GD CSV.
    Listings images are entered into the images columns as filenames. On import the importer will inform you about the folder location where images should be placed.

    3. Our Listing data is also attached to membership info … not sure how to handle that either … but I guess, we need to handle one thing at a time. Any input on this will be helpful.

    GeoDirectory doesn’t have membership features, you may need a membership plugin for that.

    4. Our listing data is from all over the U.S. and also have some global data. I guess we need a multi-location add-on?

    Yes, definitely.

    5. You mentioned that an expert can help us with that, but where to find the expert and how much that might cost us, any idea?

    https://geodirectoryexperts.com

    I was just looking into the Custom Post Type add-on. Do you think,

    1. It is possible to create a CPT which is identical to our ‘Listing’ and load up our data under that CPT?

    Yes, or something close to it if you are using the same types of fields provided in the Place Settings – Custom Fields tab.

    2. Does ‘Places’ always have to be primary in Geo Dir? Can a new CPT created by CPT addon be the primary post type?

    It is what is used in the free plugin, but you can rename it or skip using it. It is highly configurable when the CPT addon is installed. Any CPT can be ‘primary’ in that sense.

    3. What you think about this idea … how about if we change the CPT ‘Places’ to look like our ‘Listing’, I mean by replacing all the taxonomies and custom fields and then load up some data to test it … how do you think that will impact the frontend look and feel … just brainstorming here … cuz I AM LOST!!

    Yes, or make a new CPT and do the same thing. I would recommend setup of a test site with the free plugin plus Location Manager to try out adding custom fields to emulate your current listing form.

Viewing 5 posts - 1 through 5 (of 5 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket