About creating CSV files
You can create views in OpsCenter Analytics by creating and importing the comma-separated values (CSV) file that describes the views. You can create the CSV files in a text editor or Microsoft Excel and save the file as filename.csv. Note that you can only create objects of type Generic when you create views using a CSV file.
Note:
You can export and import view structures using the CSV file. However, you cannot export or import attributes that are collected by OpsCenter data collectors using a CSV file.
A CSV file typically contains the following details:
First column | View type View Type must be one of the following: Note: |
Second column | Name of the view |
Third column | Level of the view (hierarchy). The third column and subsequent columns contain the name that you give to each level. You can have as many levels as you want, which must be specified in the third column or subsequent columns in the CSV file. |
Last column | Host name Note: The last column must be the host name. If the last column of a row is not the host name, the specific row or entry is ignored and not considered. |
The CSV file contains comma-separated values. Each row defines the hierarchy of one host.
The following is the format of a sample CSV file. This CSV file contains only one level of view.
Client, View_Application, Oracle, client1 Client, View_Application, Oracle, client2 Client, View_Application, Sybase, client3
Figure: Sample view shows the view that is created when you import the sample CSV file.
The following is the format of a sample CSV file containing two levels of view.
Client, View_Global, India, Chennai, client1 Client, View_Global, India, Pune, client2 Client, View_Global, UK, London, client3 Client, View_Global, US, NYK, client4
Figure: Sample multi-level view shows the multi-level view that is created when you import the sample CSV file that contains two levels of view.
Note:
If you create a view using a CSV file that already exists in OpsCenter Analytics, the view gets deleted. You cannot modify an existing view by using a CSV file.