Export Log Data

Logging data can be exported by Export Log Data operation. You can see the exported CSV file or TXT file using software program such as Excel.

Note:

For information on the naming convention and script keywords, refer to the following.
Naming Conventions

Block

Text

exportLogData(LOGGINGGROUP, false, false);
1 2 3

1: Logging group

2: Export Latest Data

3: Append to Existing File

Note: For more information about exporting, see the following.

Exporting and Importing Logging Settings and Logging Data

Example

Example	[Export Latest Data]*1	[Append to Existing File]*1	[Append Date/Time] in [Logging Group] Property Window
Example 1	Unchecked	Unchecked	Unchecked
Example 2	Unchecked	Unchecked	Checked
Example 3	Checked	Unchecked	Unchecked
Example 4	Checked	Unchecked	Checked
Example 5	Unchecked	Checked	Unchecked / Checked
Example 6	Checked	Checked	Unchecked / Checked

*1 When [Script Mode] is [Text], "Unchecked" = 'false', "Checked" = 'true'.

Example 1

[Export Latest Data]: Unchecked

[Append to Existing File]: Unchecked

[Append Date/Time] in [Logging Group] Property Window: Unchecked

1. The first Export Log Data operation is executed after the third record is logged, resulting in the LoggingGroup1.csv file as shown below.

2. When the second Export Log Data operation is executed after the fifth record is logged, all the log data overwrites the existing file.

Example 2

[Export Latest Data]: Unchecked

[Append to Existing File]: Unchecked

[Append Date/Time] in [Logging Group] Property Window: Checked

1. The first Export Log Data operation is executed after the third record is logged, resulting in the csv file as shown below.

2. When the second Export Log Data operation is executed after the fifth record is logged, all the log data is written to a new csv file.

Example 3

[Export Latest Data]: Checked

[Append to Existing File]: Unchecked

[Append Date/Time] in [Logging Group] Property Window: Unchecked

1. The first Export Log Data operation is executed after the third record is logged, resulting in the LoggingGroup1.csv file as shown below.

2. When the second Export Log Data operation is executed after the fifth record is logged, only the records after the previous export are written to the new csv file.

Example 4

[Export Latest Data]: Checked

[Append to Existing File]: Unchecked

[Append Date/Time] in [Logging Group] Property Window: Checked

1. The first Export Log Data operation is executed after the third record is logged, resulting in the csv file as shown below.

2. When the second Export Log Data operation is executed after the fifth record is logged, only the records after the previous export results in the new csv file.

Example 5

[Export Latest Data]: Unchecked

[Append to Existing File]: Checked

[Append Date/Time] in [Logging Group] Property Window: Unchecked / Checked

1. The first Export Log Data operation is executed after the third record is logged, resulting in the LoggingGroup1.csv file as shown below.

2. When the second Export Log Data operation is executed after the fifth record is logged, all the log data is appended to existing records, resulting in duplicate data regardless of the [Append Date/Time] setting.

Example 6

[Export Latest Data]: Checked

[Append to Existing File]: Checked

[Append Date/Time] in [Logging Group] Property Window: Unchecked / Checked

1. The first Export Log Data operation is executed after the third record is logged, resulting in the LoggingGroup1.csv file as shown below.

2. When the second Export Log Data operation is executed after the fifth record is logged, only log data after the previous export are appended to existing records regardless of the [Append Date/Time] setting.

When Using SP5000 Series Open Box (Windows 10 IoT Enterprise Model)

NOTICE

LOSS OF DATA

Do not turn OFF the power while writing to a storage device that is not protected by the write filter (write protection).
Disable the write filter settings before starting the runtime application.

Failure to follow these instructions can result in equipment damage.