<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-2">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
        {font-family:"Cambria Math";
        panose-1:0 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p
        {mso-style-priority:99;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
span.StylE-mailovZprvy18
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
span.StylE-mailovZprvy19
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page Section1
        {size:612.0pt 792.0pt;
        margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.Section1
        {page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext="edit">
  <o:idmap v:ext="edit" data="1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=CS link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi Gian and all,<o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>these data are from the following site:<o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><a href="http://www.poi.cz">http://www.poi.cz</a><o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I collected, converted and merged all the files you can download
here. However, I think this website won</span><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>&#8217;t</span><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> be
of any use to anyone as these pages are written in Czech. Also data on the
website are constantly changing, so it is hard to collect them often. This site
is maintained by volunteers who prepare those data.<o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Just a note to my ID in my file: this ID was generated by POI
Converter. If it is wrong, this tool should be rewritten to generate valid CSV
files.<o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Regards,<o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Petr Rehak<o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<div>

<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>

<p class=MsoNormal style='margin-left:35.4pt'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> loadstone-bounces@loadstone-gps.com
[mailto:loadstone-bounces@loadstone-gps.com] <b>On Behalf Of </b>Gianfranco
Giudice<br>
<b>Sent:</b> Thursday, February 21, 2008 3:28 PM<br>
<b>To:</b> loadstone@loadstone-gps.com<br>
<b>Subject:</b> Re: [Loadstone] Unable to import a POI collection<o:p></o:p></span></p>

</div>

</div>

<p class=MsoNormal style='margin-left:35.4pt'><o:p>&nbsp;</o:p></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:blue'>Hi Peter</span><o:p></o:p></p>

<p class=MsoNormal style='margin-left:35.4pt'>&nbsp;<o:p></o:p></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:blue'>Yes, the &gt; sign should be
removed.</span><o:p></o:p></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:blue'>Where have you got those data? I
suppose not from Google.</span><o:p></o:p></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:blue'>I have the same problems. Only
after reprocessing the new entries will be imported.</span><o:p></o:p></p>

<div>

<p class=MsoNormal style='margin-left:35.4pt'>&nbsp;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:blue'>Gian</span><o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:35.4pt'>&nbsp;<o:p></o:p></p>

</div>

<div class=MsoNormal align=center style='margin-left:35.4pt;text-align:center'><span
lang=IT>

<hr size=2 width="100%" align=center>

</span></div>

<p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
12.0pt;margin-left:35.4pt'><b><span lang=IT style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=IT style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> loadstone-bounces@loadstone-gps.com
[mailto:loadstone-bounces@loadstone-gps.com] <b>On Behalf Of </b>Petr Rehák<br>
<b>Sent:</b> Thursday, February 21, 2008 2:27 PM<br>
<b>To:</b> loadstone@loadstone-gps.com<br>
<b>Subject:</b> Re: [Loadstone] Unable to import a POI collection</span><span
lang=IT><o:p></o:p></span></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'>Hi,<o:p></o:p></span></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'>i suppose this is not the
case. Below is a small excerpt from my CSV file:<o:p></o:p></span></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'>table,point<o:p></o:p></span></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'>name,latitude,longitude,accuracy,satellites,priority,userid,id<o:p></o:p></span></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'>&quot;CZ-Ambasada -
Afghánistán420233544228&quot;,501165700,144233300,2,4,2,62015,888256260<o:p></o:p></span></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'>&quot;CZ-Ambasada -
Albánie420233370594&quot;,501019800,144112300,2,4,2,62015,888256261<o:p></o:p></span></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'>Just a note to the quoted
text: originally there was a greater-than sign before the number (e.g. </span><span
lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>&gt;420233544228&#8221;</span><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'>, but POI Converter removed
it. Why? What other characters are being removed and how to prevent their removal?<o:p></o:p></span></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'>Note to the Database
Reprocessor tool: well, I can use it, but what it could do to make my file more
valid? Moreover, if there was an error in the file, it should have aborted
always at the same line number, but why does it abort at random lines (first
884, second 843, third 2592 etc.)?<o:p></o:p></span></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'>If nothing helped, can I
convert the CSV data straight into the binary format on my PC? There were (and
still are) similar problems with converting CSV files to binary databases in
the CellTrack application, but fortunately, CellTrack can make use of various
internal database formats.<o:p></o:p></span></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'>Thanks.<o:p></o:p></span></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'>Regards,<o:p></o:p></span></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'>Petr Rehak<o:p></o:p></span></p>

<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<div>

<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>

<p class=MsoNormal style='margin-left:70.8pt'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> loadstone-bounces@loadstone-gps.com
[mailto:loadstone-bounces@loadstone-gps.com] <b>On Behalf Of </b>Cearbhall O
Meadhra<br>
<b>Sent:</b> Thursday, February 21, 2008 1:25 PM<br>
<b>To:</b> loadstone@loadstone-gps.com<br>
<b>Subject:</b> Re: [Loadstone] Unable to import a POI collection<o:p></o:p></span></p>

</div>

</div>

<p class=MsoNormal style='margin-left:70.8pt'><o:p>&nbsp;</o:p></p>

<p class=MsoNormal style='margin-left:70.8pt'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:blue'>Hello, </span><span
style='color:black'>Petr ,</span><o:p></o:p></p>

<p class=MsoNormal style='margin-left:70.8pt'>&nbsp;<o:p></o:p></p>

<p class=MsoNormal style='margin-left:70.8pt'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:blue'>Have you checked to see if
your&nbsp;CSV file has commas after the two words &quot;table,point&quot;?</span><o:p></o:p></p>

<p class=MsoNormal style='margin-left:70.8pt'>&nbsp;<o:p></o:p></p>

<p class=MsoNormal style='margin-left:70.8pt'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:blue'>I was caught out with this myself
for ages until I realised that the conversion of a file from text to&nbsp;CSV
keeps the column position and marks column boundaries with a comma
(&quot;,&quot;).</span><o:p></o:p></p>

<p class=MsoNormal style='margin-left:70.8pt'>&nbsp;<o:p></o:p></p>

<p class=MsoNormal style='margin-left:70.8pt'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:blue'>the common result is:</span><o:p></o:p></p>

<p class=MsoNormal style='margin-left:70.8pt'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:blue'>&quot;Table,Point,,,,,,,,&quot;</span><o:p></o:p></p>

<p class=MsoNormal style='margin-left:70.8pt'>&nbsp;<o:p></o:p></p>

<p class=MsoNormal style='margin-left:70.8pt'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:blue'>If this is the case, you will need
to edit the actual .CSV version of the file to remove the trailing commas on
the first line.</span><o:p></o:p></p>

<div>

<p class=MsoNormal style='margin-left:70.8pt'>&nbsp;<o:p></o:p></p>

</div>

<p style='mso-margin-top-alt:5.0pt;margin-right:0cm;margin-bottom:12.0pt;
margin-left:70.8pt'><span style='font-size:10.0pt'>All the best,<br>
<br>
<br>
Cearbhall<br>
<br>
&quot;Good design enables - Bad design disables&quot;<br>
<br>
Tel: 01-2864623 Mob: 087 9922227 Em: cearbhall.omeadhra@colibri.ie</span><o:p></o:p></p>

<div>

<p class=MsoNormal style='margin-left:70.8pt'>&nbsp;<o:p></o:p></p>

</div>

<p class=MsoNormal style='margin-left:70.8pt'><o:p>&nbsp;</o:p></p>

<div style='margin-left:35.4pt'>

<div class=MsoNormal align=center style='margin-left:35.4pt;text-align:center'><span
lang=EN-US>

<hr size=2 width="100%" align=center>

</span></div>

</div>

<p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
12.0pt;margin-left:70.8pt'><b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
loadstone-bounces@loadstone-gps.com
[mailto:loadstone-bounces@loadstone-gps.com] <b>On Behalf Of </b>Rob Melchers<br>
<b>Sent:</b> 21 February 2008 07:31<br>
<b>To:</b> loadstone@loadstone-gps.com<br>
<b>Subject:</b> Re: [Loadstone] Unable to import a POI collection</span><span
lang=EN-US><o:p></o:p></span></p>

<p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
12.0pt;margin-left:70.8pt'>Hi,<br>
<br>
Try running the files through the Database reprocessor before sending them to
the phone. Make sure that each file starts with the two header lines (table,
point, etc.)<br>
<br>
Rob<br>
<br>
At 2/21/2008, you wrote:<o:p></o:p></p>

<p class=MsoNormal style='margin-left:70.8pt'>Hello,<br>
<br>
sorry for a high frequency of my messages, still saying &quot;unable
to...&quot;, but<br>
I am still a newbie to LoadStone GPS and haven't come across any written<br>
comments on my issues yet. So what next?<br>
I tried to generate a database import file via the POI Converter on the<br>
LoadStone GPS website and all went OK. First, I prepared a CSV file, split<br>
into multiple parts as I do have a 30000 POIs database from the Czech<br>
Republic and would like to use it. As descriptions contain non-english<br>
characters, I converted the CSV file to UTF-8 prior to converting. Then I<br>
ran the POI Converter and downloaded a TXT file. Then I placed it into the<br>
ImportExport folder and tried to import it into the default and my own<br>
database, no luck either. It randomly throws an error message saying<br>
something like &quot;abort importing on line xxxx, possibly corrupted
file&quot;. The<br>
line number is quite random, sometimes it is able to complete only 5%,<br>
sometimes 20%, but I have never managed to end up with a complete database<br>
yet. What might be the problem? I even tried to mute MobileSpeak or set a<br>
screensaver delay to 30 minutes, should it cause a problem. Any ideas?<br>
Using LoadStone GPS 0.69 with Nokia 6681 and MobileSpeak 2.03.<br>
Thanks.<br>
<br>
Regards,<br>
Petr Rehak<br>
<br>
<br>
_______________________________________________<br>
Loadstone mailing list<br>
Loadstone@loadstone-gps.com<br>
<a href="http://www.loadstone-gps.com/mailman/listinfo/loadstone">http://www.loadstone-gps.com/mailman/listinfo/loadstone</a>
<o:p></o:p></p>

</div>

</body>

</html>