using timestamps from a csv file

PetePete Global Mapper UserPosts: 13Trusted User
edited January 2012 in Technical Support
I import csv files in many formats, often including a "time" column of data. How can I get GM to recognise the "time" data as a time stamp that can be used for exporting time stamped kml files? The times are not always regular so creating them as a series within GM is not practical.

Comments

  • global_mapperglobal_mapper Administrator Posts: 17,238
    edited January 2012
    Are you looking to create time-stamped waypoints or tracks? If you just want your points time-stamped on export to GPX just make the column named TIMESTAMP.

    Let me know if I can be of further assistance.

    Thanks,

    Mike
    Global Mapper Guru
    gmsupport@bluemarblegeo.com
    http://www.globalmapper.com
  • PetePete Global Mapper User Posts: 13Trusted User
    edited January 2012
    Thanks, I am trying to import a track from a csv file that includes position, time stamps and other attributes. I would like to export this to a Google Earth (GE) so that the track can be replayed in GE using its play functions associated with timestamped data, without losing the attribute data loaded into GM with the csv. I have managed to get the timestamping side working by exporting a gpx file and then getting GE to convert that to a KML but that loses other attributes and is a messy approach to what should be a simple export. Hopefully I am just not clicking the right options. Any help would be appreciated.
  • global_mapperglobal_mapper Administrator Posts: 17,238
    edited January 2012
    What type of attribute data do you have? The GPX format doesn't support a completely generic set of attributes, you can only get out things like the display label, description, and a comment field, so you would need to have your attributes mapped to an appropriate name, like "COMMENT", for them to be exported to a GPX file.

    Let me know if I can be of further assistance.

    Thanks,

    Mike
    Global Mapper Guru
    gmsupport@bluemarblegeo.com
    http://www.globalmapper.com
  • PetePete Global Mapper User Posts: 13Trusted User
    edited January 2012
    I was only using the gpx file as a means of preservicing the timestamp between GM and Google Earth, I do not need a GPX file. KMZ files support attributes and timestamping, I am just unable to get the timestamping function into the KMZ file using GM even though GM does manage it for other formats (eg GPX) with the same loaded csv data. How do I get GM to export a KMZ file with timestamps, when ticking the timestamping box does not appear to work for me?
  • global_mapperglobal_mapper Administrator Posts: 17,238
    edited January 2012
    Can you perhaps provide me with some sample data so I can take a look and come up with some ideas on how to get it directly to KML with the timestamps intact?

    Thanks,

    Mike
    Global Mapper Guru
    gmsupport@bluemarblegeo.com
    http://www.globalmapper.com
  • PetePete Global Mapper User Posts: 13Trusted User
    edited January 2012
    I have packaged a workspace with some dummy data as requested.
  • global_mapperglobal_mapper Administrator Posts: 17,238
    edited January 2012
    Aha, it looks like your line just has a bunch of duplicate TIMESTAMP attributes rather than actual per-vertex time-stamps.

    How did you create your line? I can think of a couple of ways to go from either the source CSV or from a collection of points after loading and getting the times assigned, but I figure I'll change it where you actually need it to make it work.

    Thanks,

    Mike
  • global_mapperglobal_mapper Administrator Posts: 17,238
    edited January 2012
    I went ahead and made connecting points with a TIMESTAMP attribute into a line using the Digitizer Tool add the per-vertex times to the new line, so you could load your points and then connect them into a line, then export that to a KML with replay tracks enabled to get the timed line. I have placed a new build at http://www.globalmapper.com/global_mapper13.zip with the change for you to try. Simply download that file and extract the contents into your existing v13.xx installation folder to give it a try. If you are using the 64-bit v13 version there is a new build at http://www.globalmapper.com/global_mapper13_64bit.zip .

    Let me know if I can be of further assistance.

    Thanks,

    Mike
  • PetePete Global Mapper User Posts: 13Trusted User
    edited January 2012
    Thanks, that does the trick. Before you roll it into a release, you may want to make the line attributes and KML altitude options work as per non-timestamped exports but that is a minor niggle. I also think that a simple export of the imported csv points to a timestamped KML/KMZ is the way ahead given that is how the KML/KMZ options appear to be offering. Looking forward to GM13.x. Thanks again.
Sign In or Register to comment.