...
Code Block |
---|
taskRunId,logEntryId,creationTime,logLevel,synchLevel,logMessage,expiryTime,eventCode,moduleInstanceId,localModificationTime,eventAcknowledged,eventProcessed MC00:000009387,32,2020-01-08T10:42:22.000+00:00,20000,5,message1,2020-01-13T10:42:22.000+00:00,MyEvent.Code,none,2020-01-08T10:42:32.000+00:00,1 MC00:000009387,20,2020-01-08T09:49:46.000+00:00,20000,5,message2,2020-01-13T09:49:46.000+00:00,MyEvent.Code,none,2020-01-08T09:49:58.000+00:00,1 MC00:000009387,1,2020-01-08T09:43:34.000+00:00,20000,5,message3,2020-01-13T09:43:34.000+00:00,MyEvent.Code,none,2020-01-08T09:43:42.000+00:00,1 |
Sending log messages in xlsx format
The log messages can also be sent as attachment in xlsx format.
It has been designed to work in combination with secondary validation. For instance by using a comma separated tags in a log message of the series comparison check: <logMessage>%LOCATION_ID%;%LOCATION_NAME%;%VALUE%;@attributeIdA@;@attributeIdB@</logMessage>
This can be useful to give recipients a clear overview of abnormalities occurring in the data.
In the email alerter this can be enabled by using the log content element specifying the column separator and the xlsx format in combination with body column header elements for each column.
An example can be seen below:Example sending log entries in xlsx format
Code Block | ||||
---|---|---|---|---|
| ||||
<?xml version="1.0" encoding="UTF-8" standalone="no"?> <mc-system-alerter xmlns="http://www.wldelft.nl/fews" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.wldelft.nl/fews http://fews.wldelft.nl/schemas/version1.0/mcSystemAlerter.xsd"> <alerts> <emailalert> <recipients> <recipient email="Some.body1@somewhere.org;Some.body2@somewhere.org"/> </recipients> <configuration> <smtp fromaddress="fromaddress@somewhere.org" host="smtp.somewhere.org" port="25"/> </configuration> <subject> <subjectline content="This is my subject line DATE_TIME MC_ID"/> <substitutions> <tag tagid="MC_ID"/> <tag tagid="DATE_TIME"/> </substitutions> </subject> <body value="See log entries in xlsx attachment"/> <attachments> <attachment maxsize="10000" xsi:type="logentriesattachmentType" sortorder="LOCAL_AVAILABLE_TIME" maxentrycount="1000"> <filename includedatestamp="true" prefix="validated_timeSeries_"/> <logContent columnSeparator=";" format="xlsx"/> <bodyColumnHeader>Location Id</bodyColumnHeader> <bodyColumnHeader>Location Name</bodyColumnHeader> <bodyColumnHeader>Value</bodyColumnHeader> <bodyColumnHeader>Attribute A Value</bodyColumnHeader> <bodyColumnHeader>Attribute B Value</bodyColumnHeader> </attachment> </attachments> </emailalert> </alerts> </mc-system-alerter> |
...