Cache & Carry Posted March 3, 2003 Share Posted March 3, 2003 Hi cachers, Would it be possible to make search results downloadable in a comma separated file? I happened to be able to lay my hands on a very nice and easy tool which is able to import these files (Excel, you might know it). I would be able to sort on all kinds of attitributes and use conditional formatting to select the caches of the day (or on latest finds)... Just thinking... Link to comment
+Markwell Posted March 3, 2003 Share Posted March 3, 2003 Pocket Queries that spew to a loc file, and then Geobuddy. Only problem comes when a cache name contains either quotes or commas. Kinda messes up the schema. I like tab delimited. Clayjar helped me out with that once, and I am forever in his debt. Markwell Chicago Geocaching Link to comment
+ClayJar Posted March 3, 2003 Share Posted March 3, 2003 I take it the thing worked, then, eh? Watcher Downloads - Official Geocaching Chat Link to comment
robertlipe Posted March 3, 2003 Share Posted March 3, 2003 quote:Originally posted by Team ArJa:Hi cachers, Would it be possible to make search results downloadable in a comma separated file? I Just thinking... GPSBabel can read either the *.loc or the *.gpx output from Geocaching.com and write it in a CSV that Excel can read. I've done it. It also contains code to avoid the problems with cache names with quotes or commas that Markwell mentions. Link to comment
+Markwell Posted March 3, 2003 Share Posted March 3, 2003 quote:Originally posted by ClayJar:I take it the thing worked, then, eh? I NEVER GOT BACK TO YOU!?!? YES - it worked like a dream. It even corrected a problem that EasyGPS was having. There was one cache that wasn't showing through the Geobuddy transfer, so I had to keep entering the stuff manually for that cache. Watcher and your translation program both showed that the GPX file had the data. Interesting. I've been using it since you sent it to update my offline information. Many kudos and thanks again. Markwell Chicago Geocaching Link to comment
+Chris n Maria Posted March 4, 2003 Share Posted March 4, 2003 As you are working in Excel anyway you could try Waypoint Workbench which reads Loc,GPX and a load of other formats and will export to csv as well. Bear rescues a speciality! London & UK Geocaching Resources: http://www.sheps.clara.net Link to comment
+Beagle Posted March 5, 2003 Share Posted March 5, 2003 quote:Originally posted by Markwell: Kinda messes up the schema. Sounds like Gebuddy doesn't follow the definitions of a .csv file. Fields that contain a comma, should be enclosed by double quotes '"'. It is a fairly common mistake made by many programs that claim to read .csv files for importing or exporting purposes. Beagle As soon as you idiot proof something, they go and make a better idiot! Link to comment
+Markwell Posted March 5, 2003 Share Posted March 5, 2003 Yep. Unfortunately, the originator of Geobuddy sold it off to TopoGrafix - and who knows WHEN the software will get updated. Markwell Chicago Geocaching Link to comment
+Mr. Snazz Posted March 5, 2003 Share Posted March 5, 2003 Why on earth don't more people use TABs for field delimitation? Anyway, I've also used GPSBabel for gpx/loc->comma conversion, and it works splendidly. Link to comment
robertlipe Posted March 5, 2003 Share Posted March 5, 2003 quote:Originally posted by Mr. Snazz:Why on earth don't more people use TABs for field delimitation? Anyway, I've also used GPSBabel for gpx/loc->comma conversion, and it works splendidly. If it really turns you on, you can do tab delims in GPSBabel, too... Link to comment
+Mr. Snazz Posted March 5, 2003 Share Posted March 5, 2003 quote:Originally posted by robertlipe:If it really turns you on, you can do tab delims in GPSBabel, too... I know I just can't see why people tend to use commas over tabs, what with the inherent problems... Link to comment
+fizzymagic Posted March 5, 2003 Share Posted March 5, 2003 Actually, I think tabs have more problems. First, they are nearly impossible for humans to read, unlike properly-done comma-delimited files. Second, and more important, they are nearly impossible to edit, given the way that editors often turn them into spaces. When I write code, I avoid all tabs like the plague, so my editors are all set to automatically turn them into spaces. Third, the tab character was once not a standard character, and couldn't be counted on to work cross-platform. Link to comment
+Mr. Snazz Posted March 6, 2003 Share Posted March 6, 2003 quote:Originally posted by fizzymagic:Actually, I think tabs have _more_ problems. First, they are nearly impossible for humans to read, unlike properly-done comma-delimited files. Second, and more important, they are nearly impossible to edit, given the way that editors often turn them into spaces. When I write code, I avoid all tabs like the plague, so my editors are all set to automatically turn them into spaces. Third, the tab character was once not a standard character, and couldn't be counted on to work cross-platform. Oh, I see. Where I come from, every byte is precious, and human edit-ability/readability don't come in to play. Sometimes it isn't even a tab which is used, but rather the high-bit of a byte. Different worlds. Link to comment
Recommended Posts