Import / Export

This topic contains 24 replies, has 3 voices, and was last updated by  Paolo 8 years ago.

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

Open Support Ticket
  • Author
    Posts
  • February 20, 2017 at 4:50 pm #362692

    Joanne Lord
    Expired Member
    Post count: 85

    I’d like to export some listings from places/accommodation into (cpt) accommodation/hotel.
    Is it possible to only export certain listings, as not all my ‘places’ listings are hotels.

    February 20, 2017 at 10:34 pm #362752

    Paolo
    Site Admin
    Post count: 31211

    Hi,

    you’ll need to export all the Places and change the CPT name only for the listings needed. Re-import and only the edited listings will be updated.

    Thanks

    February 21, 2017 at 1:12 pm #362835

    Joanne Lord
    Expired Member
    Post count: 85

    thanks

    February 21, 2017 at 2:21 pm #362863

    Joanne Lord
    Expired Member
    Post count: 85

    oh blimey, that’s a lot of data all over the place.
    Ive opened the csv file with openoffice. Do you have any tips for viewing the data?
    I cant work out whats what!

    February 21, 2017 at 5:36 pm #362925

    Paolo
    Site Admin
    Post count: 31211

    in the image attached you can see how it should look like. Each column has a heading and below there is the corresponding data.

    Is this how you see your file? If not, it means that you are not opening as a CSV (comma separated). You are probably using tab or semicolon as data delimiter.

    You can set that while opening the file, see the 2nd image attached.

    Let us know,

    Thanks

    February 21, 2017 at 7:16 pm #362963

    Joanne Lord
    Expired Member
    Post count: 85

    that worked brill, thanks Paolo.

    I want to import into cpt ‘petrol stations’ and already have GD places/petrol stations.
    Also, I already have GD places accommodation and want to import into cpt accommodation/hotels
    So, how do I make sure the data is imported to the right table?
    Do I have to delete all existing data?

    February 21, 2017 at 7:22 pm #362969

    Paolo
    Site Admin
    Post count: 31211

    Hi,

    each custom post type has different CPT name. gd_place is the default. Al lthe other have name that start with gd_ and the name you assigned.

    You need to change the post_type column from one to the other according to your needs.

    Thanks

    February 21, 2017 at 8:14 pm #362991

    Joanne Lord
    Expired Member
    Post count: 85

    just the post type column or do I need to edit post category and default category too, as these are also different.

    February 21, 2017 at 9:04 pm #363004

    Joanne Lord
    Expired Member
    Post count: 85

    would it be possible to delete all the categories and add them manually from the backend?
    Just thinking I don’t know the correct wording to enter

    February 21, 2017 at 9:33 pm #363013

    Paolo
    Site Admin
    Post count: 31211

    Hi,

    yes you must enter the correct categories and default category too.

    It’s best if you do it before importing. Wording to be use is the category name.

    Thanks

    February 21, 2017 at 10:05 pm #363025

    Joanne Lord
    Expired Member
    Post count: 85

    ok thank you

    Ive run into a problem

    default category entries for ‘Places To Eat’ keeps reverting to ‘Places To eat’ (with a small e)

    February 21, 2017 at 10:57 pm #363039

    Joanne Lord
    Expired Member
    Post count: 85

    oh heck, now its asking if I want to save in ODF format or keep the current (which it says may not be compatible with csv)

    February 22, 2017 at 10:03 am #363094

    Guust
    Moderator
    Post count: 29970

    Always use CSV, you can ignore that message.

    February 22, 2017 at 12:02 pm #363113

    Joanne Lord
    Expired Member
    Post count: 85

    default category entries for ‘Places To Eat’ keeps reverting to ‘Places To eat’ (with a small e)
    will it matter?

    February 22, 2017 at 12:16 pm #363114

    Guust
    Moderator
    Post count: 29970

    You should be able to edit the category name at Places [or other CPT] > Place [or other CPT] Categories.

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 25 total)

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

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount