Omron DR 170 14 Monitoring the Status of DAS Conversations, Using DDEStatus and IOStatus in Excel

Klinkmann Automation Omron Ethernet DAServer 51

YourOPCAccessPath is the assembly of hierarchy node names leading to a specific controller device.

$SYS$Status is the discrete item used to monitor the status of connectivity with the controller device.

Note: In the case of a PLC disconnect, the DAServer will retry three times before entering into slow poll mode. In the case of reply time-out, the DAServer will go into slow poll mode immediately.

Monitoring the Status of DAS Conversations

The InTouch WindowViewer supports built-in topic names, called DDEStatus and IOStatus, that can be used to monitor the status of specific DAS conversations.

For example, let us assume that WindowViewer (VIEW) is communicating with the Omron Ethernet DAServer to a PLC that has been defined in the DAServer with the topic name OmronPLC. The discrete items, DDEStatus and IOStatus, are set to:

•0 (zero) when this DAS conversation failed.

•1 (one) when this DAS conversation is successful.

Using DDEStatus and IOStatus in Excel

The status of communications between the PLC and InTouch can be read into Excel by entering the following DDE reference formula in a cell on a spreadsheet:

=viewDDEStatus!OmronPLC

or

=viewIOStatus!OmronPLC

where:

view is the name of the InTouch application.

[DDE][IO] Status is the built-in topic name used to monitor the status of communications between the DAServer and InTouch.

OmronPLC is the exact topic name defined in the server for the PLC.

Reading Values from the DAServer into Excel

Values may be read directly into Excel spreadsheets from the DAServer by entering a DDE formula into a cell using the following format:

=applicationname<devicegroup>!itemname

Example formula:

=DASOmronEthOmronPLC!'d100'

where:

DASOmronEth is the name of the DAServer application.

OmronPLC is the exact device group name defined in the DAServer for the PLC.

D100 is the actual location in the PLC that contains the data value. This is the item name.

Omron Ethernet DAServer Ver 1.x User Manual Rev 1.3 17014m13