I export all of my cycling activities from Garmin Connect in .tcx format in order to pull them into an application I've developed myself in .Net/SQL Server. The files from the last 2 rides have omitted the <Speed> node from the <TPX> node where it usually resides, and the import into the database is failing as a result. However, average speed is calculated by Garmin Connect and displayed on the summary page for the ride, so I know this data is available, it's just not being exported. Can anyone confirm this is an issue with Garmin Connect? Is there somewhere else I can go to translate my .fit files from the device to .tcx format?
I've recently had the exact same problem. Last few rides. The last data file for me which had speed data was last tuesday (3-11-15) and a ride the next thursday (3-13-15) did not have speed. I tested the hypothesis that speed needed to be a data field. That was wrong.
I hope this gets fixed, I don't want to have to re-write my stand alone application to inject the speed nodes using the differences in time and distance.
I've attached my last file for which speed was present, and the first file for which it wasn't
David if you have any updates id love and email @ [email][email protected][/email]]
I'm a little reluctant to do it though since it might be malware. You never know.
Hey,
I've recently had the exact same problem. Last few rides. The last data file for me which had speed data was last tuesday (3-11-15) and a ride the next thursday (3-13-15) did not have speed. I tested the hypothesis that speed needed to be a data field. That was wrong.
I hope this gets fixed, I don't want to have to re-write my stand alone application to inject the speed nodes using the differences in time and distance.
I've attached my last file for which speed was present, and the first file for which it wasn't
David if you have any updates id love and email @ [email][email protected][/email]]
I tried working with Garmin Support to try to resolve this issue. They wouldn't take my case because my files were created with an older version of the firmware on my Edge 510.
They tried to get me to install Garmin Express on my Windows XP box which, according to their system requirements is not one of the supported OS'es. This move would have, at the least wasted my time, and at most, crippled my registry with conflicts, and/or useless entries.
The lack of <AltitudeMeters> nodes in Garmin Connect .tcx exports must be due to changes in the websites backend processing. Working with a .fit file that Garmin Connect failed to produce a .tcx file with altitude with, I was able to produce a .tcx with altitude using a third party product called TCX Converter: http://www.tcxconverter.com/TCX_Converter/TCX_Converter_ENG.html
Similarly, Strava took that same .fit file and was able to report on altitude which matched the altitude displayed on the 510 for the ride.
The lack of <Speed> nodes in in Garmin Connect .tcx exports is more troubling. TCX Converter did not recover speed information from rides I took after March 8 2015. Cadence information is present in these rides, and I use a combination Speed/Cadence sensor so it doesn't make sense that cadence is present and speed isn't . Prior to March 8th, I hadn't used the Edge 510 for 3 months. When I turned it on on March 8th it took a while to come up. Looking at the files on the device with Windows Explorer, many of the files and folders have a Date Modified timestamp equivalent to the time when I turned it on. Did Garmin try to beam down a code update from a satellite or is there a date based logic bomb in the firmware? I don't know!
Since I'm not optimistic about Garmin resolving this issue in a timely way, I'm going to calculate speed in my application.
I'll keep using the 510 until something else breaks which renders it useless. The only reason I got it in the first place was because it records elevation that Strava recognizes, which is always greater then the elevation that Strava calculates for rides recorded with Iphone apps. If it does break, I'll move back to Cyclemeter.
After data has been pulled from .tcx files into SQL Server here's a solution for calculating speed from distance. The 510 samples every second, the query derives additional meters traveled for each trackpoint node.
======================================================================================================== CREATE PROCEDURE [dbo].[UpdateCalculatedSpeed] @RID int AS
INSERT INTO #TPRaw (RID, DistanceMeters, Extensions_Id) (SELECT T.RID,T.DistanceMeters, E.Extensions_Id FROM Trackpoint AS T INNER JOIN Extensions AS E ON T.RID = E.RID AND T.Trackpoint_Id = E.Trackpoint_Id INNER JOIN TPX AS TX ON E.RID = TX.RID AND E.Extensions_Id = TX.Extensions_Id WHERE TX.RID = @RID)
UPDATE TPX SET CalculatedSpeed = D.MetersPerSecond FROM TPX INNER JOIN (SELECT TP2.RID, TP1.Extensions_Id AS ExId1, TP2.Extensions_Id AS ExId2, TP2.DistanceMeters AS TP2Meters, TP1.DistanceMeters AS TP1Meters, CASE WHEN TP2.Extensions_Id = 0 THEN TP2.DistanceMeters ELSE (TP2.DistanceMeters - TP1.DistanceMeters) END AS MetersPerSecond FROM #TPRaw AS TP1 RIGHT JOIN #TPRaw AS TP2 ON TP2.Extensions_Id = TP1.Extensions_Id + 1) AS D ON TPX.Extensions_Id = D.ExId2 AND TPX.RID = D.RID
