[wam67]

Hi,

I'm trying to import data into SiDiary using a CSV file, and even though it says the values were imported, I don't see any values in the program afer I'm done.

Can someone please help?

Thanks,



Walter

[Andi]

Hi, Walter

Can someone please help?

Is it posible, to post the four or five first lines from your 'csv'-File?

Withhin your question without an example it is not easy to help you


Andi

[wam67]

Hi Andi,

Here are the first few lines of my file:


DAY;TIME;KETONE;BG_LEVEL;CH_BE_KHE;BOLUS;BASAL;BLOODPRESSURE;REMARK
8/22/2005,2:48:00,0,289,0,0,0,0,0
8/21/2005,22:02:00,0,391,0,0,0,0,0
8/21/2005,17:21:00,0,142,0,0,0,0,0
8/21/2005,10:32:00,0,73,0,0,0,0,0
8/21/2005,9:25:00,0,107,0,0,0,0,0
8/21/2005,8:19:00,0,117,0,0,0,0,0


Hope this enough.

Thanks,



Walter

[goofy]

Hi!
I would suggest that you try this: Seperate the data by ";" and do not use a ",". Then the values should be visible. (I have the tested it with the german version.) The csv-file you want to import sould look like the following:

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

[wam67]

Hi,

I tried using ";" instead of "," but I get the same result.

It says the values were imported, but I don't see them in the BG-Grid or anywhere else.

I don't know what I'm doing wrong.

Thanks for the suggestion,



Walter

[goofy]

Hi Walther,

have you  tried to change the the syntax for "Day" from "mm/dd/yyy" to "dd.mm.yyyy"

I have received the same message which told me that the data was imported and yet I did not see them. After I have changed the syntax to the german notification the data was readable.

[Andi]

I tried using ";" instead of "," but I get the same result.

...

I don't know what I'm doing wrong.

See the difference:
Walter: 8/21/2005,9:25:00,0,107,0,0,0,0,0
Goofy:  21.08.2005;17:21:00;0;142;0;0;0;0;0

I think, the date has to be corrected ...


Andi

[wam67]

Hi,

This is my new data file:

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

Same problem . . . . unfortunately.


Walter

[Andi]

This is my new data file:

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

Same problem . . . . unfortunately.

Thats rather hard 

Alf, i think, this is now your turn


Andi

[goofy]

i have to correct my previous posting   

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