Write Traces to Spreadsheet File VI

formatting information —

formatting information contains inputs that determine the format of the spreadsheet.

Refer to the Details section for information about formatting the spreadsheet.

header text — header text is the text to display in the column header. footer text — footer text is the text that appears at the bottom of the spreadsheet file. delimiter — delimiter is the separator used in the spreadsheet format. The default is a tab. You also can choose to delimit the columns of the spreadsheet with commas, semicolons, spaces, or pipes. Pipes are the characters entered when you press the <Shift–\> keys. row format — row format is the format of the rows of the spreadsheet.

trace information —

trace information contains timestamp and sample interval information about the trace(s).

sample interval — sample interval determines the time interval for each historical trace. If you do not wire this parameter, the data is sampled at 1 second intervals. time interval — time interval is the span of time between the start timestamp and stop timestamp. If you do not wire this input, this VI reads all data logged up to now. start timestamp — start timestamp specifies the start date and time of data you want to retrieve from the Citadel database. If you do not wire this input, this VI uses the timestamp of the first data point in the database. stop timestamp (now) — stop timestamp specifies the end date and time of data you want to retrieve from the Citadel database. If you do not wire this input, this VI uses the timestamp of the last data point in the database.

database URL —

database URL specifies the computer name and the database name where the Citadel database resides. Enter the database URL in the format \\computer\database.

For example, if you have a copy of the LabVIEW Datalogging and Supervisory Control (DSC) Module and Citadel service installed on a computer named datalogger and the name of the database on that computer is data, you can access the data on datalogger from another computer by using the path \\datalogger\data. If you provide a database name only, this VI searches for the database on the local computer. If you do not wire database URL, this VI resolves the database URL from the Shared Variable Engine (SVE). If the SVE resolution fails, this VI reads data from the database associated with the default DSC Module process.

trace names —

trace names specifies the list of historical traces for which you want to read historical data. You can specify either Shared Variable references or existing traces for this parameter. The DSC Module uses these trace names as column headers when you convert this information into spreadsheet format.

output file path —

output file path is the full path to the spreadsheet file to be created.

error in (no error) —

error in describes error conditions that occur before this node runs. This input provides standard error in functionality.

timeout (30 s) —

timeout specifies the maximum time, in seconds, that this VI waits for reading data from the Citadel database. The default is 30. A timeout value of less than or equal to 0 indicates no timeout, which means this VI waits indefinitely until this VI receives data from the Citadel database. This VI ignores this value if you set show status bar to TRUE.

show status bar (T) —

show status bar enables a progress bar during the operation if show status bar is TRUE.

database URL out —

database URL out returns the computer name and the database name that specify where the Citadel database resides. The format is \\computer\database.

output file path out —

output file path out returns the full path to the spreadsheet file.

If a value is a data break, this output returns a data point whose data is NaN and whose timestamp you can ignore.

error out —

error out contains error information. This output provides standard error out functionality.

0 = asynchronous

1 = synchronous