How to keep "Comment" text data in gdb to ucsv back to gdb?

[Peter Attfield]

Some parts of this message have been removed. Learn more about Nabble's security policy.

I am using GPSBabel to convert a Garmin MapSource file (gdb) to a universal CSV file so that I can use Waypoint data in a spreadsheet, edit some data in that spreadsheet, and convert it back to gdb.

 

After I use GPSBabel to convert the gdb file, the text I entered in the "Comment" field appears in a field titled "Description" in the u-csv file. Good.

 

But when I convert the u-csv file back to gdb, the "Comment" field in MapSource is now empty, and that text is nowhere to be found.

 

Any suggestions on how to maintain the Comment/Description text?

 

(I am a non-programmer and am using the graphic interface of GPSBabelGUI-2.)

 

Thanks for your consideration.

 

Peter.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Gpsbabel-misc mailing list http://www.gpsbabel.org
Gpsbabel-misc@...
To unsubscribe, change list options, or see archives, visit:
https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc

[Olaf Klein-3]

Hi Peter,

> I am using GPSBabel to convert a Garmin MapSource file (gdb) to a universal
> CSV file so that I can use Waypoint data in a spreadsheet, edit some data
> in that spreadsheet, and convert it back to gdb.
>
> After I use GPSBabel to convert the gdb file, the text I entered in the
> "Comment" field appears in a field titled "Description" in the u-csv file.
> Good.
>
> But when I convert the u-csv file back to gdb, the "Comment" field in
> MapSource is now empty, and that text is nowhere to be found.

I've tested the described way and I got all "Description"s back into a gdb
file. Please try our latest release (1.3.5). If it doesn't helps, please
provide a sample file (csv format, after edit) , which will be result in
empty "MapSource comments".

O.K.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Gpsbabel-misc mailing list http://www.gpsbabel.org
Gpsbabel-misc@...
To unsubscribe, change list options, or see archives, visit:
https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc

[Peter Attfield]

Thanks Olaf.

As you suggested, I downloaded the latest GPSBabel release and it was
successful in maintaining the "Comment" data.
(I had earlier discovered a work-around:  I could get the Comment data that
was converted from the gdb file to the csv file back to a gdb file if I
simply changed the column header in the csv file from "Description" to
"Comment".

I have also discovered that I have to change the Date field in the csv file
from a format of 14/07/2008 to a format of 2008-07-14. Otherwise I was
getting error messages of "unable to parse date string".

That has my three biggest problems solved, but left me wondering about two
other fields.  Is it possible to keep the waypoint "Category" and "Link"
information when converting from gdb to u-csv and back to gdb?

Peter.

----- Original Message -----
From: "Olaf Klein" <o.b.klein@...>
To: <gpsbabel-misc@...>
Cc: "Peter Attfield" <attmack@...>
Sent: Saturday, July 19, 2008 6:00 PM
Subject: Re: [Gpsbabel-misc] How to keep "Comment" text data in gdb to ucsv
back to gdb?

> Hi Peter,
>
>> I am using GPSBabel to convert a Garmin MapSource file (gdb) to a
>> universal
>> CSV file so that I can use Waypoint data in a spreadsheet, edit some data
>> in that spreadsheet, and convert it back to gdb.
>>
>> After I use GPSBabel to convert the gdb file, the text I entered in the
>> "Comment" field appears in a field titled "Description" in the u-csv
>> file.
>> Good.
>>
>> But when I convert the u-csv file back to gdb, the "Comment" field in
>> MapSource is now empty, and that text is nowhere to be found.
>
> I've tested the described way and I got all "Description"s back into a gdb
> file. Please try our latest release (1.3.5). If it doesn't helps, please
> provide a sample file (csv format, after edit) , which will be result in
> empty "MapSource comments".
>
> O.K.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Gpsbabel-misc mailing list http://www.gpsbabel.org
Gpsbabel-misc@...
To unsubscribe, change list options, or see archives, visit:
https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc

[Olaf Klein-3]

Hi Peter,
> I have also discovered that I have to change the Date field in the csv file
> from a format of 14/07/2008 to a format of 2008-07-14. Otherwise I was
> getting error messages of "unable to parse date string".

unicsv has a fixed date format (YYYY/MM/DD).

>
> That has my three biggest problems solved, but left me wondering about two
> other fields.  Is it possible to keep the waypoint "Category" and "Link"
> information when converting from gdb to u-csv and back to gdb?

the "link" field is internal called "URL". So rename your column to URL and
you'll get the link items back into gdb.

The category problem isn't simple problem and it's in our working queue since
years. But I hope we can realize category support soon.

O.K.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Gpsbabel-misc mailing list http://www.gpsbabel.org
Gpsbabel-misc@...
To unsubscribe, change list options, or see archives, visit:
https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc