40% OFF EVERYTHING
BLACK FRIDAY SALE
Buy Now

Upload issues

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

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

Open Support Ticket

Tagged: , ,

  • Author
    Posts
  • June 24, 2016 at 7:24 pm #215425

    jopa123
    Full Member
    Post count: 16

    Sirs,

    I’ve spent a few hours trying to get my spreadsheet in tip top shape. After uploading the file I got the common “item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude)” message.

    Realized I did not have the multilocation addon activated. After activating, I got the same message. Thought it might be that I have city and state in the address field (haven’t fixed that yet).

    Went back to check my spreadsheet and saw that the Post Content column was broken into multiple cells where there were commas.

    Before I go fix all of this by hand, I’d like to understand what I am doing wrong. I am using Open Office and my delimiters are set to :

    Field Delimiter ,
    Text Delimiter ”

    Thanks for any help.

    June 25, 2016 at 8:16 am #215695

    Guust
    Moderator
    Post count: 29970

    The CSV is tab limited, not comma limited.
    You have post_ids, that only works if you want to over-write listings, see https://wpgeodirectory.com/docs/core-export/#import

    June 26, 2016 at 2:40 am #216116

    jopa123
    Full Member
    Post count: 16

    Thanks for the response. A quick follow up question, though. I’m kind of new to Open Office.

    My process was this. I created a dev site on a subfolder. I transferred listings from Geotheme using the guide. After the import, I exported the listings through Geodirectory (csv). I opened using Open OFfice.

    The options when I open have tab and csv delimiters clicked. If I uncheck the tab option, all fields go into one column and have small arrows separating what would have been the individual cells.

    When I save the file and check the edit filters setting, I see no option to remove tab delimiters.

    So my question is how do I save this file as comma limited and not tab limited?

    June 26, 2016 at 1:09 pm #216239

    Guust
    Moderator
    Post count: 29970

    Have a look here: https://wpgeodirectory.com/docs/csv-tips-and-tricks/

    June 28, 2016 at 3:42 am #217299

    jopa123
    Full Member
    Post count: 16

    Guust,

    That worked, thanks. However, I screwed up a little more.

    I got the csv in an acceptable format, straightened all of the cells out, saved in comma limited format, removed post id’s and imported.

    Now I have duplicate place listings (removing the post id’s made GD create a new listing for each). Totally my mistake.

    My next question would be, what is the easiest method to remove duplicates? Should I try this through PhpMyadmin? I’m fairly familiar with that. My biggest concern would be the URLs. The URLs for he “new” listings have a ‘2’ added to the end. I do not want that in the URL if I can help it.

    I apologize for my ignorance.

    June 28, 2016 at 3:57 am #217308

    Guust
    Moderator
    Post count: 29970

    Simplest is to mass delete from the admin backend.
    Filter by date, and bulk delete.
    You can set the number of listings to show per page to 200 or so in the screen options up the top.

    July 8, 2016 at 1:24 am #223645

    jopa123
    Full Member
    Post count: 16

    Just wanted to check back in and thank you for the response. It worked well. Great support. Thank you.

    July 8, 2016 at 1:51 am #223651

    Guust
    Moderator
    Post count: 29970

    You’re welcome 🙂

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