Emerson Exchange 365

In my opinion the best way to do this is to have a macro or a custom application that would read the event journal file and output all related alarms to a file or to an MS Excel file. In this way the operator does not need to write it down in paper and all they have to do is run the macro/application then take the file or MS Excel file for the result.

I admit that most operators and plant personnel are not comfortable reading the batch journal. When this issue comes I usually create a macro or a standalone application that outputs the important information that they need from the event journal files.

You may want to ask the customer if it is sufficient to provide an MS Excel file or a readable file that shows the alarms for their requirement. In case YES then a macro is sufficient. In case NO then they need to agree that this may need additional changes to the DeltaV configuration like additional module or script on the phase to attain this in showing it to the DeltaV Operate.

Hope this helps.

Regards,
Neil Castro

In reply to Neil Castro:

Hi Neil,

The customer side do not allow the use of excel (non- validated software) as a form of reporting and attachment to batch record. As per their batch record SOP, they need to write the values down...thats why they requesting to have a form of overall display for their ease of recording.

Could you assist me on how i could go about doing the micro or customization using the event journal and display those real time alarms activated in the pop-up graphic?

Thanks,
Lay Lan

In reply to Lay Lan Seah:

I have this issue as well in one of the plants that I previously worked with.

Fortunately the plant allowed copying the journal files to a secured non-DeltaV machine. Here the operators run the macro to get the Excel file then attached it with the journal file (raw data from DeltaV). In their scenario they are not looking for alarms but on some other parameters that are in the journal.

I maybe able to help you if your client allows copying the journal files to a non-DeltaV machine where the MS Excel can be run.

You may contact me via email if you want to pursue this.

Regards,
Neil Castro

Hi,
I have used alarm and events journal to find out last simulation done of a DeltaV CM via graphic.

I had to setup a SQL connection to the Batch Historian (all alarms and events end in Batch Historian for Batch History reports on our site).
If a CM was in simulate depending on certain parameter values, I queried the Events table in Batch Historian to get the information like (Username, Value, Time) for the simulated tag.

It should be possible to query BatchEvents to get various timelines for Batch steps for a BatchID and use that to query Events table and filter by Unit (for the BatchID) to get the info you are looking for. The data received will be in a table and then its just the matter of populating text objects with table contents
If the alarms are one or two as you specified for each step, it will be easy to display it via text on a graphic. Else you might have to loop at notepad (can be opened within DeltaV operate) or other way to displays all alarms for the batch.

If the customer has different servers for Batch Events and Alarms Events, connect to Batch for getting Batch Info and then connect to Alarms server to get the alarm data.

Hope this helps.

Regards
Amod Gokhale