| [version en cours de rédaction] | [version en cours de rédaction] |
(Page créée avec « {{Tuto Details |Description=<translate>Data contained in the winmulti version 6 SQLite databases</translate> |Categories=Software |Tags=SQLite, Useage.db3, remakes }} <tra... ») |
|||
| Ligne 6 : | Ligne 6 : | ||
<translate>{{Warning|...All .db3 databases are live data and use a very simple SQLite structure. They are not designed for advanced sharing and should be treated as read only. A copy of the database should be made before running any queries}}<br /> | <translate>{{Warning|...All .db3 databases are live data and use a very simple SQLite structure. They are not designed for advanced sharing and should be treated as read only. A copy of the database should be made before running any queries}}<br /> | ||
| − | = Useage.db3 Database = | + | =..\_machine\Useage.db3 Database= |
A database is produced called useage.db3 containing all data for work that has passed through the machine<syntaxhighlight> | A database is produced called useage.db3 containing all data for work that has passed through the machine<syntaxhighlight> | ||
Location: | Location: | ||
| Ligne 12 : | Ligne 12 : | ||
..masterdir.. is normally c:\ddrive\ | ..masterdir.. is normally c:\ddrive\ | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| + | |||
'''Database Structure'''{{#annotatedImageLight:Fichier:Advanced Database Information Image.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/f/fb/Advanced_Database_Information_Image.png|href=./Fichier:Advanced Database Information Image.png|resource=./Fichier:Advanced Database Information Image.png|caption=|size=800px}} | '''Database Structure'''{{#annotatedImageLight:Fichier:Advanced Database Information Image.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/f/fb/Advanced_Database_Information_Image.png|href=./Fichier:Advanced Database Information Image.png|resource=./Fichier:Advanced Database Information Image.png|caption=|size=800px}} | ||
| + | = ..\_machine\diagnostic\diagnostic.db3 = | ||
| + | <syntaxhighlight> | ||
| + | Location: | ||
| + | ..masterdir..\_machine\diagnostic\diagnostic.db3 | ||
| + | ..masterdir.. is normally c:\ddrive\ | ||
| + | </syntaxhighlight><br /> | ||
| + | |||
| + | == Alarm Log == | ||
| + | logs every alarm that is triggered{{#annotatedImageLight:Fichier:Advanced Database Information Image 1.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/a/a0/Advanced_Database_Information_Image_1.png|href=./Fichier:Advanced Database Information Image 1.png|resource=./Fichier:Advanced Database Information Image 1.png|caption=|size=800px}} | ||
| + | |||
| + | == '''Odometer''' == | ||
| + | under development{{#annotatedImageLight:Fichier:Advanced Database Information Image 2.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/8/8a/Advanced_Database_Information_Image_2.png|href=./Fichier:Advanced Database Information Image 2.png|resource=./Fichier:Advanced Database Information Image 2.png|caption=|size=800px}}<br /> | ||
| + | |||
| + | == '''Production Reports''' - == | ||
| + | Log of each report sent to the production email address with the totals of the daily production values{{#annotatedImageLight:Fichier:Advanced Database Information Image 3.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/e/ed/Advanced_Database_Information_Image_3.png|href=./Fichier:Advanced Database Information Image 3.png|resource=./Fichier:Advanced Database Information Image 3.png|caption=|size=800px}}<br /> | ||
| + | == '''runningMH''' == | ||
| + | Log of each minute of running detailing how many seconds in that minute the machine was running, idle or waiting for an operator.{{#annotatedImageLight:Fichier:Advanced Database Information Image 4.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/a/a8/Advanced_Database_Information_Image_4.png|href=./Fichier:Advanced Database Information Image 4.png|resource=./Fichier:Advanced Database Information Image 4.png|caption=|size=800px}}<br /> | ||
| + | == '''runningMHArchive''' == | ||
<br /></translate> | <br /></translate> | ||
{{PageLang | {{PageLang | ||
| + | |Language=en | ||
|SourceLanguage=none | |SourceLanguage=none | ||
|IsTranslation=0 | |IsTranslation=0 | ||
| − | |||
}} | }} | ||
{{AddComments}} | {{AddComments}} | ||
Version du 30 juin 2022 à 10:59
Data contained in the winmulti version 6 SQLite databases
..\_machine\Useage.db3 Database
A database is produced called useage.db3 containing all data for work that has passed through the machine
Location:
..masterdir..\_machine\useage.db3
..masterdir.. is normally c:\ddrive\
Database Structure
..\_machine\diagnostic\diagnostic.db3
Location:
..masterdir..\_machine\diagnostic\diagnostic.db3
..masterdir.. is normally c:\ddrive\
Alarm Log
logs every alarm that is triggered
Odometer
under development
Production Reports -
Log of each report sent to the production email address with the totals of the daily production values
runningMH
Log of each minute of running detailing how many seconds in that minute the machine was running, idle or waiting for an operator.
runningMHArchive
Draft
Français
English
Deutsch
Español
Italiano
Português