Autor Thema: Importing Data from a New Qardio BP Meter  (Gelesen 6700 mal)

Offline craigwalsh

  • Newbie
  • *
  • Beiträge: 6
  • Country: us
    • Walsh Family History
  • Diabetestyp: DM 2
  • Therapie: Insulin-Pen
Importing Data from a New Qardio BP Meter
« am: April 02, 2016, 00:06 »
I've just purchased a Qardio blood pressure meter -- it is about 1/3 of the size of my Withings BP meter, and much easier to use.  My blood pressure and pulse are automatically downloaded from the meter to my iPhone (along with whether my pulse is regular or irregular).  To export these readings from the Qardio application I simply click a few buttons and the app sends me an e-mail message with an attached .csv file.

The meter is described at www.getquardio.com - they also appear to be on the brink of selling a portable, user-friendly ECG/EKG device.  But that's a story for another day . . .

The .csv format, as it comes from the Qardio system, is as follows:

SYS   DIA   BPM   NOTE   DATE   IHB
123   76   58      3/31/2016 22:59   regular
129   77   58      3/30/2016 23:04   regular

I followed the instructions in the manual to convert this (I think) to the correct import format:

SYS   DIA   BLOODPRESSURE   UDT_PULSE   DAY   TIME   UDT_HRTBEAT
123   76   123/76   58   3/31/2016   22:59:19   regular
129   77   129/77   58   3/30/2016   23:04:47   regular

I also created PULSE and HRTBEAT as user-defined data fields.

I tried to import my .csv file (after having made the conversions, above) into SiDiary 6 on my Windows computer.  The import seemed to go well, but then I was told that there was no new data to import.

I'm at a bit of a loss now.  Can anyone please help me figure out how to import the data exported from my new BP meter?

Thanks

Craig

« Letzte Änderung: April 02, 2016, 01:13 von craigwalsh »
Craig Walsh

Offline craigwalsh

  • Newbie
  • *
  • Beiträge: 6
  • Country: us
    • Walsh Family History
  • Diabetestyp: DM 2
  • Therapie: Insulin-Pen
Re: Importing Data from a New Qardio BP Meter
« Antwort #1 am: April 02, 2016, 00:52 »
I've tinkered a bit more and have changed the .csv file to:

SYS,DIA,BLOODPRESSURE,UDT_PULSE,DAY,TIME,UDT_HRTBEAT
123,76,123/76,58,03/31/16,22:59,regular
129,77,129/77,58,03/30/16,23:04,regular
128,75,128/75,56,03/29/16,23:19,irregular
127,73,127/73,60,03/28/16,23:56,regular
124,72,124/72,53,03/28/16,16:43,regular

Still doesn't work.  As the device puts SYS and DIA in separate columns, the BLOODPRESSURE column is a combination of the two.  If I delete SYS and DIA the resultant column contains nonsense. 

The SiDiary user manual indicated (or seemed to me to indicate) that columns that did not have recognized headers would be disregarded.

The date format in SiDiary is mm/dd, and the time format is 24 hour.

I'm still at a loss to figure out why this won't import.

Thanks for any suggestions or advice.

Craig
« Letzte Änderung: April 02, 2016, 01:14 von craigwalsh »
Craig Walsh

Offline craigwalsh

  • Newbie
  • *
  • Beiträge: 6
  • Country: us
    • Walsh Family History
  • Diabetestyp: DM 2
  • Therapie: Insulin-Pen
Re: Importing Data from a New Qardio BP Meter
« Antwort #2 am: April 02, 2016, 02:16 »
Deleted the extraneous columns.  New .csv file:

UDT_PULSE,DAY,TIME,UDT_HRTBEAT,BLOODPRESSURE
58,03/31/16,22:59,regular,123/76
58,03/30/16,23:04,regular,129/77
56,03/29/16,23:19,irregular,128/75
60,03/28/16,23:56,regular,127/73
53,03/28/16,16:43,regular,124/72

Still no luck.

C
Craig Walsh

Offline craigwalsh

  • Newbie
  • *
  • Beiträge: 6
  • Country: us
    • Walsh Family History
  • Diabetestyp: DM 2
  • Therapie: Insulin-Pen
Re: Importing Data from a New Qardio BP Meter
« Antwort #3 am: April 02, 2016, 19:06 »
It was suggested that I add pulse after the systolic/diastolic readings -- i.e. systolic/diastolic/pulse.

I did so, and deleted the user-defined (UDT) pulse column.

New .csv file:

DAY,TIME,UDT_HRTBEAT,BLOODPRESSURE
3/31/2016,22:59,regular,123/76/58
3/30/2016,23:04,regular,129/77/58
3/29/2016,23:19,irregular,128/75/56
3/28/2016,23:56,regular,127/73/60
3/28/2016,16:43,regular,124/72/53

Alas, still doesn't work.

Craig Walsh

Offline Joerg Moeller

  • Administrator
  • Special Member
  • *****
  • Beiträge: 16763
  • Country: de
  • Ohana heißt "Familie"...
    • Diabetesinfo
  • Diabetestyp: DM 1
  • Therapie: Insulin-Pumpe
Re: Importing Data from a New Qardio BP Meter
« Antwort #4 am: April 04, 2016, 13:48 »
No, but...

DAY;TIME;UDT_HRTBEAT;BLOODPRESSURE
3/31/2016;22:59;regular;123/76/58
3/30/2016;23:04;regular;129/77/58
3/29/2016;23:19;irregular;128/75/56
3/28/2016;23:56;regular;127/73/60
3/28/2016;16:43;regular;124/72/53

...works. If course there must be a user defined datatype with 'HRTBEAT' as it's key.

SiDiary uses a semicolon as separator, as shown in our manual and the help function, chapter 6.3.4.1  "Import from a CSV-file"

Kind regards
Joerg
Meine Seite über Diabetes: http://www.diabetesinfo.de/
Meine Facebook-Seite: https://www.facebook.com/Diabetesinfo.de/