Failed to import activity about activitylog2 HOT 5 CLOSED

(Sorry, I closed this by clicking the wrong button, reopening it)

Can you share that activity, so I can have a look? Either attach it to this issue, or send it to me directly at [email protected]. I have a large collection of "odd" FIT files for testing, but it seems that there is always a new one, which breaks...

Also, does this activity contain data collected using a "Connect IQ" application? (support for these is new).

from activitylog2.

Yes the activity contains data from a connect iq data field...it is a multi data field in one page using stock data field showed...and the Garmin connect iq power field.

All my activities since years have this kind of data because I use this all in one data field .

In fact I tried to import also other activities and none worked..
( Sorry I closed also by mistake clicking in phone...reopened)

from activitylog2.

The patch below will avoid inserting the multi-value field in the database, and the activity will import correctly (without that field being added). You will still be able to see the running power data.

I will push a fix later today (I want to do some more testing), but meanwhile, you can apply the patch below, by saving it to a file (make sure you use UNIX line endings) and using "git apply". A;ternatively, you can open the "rkt/database.rkt" file in a text editor, find the xdata-store-values and xdata-store-summary-values functions and replace the "(when val" lines with "(when (and val (or (number? val) (string? val) (bytes? val)))".

Also, how does Garmin Connect display this field in its GUI? I am not sure there is enough information in the FIT file itself to display it properly...

 rkt/database.rkt | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/rkt/database.rkt b/rkt/database.rkt
index 154ceea..157bb46 100644
--- a/rkt/database.rkt
+++ b/rkt/database.rkt
@@ -364,7 +364,7 @@
 (define (xdata-store-values db record id xdata-fields)
   (for (([field-key field-id] (in-hash xdata-fields)))
     (define val (dict-ref record field-key #f))
-    (when val
+    (when (and val (or (number? val) (string? val) (bytes? val)))
       (query-exec db sql-insert-xdata-value id field-id val))))
 
 (define sql-insert-xdata-summary-value
@@ -379,7 +379,7 @@
 (define (xdata-store-summary-values db record id xdata-fields)
   (for (([field-key field-id] (in-hash xdata-fields)))
     (define val (dict-ref record field-key #f))
-    (when val
+    (when (and val (or (number? val) (string? val) (bytes? val)))
       (query-exec db sql-insert-xdata-summary-value id field-id val))))

from activitylog2.

Hi @airon111 , I updated the master branch with a fix for this issue. Can you please fetch the latest sources, rebuild the application and try to import again? Thanks, Alex.

from activitylog2.

Pulled latest sources and tried it, working perfectly...
Thank you very much

from activitylog2.