[Loadstone] Importing database problem as it happens to me
milos.przic at gmail.com
Sat May 1 08:41:10 BST 2010
Hi Shawn, it doesn't work. When I do it with the offline tools, I get
Warning: Invalid argument supplied for foreach() in
E:\loadstone\htdocs\tools\poiconv\index.php on line 238
and with the online tools I don't get the error, but get this:
Number of POI's: 0.
Number of UTF-8 corrections: 0.
And when I do the deleting and the stuff I escribed in my previous message I
get the number of pois etc.
So please help me somehow, I don't know what to do anymore, and I need
msn: milos.przic at gmail.com
----- Original Message -----
From: "Shawn Kirkpatrick" <shawn at loadstone-gps.com>
To: <loadstone at loadstone-gps.com>
Sent: Saturday, May 01, 2010 1:29 AM
Subject: Re: [Loadstone] Importing database problem as it happens to me
> If I were to guess at this I'd say you don't need to do all that deleting
> and editing of the geonames file. Just feed it to the poi converter and
> let it handle it. Your editing of the file is probably causing fields to
> get reversed or something.
> On Sat, 1 May 2010, Milos Przic wrote:
>> Hi all,
>> So that's how it happens to me when I try to import the ldb file. Tell
>> me if there is something wrong, or if I should correct something, and I
>> am going to describe everything I do in detail, step by step:
>> 1. I go to the geonames.org site and download the csv file I need.
>> 2. I open the file using notepad as the quotes are not seen when the file
>> is openned using the excel.
>> 3. I delete the first line of the table that says "point id point name
>> latitude longitude", so that the first line is the point id.
>> 4. Then I press the ctrl+h to go to the find and replace option, and in
>> the find field I write the quote sign (").
>> 5. The replace with field remains blank, so that the all quote signs are
>> 6. Then I save the changes to the file.
>> 7. Then I open the loadston poi converter.
>> 8. I input my email address, I select the file and choose the geonames to
>> ldb among the formats in the combo box, and click "submit".
>> 9. I get the exact number of the converted points (more then 0, without
>> any error), and click the download file link.
>> 10. I move the resulting ldb file in the inportexport folder in my phone.
>> 11. I make a new database in order not to manage the default database.
>> 12. I import the file, and get the messages that the pois are imported.
>> The number is the same as on the resulting page of the converter.
>> 13. I press 0 to activate the exploration mode, but there are no points!
>> That's it. Now what's wrong? Is it a bug or my mistake?
>> Thanks all in advance, and I appologize for so long message, but I had
>> to explain as I will need this maps in the very neer future.
>> Best regards!
>> Milos Przic
>> msn: milos.przic at gmail.com
>> skype: Milosh-hs
>> __________ Information from ESET NOD32 Antivirus, version of virus
>> signature database 5076 (20100430) __________
>> The message was checked by ESET NOD32 Antivirus.
> Loadstone mailing list
> Loadstone at loadstone-gps.com
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 5076 (20100430) __________
> The message was checked by ESET NOD32 Antivirus.
__________ Information from ESET NOD32 Antivirus, version of virus signature database 5076 (20100430) __________
The message was checked by ESET NOD32 Antivirus.
More information about the Loadstone