SiDiary > SiDiary English

Importing Data using CSV File

<< < (3/3)

Andi:

--- Zitat von: goofy am August 22, 2005, 21:11 ---i have to correct my previous posting   :patsch:

i´ve tested with this lines

DAY;TIME;KETONE;BG_LEVEL;CH_BE_KHE;BOLUS;BASAL;BLOODPRESSURE;REMARK
22.08.2005;2:48;0;289;0;0;0;0;0
21.08.2005;22:00;0;391;0;0;0;0;0
21.08.2005;17:21;0;142;0;0;0;0;0
21.08.2005;10:32;0;73;0;0;0;0;0

look at the time syntax "hh:mm" not "hh:mm:ss"

 i´m sorry

--- Ende Zitat ---

Hmmmm ... Very simple but effectfull  :rotwerd:

I looked for my data, before i used sidiary:

03.09.2004;06:41;;;;6,0;;;
03.09.2004;06:52;;;8,0;;;;
03.09.2004;10:51;;98;;;;;
03.09.2004;12:14;;;20,0;;;;
03.09.2004;12:14;;;;14,0;;;
03.09.2004;15:13;;118;;;;;

So, i think, the '0' (zero) do not need to filled up ...


Andi

wam67:
I don't know what the problem is . . . . . still no data.  Even after I changed the date format not to include seconds.  I also tried taking out the "0", nothing yet.

Thanks for your patience.   :)

Is there a way to debug the operation?   ???

Thanks,


Walter

Quo:
To debug, the easiest way might be to enter some sample data, and export it. Then you can model your file after the exported data.
I have been successful with files looking like that:

--- Code: ---DAY;TIME;KETONE;BG_LEVEL;CH_BE_KHE;BOLUS;BASAL;BLOODPRESSURE;WEIGHT;REMARK
2005-06-17;17:17;;093;;;;;96.1;
2005-06-17;17:26;;;5;6.2;;;;17:26 1.5 hochgesetzt||

Entries in the "small hours" are formatted with padded zeroes:
2005-05-03;00:23;;065;0.5;;;;;
2005-05-03;02:55;;093;;;;;;
2005-05-03;08:04;;087;;;;;;


--- Ende Code ---

That at least has been the date format I got from a tentative export. I arranged my script reformatting my data for Sidiary so comments got a leading timestamp and a trailing newline (the double-pipe "||") since SiDiary doesn't maintain the association of the comments with the entry they were made to, but accumulates them all for one day. (And, consecutively, on export duplicates them for each and every line exported!) So data into SiDiary is a one-way trip - keep your backups around.
Formatted this way, the comments align in a way that keeps them usable.
I haven't found how to import/export Sport and other fields yet.

Good luck,
   Tatjana

Alf:
Wow,

what a thread when I'm not online for some hours...   :staun:

So of course there's a debug option. ;)

If you would send me your csv file to my personal email address, I will debug it immediately!

Please add some details about your current windows datetime settings.

Cheers, Alf.

Navigation

[0] Themen-Index

[*] Vorherige Sete