Alarms & Events PDF Conversion
I want to export my alarms and events from 800xA V4.1 alarm and events viewer to a PDF or Excel. Also i have events browser in IM server which has these add ons but i am facing some commuunciation issue for linking the event browser (html) to these pdf and excel. So i want to export to excel or pdf from alarms and events
Tried using DataDirect's ABBAERetrieval() function in Excel?
OPC DA, HDA and AE retrieval is free of charge with DD if hosted in Excel on a client or server of the 800xA system. Read more in the IM Data Access and Reports User's Guide.
For one-shot scenarios regular cut & paste is probably faster (CTRL-A, CTRL-C and CTRL-V).
Reading from lists filtered for alarms returns an array of error messages:
"Object specified, ...some list..., is configured to retrieve Process Alarms - must be Events or Archived Events"
In 5.0 and later, the ABBAERetrieval function can read from lists filtered for alarms as well.
However, since the 800xA system automatically record an event for all coming and going alarms (and additional events such as acknowledge, etc. as well if desired) you can retrieve the alarm information also from an event list (just be sure to add the AlarmState column).
The below is made in Excel 2003 in 4.0 SP1:
The alarm -> event settings are made on the Alarm Manager's service group (Special Configuration tab)