The CSV data collector collects data from the CSV files, which contains data that is exported from any custom application. In Symantec Control Compliance Suite, any DPS that is registered to a site can be configured as a CSV data collector. You can configure a DPS as a CSV data collector either from the Grid View or from the Map View of the console.
The CSV file stores data in the comma-separated format. The CSV file must be placed in a a network share path of the computer that hosts the DPS. The CSV data collector is configured to fetch data from the CSV file. You must ensure that the data is arranged in a specific format in the CSV file, which is easily interpreted by Symantec Control Compliance Suite.
If a CSV file is shared on a DPS collector computer, then ensure that the user has either log on locally or log on as a batch job permission. This permission is required for the CSV data collector of both the single setup and distributed setup modes.The user is the one whose credentials are required to access the network share path. The same user credentials are also specified for the selected platform of the CSV option in the Components settings dialog box.
The CSV data collector can be used for data collection in the following scenarios:
To configure the CSV data collector
Enter the platform of the application whose data is to be queried .
You can use the drop-down box to select the platform of the application.
CSV File(s) Path
Enter the path where the CSV file is placed.
Click the browse button and in the Browse for folder dialog box, browse to the path where the CSV file is located. You must ensure that the CSV file path is specified in the UNC format, \\<server name>\<share name>\<path>\<filename>.csv.
Enter the domain of the Windows computer, where the CSV file is located.
You need to provide the credentials of the Windows domain user in the dialog box, Credentials for the Platform.
Enter the user name of the specific domain.
Enter the search pattern of the CSV file.
For example, in a given share path there can be several CSV files for the same platform. In such a case, if you want to have data from the CSV file that starts with the alphabet, m, then the search option can be, m*.csv.
Enter the encoding type of the file. For example, Unicode (UTF -8).
You can use the drop-down box to select the unicode of the CSV file.