Issue
How to create a write to file notification that creates a comma separated value (CSV) file.
Product Line
EcoStruxure Building Operation
Environment
- Building Operation Enterprise Server (ES)
- Building Operation Automation Server (AS)
Cause
Write to file notification has options for Excel and text formats, but no option for CSV format.
Resolution
As the name suggests, Comma-separated values (CSV) is a text file format that uses commas to separate values, and newlines to separate records. A CSV file stores tabular data (numbers and text) in plain text, where each line of the file typically represents one data record. This means that the text format can be selected in in the notification to provide a CSV file.
Building Operation 1.7 and earlier
Under file name, use the extension .csv. See screenshot below:
This will produce a .csv file located in your database folder under the Notification folder.
Building Operation 1.8 and later
With the introduction of "Variable Triggered Notifications" and "Alarm Triggered Notifications," users can now find the Write to File option within the "Distribution method" in the Triggered Notification Object.
Within the Configure Write to File window, users will have the option to save the file with the .csv extension.
This will produce a .csv file located in your database folder under the Notification Files folder.
For additional information and guidance, refer to the Notifications topic in EBO WebHelp.