CacheAddict.com Posted May 28, 2009 Share Posted May 28, 2009 If you can help please contact me mike@atwellfamily.net. Thanks Quote Link to comment
+McBack Posted May 28, 2009 Share Posted May 28, 2009 You find info about the .gpx file here www.topografix.com/gpx.asp It's a xml file so maybe you'll find somkind of xml to ... translator that works. Quote Link to comment
+mtn-man Posted May 28, 2009 Share Posted May 28, 2009 I'll move this to the software forum. You will probably get better help there. Quote Link to comment
+obsidianspider Posted May 28, 2009 Share Posted May 28, 2009 What are you trying to do with the file? A little more information and maybe someone will be able to assist you. Quote Link to comment
CacheAddict.com Posted May 28, 2009 Author Share Posted May 28, 2009 What are you trying to do with the file? A little more information and maybe someone will be able to assist you. I want to down load the GPX into a Sql table so I can tehn display the data on a webpage. www.geocachingcolo.com We had someone write a exe file that converted the qpx file to xlm but when Groundspeak changed the format of the file the exe stopped working and the person will not help up modify the program. I am a self confessed hack but can't seem to figure this out. Quote Link to comment
+JeremyR Posted May 28, 2009 Share Posted May 28, 2009 Leaving aside the matter of the fact that you'd be in violation of the user agreement if you didn't have GSP's permission to do this (I'm going to assume in good faith that you have), here's one of a hundred ways you could do it: As McBack said, a GPX file is just an XML document. You could easily use XSL to translate the GPX/XML data into a text file of SQL statements which you would then insert into your database (for example with phpMyAdmin or similar). This is obviously only a semi-automated method. There are other ways that would involve more or less human interaction. A PHP (or similar) script scheduled by cron that checks an email account for a PQ delivery, extracts the GPX from the zip, processes it and inserts/updates to a database would be one way to fully automate but would obviously be a far more involved undertaking. As a "self confessed hack", I trust you don't mind me giving you ideas rather than fully fledged solutions Quote Link to comment
+mallybiky Posted May 29, 2009 Share Posted May 29, 2009 I have quite a lot experiance with gpx files, xml, database, programming, ... so probably I can help you ... but I need a good look on the requirements before doing anything. I regularly display the content of gpx file on googlemaps with javascript (no database needed) like on following link. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.