menu

Functionality

Since V10_SP14, the app TS-MDA exports informations about machine states in a machine readable format.

The data enables e.g. evaluations

  • how many hours a day which program was running
  • how much percent of a day a machine stands still

Generation of log files

The log files are in CSV file format. They are saved under "Logs\Logs\Service\Shift Log"

The purpose of the ShiftLog file is to summarize all general information of the monitoring to one file. 

Every monitoring channel that is enabled to write this file will produce one entry (row) after a process has been finished. All monitoring methods write into the same file.

The ToolScope will only start a new file if the given time interval for the file is exceeded or the file gets to big (> 500000 entries).

The file name follows this pattern: shift_log_<NAME_OF_THE_MACHINE>_YYYY-MM-DD HH.MM.SS.csv

Raw file format description

The first line of each file always contains the head line with the column names. Each column is separated by ‘;’ (colon).

Starting with the second line each row contains (separated by colon):

Colon name

Content

TimeStamp

Unix Timestamp; Milliseconds since 1.1.1970

(Time of the event)

Time

Time, Human readable, YYYY-MM-DD HH:MM:SS.SSS

Time zone dependent (SSS=Milliseconds)

MachineName

The name of the Machine (Computer name of ToolScope)

MonitoringChannel

The number of the monitoring channel; Starting with 1

ControlChannel

The number of the control channel; Starting with 1

EntryType

The type of the entry (* Detailed description further down)

ProcessLength

The length of the process in milliseconds

ProcessName

The name of the process (Process identifier)

(Untranslated)

ToolName

The name of the tool (Tool identifier)
(Untranslated)

ISError

Flag 0/1:   -  1: Error in process

ISLearning

Flag 0/1:   -  1: Process was learning process

ISRework

Flag 0/1:   -  1: Process was rework process

Definition of "EntryType"

The purpose of the column “EntryType” is to distinguish between different types of entries.

EntryType

Name

Description

1

PROCESS_END

Process ended (Default entry).

2

IDLE_START

Machine switches from working to idle.

A new row will be added as the machine is not within a process and it is not doing any process feeding for longer than 5 seconds.

3

IDLE_END

A new row will be added as the machine switches from idle to working by starting a new process or start doing process feeding. 

The field ProcessLength will be filled with the idle duration.

4

TS_STARTUP

ToolScope starts up (e.g. reboot or power loss).

The field ProcessLength is filled with the estimated total offline time.

Time will be exact if we have a controlled shutdown and estimated (±30 seconds) if we have a power loss.

5

TS_SHUTDOWN

ToolScope shuts down (entry is created on next startup, but always before the TS_STARTUP event).

 

Example of a file as raw input

TimeStamp;Time;MachineName;MonitoringChannel;ControlChannel;EntryType;ProcessLength;ProcessName;ToolName;ISError;ISLearning;ISRework

1486995410368;2017-02-13 14:16:53.771;TOOLSCOPE_357;1;1;1;3048;$(TechnicalDictionary.25$): 0070_03_01 / $(ProcessIdentifier.ProgramNumberName$): $(TechnicalDictionary.Error$);$(TechnicalDictionary.26$): 7005 / $(ProcessIdentifier.ToolNumberName$): $(TechnicalDictionary.Error$);0;0;0

1486995410368;2017-02-13 14:16:53.886;TOOLSCOPE_357;2;1;1;3048;$(TechnicalDictionary.25$): 0070_03_01 / $(ProcessIdentifier.ProgramNumberName$): $(TechnicalDictionary.Error$);$(TechnicalDictionary.26$): 7005 / $(ProcessIdentifier.ToolNumberName$): $(TechnicalDictionary.Error$);0;0;0

 

Configuring a ToolScope to generate MDA information

  • Select "Log settings" under "Settings" tab in ToolScope.
  • "Storage interval for new files" can be "One file per Day / One file per Minute / One file per Hour / One file per Day / One file per Week / One file per Month / One file per Year".
     

           Note : No restart is required for any change in time interval. ToolScope will automatically adopt the changes selected here.

  • Now, we need to configure the Channels to activate Shift Log generation. For that please select Monitoring -> Channel 1/Channel 2.
  • You need to select "Writing measuring logs" check box to generate Shift Log associate with Channel. Please remember if this check box is not selected ToolScope will not generate the Shift Log CSV file.
  • Now, you need to do "Monitoring OFF > ON" to activate your changes.
  • Please repeat the above steps for each Channel, if you wants to generate the Shift Log.
  • Point to be remember, if none of your Channels are writing measuring logs, still you can find a Shift Log file inside the "Logs\Logs\Service\Shift Log"  with values. Those values are for "TS_STARTUP" and "TS_SHUTDOWN".  Bellow is an example of default values.

Downloading MDA information manually by USB

To download the needed files from a ToolScope, you can download them via USB. For this plug a USB-device into the ToolScope and navigate to "Service -> USB" within the ToolScope. Check the timeframe you are interested in on the left and "User Log" on the right to receive the correct files. At the end hit "Start" :

             

Downloading Service logs manually by network

To download the Service logs from a ToolScope, you can also download them over the network. For this, connect to the ToolScope-IP with a FTP-Client or over the Windows-Network and go to ftp/logs/Service/Service Log . See the article about the directory structure.

             

Excel example for MDA Analysis

KOMET BRINKHAUS offers a macro enabled Excel file (Shift-Log) for giving you first steps of evaluating our data.

This file is generating reports from CSV files called “shift_log_xxx_ yyyy-mm-dd hh.MM.ss.csv”. One can use the Excel file to view different kind of reports as a pie chart, e.g. reports like “Total Time Production”, “Total Machine Stop time” and “Rework/Learn/Error time” all in a single Excel Sheet.

Shift-Log can be saved in Desktop and user can import data from ToolScope user log. Report will be generated depending on Date and Time given as user input.

Features / Generics

  • Language Support [German, English, Chinese]

    Shift-Log Version 5.0 has German, English and Chinese Language support.

    One can select a language by giving values 1/2/3 in the language field. While generating reports, the macro will take this as an input and will generate reports in the selected language.

    For better result, please follow “Steps to generate Report”
    .

    Example of Chart prepared in different Languages
     

  • Progress Bar

    During report generation a Progress Bar will be appeared to show the progress. Also it will disable user to select any data in Excel.     


    Progress Bar
     

  • Installation requirements

    Shift-Log can be saved in any standard Windows PCs, having Microsoft Excel installed. No specific installation guide is required. This macro enabled Excel file is prepared in Microsoft Excel Version 2010. For better results please open it with Excel 2010 or a newer version. No specific hardware or higher memory values are required to execute Shift-Log.


    Example of a generated report

Detailed Steps to generate a report

 

Once the summary files are imported available from your workstation, the Excel file can access it. we can give file location as an input parameter. You do not have to download them for this. A connection to the KOMET Cloud is sufficient. The reports can be generated from the cloud data, too.

The Excel example will  check the given path, and will select files matching with other given inputs and generate report files.

 

Step 1: Define the language input value as 1/2/3

 

 

Choose from – 1 = German; 2 = English; 3 = Chinese

Press F9 after change, if automatic change is deactivated in your Excel.      

 

Note: Once a macro generates the report files, user cannot change the language. The change of the language requires a recalculation of the reports.

 

Step 2: Define the file path.

Here user can enter the imported Summary file location. Another option is keep this cell as blank and while running a Folder Selection Window will appear and then choose your export file location.

 

Cell for File Path Input

 

 

Help Text for file path input

         

Fig 7: “Select Folder”

 

Step 3: Enter your desired date and time, format should be YYYY-MM-DD HH:MM.

Enter Start and End Time and Date

 

Note: Do not add AM/PM with date and time. Excel will convert it automatically. If already AM/PM is present please remove them.

 

The time in seconds you enter here, is the timeout (no new process) after which the machine will be assumed as standing still.

 

Timeout Value

 

Step 5: Change this value as you selected in tool scope as column separator for csv files. Typically it is “;” or “,”.

 

                Step 6: Now, you can click “Start Processing” to generate reports.

 

“Start Processing” Button

 

 

Note: A “Clear” Button is also present, just beside “Start Processing” button. This will clear all your input data.

“Clear All” Button

Possible Error messages

The user can get the following error messages, if there is any wrong input data entered in the Excel.

 

  1. Error: File Location not found !!


    Error: File Location not found !!

    Reason: No file path entered. Please select a valid file path or entered it manually.
     
  2. Error: Missing Date and Time !!


    Error: Missing Date and Time !!

    Reason: Either Start or End Date and Time is missing.
     
  3. Error: Missing Time out value !!


    Error: Missing Time out value !!

    Reason: Enter time-out value.
     
  4. Error: No File found !!


    Error: No File found !!

    Reason: Date and Time is not matching with any valid file in given path.