Too many columns?
Mon, 11/25/2013 - 1:23am
![]() |
![]() 13 years
|
When I click "check for problems" for my POI file that I'm maintaining, I get entries that are flagged for "too many columns".
Basically it looks like since I've put some notes in the Description box, which amounts to a fourth column, I'm getting this "problem".
The question is, is this a real problem that needs to be fixed or can I leave these entries alone without deleting the (brief, one word) descriptions?
flagged by what?
If you download the file as CSV, it shows as a four column CSV. From the way the information in the file is structured, the problem may be do to trying to keep everything in three columns. (I know, you use a Tom-Tom and it will only input a 3 column file.)
I think you will find it less frustrating to build your source file using more columns and then use either functions in Excel or another spreadsheet program or EPE to combine the columns into your desired output file.
As an example, your first entry is Lon, Lat, Description, Status
-79.0184, 38.14528, I-81 Nb Staunton VA 3 crosses v, verif
where I am guessing that the fourth entry, verif, is your note on the status of the entry.
The problem with trying to do everything in a 3 or four column format CSV file is it quickly becomes very difficult to maintain the file as the database grows. In your case, I would start be breaking the file down into at least 7 different fields. Lat, Lon, address (location), city, state, comment and status. Using this format, your first line would show in a spreadsheet as:
-79.0184, 38.14528, I-81 Nb, Staunton, VA, 3 crosses, verified.
You can use EPE to combine the fields or you can use functions in most spreadsheet programs to do the same thing. For the novice, EPE is much easier to work with.
Illiterate? Write for free help.
Use quotes
The problem with Comma Seperated Values (CSV) format, is if you need to use commas in any of the fields.
To get around this limitation is to use quotes.
Denver, CO alone will look like 2 items.
"Denver, CO" will look like 1 item.
Garmin Nuvi 2450
Thank you both
for the help and the advice.
I'm using TomTom POI Editor now and I find it's a good program. I'll decide how to proceed from here based on the advice.
For now I may just remove the "verif" from the description so there's no problems, although the file looks as though it's just fine and has been working. I'm just a little concerned that there may eventually be a major problem based upon the "too many columns" flag I'm getting.
Amazing GPS: I once was lost but now am found.