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.