Blog

03-07-2014 Jeremy Dahan blog home
Accublog

Import my data

For this test, we will use the Accu-Chek Mobile and a Windows 7 PC.
First, plug in your device to your computer, and access to it:


For me, it’s under G: drive.
In the G: drive, you will find a “Start.html” file, which you need to launch.
(I don’t know why, but I have to launch it with Internet Explorer, otherwise the export doesn’t work.)



Here’s the part that interest us. At the top, you can see a floppy icon and at the top left, the “period” you want to export – the dropdown menu - .



After clicking on the floppy icon, you can save or open the file (in CSV format).
Now, open it with Excel, or if you don’t have it, you can use OpenOffice.org.
Here’s how my file look like in Excel, and I’ll need to clean it up and keep only 3 columns, remove 2 lines, and rename the first one.
So change your file from this:



To this:


I renamed the column « Date » to « date », “Heure” to “time” and “Résultats” to “value”.

To be clear, the column which contains the date, has to be named “date”, the one which contains the time: “time” and the one which contains your glucose results “value”. The columns names are really important to make the import work.
To delete columns and/or lines, use this tool in Excel:

The last step is to save the file in CSV format with “;” separator:
(point-virgule = semicolon)



You can name the file like you want, it won’t change anything.
You can check your file to ensure that there is not extra column, to do this, open it with notepad, you should have something like this:



At the bottom of your file opened with notepad, or any other text editor, be sure to don’t have extra line. If there are “empty” lines, delete it until your file end with the last value :



Here, I’m at the end of my file and I can’t scroll anymore, this is what you should have, otherwise, the import will failed on dipikapp.

And we’re done with our file, with just need to import it on dipikapp, in the “glucose” page.

Here, choose the file you just created with the “choose file” button, and click on “Import CSV’.


If your file is correct (no extra column or extra line), it should work and display a message saying that the importation went well.

In my example, I choosed to import 14 days, so about 100 values, but you can import many more.

I hope I was clear enough to show you how to import your data from your meter, and if you have any questions, feel free to contact us through the contact form on the home page.

Bye!

PS: Sorry for the non-french speaker, all my software are in French and I’m not able to change the language once it’s installed.