GeoNames Forum

Guys, please, i need help.
I created all those necessary tables in my bd and everything, but i can`t reach to insert txt file...
The data in this txt file is not divided in rows, so, i tried to divide it in rows, but i can`t , cause when there are two words (ex. St. San Francisco) it inserts it in different rows, as i gave to my program a "space" as a parameter of division of rows. I also tried Navicat, but the same thing happens.. it wether inserts every word to different row or all the txt into one row.
And i haven`t even tried futher action as i couldn`t import that data.
I`ve read all those manuals, but my problem persists...
Can anybody explain me step-by-step how to make it work and what program should i use???
i`m new in all this...
Thank you.

Hi Alex

Why did you use 'space' as column delimiter? The geonames dump files use tabulator '\t'.

Cheers

Marc

Hi, marc.
These are the steps i follow to insert it using Navicat:
1) select table (geonames in this case)
2) i call import wizard and tell it to import txt file
3) select the root of the file and encoding: 65001 (UTF-

4) option: delimited, field delimiter: tab,
record separator (predetermined):CRLF, text qualifier: "
5) then i have additional options like:
first row:1
last row:17 (as i have 17rows in geonames table)
field name row:1 (predetermined)
date order: YMD
date delimiter:-
time delimiter: :
decimal symbol: ,
6) here it gives me sourse table and target table, after that i do "Next" and it hangs on.... nothing happening after this.. "This program doesn`t response"
I think maybe one of the options is wrong so that it can`t find how to make it and denies this action.

Hi Alex

I am afraid I don't know anything about Navicat. You should try reading the documentation for Navicat or use the mysql tool 'load data'.
What is a little bit strange for point 6 is to ask for a source table if you want to do a file import.

Cheers

Marc