problem csv to geodata

[johoo]

i have a problem to convert the csv to geodata
all i'm getting is the input string not correct thing
and i tryed and tryed but i can't get it working

i also saw a german guy here who had the same problem but he got it working only he did not wrote the answer about what he did

can somebody look into it because i have no idea anymore

http://www.sendspace.com/file/btulzn
here is my file
it didn't upload on dcemu so i used sendspace

i also found this:
Yes, the CSV is ; not , delimited (makes sense since decimal point is decimal coma), redownload http://www.in7ane.com/psp/gmdl0.4.17a.zip and check the CSV is delimited by ;... checkbox

i know my file got the ; but when i check the ; it gives me the same error

[Codaz]

Get GMDL 0.501 from here.

It solves a LOT of problems with CSV geodata:

http://www.in7ane.com/psp/gmdl0.5.01b.zip

[johoo]

hi codaz
thnx for the help

i have that version of gmdl and stil no luck
i also tried different versions without luck

something is wrong with it but i can't find out what

the only thing i can think of is that the csv isn't convert correct in excel

i don't know anymore,i'm out of options

[in7ane]

The CSV seems to be formatted in a strange way:

LONG;LAT;FULL_NAME;;;;;;;;;;;;;;;;;;;;;;;
3.583.333;51.45;1e Binnenhaven;;;;;;;;;;;;;;;;;;;;;;;
6.966.667;52.95;1e Exlo?½rmond;;;;;;;;;;;;;;;;;;;;;;;
4.35;51.883.333;1e Petroleumhaven;;;;;;;;;;;;;;;;;;;;;;;

3.583.333 for example is not a valid longitude (I guess 3.583333 ? if so http://www.in7ane.com/psp/gmdl0.5.02a.zip will now parse it that way).

[waichai]

@johoo
after converting from csv to geodata and
try to switch the first column and second column
for example:
!IMAGE:bk.png,
51.609705,7.507323,Burger King,,

to

7.507323,51.609705,Burger King,,

[johoo]

hi waichai

i tryed it but stil not de correct string

i thought it was excel because i have a 2003 version
but yesterday i used a friends computer and he had the latest version of excel
but stil the same

i dont know it anymore

hi in7ane

i just got the txt file from google
maybe the file isn't correct in the first place
i go look into it
thnx for the help, now i know whats wrong with it

edit: just looked at the txt file and that one doesn't have a dot 3.583333 and when converted to csv it got a dot 3.583.333
so it must be excel
but for now i don't know how thats possible
for now i have something to go on and i'm getting some closer to the sollution

oh yes yes yes i did it
i know now what the problem is

For example (the NZ txt extract), open Excel, open the txt, leave the import on Delimited, with Tab, on the finish screen press advance and make sure the thousant thing is off and its okeand Finish, select all cells except the header row, and sort AtoZ (this eliminates the empty rows). Re-arrange the columns as follows: LONG, LAT, FULL_NAME and delete the others. Save-as a csv (Yes to keeping in the CSV format).

thnx in7ane for giving the right direction