[Donald]

Hello Cici, thanks for your response. I think that I have it! I imported the comma delimited csv file into Excel as a column file, then re-exported out as a csv. I uploaded it and it worked!

[Donald]

Halelujiah, I think I got it! Apparently there were hidden spaces in the excel file that would not show up until it got into the tab delineated format. It took quite a bit of running around to figure it out — converted the excel to csv, then opened the csv in TextEdit (mac) to view w the commas. Did a search for all the the commas and quote marks.

Then for some reason, I couldn’t bulk delete all of the locations at one time (728 locations). It would give me a random number of locations to delete at one time (sometimes 50, sometimes 2, etc). Finally got over that hump. Then it gave me a geo coding error — which I worked out.

All seems to be good to go. Thanks VERY much Cici!!!

[Donald]

Thanks for responding. Here is what is so odd — the Big A is not one of the problem locations — it has an address. And those characters are NOT in my excel file — they only appear when converted to csv file. And why are all of the locations in and around Alabama — even though I have cross-referenced w Google.

[Donald]

I have tried removing anything that appears to be an issue — no change. I have noticed that nearly all of the locations are in Alabama — not ALL of the locations, but nearly all? I cross-referenced with Google — actually typed the name the same way they are in google maps and still not coming up.

Attachments:

You must be logged in to view attached files.

[Author]

Posts