|
|
| (Une révision intermédiaire par le même utilisateur non affichée) |
| Ligne 4 : |
Ligne 4 : |
| | |Tags=SQLite, Useage.db3, remakes | | |Tags=SQLite, Useage.db3, remakes |
| | }} | | }} |
| − | <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>23/07/2025 Moved to Confluence |
| | | | |
| − | =..\_machine\Useage.db3 Database=
| + | [https://stuga-ltd.atlassian.net/wiki/external/MDQ3OGFkZmQ3YTBlNDc5ZmE4YjRkNmRiMDkxYzdlYzU Click Here to view]</translate> |
| − | A database is produced called useage.db3 containing all data for work that has passed through the machine<syntaxhighlight>
| |
| − | Location:
| |
| − | ..masterdir..\_machine\useage.db3
| |
| − | ..masterdir.. is normally c:\ddrive\
| |
| − | </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}}
| |
| − | | |
| − | =..\_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'''==
| |
| − | After a complete day, the runningMH data is compressed and summed into in 15 minute intervals. This process happens when the front end winMulti is run from the desktop - all previous days are archived. The archve data is used to create the daily calculations{{#annotatedImageLight:Fichier:Advanced Database Information Image 5.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/a/aa/Advanced_Database_Information_Image_5.png|href=./Fichier:Advanced Database Information Image 5.png|resource=./Fichier:Advanced Database Information Image 5.png|caption=|size=800px}}
| |
| − | | |
| − | =='''runningSaw'''==
| |
| − | This is the same data as runningMH but for the saw side of a 2-side machine. It is not used in calculation{{#annotatedImageLight:Fichier:Advanced Database Information Image 6.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/d/d6/Advanced_Database_Information_Image_6.png|href=./Fichier:Advanced Database Information Image 6.png|resource=./Fichier:Advanced Database Information Image 6.png|caption=|size=800px}}
| |
| − | | |
| − | == '''timings''' ==
| |
| − | Log of the time taken for each operation macro on each profile. Used to calculate batch time predictions.{{#annotatedImageLight:Fichier:Advanced Database Information Image 7.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/0/07/Advanced_Database_Information_Image_7.png|href=./Fichier:Advanced Database Information Image 7.png|resource=./Fichier:Advanced Database Information Image 7.png|caption=|size=800px}}
| |
| − | | |
| − | == '''timingsArchive''' ==
| |
| − | Archive of the timings data. This process happens when the front end winMulti is run from the desktop - all previous days are archived. The archve data is used to create the daily calculations{{#annotatedImageLight:Fichier:Advanced Database Information Image 8.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/a/a8/Advanced_Database_Information_Image_8.png|href=./Fichier:Advanced Database Information Image 8.png|resource=./Fichier:Advanced Database Information Image 8.png|caption=|size=800px}}<br /></translate>
| |
| | {{PageLang | | {{PageLang |
| | |Language=en | | |Language=en |
Français
English
Deutsch
Español
Italiano
Português