Here I am again.
My project has continued since my last post here.
I have converted my MS XL worksheets, which I used so far, to a single XML file manually, with no redundancy.
It can be the basis of a database structure. For that, I have still some work to do.
Anyway, this XML file can give you an idea of a good DB structure.
But this file still has to be inspected by me for defects!
I append a preliminary version of my XML file for you to see. You can open it in web browser.
It does not have all data since I used e-cigarettes in spring 2016, thus some entries may be incomplete.
Also, over time, I refined my recordings.
Somewhat later in 2018, I started to record the IR AC measured with a Vapcell YR1030.
However, its voltage display does not seem to be reliable, thus disregarded; for that, I continue using my good old HP multimeter.
You can download this file and open it in a web browser.
You may lower the zoom factor to avoid line breaks in the display, and/or make the browser window wider.
An XML file is quite self-explanatory.
In the past, I found that even laymen could interpret the content of such files quite well.
At that, it is "well-formed", thus has no structural defects.
Note that some attributes in section entries relate to other sections.
In that case, the information in different sections must be combined.
My XML data is quite complete by now and can be used to create and fill a database.
That might be a good thing, but is not exactly necessary.
HTML + JavaScript + XML might do a good job also.
I'll have to think this over, before using a MySQL database on my Laptop or elsewhere in the WWW.
In my XML file, my mods can be found in section "mods".
Chargers are in section "chargers",
cells in section "cells",
and charges in section "charges", the latter using cell id and mod id.
Note that this section now looks ordered by cell id and time, but this is not a requirement and can change with each new charge data entered!
I also could sort this section by charges:charge:start, without any loss of information.
Quite new is the section "chrg-currents", which gives information about charge currents for cells recommended by Mooch.
It is not referenced by other sections, but may be useful for you before charging a cell.
Date and time noted comply to ISO 8601. This notation is clearly understood all over the world.
Thus, they have an offset to UTC at their end.
Easy to see that for my place they are given in either CET (+01:00) or CEST (+02:00).
You can easily convert this to your own timezone. (If you are not sure, ask Wikipedia).
Please disregard the section "dst" in my XML file. This is just a reminder for me for the place where I live.
You may ignore or delete this data without any problem. It is not referenced elsewhere in sections of this XML file.
And anyway, it won't hurt anybody, be this section present or not.
Feel free to remove it if you want to.
My Vaporesso Tarot Nanos with built-in LiPo cells appear in the "mods" section.
As they have internal cells, I can hardly gather information about their charging data.
But anyway, I do not charge them above 95% displayed, usually lower.
To sum it up, just build your own XML file like I did. It gives you so much more insight about the cells which you are using in your e-cigarettes.
Best regards,
aLyr
PS: The appended file is a .txt file as ECF does not allow to upload XML files. Please download it and change the file suffix from .txt to .xml. Thereafter, opening the file in a web browser ought to work.
