README.design

Sat, 02 Feb 2019 14:57:41 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Sat, 02 Feb 2019 14:57:41 +0100
changeset 232
daf2d9d6fa18
parent 218
38499e3859fa
child 239
03e81378182d
permissions
-rw-r--r--

When adding yeast the flocculation and cells fields were not added. Possible fix for double water agents in the miscs grid. Better efforts to set the initial water infuse amount. The new recipe wizzard now uses indexed fields. In recipe print fixed the yeast amount and cost.

0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
1 Centrale daemon 'bmsd' regelt de dagelijkse berichten tussen MQTT en de
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
2 database. Om deze berichten betrouwbaar af te handelen is MQTT er tussen
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
3 gezet.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
4 Alle sensoren en controllers communiceren uitsluitend via MQTT.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
5
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
6 Sensoren en controllers:
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
7
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
8 1. Vergisting controllers.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
9 2. Temperatuur loggen.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
10 3. Hergisting drukmeters. (druk + temp).
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
11 4. Brouw controllers.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
12 5. Ispindel.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
13
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
14
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
15 Stappen:
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
16
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
17 1. Importeren oude vergisting en brouw logs. DONE.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
18 2. Thermferm moet DLOG berichten gaan sturen, per wijziging en per 5 minuten. DONE.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
19 3. bmsd moet deze DLOG berichten verwerken. Versie 0.0.2. Bier producten in database. DONE.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
20 4. Versie 0.0.2 handmatig installeren op productie. DONE.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
21 5. Thermferm uitbreiden met vergisting stage. DONE.
104
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
22 6. Brouw controller uitbreiden met MQTT. Niet, ESP32 wordt onstabiel.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
23 7. bmsd uitbreiden met brouw controller berichten. Niet, zie hierboven.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
24 8. bmsd productie platform upgraden, versie 0.0.3 DONE.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
25 9. bmsd recepten editor implementeren, geschikt voor enkel recepten en productie.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
26 10. bmsd uitbreiden met productie stappen, met hieraan productie recepten.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
27 11. bmsd koppelen logs aan productie.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
28
0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
29
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
30
54
294dda7f1779 Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents: 40
diff changeset
31 Web interface bouwen met jqwidgets.
0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
32
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
33
195
2ac491548d8d Fermentables database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Added the added and dissolved_protein fields. Removed the ibu_gal_per_lb field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents: 194
diff changeset
34 Database inventaris: Werking Maten Index/Strings Bool/Ints Utf-8 POST
2ac491548d8d Fermentables database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Added the added and dissolved_protein fields. Removed the ibu_gal_per_lb field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents: 194
diff changeset
35 ---------------------------- ------- ------- ------------- --------- ----- ----
210
3ced4934e230 Updated design document
Michiel Broek <mbroek@mbse.eu>
parents: 200
diff changeset
36 inventory_equipments Ok. Ok. Ok. Ok. Ok. Ok.
196
531d5458782f Hops database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Removed the useat field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents: 195
diff changeset
37 inventory_fermentables Ok. Ok. Ok. Ok. Ok. Ok.
531d5458782f Hops database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Removed the useat field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents: 195
diff changeset
38 inventory_hops Ok. Ok. Ok. Ok. Ok. Ok.
200
7b2f11652d67 Miscs from bool to ints. Miscs database uses POST instead of GET. Dropdowns are unsing indexes. Dynamic edit screen adjust for weight and liter. Edit screen redesigned. Friendly show duration of ingredients.
Michiel Broek <mbroek@mbse.eu>
parents: 198
diff changeset
39 inventory_miscs Ok. Ok. Ok. Ok. Ok. Ok.
210
3ced4934e230 Updated design document
Michiel Broek <mbroek@mbse.eu>
parents: 200
diff changeset
40 inventory_suppliers Ok. Ok. Ok. Ok. Ok. Ok.
3ced4934e230 Updated design document
Michiel Broek <mbroek@mbse.eu>
parents: 200
diff changeset
41 inventory_water Ok. Ok. Ok. Ok. Ok. Ok.
198
f0ec83e1e01f Switches yeasts inventory to indexed names and translations. Database save is using POST instead of GET. Redesigned the web page. Added total cost display which updates on inventory changes.
Michiel Broek <mbroek@mbse.eu>
parents: 196
diff changeset
42 inventory_yeasts Ok. Ok. Ok. Ok. Ok. Ok.
217
318aab371497 Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents: 216
diff changeset
43 profile_fermentation Ok. Ok. Ok. Ok. Ok. Ok.
216
fda7286871f2 Fixed the utf-8 problems when storing json arrays on the server by using manual encoding. The json-encode function sucks for this project. Added step detail edit screen instead of on grid cell editing. This must go into the product and recipe editors too.
Michiel Broek <mbroek@mbse.eu>
parents: 212
diff changeset
44 profile_mash Ok. Ok. Ok. Ok. Ok. Ok.
218
38499e3859fa Global setup switched to dropdown indexes.
Michiel Broek <mbroek@mbse.eu>
parents: 217
diff changeset
45 profile_setup Ok. Ok. Ok. Ok. Ok. Ok.
217
318aab371497 Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents: 216
diff changeset
46 profile_styles Ok. Ok. Ok. Ok. Ok. Ok.
212
adda48f710cd Water profile uses POST instead of GET. Added tooltips to the editor screen. Updated the editor screen. Total alkalinity and Bicarbonate update each other. More and smaller columns in the listing screen. Rearranged the editor screen.
Michiel Broek <mbroek@mbse.eu>
parents: 210
diff changeset
47 profile_water Ok. Ok. Ok. Ok. Ok. Ok.
195
2ac491548d8d Fermentables database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Added the added and dissolved_protein fields. Removed the ibu_gal_per_lb field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents: 194
diff changeset
48 recipes
2ac491548d8d Fermentables database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Added the added and dissolved_protein fields. Removed the ibu_gal_per_lb field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents: 194
diff changeset
49 products
18
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 0
diff changeset
50
200
7b2f11652d67 Miscs from bool to ints. Miscs database uses POST instead of GET. Dropdowns are unsing indexes. Dynamic edit screen adjust for weight and liter. Edit screen redesigned. Friendly show duration of ingredients.
Michiel Broek <mbroek@mbse.eu>
parents: 198
diff changeset
51
21
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
52
18
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 0
diff changeset
53
0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
54 Database:
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
55
104
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
56 1. Recepten opslaan standaard maar ingredienten in json formaat omdat dit flexibel is.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
57 2. Productie Brouwsels bevatten ook logs, en linken naar een extra recepten database (brews).
63
1d1e3002f26b Design update
Michiel Broek <mbroek@mbse.eu>
parents: 54
diff changeset
58 3. Inventaris ingredienten in MySQL. Voorraad historie is extra arrays.
0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
59 4. Export naar beerxml.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
60 5. Import van brouwhulp xml met sync vanuit backup locatie.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
61 6. Brouwerij configuratie voornamelijk in json.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
62
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
63
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
64 MQTT structuur volgens Sparkplug model.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
65
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
66 mbv1.0/fermenters/[NBIRTH,DBIRTH]/<hostname>/
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
67 mbv1.0/fermenters/DDATA/<hostname>/<unitalias>/
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
68
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
69 ---------------------------------------------------------------------------
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
70
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
71 namespace/group_id/message_type/edge_node_id/{device_id}
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
72
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
73 namespace is de root, "mbv1.0"
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
74
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
75 group_id oa: fermenters, brewcontrol, env_sensor
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
76
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
77 message_type: NBIRTH - Birth certificate for MQTT EoN nodes.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
78 NDEATH - Death certificate for MQTT EoN nodes.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
79 NCMD - Node command message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
80 DBIRTH - Birth certificate for devices.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
81 DDEATH - Death certificate for devices.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
82 NDATA - Node data message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
83 DDATA - Device data message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
84 DLOG - Device data logging.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
85 DCMD - Device command message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
86 STATE - Critical application state message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
87
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
88 NCMD: reboot (application restart)
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
89 rebirth
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
90
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
91 DCMD: fermenter state change + temperature settings.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
92 fermenter profile install.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
93 fermenter load product.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
94 fermenter set stage
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
95
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
96
109
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
97 Product: code, uuid en naam.
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
98 Stage: Plan Wait Brew Primary Secondary Tertiary Package Carbonation Mature Taste Ready Closed
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
99 | | | | | |
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
100 | | | | | +------------- Log/rapport
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
101 | | | | +------------------------ rapport/etiketten
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
102 | +-------+---------+--------------------------------- Log/rapport
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
103 +--------------------------------------------------------- Log/rapport
0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
104
174
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
105 Main table: products.
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
106 In progress: overview.
180
a5aa3502310c Updated README. Getfermenter and getnode scripts return 0 and 1 instead of false and true for boolean values. Global variable my_uuid added. Moved the javascript out of mon_fermenter.php. Added log chart view button in the fermenter monitor.
Michiel Broek <mbroek@mbse.eu>
parents: 174
diff changeset
107 In Progress: view charts. DONE fermenters, todo brewlogs.
174
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
108 In Progress: view logs.
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
109 In Progress: update state.
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
110 In Progress: Tabbed screens. DONE.
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
111 Start new: some sort of wizzard like a new recipe. DONE.
109
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
112 Archive: select via name/code/date.
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
113 Calendar: shows upcoming events.
174
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
114 Recipes can be copied to 'recipes' or 'brews', imported from 'recipes'/'products' or created manual.
180
a5aa3502310c Updated README. Getfermenter and getnode scripts return 0 and 1 instead of false and true for boolean values. Global variable my_uuid added. Moved the javascript out of mon_fermenter.php. Added log chart view button in the fermenter monitor.
Michiel Broek <mbroek@mbse.eu>
parents: 174
diff changeset
115 Products recipes Beerxml import.
a5aa3502310c Updated README. Getfermenter and getnode scripts return 0 and 1 instead of false and true for boolean values. Global variable my_uuid added. Moved the javascript out of mon_fermenter.php. Added log chart view button in the fermenter monitor.
Michiel Broek <mbroek@mbse.eu>
parents: 174
diff changeset
116 Recipes Beerxml import.
106
c64d979613ab Prepare for production brews databases
Michiel Broek <mbroek@mbse.eu>
parents: 104
diff changeset
117
114
4935e86b2775 Small fixes for prject import from Brouwhulp. Fixes for poduct database read/write. New menu entries. Equipment select in product editor. Started brewday editor. Added conditions on some buttons and edit fields. Screen layout changes.
Michiel Broek <mbroek@mbse.eu>
parents: 109
diff changeset
118 Een cronjob om de Stage bij te werken in geval van Package .. Taste.
194
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
119
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
120 -----------------------------------------------------------------------------
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
121
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
122 Formaat csv vergisting logs.
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
123
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
124 Directory: www/logs/fermentation
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
125 Filenaam: product_code\ product_name.log
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
126
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
127 2014-11-15 18:39,BEER,PRIMARY,20.312,19.750,-1.500,20.5,18.6,18.8,35,12345,0,67890,Whatsup,Fermenter
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
128 | | | | | | | | | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
129 0 datetime + | | | | | | | | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
130 1 mode --------------+ | | | | | | | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
131 2 stage -------------------+ | | | | | | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
132 3 temp air -----------------------+ | | | | | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
133 4 temp beer -----------------------------+ | | | | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
134 5 temp chiller ---------------------------------+ | | | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
135 6 temp room -------------------------------------------+ | | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
136 7 setpoint low ---------------------------------------------+ | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
137 8 setpoint high -------------------------------------------------+ | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
138 9 heater power ------------------------------------------------------+ | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
139 10 heater usage ----------------------------------------------------------+ | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
140 11 cooler power --------------------------------------------------------------+ | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
141 12 cooler usage ------------------------------------------------------------------+ | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
142 13 event --------------------------------------------------------------------------------+ |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
143 14 fermenter uuid --------------------------------------------------------------------------------+
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
144
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
145 De oude logs zijn geimporteerd en geconverteerd. Nieuwe worden geschreven
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
146 door bmsd welke de log gegevens ontvangt via MQTT DLOG berichten.
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
147 Vanwege de snelheid van verwerken staan de logs niet in de database.
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
148
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
149 -----------------------------------------------------------------------------
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
150

mercurial