Files that need commas removed to work with POI Loader 2.60
Thu, 01/27/2011 - 11:39am
 |
 17 years
|
Please post the link to the POI File that needs to have commas removed in order to be loaded with the new POI Loader 2.60.
Miss POI
Here are a couple
http://www.poi-factory.com/poifile/download/csv?node=15576
http://www.poi-factory.com/poifile/download/gpx?node=9761
Nuvi 2460LMT
It doesn't appear
It doesn't appear to be a horrendous task to fix those files that have loading problems using version 2.6.0.
The only field that cannot have a comma is the name field or Column C, The new version of POI Loader has no problems with commas in the 4th column or Description field.
Try this test for yourself:
-86.152627,34.197973,Dales, BBQ,"10850 Al hwy. 168,Boaz, AL 35957,(256) 593-1168"
and
-86.152627,34.197973,Dales BBQ,"10850 Al hwy. 168,Boaz, AL 35957,(256) 593-1168"
The first entry will load, but the POI Name will be Dales and the Description BBQ. For the second, the name will be Dales BBQ with the address, city, etc. as the description.
The only difference between the two is the name field - after the Latitude, has a comma.
Illiterate? Write for free help.
Good news!
Good news! It is not a big problem if it applies only to column 3. The most important place to have commas is in column 4.
Box Car, in your first example, you made a 5 column CSV. Maybe you meant to put double quotes around "Dales, BBQ"...
.
Turboccc - would you be able to create a program for this site which could automatically scan csv files to confirm there are no commas in the 3rd field?
Since this site is composed of user-created POI files there has to be some way we can insure new files confirm to the "no comma in 3rd field rule".
If the file contains only
If the file contains only three fields, then it will allow commas in the third field. It allows commas in the last field only.
Tight lines
3rd column is 4 columns? Did I say this was a BUG? LOL!
Yes, I can make a program that Miss POI can run on her side. I do not know how/where files are stored on POI Factory, but if Miss POI has a direct file access, I can make the program to scan all folders and sub-folders. Since I can parse CSV files, I can detect and correct fields that have a comma in them. The same program could be available for everybody to scan their own files.
3rd column is 4 columns? Did I say this was a BUG? LOL!
Yes, I can make a program that Miss POI can run on her side. I do not know how/where files are stored on POI Factory, but if Miss POI has a direct file access, I can make the program to scan all folders and sub-folders. Since I can parse CSV files, I can detect and correct fields that have a comma in them. The same program could be available for everybody to scan their own files.
I think it would be a good thing if you could make a program that each of us with poi files could fun on our own. Great ideal and good job. Thanks
johnm405 660 & MSS&T
Yep.
Yep. Forgot the double quotes.
Actually I had both lines in the same CSV file. The first line truncated at the comma following Dales.
Illiterate? Write for free help.
This can be done with Excel
This can be done with Excel by high-lighting the third column and doing a "fine" and "replace" to fine all the "," and replace all with a space.
Tight lines
2.60
Yes, I can make a program that Miss POI can run on her side. I do not know how/where files are stored on POI Factory, but if Miss POI has a direct file access, I can make the program to scan all folders and sub-folders. Since I can parse CSV files, I can detect and correct fields that have a comma in them. The same program could be available for everybody to scan their own files.
A question Turboccc.What about some of the files that may have to many characters in column c?I emailed Garmin to find out how many characters are to many? How about authors who have only 3 columns using c for comments such as address etc.Need to pull the commas out and replaced with a space so they don't run together.
Charlie. Nuvi 265 WT and Nuvi 2597 LMT. MapFactor Navigator - Offline Maps & GPS.
Column truncation and comma replacement
Both pose no problem. I can adapt to the final decision. Even EPE will warn about those issues or correct them automatically.
Max column size
I emailed Garmin to find out how many characters are too many?
Their answer will be: "they don't know"!
It seems it is not related to the length of the column, but to the number of chatacters in columns 3 and 4. If you have less characters in column 3, you can put more in column 4.
The maximum number of characters available for both columns 3 & 4 is...
1024 characters!
Subaru Dealerships
http://www.poi-factory.com/poifile/download/csv?node=15335
On line 211: -71.107665,42.834129,"Singer Subaru, LLC ","77 Plaistow Road
Plaistow, NH 03865
(603) 382-7101"
Files I've found with commas causing problems
Please post the link to the POI File that needs to have commas removed in order to be loaded with the new POI Loader 2.60.
Miss POI
Just a few I've had that got errors loading with POI Loader v2.60 but worked fine in v2.5.4
http://www.poi-factory.com/node/3497
http://www.poi-factory.com/node/1918
http://www.poi-factory.com/node/3724
http://www.poi-factory.com/node/1697
http://www.poi-factory.com/node/24477
http://www.poi-factory.com/node/541 (Is an old file, newer files have replaced this one, maybe just eliminate it)