Have The Data, Can't get the format right!!
Thu, 03/22/2007 - 12:11am
|
17 years
|
Hello All,
1st, I have been following your discussions and ALL of you have been a great help! I have a Garmin C330 and have been working on some custom POI's. What I can't figure out is HOW to get the information I need into the proper format on the GPS. I really need Location Name, Address, Contact and Phone Number to pull across. I used a Concatenate formula to pull all the information for the site location. My GPS Screen is pulling this on the top line display BUT also, it is spiltting the POI Location Name and placing it in the lower section of the screen as well. I am using a CSV file format.
Any help would be appreciated.
Thanks,
Chris
so, what you're saying....
Are you saying that the output on the screen is not displaying how you would like it to look?
Post a line here if you can, so we can have a look.
........Garmin StreetPilot c550 / Nüvi 765...........
3 Columns or 4
Are you using 3 or 4 columns? If you are using three columns, it may be too much information. Try putting the Location name in column 3 and concatenate the additional information into the 4th column.
Garmin StreetPilot c530, Mapsource
Thanks!
Folks, I fought with it for hours last night and pulled POI's down from the site to see if I was doing something wrong. I finally found one that was indeed using 4 columns which I didn't know I could. I shortened the data in column 3 and added the additional info to column 4. Worked like a charm!
Next question, looking through the post's it looks like I'm limited to about 700 KB on custom POI's to the device. Is this correct? My file is 4.7 MB. I thought I could load to SD card but in looking through other posts this too seems to be not possible. Is my only choice to shrink the data or can I somehow use the SD Card to store larger POI files?
Thanks Again!
Like This
This is how I finally got the info to fit the screen
-81.4306 30.3942 Transportation Security Administration-,Orlando|20050819 9451 Airport Blvd,Orlando,Michael Sweeney, 4073403060
If I could figure out line breaks in excel without editing 45,000 lines that would be awesome too
Check it with Notepad and it should look similar to this
This is how I finally got the info to fit the screen
-81.4306 30.3942 Transportation Security Administration-,Orlando|20050819 9451 Airport Blvd,Orlando,Michael Sweeney, 4073403060
If I could figure out line breaks in excel without editing 45,000 lines that would be awesome too
Check it with Notepad and it should look similar to this (all on one line)
-81.4306,30.3942,"Transportation Security Administration-,Orlando","20050819 9451 Airport Blvd, Orlando,Michael Sweeney,4073403060"
Using Notepad, anytime there is a comma not within quotes, it will create another field.
You may want to download 'POI File Verifier'. It will correct some of the errors and enclose fields 3 and 4 in quotes.
Hope this helps.
RT
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."