Examples

FTP Example

In this example, the Data Exporter module is used to upload all data sent from an OPC UA client to an FTP server.

• Step 1: Add a new module in the "Modules" section, choose a name, and select "DataExporter" in the "Module type" field.

Figure 6: Creating a new module

Figure 7: Setting the instance type

Figure 8: Creating a new Agent

Figure 9: Agent parameters

Figure 10: Agent parameters

Figure 11: FileZilla FTP server

• Step 5: Add a new group in Agent and select a name for it.

Figure 12: Creating a new Group

• Step 6: Configure the Group (Filename, Period, Mode, Input tag group, etc.). In this example, the Group has been named “Electrical meter”, since the data has been collected from an electrical meter. The “Electrical meter” tag group has been selected in the “Input Tag Group” field in order to filter the data due to be exported.

Figure 13: Group parameters

 Figure 14: Tag groups options

Result:

Figure 15: Exported file folders

 Figure 16: Exported group folders

<?xml version="1.0"?>

-<Data End="2021-04-21T09:47:00Z" Start="2021-04-21T09:46:00Z" Name="Electrical meter">

<Tag Name="ANGLE_PHASE" good="1.00" count="8" avg="333.74" last="333.58" first="336.33" max="336.33" min="333.17"/>

<Tag Name="CURRENT" good="1.00" count="11" avg="4.65" last="4.69" first="4.79" max="4.79" min="4.58"/>

<Tag Name="ENERGY_ACTIVE_IMPORTED" good="1.00" count="2" avg="8583.66" last="8583.67" first="8583.66" max="8583.67" min="8583.66"/>

<Tag Name="ENERGY_ACTIVE_EXPORTED" good="1.00" count="1" avg="0" last="0" first="0" max="0" min="0"/>

<Tag Name="FREQUENCY" good="1.00" count="5" avg="49.98" last="50" first="50" max="50" min="49.95"/>

<Tag Name="POWER_ACTIVE" good="1.00" count="13" avg="828.85" last="819.89" first="895.75" max="898.59" min="808.91"/>

<Tag Name="POWER_ACTIVE_MAX" good="1.00" count="1" avg="4872.16" last="4872.16" first="4872.16" max="4872.16" min="4872.16"/>

<Tag Name="POWER_APPARENT" good="1.00" count="13" avg="923.84" last="915.51" first="978.01" max="980.75" min="906.44"/>

<Tag Name="POWER_FACTOR" good="1.00" count="2" avg="0.90" last="0.89" first="0.92" max="0.92" min="0.89"/>

<Tag Name="POWER_REACTIVE" good="1.00" count="13" avg="-407.25" last="-407.32" first="-392.55" max="-392.55" min="-412.67"/>

<Tag Name="VOLTAGE" good="1.00" count="13" avg="232.76" last="231.53" first="232.86" max="233.11" min="231.53"/>

</Data>

SFTP Example

In this example, the Data Exporter module is used to upload data being sent from an OPC UA client to an SFTP server.

• Step 1: Add a new module in the "Modules" section, choose a name and select "DataExporter" in the "Module type" field.

Figure 17: Creating a new module

Figure 18: Setting the instance type

Figure 19: Creating a new Agent

• Step 4: Configure the Agent (Output path, File compression, File type, Date format, File upload, etc.) and save the changes. In this example, the data will be transferred to Rebex Tiny, which is a free local SFTP server.

Since the files will be uploaded to a local SFTP server, the Agent has been named "Agent_SFTP". The files will be exported as CSV Files. The date format is ISO8601. For the connection section, the configuration would be: Host: localhost, Port:22, Username: tester.

Figure 20: Agent parameters

Figure 21: Agent parameters

Figure 22: Rebex Tiny SFTP server

Figure 23: Creating a new Group

• Step 6: Configure the Group (Filename, Period, Mode, Input tag group, etc.). In this example, the Group has been named “Electrical meter”, since the data has been collected from an electrical meter. The “Electrical meter” tag group has been selected in the “Input Tag Group” field in order to filter the data due to be exported.

Figure 24: Group parameters

Figure 25: Tag group options

Result:

Figure 26: Exported data folder

Exported CSV file:

#Name=Electrical meter
#Start=2021-04-19T10:39:00Z
#End=2021-04-19T10:40:00Z
:Tag,min,max,first,last,avg,count,good
ANGLE_PHASE,333.97,333.97,333.97,333.97,333.97,1,1.00
CURRENT,4.77,4.77,4.77,4.77,4.77,1,1.00
ENERGY_ACTIVE_IMPORTED,8545.32,8545.32,8545.32,8545.32,8545.32,1,1.00
ENERGY_ACTIVE_EXPORTED,"null","null","null","null","null",0,0
FREQUENCY,"null","null","null","null","null",0,0
POWER_ACTIVE,856.02,856.02,856.02,856.02,856.02,1,1.00
POWER_ACTIVE_MAX,"null","null","null","null","null",0,0
POWER_APPARENT,952.82,952.82,952.82,952.82,952.82,1,1.00
POWER_FACTOR,"null","null","null","null","null",0,0
POWER_REACTIVE,-418.39,-418.39,-418.39,-418.39,-418.39,1,1.00
VOLTAGE,234.61,234.61,234.61,234.61,234.61,1,1.00