The leader in industrial automation and control solutions

Applicable Model(s)

HMI5000 series
cMT series

Title

Converting Data Sampling to a CSV

Date

7/1/2025

Rev

00

P/N

TN5161

Summary

HMI5000 series devices save data sampling info as an .RTFM file, and cMT devices save data sampling info as a .db file. While these file formats are convertible and openable after the fact, they’re not human-readable on their own.

This document describes the process of converting these data log files into CSV files, which improves their readability.


Solution

Sampled data can be converted to a CSV file format using the Backup Object in EBPro.

The backup object can be accessed from the Data/History tab:

Data/History tab location in EBPro

There are 2 different backup objects available in EBPro (only the per-page backup object is available on HMI5000 models), but both can be used to create CSVs from the data sampling data.

Global Backup Project

1.

Press the New button on the Global backup list popup.

New button on the Global backup list popup

2.

Set up a bit trigger for the data backup. Ensure Follow is enabled so that the bit trigger is turned off once the backup has finished.

Set a bit trigger with Follow enabled in the Backup window

The configuration options will be the same as the Per-page backup. Instead of placing a button on the screen to trigger the backup, the backup will start when the trigger condition that was just configured is true.

Per-Page Backup Object

1.

On the General tab, select Historical data sampling and then choose which data sampling index to back up from.

Historical data sampling selection

2.

Then, advance to the Output tab and select the backup destination and file format.

Select output location in backup location

3.

Place the per-page backup object on the screen. Whenever a user presses that button, a backup of the historical data sampling files will be converted into a CSV file in the configured destination.

Note:

To have the backups appear on a USB disk on the device, make sure that there is a USB disk that’s 32GB or less in disk size, formatted with FAT32, present in the USB-A slot on the device

To send the backups to an email address, ensure that the SMTP email settings are configured. Refer to these tech notes for more information:

To send backups over FTP, make sure FTP settings are configured properly. Refer to this tech note for more information: