Announcement

Collapse
No announcement yet.

CSV File Solution

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • CSV File Solution

    Hi! I wanted a way to view the CSV files made by Map Monkey's plugin that tracks where I drive. I upload these files to my webserver, and the PHP I made (took about an hour or less) reads them and seperates the data. Take a look! I have to sort through it and make it look a lot better - but it's functional! Tell me what you think! -Brett W

    http://www.woollum.com/gpstrack/

  • #2
    I like it!

    What's with the distances on the last 3 files, is this because you made big journeys without having destinator running or does it look like a bug?
    Destinator 3 For PC! - http://www.map-monkey.co.uk/

    Comment


    • #3
      Good job.

      Bit worried about the distances, in files 2 to 5.

      I guess the info has not been manipulated in any way??
      Re-boxed Dell Optiplex GX110 PIII 733 256Mb RAM
      Modified Sproggy PSU
      Custom made automatic start-up/ shut-down controller
      Dual 2.5" HDDs
      Laptop DVD Reader
      D-Link FM Radio
      5" PSOne LCD
      Installed and working. 75% complete.

      Comment


      • #4
        Now it would be very cool if we find a way to plot the whole journey
        Ikea Case. Epia M10000.M1-ATX. 512 Mb. 2,5" 80 GB HDD. 7" Lilliput. BU-303 GPS. Sony Joystick.
        Status -->
        Lilliput Installed (not indash yet..)
        BraveCar 2.5

        Comment


        • #5
          You know you want to add sorting by colums and an upload file section for people to upload their csv and get it automatically converted .

          Comment


          • #6
            Originally posted by Bravellir
            Now it would be very cool if we find a way to plot the whole journey
            Convert the CSV file to a GPX file and plot it at www.gpsvisualizer.com or www.motionbased.com

            Comment


            • #7
              i am out now (in the truck too!) but ill look into plotting later. i will also xplain the milages.... -BW

              Comment


              • #8
                Oookkkk... This sample was built in about an hour - just a simple test before I had to run off to work. I would like to see what I can do to make a VB app or similar that will allow a mobile computer to automatically upload to my server when a connection is available - and to be hidden so it's not in the way. I also will make the viewing area have a link to a plotted map so it's easy... Much more work to be done! I also wanna make it better looking - it's ugly! -BW

                EDIT: The milage was off i believe because I didnt have it configured right. You can see the lat/lon is waaaay off on a few values - which results in high numbers when compared to the correct data...

                Comment


                • #9
                  Anyone know of a way to do visualisations offline?
                  PC Chips 1500,512mb ddr,no case yet, LinITX 7" touchscreen,300w inverter,RoadRunner FreeDrive,BU303 gps mouse.

                  Comment


                  • #10
                    There are tools that will import into MapPoint and create a track or import as pushpins which isn't so great. By far the best tracks I've seen though are using GPSVisualizer, you have to do it online but can then save the image I believe. The background can also be either a map or a satellite photo.

                    Chris.

                    Comment


                    • #11
                      I looked into the GPSVisualizer. I am not quite sure how to do this. There is no formatting needed to view the CSV files in GPSVisualizer. All you have to do is upload and view on their site. I am just not sure how to interface this yet.... I will work on it I guess - gotta figure how to make my server's php file upload the data to the GPSVisualizer site... We'll see how it goes. -BW

                      Comment


                      • #12
                        I should be able to come up with a nice little php script (if you'd like) that will upload the CSV file to GPSvisualization.com and then download the SVG file to a temp file and maybe even convert it to a jpg. I'll play around with it a bit and see what I can do.

                        Progress: On hold while I pay off my new PowerBook :D
                        Part List:
                        VIA MII10000 - 512MB - 20Gig 2.5" - Rikaline 6010 - 7" Lilliput - CNX-P1260 - Alpine 4ch Amp - 4 Gauge wire and fused distrobution block.

                        Comment


                        • #13
                          GPSVisualizer works better with GPX files, a more standard mechanism for tracking journeys and points. It's a little trickier to create a GPX file rather than a CSV file as there are some rules you have to follow.

                          The best solution would be for NM to create the file in GPX format to start with or, as an alternative, write a little conversion program or script.

                          As an aside if you decide to try this the GPX format doesn't like more than one point per second with some tools so it is best to suppress additional points within the same second of they occur. I have done a little with this and can help out if someone wants to have a go at it.

                          Chris.

                          Comment


                          • #14
                            Originally posted by ukchris
                            GPSVisualizer works better with GPX files, a more standard mechanism for tracking journeys and points. It's a little trickier to create a GPX file rather than a CSV file as there are some rules you have to follow.

                            The best solution would be for NM to create the file in GPX format to start with or, as an alternative, write a little conversion program or script.

                            As an aside if you decide to try this the GPX format doesn't like more than one point per second with some tools so it is best to suppress additional points within the same second of they occur. I have done a little with this and can help out if someone wants to have a go at it.

                            Chris.
                            Why do I have to do everything?? That's why I made an SDK!
                            Destinator 3 For PC! - http://www.map-monkey.co.uk/

                            Comment


                            • #15
                              heh. I didn't mean to imply you should do it, someone should write a converter. Once they've done that and got the nitty bits sorted they might send you the code so you could optionally incorporate it into the logging process if you wanted to.

                              Having MM create GPX tracks would be a very powerful feature, also if it could read GPX files...

                              Comment

                              Working...
                              X