Alarm & Event Query To Spreadsheet File VI doesn't work correctly (DSC 7.1)

[AndrewWilliams]

I am using the Alarm & Event Query To Spreadsheet File VI to write alarms/events to an Excel spreadsheet. However there are two things it does wrong:

1. Global variables in the header are not correctly inserted. I am using the header "{creationDate}{delimiter}{creationTime}" but none of the variables are translated to their actual values. The same header in Write Traces To Spreadsheet VI works correctly, so I assume it is only the Alarm & Event Query To Spreadsheet File VI that isn't working.

2. My display format is set to display the date of the alarms but it never appears. Set time/ACK time, etc all appear, just not the date.

Can anyone explain what might be wrong?

[PNHorn]

Hi AndrewWilliams,

I have been looking into this problem for you and I can't quite figure out exactly what it is you are trying to do. Could you possibly send me your VI's (for the Alarm & Event Query To Spreadsheet File VI and for the Write Traces To Spreadsheet VI) so I can get a better idea of it.

Have you looked at the Export Alarms to File VI in the LabVIEW examples that are installed with the DSC module. This is a very good VI and it might help you to see any faults in your code.

Hope this helps, I look forward to speaking to you soon.

Best regards,

Peter H.
Applications Engineer.
National Instruments.