CVS file Description Issue

 

I was having difficulty with the description not showing up on the POI EDIT software made from a .cvs file I built. Just some squiggly lines showed up in POI EDIT.....<--break-->
Looked over the .cvs file using .xls and could see nothing wrong.
Copy and pasted the file to Notepad and found two lines where the descriptions were attached to the latitude column. Realigned columns in Notepad, copy and pasted the new Notepad file back to .cvs and then opened in POI EDIT. Everything was fine.
You can see issues in Notepad that may not be visible in cvs or xls.
You learn something every day.
Chuck

Excel not perfect

Excel is a long way from perfect for constructing csv files. Excel will format POIs in ways you don't want; and, worse yet, in ways you can't see until you check it with a text editor ... like Notepad. POI Verifier will also find (and correct) many of these problems.

RT

--
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."

Re: CVS File Description Issue...

Hi chaspoi,

I think you mean ".csv" file...

Regards,

Tailspin

Nüvi 670
Mac User

--
Sullivan's Law: Murphy was an optimist!

.csv file

Thanks Tailspin, pardon my dyslexia...
Chuck

Changing file suffixes

chaspoi wrote:
"Copy and pasted the file to Notepad and found two lines where the descriptions were attached to the latitude column. Realigned columns in Notepad, copy and pasted the new Notepad file back to .cvs and then opened in POI EDIT. Everything was fine."

Chuck, the easiest way to change a file from .csv to .txt and back again is to merely change the suffix. If a file is named poi.csv, for example, and you open it, it's opened by Excel. If you do nothing but rename the file to poi.txt and open it, it's opened by Notepad. You can use Explore to open the folder the file is in, then make the file suffix either .csv or .txt, whatever suits your needs at that moment.

--
"No misfortune is so bad that whining about it won't make it worse."

Thanks for the tip

Thanks,
I will do that in the future, much easier.
Would be nice if POI EDIT would use .txt files.
Chuck

Right click, Open with...

plunder wrote:

If a file is named poi.csv, for example, and you open it, it's opened by Excel. If you do nothing but rename the file to poi.txt and open it, it's opened by Notepad. You can use Explore to open the folder the file is in, then make the file suffix either .csv or .txt, whatever suits your needs at that moment.

Or you can simply right click on the .CSV file and pick Open With... and choose Notepad. No need to change the suffix even.

PT

--
Garmin nüvi 200 (my first GPS), 780, & 3700 Series. And a Mac user.