Accessing Raw Production Data from Diagnostic SQLite Database

How to access the data stored by winMulti for machine useage

Difficulté

Hard Difficile

Durée

10 minute(s) minute(s)

Introduction

The winMulti software stores the production data in a SQLite database. This tutorial describes how this data can be accessed for further analysis with tools such as Excel and Access

Étape 1 - Ensure you have a SQLite reader installed

Use DB Browser - free download at

https://download.sqlitebrowser.org/DB.Browser.for.SQLite-3.12.2-win64.msi

Étape 2 - Copy the diagnostic database from machine

1. Connect via TeamViewer to the machine and run file transfer
2. Navigate to c:\DDRIVE\_machine\diagnostic\
3. Copy diagnostic.db3 to your local PC

...You can also simply cut and paste this from the TeamViewer desktop to your local desktop

Étape 3 - Open the records and copy the data

1. Open the diagnostic database using DB Browser
2. Select Tab "Browse Data"
3. Select Table "runningMHArchive"
4. Highlight all the records
5. Copy (Ctrl-c)

...The "runningMHArchive" data is an aggregated version of the "runningMH" table. The winmulti software regularly takes the runningMH data for the last month (which is timesliced in minutes) and aggregates it into 15 minute slots. If you want data from the last month, use the runningMH table instead NOTE - This has been changed on version 6.5.24.0 software to aggregate the previous 2 days rather than one month

Étape 4 - Paste into your preferred data application

1. Open a blank page in Excel
2. Select the first cell
3. Paste the data
4. Put in the field headers if required

Étape 5 - Data Meanings

See Understanding Output Timings Tab#Output Timings Tab for more information on precisely what the numbers mean, but in general

The data is sliced into 15 minute intervals

Pieces cut – the qty of finished pieces output

Frames Cut – Increments when the final piece of a whole frame/slot is cut (this is not reliable data)

Running Time – Time in seconds that the machine is operational

Loading Time – Time in seconds that machine is loading bars (not machining)

Idle Time – Time in seconds where the machine is idle

Operator Wait – Time in seconds waiting for an operator to do something

en none 0 Draft