| Versions |
  |
|
| Author |
 Topic  |
|
|
OhMioMy
USA
144 Posts |
 Posted - 19 avr. 2007 : 22:51:53
|
I have devised a procedure to import/upload your AddressBook/Contacts to a c310x MyPOI folder. It involves using exported .csv files from your AddressBook. You need the Lot/Lan for an address in order to import it as a POI it into PoiExplorer. That can be obtained free by pasteing a .csv[list of addresses] file into a web site. With a list Lot/Lan's in hand, the .csv file can then be rearranged and imported into PoiExplorer. The format would be:
POI Nane field [first name:last name:phone number]max ~40 characters.
Description first line [street address] max~45 characters
Description second line [city:state:zip:cell]max~45 characters
Once you see how it is done, you can arrange the format to your needs. The Autogenerated address line will be the address closest to the Lot/Lan that the c310x can find.
If you are interested in doing the above procedure, respond and I will document how to do it. |
|
|
Ads
|
|
|
IanJ
Australia
122 Posts |
Posted - 20 avr. 2007 : 02:34:49
|
@OhMioMy,
I would be very interested in being able to do this. Please document it.
Cheers, Ian |
If at first you don't succeed to hell with it! |
 |
|
|
Full_Screen57
14 Posts |
Posted - 20 avr. 2007 : 04:28:31
|
| What are you waiting for? Go for it. And, THANKS!!! |
|
|
|
OhMioMy
USA
144 Posts |
Posted - 20 avr. 2007 : 21:13:16
|
I needed an automated process to convert a list of 722 customer names and addresses into POI's in my c310x.
The objective is to create a .csv file that will import into iGo POI Explorer. The file format will be:
Name,West Longitude,North Latitude,Description
Name[Full name Phone number],{max 45 characters}
West longitude{-85.1234},
North Latitude{34.1234},
Description(1st line)[Street Address]{45 characters}
(2nd line) [city state zip cell#]{45 characters}
You will need 3 freeware programs to accomplish this, download and install them.
CSVed-Used to edit and manipulate .csv files
http://csved.sjfrancke.nl/index.html
XVI32-A simple Hex Editor
http://www.chmaas.handshake.de/
A Text editor-WordPad if you have it or you could use EditPad Lite[DO NOT use a word processors like Word or Word Perfect]
http://www.editpadlite.com/editpadlite.html
iGO POI Explorer-If you don't already have it on your system, read this thread. You MUST also install .Net Framwork and ActiveSync for POI explorer to work!!
http://www.gpspassion.com/forumsen/topic.asp?TOPIC_ID=72267&whichpage=1
The Basic steps are:
1. Export a .csv file from your source.
2. Use CSVed to Convert the .csv file to a .tab[tab delimited] file.
3. Copy and paste the .tab file into the web site http://www.batchgeocode.com/ and generate the Lot/Lan values.
4. From the web site, copy and paste the information into your text editor and save a new file with Lot/Lan info in it.
5. Open the new file with CSVed and convert it to back to a .csv file.
6. Use CSVed to rearrange and combine the columns into the format for import into POI Explorer.
7. Use the Hex editor to replace the "@" character with Hex[0A] the Line Feed character.
8. Import the file into POI Explorer and update the iGO.db file.
9. Copy the iGo.db file to the c310x and you are done.
The details.........
Step 1.
your exported file should contain: Name, Address, City, State, Zip, Phone, Cell.
Your address data CAN NOT CONTAIN any comma's ie{123 jones Street, Ste.100} as this will totally hose your COMMA separated file. If you have comma's in your addresses, try to export a Tab separated file and use the text editor to search for and replace commas with spaces or :.
Step 2.
The web site that generates Lat/Lon information requires a tab separated file.
start the CSVed Program and explore the tabs at the bottom.
Under Modify, Set Separator, click Comma, then open your .csv file.
Under Modify, Set Separator, click Tab, then save the Tab seperated file to a new name. Open this tab separated in the text editor then highlight and copy the entire file.
Step 3.
Open the web site http://www.batchgeocode.com/ and follow the instructions to generate the Longitude Latitude information.
Step 4.
Highlight the result information then open a blank file in the text editor and paste in the information. Save this new file.
Step 5.
Use CSVed to convert this file back to a .csv file and save it. Make a second copy of this file so you can come back to it if needed.
Step 6.
open the new .csv file with CSVed. Now by moving and combining columns, you can generate the format needed to import into POI Explorer.
column-1 must be a combination of {name} and {phone}. Use Modify, copy-move column, to put the {name} in column 1. Then use Modify 2, Join columns, to combine column 1 to {phone} column. SAVE!
Column-2 is the Longitude [-84.12345], move it into column-2 position.
Column-3 is the Latitude [38.12344], move it into column-3 position. SAVE!
Column-4 is the street address. SAVE!
Column-5 is the combination of city, state, zip, cell. Combine state with city, then combine zip with the result, then combine cell. Save!
The result will be: Name+phone,-84.123,37.123,street address,city+state+zip+cell
Column-4 is Description line-1 and Column-5 is description line-2 so you must combine columns 4 and 5 with a Hex[0A](line feed character)between them to get two lines. The Line Feed character can not be entered from the keyboard so you must use a Hex editor. We will combine columns 4 and 5 with a "@" between then and later use the Hex editor to search=@ and replace=0A. (if you have any @ in your text, use something else that does not appear in your text.)
Use Modify 2, Join Columns, check 'add text between' and enter the @ then combine column 4 to column 5. SAVE!
Step 7.
Start the Hex editor and open the file saved above. Select Search, Replace. Use Find, text string = @ and Replace with, Hex string=0A [zero A} select Replace All. SAVE!
Step 8.
copy your \My Flash Disk\MioMap\MioMap\iGo.db file to your hard drive. Make a backup copy somewhere else just in case.
open iGoPOI Explorer and select File, Import, iGO Database from file(offline), your iGO.db file. Right click in the tree on iGO POI Database and create a folder to receive your .csv file.
Right click in the LEFT box and select "Import POI's from file here", under file types select "CSV POI File" Open your .csv file
Open the newly created directory and highlight and drag the file contents to your directory in the tree and delete the newly created directory.
Select File, Export, iGO Database to file(offline), select the iGo.db file that you started with and Save.
Step9.
Exit the map program on the c310x, delete the iGo.db file then reploac it with
the updated iGo.db and restart MioMap and explore your new POI's.
I have a total of 1028 custom POI's and have not noticed any effects on operation.
The auto generated address line [2] on the POI detail screed, is the closest physical address that the unit can fine to the Lot/Lan entered. It may not be the same as the address that you entered.
You can get two lines out of the Name[top] field also by putting in the Hex[0A] to get a line feed.
If you just want to store 4 lines by 45 characters of information in each record and do not care about having a routeable POI, make the Lot,Lan entry ,-0,0, . The automatic address line will not be generated.
In iGO.db file, everything within a folder MUST be the same format! |
Edited by - OhMioMy on 22 avr. 2007 01:46:07 |
|
|
| |
Topic |
|
|
|
| This page was generated in 0,42 seconds. |
 |
|
- 
del.icio.us
How to import AddressBook to C310x POI
