0% found this document useful (0 votes)
63 views

Data Connect: Using Xlreporter With Kepserverex - Da

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
63 views

Data Connect: Using Xlreporter With Kepserverex - Da

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Data Connect

Using XLReporter with KEPServerEX - DA


Overview
XLReporter takes process values directly from a PLC to a report without requiring a historian or database. This
is accomplished by “report-as-you-run” technology that automatically populates a workbook, periodically or
on event, without needing Excel. Completed reports are produced in workbook, PDF and web formats.

Prerequisites
Verify Communication
From the Kepware program group, open the KEPServerEX Configuration application then select Tools, Launch
OPC Quick Client.

Expand Kepware.KEPServer.EX.V6, then a folder like _System.


 Verify the tags have a good quality data value.

If at any point you experience an issue with this client, contact Kepware technical support to troubleshoot and
correct these issues.

Copyright © SyTech, Inc. 2021. All rights reserved.


Create a Project
From the XLReporter Project Explorer select File, New to start the Project Wizard. This will give step-by-step
instructions on creating a project
Step 1
 Enter a Project Name and Description (optional).

Step 2
 Configure the data connector, click Add

Select Kepware, KEPServerEX Real-time values (OPC DA)

The connector requires a Primary Server which, by default has Node set to local.

Copyright © SyTech, Inc. 2021. All rights reserved.


Remote Communication to KEPServerEX
If KEPServerEX is installed on a workstation remote from the PLC then set the Node to an item in the
dropdown list or enter an IP address.
The workstation must also have the OPC core components installed. To determine if the core components are
installed verify the following file exists:
 64 - bit OS C:\Windows\SysWow64\OPCEnum.exe
 32 - bit OS C:\Windows\system32\OPCEnum.exe
If the components are not installed then they are provided in the tools folder of the installation or from
www.opcfoundation.org.
Verify Data Communication
To verify communication to KEPServer EX, open the Project Explorer and select the Tools tab. Launch the
System Check application.
 Click Add
 Choose the KEPServer EX DA Connector from the dropdown list.
 Click the pushbutton ([…]) next to Items to open the Tag Browser window.

 Select one or more tags, click OK.

Copyright © SyTech, Inc. 2021. All rights reserved.


 Click Start to verify the communication.

Copyright © SyTech, Inc. 2021. All rights reserved.

You might also like