40% OFF EVERYTHING
BLACK FRIDAY SALE
Buy Now

Database import issues

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

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

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • December 30, 2016 at 3:32 am #333306

    Israel Medel
    Buyer
    Post count: 21

    Hi, I have some issues with the import of .csv to the database, because it deconfigures the map functionality and I need to import a huge amount of data that I can’t upload one by one from the dashboard.

    Here is a video about the situation, is long because I try to explain all the issues.

    https://www.youtube.com/watch?v=PMTAw9jDEcQ

    I just bought the MultiLocations add-on, but I need your help for make it work as I need.

    In advance, thanks for your help.

    December 30, 2016 at 5:26 am #333326

    Guust
    Moderator
    Post count: 29970

    Sorry, but I am not going to watch a 22 minute video.
    Firstly, I don’t understand why you are even accessing the database at all.
    There is no need for that. If you change things direct in the database, you are bound to break things.

    https://wpgeodirectory.com/docs/core-export/

    Please post URL and admin details in a private reply and a copy of the CSV or part you have trouble with.

    December 30, 2016 at 6:17 am #333330

    Israel Medel
    Buyer
    Post count: 21

    If I for example have 2 listings and export them in .csv and I import that file is not problem, but if I change something like the name of a listing in the .csv file in libreoffice and I import it, the map stop working.

    Here is a (1:11) video.

    https://www.youtube.com/watch?v=Dl9l6MoWqco

    The .csv file is attached.

    December 30, 2016 at 6:36 am #333333

    Guust
    Moderator
    Post count: 29970

    Your lat and lng are not valid, they have commas in them instead of dots.

    December 30, 2016 at 6:55 am #333340

    Israel Medel
    Buyer
    Post count: 21

    That’s it, is working now.

    Thanks.

    (Solved)

    December 30, 2016 at 8:35 am #333344

    Guust
    Moderator
    Post count: 29970

    You’re welcome 🙂

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 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