GPX to CSV

[colin masters]

Hi

I am trying to convert a GPX file to a XCSV file with more than just the lan / lon / description of each waypoint, I presume I need to create a style to do this?

I have created a basic style which seems to work!!! but have a couple of questions-  Is it possible to also pull the Value contained in the <sym> tag from the GPX to the XCSV file?

Also is it possible to encapsulate each field with “ so the CSV Output would be “lat”,”Lon”,”Name”,”Desc”,”Sym” etc?

 

And finally can I specify any field from the input file to be passed to the CSV or is it only certain fields that can be passed?

 

#Date 30/11/2011

 

DESCRIPTION Comma separated values
EXTENSION CSV
SHORTLEN 50
PROLOGUE Latitude,Londitude,Name,Description
#
FIELD_DELIMITER COMMA
RECORD_DELIMITER NEWLINE
BADCHARS  COMMA

 

#
# INDIVIDUAL DATA FIELDS, IN ORDER OF APPEARANCE:
#
IFIELD LAT_DECIMAL,"","%f"
IFIELD LON_DECIMAL,"","%f"
IFIELD SHORTNAME, "", "%s"
IFIELD DESCRIPTION, "", "%s"

 

OFIELD LAT_DECIMAL,"","%f"
OFIELD LON_DECIMAL,"","%f"
OFIELD SHORTNAME, "", "%s"
OFIELD DESCRIPTION, "", "%s"

 

Thanks

 

Colin

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
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

[Robert Lipe-4]

On Thu, Dec 1, 2011 at 3:09 AM, colin masters <colin_masters2002@...> wrote:

Hi

I am trying to convert a GPX file to a XCSV file with more than just the lan / lon / description of each waypoint, I presume I need to create a style to do this?

If you're living within the capabilities of what can be one with style, yes.

 

I have created a basic style which seems to work!!! but have a couple of questions-  Is it possible to also pull the Value contained in the <sym> tag from the GPX to the XCSV file?

See 

ICON_DESCR

at http://www.gpsbabel.org/htmldoc-development/style_define.html

 

Also is it possible to encapsulate each field with “ so the CSV Output would be “lat”,”Lon”,”Name”,”Desc”,”Sym” etc?

Not really as that's not longer really a something-sepearated file format, it's a something-separated that might need to be escaped or quoted format.

 

 And finally can I specify any field from the input file to be passed to the CSV or is it only certain fields that can be passed?

 

Described in the doc above.

If you don't need absolute control of the format, but do want everything known converted to a quoted format suitable for most spreadsheets, take a look at the unicsv output format.

http://www.gpsbabel.org/htmldoc-development/fmt_unicsv.html

If you really do need a high level of control of the file, you can develop a custom module in C.   It's pretty straight-foward and we have lots of examples.

RJL

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
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

[colin masters]

Many thanks

the  XCSV is Exactly what I wanted

 

Thanks

 

Colin

From: Robert Lipe <robertlipe@...>
To: colin masters <colin_masters2002@...>
Cc: "gpsbabel-misc@..." <gpsbabel-misc@...>
Sent: Thursday, 1 December 2011, 12:09
Subject: Re: [Gpsbabel-misc] GPX to CSV

On Thu, Dec 1, 2011 at 3:09 AM, colin masters <colin_masters2002@...> wrote:

Hi

I am trying to convert a GPX file to a XCSV file with more than just the lan / lon / description of each waypoint, I presume I need to create a style to do this?

If you're living within the capabilities of what can be one with style, yes.

 

I have created a basic style which seems to work!!! but have a couple of questions-  Is it possible to also pull the Value contained in the <sym> tag from the GPX to the XCSV file?

See 

ICON_DESCR

at http://www.gpsbabel.org/htmldoc-development/style_define.html

 

Also is it possible to encapsulate each field with “ so the CSV Output would be “lat”,”Lon”,”Name”,”Desc”,”Sym” etc?

Not really as that's not longer really a something-sepearated file format, it's a something-separated that might need to be escaped or quoted format.

 

 And finally can I specify any field from the input file to be passed to the CSV or is it only certain fields that can be passed?

 

Described in the doc above.

If you don't need absolute control of the format, but do want everything known converted to a quoted format suitable for most spreadsheets, take a look at the unicsv output format.

http://www.gpsbabel.org/htmldoc-development/fmt_unicsv.html

If you really do need a high level of control of the file, you can develop a custom module in C.   It's pretty straight-foward and we have lots of examples.

RJL

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
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