Updating some entries with CSV file, has breaks map functionalities

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

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

Open Support Ticket
  • Author
    Posts
  • September 21, 2017 at 10:20 am #396738

    Giorgio Draghetti
    Expired Member
    Post count: 14

    I tried two times to be shure.
    The original file was exported from GD.
    The entries where selected and updated in two fields:
    – is_featured
    – geolocalization (copied from similar listings)
    The csv file with modified entries was imported without errors

    but now the maps are not anymore working.

    September 21, 2017 at 10:22 am #396740

    Giorgio Draghetti
    Expired Member
    Post count: 14
    This reply has been marked as private.
    September 21, 2017 at 11:49 am #396753

    Guust
    Moderator
    Post count: 29970

    There cannot be any author with ID of “0”.
    Latitude and longitude have to be decimal.

    Thanks

    September 22, 2017 at 8:38 am #396898

    Giorgio Draghetti
    Expired Member
    Post count: 14

    Thanks for this.
    I will try as soon as i find a way to correct the “numbers” problems reported here.
    I think the import/export functionalities needs some adjustments:
    IMPORT
    – My first data was imported from CSV with no data in Author field. ‘0’ was created by the GD import routine. If ‘0’ is not supported, please, assign a valid code in import
    – if some data can’t be interpreted, import must fail and do not corrupt the item data
    EXPORT
    – custom fields needs to be defined as “text” in csv (include value in text delimiters) since if you don’t specify “text”, any number code you insert (zip code and phone number included), will be interpreted as “number” by all softwares and ‘0’ digits at the very beginning of the code will be eliminated.

    September 22, 2017 at 11:09 am #396906

    Guust
    Moderator
    Post count: 29970

    The instructions are at https://wpgeodirectory.com/docs/core-export/ and should be clear enough:

    These are the mandatory fields for listings:
    post_author: the WordPress ID of the WP user, for example you can use 1 for the first admin account created
    …
    post_latitude: latitude in signed degrees format, for example -20.97625669
    post_longitude: longitude in signed degrees format, for example 162.45444

    CSV files should only be edited with OpenOffice or LibreOffice Calc [that takes care of any “text” issues]

    Thanks

  • Author
    Posts
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
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount