5,838
edits
Diary.db: Difference between revisions
From Cumulus Wiki
Jump to navigationJump to search
m
Remove duplicated text
m (→Content) |
m (Remove duplicated text) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
'''This is the file where MX stores its [[Weather Diary]]''' | '''This is the file where MX stores its [[Weather Diary]]''' | ||
=Introduction = | =Introduction = | ||
| Line 22: | Line 21: | ||
*Entry (a text field for storing comments) | *Entry (a text field for storing comments) | ||
= Accessing MX diary outside MX = | |||
The weather diary is stored in | The weather diary is stored in a sqLite database and that can be easily accessed by any ODBC software (e.g. Libre Office Base) and many other well known database software. It can also be accessed using PDO instructions in PHP Hypertext Preprocessor. | ||
Here is an example in a PHP 7.3 (please note, this script will not work without changes for PHP 7.4, and PHP 8.x) script (modification of script available in [[File:Snow diary.zip]]) of accessing any one day ($rowMetDayStamp in yyyy-mm-dd format): | Here is an example in a PHP 7.3 (please note, this script will not work without changes for PHP 7.4, and PHP 8.x) script (modification of script available in [[File:Snow diary.zip]]) of accessing any one day ($rowMetDayStamp in yyyy-mm-dd format): | ||
| Line 47: | Line 46: | ||
foreach($row as $key => $value ) | foreach($row as $key => $value ) | ||
{ | { | ||
[[MX_on_Linux#Editing_the_Weather_Diary]] if($key == 'Timestamp') | |||
{ | { | ||
$keyDate = substr($value, 0, 10); | $keyDate = substr($value, 0, 10); | ||
| Line 68: | Line 67: | ||
</pre> | </pre> | ||
==Editing== | |||
Please see [[MX_on_Linux#Editing_the_Weather_Diary]], although that applies to Linux devices a similar approach can be taken using Microsoft Windows. | |||
[[Category: | |||
[[Category:Cumulus Files]] | |||
[[Category:Cumulus MX]] | [[Category:Cumulus MX]] | ||
