|
Tables
Data can be exported from OpsCenter using the tables. In the Filter & Controls window to the left of the table, there is a link called Export Table in the Additional Controls section. Clicking on this link will bring up a window which will provide options on where to export the data and how to format the data. The default options will create an output file which can be opened and automatically formatted in most spreadsheet programs. Just click the Browse button to choose a location and file name to save the exported data.
| o | This will determine how the fields (columns) will be separated when outputted. Any printable character as well as the tab and return (new line) character can be selected. (Default Value: Tab.) |
| o | This will determine how the records (rows) will be separated when outputted. Any printable character as well as the tab and return (new line) character can be selected. (Default Value: Return.) |
| ▪ | This option will determine whether or not the title information will be outputted. The title lines can be customized in the Title box. If enabled, the title lines will be outputted first and appear at the very top of the output file. (Default Value: True.) |
| ▪ | This option will determine whether or not the column titles/headers are outputted. If enabled, the headers will be outputted between the title lines and the data rows. The headers will be separated by the same field delimiter as the data so the header and data fields will be aligned when importing the data into a spreadsheet program. (Default Value: True.) |
| ▪ | The tables have many columns which can be displayed. Only a portion of the available columns are displayed by default. (You can change the visible table columns by right-clicking on the table header.) This option will determine whether just the currently visible columns are outputted or if all columns are outputted. If enabled, only the visible columns are outputted. (Default Value: True.) |
| ▪ | When the table is set to group records based on a specific field, this option will determine whether the group names are outputted. If disabled, the grouped rows will still be outputted but the group name header will not be outputted. If table grouping is not being used, this option will not have any effect on the output. (Default Value: False.) |
| o | Output visible/filtered rows only |
| ▪ | This option will only output the rows that are currently visible. Rows will be hidden when a search term is being used to filter the data. If enabled, only the filtered, visible rows will be outputted. If disabled, any current search filter will be disregarded and all visible and hidden rows will be outputted. Group, employee, and time filters set in the Filter & Controls window will not be effected by this. Data filtered out by these controls will not be outputted no matter how this option is set. (Default Value: True.) |
| ▪ | This option will add quotation marks around string fields. This can sometimes be necessary in situations where the contents of the string may include the field or record delimiter character. When importing the data into a spreadsheet program, the quotes will preserve the field even if delimiter characters are present. (Default Value: True.) |
| o | There are three lines which provide information about the table of data being exported. This information will appear at the top of the output file. If the Output title lines option is disabled, this information will not be outputted. |
| o | This is name of the file where the data will be exported. Click on the Browse button to choose a location and file name. The file name in the Save As window can be changed to whatever you want. |
|