Example Database Xcel Document

This topic contains 23 replies, has 4 voices, and was last updated by  Guust 7 years, 11 months ago.

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

Open Support Ticket
  • Author
    Posts
  • May 19, 2016 at 6:29 am #194038

    Thomas Hutton
    Free User
    Post count: 99

    Hi There…

    Our website will have a database of literally hundreds (poss thousands) of entries to add, all of which are in an excel document.

    I know GEODIRECTORY supports population of entries through an excel.csv but we want to test using one of your supported examples so we can marry up the fields / columns etc.

    We’re stumbling around the support forum trying to find the example .csv you supply but cannot find it… could you please send one or the link to please.

    Plus any info or links on how to make the process go smoothly would be great also.

    many thanks
    Tom

    May 19, 2016 at 6:46 am #194041

    Kor
    Moderator
    Post count: 16516

    Hi Thomas,

    I’ve just exported my GD data to a .csv file and attached it in this reply. Could you please check on it and see if it’s what you’re looking for? Check out this section of the documentation for more info about importing/exporting in GD https://wpgeodirectory.com/docs/core-export/ . I hope it helps.

    Thanks!

    May 19, 2016 at 12:46 pm #194199

    Guust
    Moderator
    Post count: 29970

    Best practice is to set up your custom fields, price packages, categories etc.
    Then add a couple of listings from the frontend.
    Then go to GD > Export and Import, and export your listings.
    You will have the perfect CSV file, ready with all custom fields and ordered exactly correctly.

    May 23, 2016 at 2:26 pm #196570

    Thomas Hutton
    Free User
    Post count: 99

    Hi Guys,
    Ok, thanks for the advise…

    BUT… we’re having trouble importing DB’s using the import feature: GD IMPORT & EXPORT CSV

    After many attempts adapting the clients data and failing we even tried exporting a current DB and simply re-importing the identical DB which resulted in errors (see attached grab).

    The screen grab attached is the result an an identical DB being exported and then imported. The only difference being it’s file name.

    Please advise?

    Thank you

    May 23, 2016 at 5:12 pm #196668

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    please provide a link and admin credentials in a private reply and we will have a look.

    Thanks

    May 24, 2016 at 7:02 am #197066

    Thomas Hutton
    Free User
    Post count: 99
    This reply has been marked as private.
    May 24, 2016 at 7:12 am #197068

    Guust
    Moderator
    Post count: 29970

    The file is semi-colon separated instead of comma separated.

    May 24, 2016 at 8:41 am #197087

    Thomas Hutton
    Free User
    Post count: 99

    Hello,

    Sorry to sound ‘thick’ but we cannot see any semi-colons in this file name (below)?

    gd_pet_shops_2405160701.csv

    Please advise what you mean?

    Thank you
    LT

    May 24, 2016 at 8:59 am #197092

    Guust
    Moderator
    Post count: 29970

    Mmmm, you’re right.
    I had re-saved it and successfully uploaded it to your site, that is why I thought that was the problem.
    I had no problem uploading the file at all, all 8 listings were imported but I deleted them again.

    May 24, 2016 at 9:37 am #197095

    Thomas Hutton
    Free User
    Post count: 99

    Hello,

    OK, We also managed a successful import of the same file.

    So we went back to our original task of attempting to upload a revised file, which errors.

    Is it imperative that the Lat, Long Co-ords are present on the DB?

    Please see attached modified file.

    Thank you
    LT

    May 24, 2016 at 9:44 am #197099

    Guust
    Moderator
    Post count: 29970

    That one will not work, you are missing city, lat and lng

    See https://wpgeodirectory.com/docs/core-export/#mandatory

    May 24, 2016 at 9:47 am #197100

    Thomas Hutton
    Free User
    Post count: 99

    That’s what we were afraid of. The client has over 3,000 entries to load.

    Can you think of anyway the lat’ long could be achieved via the postcode?

    Thank you
    LT

    May 24, 2016 at 9:50 am #197102

    Guust
    Moderator
    Post count: 29970

    Have a look at https://wpgeodirectory.com/docs/core-export/#batch

    May 24, 2016 at 10:03 am #197104

    Thomas Hutton
    Free User
    Post count: 99

    Hello,

    Please see the attached. It’s an exact duplicate of the exported DB apart from the final entry which has been added for testing we get the following error.

    Total 9 item(s) found.

    7 / 9 item(s) updated.

    1 / 9 item(s) added.

    1 / 9 item(s) could not be added due to blank title/invalid post type.

    Please advise?

    Thank you
    LT

    May 24, 2016 at 10:09 am #197108

    Guust
    Moderator
    Post count: 29970

    There is no listing with ID 12000 to update is there?

    https://wpgeodirectory.com/docs/core-export/#import
    Do NOT add a post_id when importing new listings; WP needs to create its own post_id to avoid database conflicts.

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

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

Open Support Ticket