City selection broken after importing csv

This topic contains 3 replies, has 2 voices, and was last updated by  jimmymoto 9 years ago.

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

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • #38787

    jimmymoto
    Full Member
    Post count: 91

    I’ve been experiencing a problem with city selection not working properly after importing my listings (site under development).
    After importing .csv (using GD import CSV tool), everything looks great except that if I edit any listing he city selector is blank and I cannot select the city.
    Furthermore, since “city” is a required field I effectively cannot save any changes to the listing unless I change Multilocation–City–Enable default city.

    fyi. I have some custom fields importing via the database, and am also importing listing expiry dates, “is_featured” binary, and package IDs. All seem to import correctly.

    Also fyi, City selector works fine when adding new listings.

    When checking the geodir_post_locations table in the database, I noticed that the csv import is creating a duplicate set of location ID #’s that do not match the original ID #’s I set up. I’m not sure ho to fix this without breaking the GD map (tried to manually change, but then got “no listings found” on map).

    I’ve also tried re-importing .csv with an added column for “post_location_id” to see if I could force GD to assign existing ID #’s to each listing, but new ID #’s were auto-created again anyways.

    Can you please investigate?

    #38788

    jimmymoto
    Full Member
    Post count: 91
    This reply has been marked as private.
    #38860

    Paolo
    Site Admin
    Post count: 31206

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

    #38901

    jimmymoto
    Full Member
    Post count: 91

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

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

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

Open Support Ticket