Mercurial > bms / annotate

README.design@fda7286871f2 (annotated)

README.design

Sun, 27 Jan 2019 17:39:53 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Sun, 27 Jan 2019 17:39:53 +0100
changeset 216
fda7286871f2
parent 212
adda48f710cd
child 217
318aab371497
permissions
-rw-r--r--

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.

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.
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
43 profile_mash 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
44 profile_profiles Ok. Ok. Ok.
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
45 profile_styles 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
46 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
47 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
48 products
18
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 0
diff changeset
49
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
50
21
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
51
18
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 0
diff changeset
52
0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
53 Database:
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
54
104
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
55 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
56 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
57 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
58 4. Export naar beerxml.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
59 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
60 6. Brouwerij configuratie voornamelijk in json.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
61
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 MQTT structuur volgens Sparkplug model.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
64
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
65 mbv1.0/fermenters/[NBIRTH,DBIRTH]/<hostname>/
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
66 mbv1.0/fermenters/DDATA/<hostname>/<unitalias>/
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
67
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 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
71
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
72 namespace is de root, "mbv1.0"
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
73
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
74 group_id oa: fermenters, brewcontrol, env_sensor
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
75
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
76 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
77 NDEATH - Death certificate for MQTT EoN nodes.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
78 NCMD - Node command message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
79 DBIRTH - Birth certificate for devices.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
80 DDEATH - Death certificate for devices.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
81 NDATA - Node data message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
82 DDATA - Device data message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
83 DLOG - Device data logging.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
84 DCMD - Device command message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
85 STATE - Critical application state message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
86
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
87 NCMD: reboot (application restart)
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
88 rebirth
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
89
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
90 DCMD: fermenter state change + temperature settings.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
91 fermenter profile install.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
92 fermenter load product.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
93 fermenter set stage
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
94
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
95
109
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
96 Product: code, uuid en naam.
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
97 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
98 | | | | | |
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
99 | | | | | +------------- Log/rapport
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
100 | | | | +------------------------ rapport/etiketten
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
101 | +-------+---------+--------------------------------- Log/rapport
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
102 +--------------------------------------------------------- Log/rapport
0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
103
174
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
104 Main table: products.
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
105 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
106 In Progress: view charts. DONE fermenters, todo brewlogs.
174
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
107 In Progress: view logs.
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
108 In Progress: update state.
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
109 In Progress: Tabbed screens. DONE.
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
110 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
111 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
112 Calendar: shows upcoming events.
174
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
113 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
114 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
115 Recipes Beerxml import.
106
c64d979613ab Prepare for production brews databases
Michiel Broek <mbroek@mbse.eu>
parents: 104
diff changeset
116
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
117 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
118
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 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
122
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 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
124 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
125
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 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
127 | | | | | | | | | | | | | | |
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 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
129 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
130 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
131 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
132 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
133 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
134 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
135 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
136 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
137 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
138 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
139 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
140 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
141 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
142 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
143
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 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
145 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
146 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
147
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

Mercurial Repository: bms

mercurial