Part 8. Phần mềm SCADA Cimon Ultimate Access - Data Logging

Data Logging là một tính năng lưu dữ liệu lịch sử dưới dạng tệp. Chức năng này có thể thu thập dữ liệu từ các thẻ analog và kỹ thuật số. Tệp nhật ký có thể được chuyển đổi thành tệp văn bản hoặc tệp csv và được sử dụng làm dữ liệu cho đối tượng Trend.

1.1 Features

Collects the tag value at regular interval and saves the data as a file.
You can efficiently manage the storage space by collecting the data only when
the tag value changes.
You can manage the log files by configuring the file size and creation interval.
Data log file can be backed up automatically.
Log data can be loaded by using the command expression.
You can display the historical data on the Historical Trend

1.2 Settings

Double-click [Data Logging] on the Project workspace or select [Tools] – [Data Logging] to bring up the configuration window as shown below.

Model Name

Enter the name of the Data Logging model. You may use alphanumeric
characters, Korean alphabets and special characters as the model name. You
cannot use the duplicated model name.

Logging At

Tag value changes

The data is logged only when the tag value changes.
Since this option does not collect data at a regular
interval, the file size can be reduced.
The system cannot recognize the change in value less than a second.

Regular Interval

The data is logged according to the assigned interval.
You can assign the interval from 1 to 10,000 seconds. (166min 40sec)

A minute Interval

The data is logged at every minute.

I/O Device’s Log Data

You can collect the data from the CM1-LG32A PLC module.

Interval

Assign the data logging interval in second unit. You can assign the interval from 1 to 10,000 seconds. (166min 40sec)

Save In

Assign the file directory to save the log file. You can select the [Browse] button and assign the path. If you have not assigned the file path, the log file will be saved in the folder named as the Data Logging model.
- ProjectFolder\DataLoggingModel\YYYYMMDD.cld
If “Logging At” option changes or the project uses the same file path to save file in, you have to back up the existing data before you start data logging.

Prints out the tag value at every interval. You can select a printer from the list.

Create File

You can create a log file according to the assigned interval (Daily, Weekly or Monthly).
You can also create log files according to the file size (1KB~10,000KB) and the maximum number of files (2~1,000). When you select this option, each file is created in ‘File size x Max No. of Files’ size.
You cannot select the size of files when you log the data at a minute interval.
You can only assign the maximum number of files

Backup Option

Overwrite

When the number of files reaches the maximum, the system deletes the oldest file and saves the new file.

Warning before Overwrite

When the number of files reaches the maximum, and the project is executed with CimonX, the warning message will pop up and the data logging will stop. You can continue the data logging by saving the old files to the other folder and pressing the ‘OK’ button.

Save before overwrite

When the number of files reaches the maximum, the system will automatically save the old files to the assigned folder and saves the new log file

Add

Adds a new model with the configuration. You cannot add a new model if there is a model with same name.

Saves the changes of the selected Data Logging model.

Delete

Deletes the selected model.

1.3 Setting Up the Data Logging

(1) Creating a Data Logging Model

a) Select [Tools] – [Data Logging]

b) Assign the ‘Model Name’, ‘Log Option’, ‘Create File’ and ‘Backup Option’. Press [Add] button to register the model

(2) Assigning a Data Logging Tag
a) Select [Tools] – [Database].
b) Double-click or create a tag to collect the value.
c) In the [Advanced] tab, select the [Data Logging] option and assign the data logging model.

1.4 Related Features

In this section, you can find functions and subroutines1 frequently used for Data Logging. Please refer to the table below for applicable functions/subroutines. For more detailed information of each function and subroutine, please refer to the next section

Command			Description
Data Logging	Subroutine	LogFileDialog	Brings up the dialog box to convert the data log file (.cld) into text or csv file.
	Subroutine	LogFileConvert	Converts the cld file into text file.
	Function	DLogVal	Returns the logged data from the specified time.
	Subroutine	ShowDatalog	Brings up the [Data Logging] window in CimonX runtime.
	Subroutine	EnableDatalog	Manually controls the operation of data logging

1.4.1 Functions for Data Logging

LogFileDialog

Brings up the dialog box to convert the data log file (.cld) into text or csv file

Subroutine

Command

LogFileDialog()

Script

LogFileDialog

Description

Brings up the [Convert Logging File] window. You can select a file from the list and convert it into text or Excel file.

Including Saving Folder	When you select the option, ‘…’ is included in front of the file name which is currently saving the data.
Convert	Converts the logged data file (.cld) into a text file in a different name.
Clipboard	Copies the data to the clipboard. You can paste the data into the Notepad or Excel.
CSV	Converts the logged data file into csv file in a different name

Example

Brings up the [Convert Logging File] window. LogFileDialog()

LogFileConvert	Converts the cld file into text file.
Subroutine	Command	LogFileConvert(“cld File Name”,”File Path”)
	Script	LogFileConvert “cld File Name”,”File Path”
Description	Converts the log data file (“cld File Name”) into text file and save it in the File Path. “cld File Name” and “File Path” must include the entire path and the file name
Example	E.g.1) Converts the ‘20180329.cld’ file in the C drive as ‘20180329.txt’. LogFileConvert("C:\CIMON\SCADA3.90\Trend\ytTrend\20180329.cld", "C:\20180329.txt") E.g.2) Assign cld File Name and File Path to the string tags and use the tag name as parameters. LogFileConvert(StringTagName1, StringTagName 2)

DLogVal	Returns the logged data from the specified time
Subroutine	Operation	DLogVal("Tag Name", “Time Value”)
	Script	n = DLogVal("Tag Name", “Time Value”)
Description	Returns the tag value according to the Time Value. The omitted values after the Time Value is set as the initial value. E.g.) If you have entered Time Value as ‘2003’, it represents ‘2003-1-1 0:0:0’.
Example	Returns the ‘ELEC’ tag value of 2018- 3- 29 9: 54 DLogVal(“ELEC”, “2018Y03M29D09h54m”)

Time Value	Range	Example
yyyyYmmMddD HHhMMmSSs	-(Present Year-1970) ≦yyyy≦0 1970 ≦ yyyy < 2037 mm: 01~12 dd: 01~31 HH: 00~23 MM: 00~59 SS: 00~59	2013Y12M15D0h30m30s -3Y01M01D00h00m00s
mmMddD HHhMMmSSs	mm ≦ 0 mm: 01~12 dd: 01~31 HH: 00~23 MM: 00~59 SS: 00~59	3M15D10h30m30s -1M01D00h00m00s

ddD HHhMMmSSs	dd ≦ 0 dd: 01~31 HH: 00~23 MM: 00~59 SS: 00~59	15D10h30m30s -5D00h00m00s
HHhMMmSSs	HH ≦ 0 HH: 00~23 MM: 00~59 SS: 00~59	10h30m30s -30h00m00s
MMmSSs	MM ≦ 0 MM: 00~59 SS: 00~59	30m30s -15m00s
SSs	SS ≦ 0	–300s

ShowDatalog	Brings up the [Data Logging] window in CimonX runtime.
Subroutine	Command	ShowDatalog()
	Script	ShowDatalog
Description	Brings up the [Data Logging] window in CimonX runtime.
Example	Brings up the [Data Logging] window. ShowDatalog()

EnableDataLog	Manually controls the operation of data logging.
Subroutine	Command	EnableDataLog(“Data Logging Model”,Option)
	Script	EnableDataLog “Data Logging Model”,Option
Description	Runs or stops the data logging of the assigned Data Logging Model. When you assign 0 to Option, the data logging will stop. If 1 is assigned to Option, the data logging will be started.
Example	Start the Data Logging model named “DataLog”. EnableDataLog("DataLog", 1)