#2 Aug 28, 2016 17:54
Can you attach the CSV file so we can debug this more easily?
Why are you using fake postcodes?
File attached. Cheers.
The data source I used only had the city names and region codes. I just filled the postcode column so it's not empty. I don't really need the postcode, bigger cities have more than one anyway and I wouldn't want to log them serveral times. Tbh, I intend to provide users with the chance to enter their address via the respective user fields. I'm just thinking that this in-built selection of city etc. might make it easier for me (well... the IT guy) later on to create stats on where my users reside. In addition, the fields in the Identity section can't be hidden in the user profile as far as I can see. So I might as well use some of them.
It won't let me attache the file.
"Couldn't attach selected file:«cities.csv» has an unrecognized extension."
I just authorized CSV, sorry about that; can you please try again? Thanks.
take 2 ;)
Any progress on this one? I have tried again by entering the data differently. But it always comes back with the same error. It forces the content from all the columns into the one "post code" field and then says that the entry is too long for this field.
@bluesteens try using semicolon as fields separator, it will work.
OK, that got the cities in. Thanks mgsolipa!
However, it didn't recognise the region code, which I had typed exactly as in the Regions editor, e.g. sco for Scotland. So, the cities were linked only to the country, but not the region. As long as the regions were still defined, the cities didn't appear in the drop-down of the user profile. I had to delete the regions in the editor, so that the cities become visible in the drop-down.