Format Alarm to spread sheet file data

[hema]

I have used Alarm & Event Query to SpreadSheet file.vi
and have given a htm path to save the contents.
I have attached the file.
But when we see this file, there is some code 432384A0
in the Ack Time and Clear Time columns.
I want to know why this is coming.
Secondly i want only the tagname to come in the Object Name column. But instead i get the full path for example..\\Worksationa7\LabVIEW\tag2.
How to get over this problem.thank u
hema

[Khalid]

Hi,

Looks like you found a bug! 'Ack Time' and 'Clear Time' columns when not available are supposed to be blank (as they're in the text report), but apparently it's not in the HTML report.

A workaround for now would be to create your own HTML report using the Alarm & Event Query VI. You will have to index the array, and then unbundle the cluster and extract the values while embedding them in HTML tags. This is easy to do but can be quite time consuming.

Also, this approach will allow you to strip the trace URL and get just the tagname.

Hope this helps.

Khalid