Why can't I see all info
Sun, 10/14/2007 - 12:44pm
|
16 years
|
I am trying to get into making POIs. For an example the POIs for Cracker Barrel US stores when I open it in Excell I can see the Lat., Long.,Name and location but that's all. On my Garmin Nuvi 670 I see the town, the phone number and some other items. I want to make a POI of locations in Ontario, Canada showing the Name, Address, Phone Number, Etc. If I import the Cracker Barrel file into POI Edit I see the phone number and missing items I don't see in Excell ( Office 2007 ) on Vista. Can someone please point me to a tutorial or explain what I need to do?
Doug
Are your column widths
Are you column widths in EXCEL to narrow ?????
MrKenFL- "Money can't buy you happiness .. But it does bring you a more pleasant form of misery." NUVI 260, Nuvi 1490LMT & Nuvi 2595LMT all with 2014.4 maps !
Are Your Columns Widths
That's one of the first things I tried. There are 4 columns showing in Excell.
Doug
Nüvi 3790
Try
Expanding the row height. If there is a line feed the data can be hidden.
Computers are useless. They can only give you answers. - Pablo Picasso (Bob - Garmin c530, eTrex Vista HCx)
Linebreaks
I am trying to get into making POIs. For an example the POIs for Cracker Barrel US stores when I open it in Excell I can see the Lat., Long.,Name and location but that's all. On my Garmin Nuvi 670 I see the town, the phone number and some other items. I want to make a POI of locations in Ontario, Canada showing the Name, Address, Phone Number, Etc. If I import the Cracker Barrel file into POI Edit I see the phone number and missing items I don't see in Excell ( Office 2007 ) on Vista. Can someone please point me to a tutorial or explain what I need to do?
Doug
If the 4th column has linebreaks, it will only display the first line. Just click on the 4th column and it should display all of the lines.
RT
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."
AutoFit Rows
Highlight the whole spreadsheet, click on FORMAT, then ROW and then AUTOFIT.
You will see all the info that had most likely been separated by line feeds (alt - ENTER)
Open it in notepad to see
Open it in notepad to see how it has been formatted. Not that it will help you with your problem, but at least you know that you dealing with alt+Enter or you simply don't have a fourth column.
Charley - Nuvi 350 - Bel STI Driver - Cobra 29 w/ wilson 1000 - AIM: asianfire -
Try
I tried that when I expanded the column width, but I guess I didn't expand it enough. The info was in column 4, thanks for your help. Makes me think of when I started into computers long, long ago. Most answers are so obvious when pointed out, that you feel so duh! Now I can start this project and hopefully end up with something worthwhile.
Thanks, Doug
Nüvi 3790
I say "DUH" all the time at
I say "DUH" all the time at work when I have to get help. So don't worry about it!
Charley - Nuvi 350 - Bel STI Driver - Cobra 29 w/ wilson 1000 - AIM: asianfire -
The only dumb question ...
"The only dumb question is the one you don't ask."
RT
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."
So would it then really be
So would it then really be question? LOL.
Charley - Nuvi 350 - Bel STI Driver - Cobra 29 w/ wilson 1000 - AIM: asianfire -
Yes
So would it then really be question? LOL.
Asking doesn't make it a question; wanting to know the answer makes it a question.
RT
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."
Ah, good point.
Ah, good point.
Charley - Nuvi 350 - Bel STI Driver - Cobra 29 w/ wilson 1000 - AIM: asianfire -