Unable to import simple CSV

[GoogleCodeExporter]

Windows 7/64, WB CSV import 3.0.9 (also tried 3.0.3)

I have imported a gpx file containing a route to ST3.
I have downloaded an Excel spreadsheet with the HR data
I have exported that excel spreadsheet to csv with following syntax

category,date,time,heartrate,power
Running,22/04/2012,10:52:58,93,83
,,10:52:59,94,83
,,10:53:00,96,83

The original csv file contains over 10,000 lines of HR date, but I have 
simplified it to 3 lines above to test.

When importing as CSV for the above file, it shows the attached CSV1.  If I 
tick the 22/4 and hit next it shows CSV4.  Note that the add/update data fields 
are all grayed out.

If I try this with the 10K line file, it shows 10K items all ticked for the 
5/11 (I tested this yesterday) and the last on is the 22/4 showing same date 
found.

Original issue reported on code.google.com by antony.b...@gmail.com on 5 Nov 2012 at 10:59

Attachments:

• CSV1.jpg
• CSV4.jpg

[GoogleCodeExporter]

Only the first data row contains the activity and date. When you expect that 
this import updates one single activity, all data rows of one training need to 
have the same date. Otherwise the plugin will not link the data.

Original comment by wolfgang...@googlemail.com on 6 Nov 2012 at 7:11

[GoogleCodeExporter]

Your comment seems at odds with the statement in the readme

"When no date is given, multiple lines refer to the same date, or GPS 
coordinates are found, the file is handled as one acitivity with multiple 
trackpoints. Otherwise each line is handled as one activity. "

I am trying to update an existing activity.  I have tried all rows with the 
date.  It still does not work.  I used your CSV exporter tool to export an 
activity and that ONLY has a single date in the first row like my example.

I finally found a problem.  Using your CSV exporter, I did the following

- exported an activity from ST3
- Removed all but 3 data lines
- Changed the date in the first row to my new activity I was trying to merge to
- Tested the import. 

That came up with the single correct activity.

So, I then removed fields one by one from each data row and re-tested the 
import.

It worked until finally I removed the "elevation (m)" field from the import 
file, leaving only the fields in my example, and it no longer worked and 
treated each line as a separate date.

If I add back the elevation it works.

However, that import still did not work correctly as it says that I spend 4700 
minutes in zone 1 HR.  The activity was only 3 hours and the HR data says it 
was only 2 hours.

So, there's something wrong going on.  Is there any way to debug this or log 
the activity?

Original comment by antony.b...@gmail.com on 6 Nov 2012 at 10:44

[GoogleCodeExporter]

Merging data into existing activities is not easy. Once upon a time I invested 
a lot of time into iBike support (merging iBike data into an existing activity 
imported from a GPS device). I'm no longer supporting this Plug-in. The source 
code is available for download ;-)

Original comment by wolfgang...@googlemail.com on 6 Nov 2012 at 11:07

[GoogleCodeExporter]

Cool, I hadn't noticed the source.  I'll download it and see what I can do.  I 
only need it to import a few Suunto Ambit logs that I lost the XML for and I've 
got to fetch the XLS from Suunto's website, but it will be interesting to get 
an idea of the ST3 APIs.

Original comment by antony.b...@gmail.com on 7 Nov 2012 at 4:25