Need help fixing a data import

This topic contains 3 replies, has 2 voices, and was last updated by  Paolo 6 years, 10 months ago.

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • June 21, 2017 at 4:05 pm #384234

    Joe Oliveri
    Expired Member
    Post count: 4

    I imported over 2,000 records and I had a comma after the city name.
    Now the data shows up in the system with 2x commas.

    for example

    200 Any street Albany,,New York, United States

    Is there any way to safely search “,” and replace with ” ” (since you already append a comma onto the result)

    I have better search and replace installed but have no idea which table to look in.

    Thanks again,
    Joe

    June 21, 2017 at 9:28 pm #384263

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    you’ll need to search in the pos_city column of the wp_geodir_gd_place_detail table and the city column in the wp_geodir_post_locations table.

    Thanks

    June 22, 2017 at 11:55 am #384318

    Joe Oliveri
    Expired Member
    Post count: 4

    Thank you for the help.. it is appreciated.

    I also found another method, if anyone is interested.

    I simply exported the database using your export tool, made the modification in the CSV file

    (post_city) Find and replace “,” with “” and re-imported the table using the Update listing if post with post_id already exists option.

    Looks like it worked like a charm!

    Thanks again for your prompt reply!

    June 22, 2017 at 5:30 pm #384364

    Paolo
    Site Admin
    Post count: 31206

    Yes that was actually the best alternative … thanks for sharing 🙂

  • Author
    Posts
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