How to create a data object on a csv file in CA Service Catalog

Document ID : KB000125346
Last Modified Date : 28/01/2019
Show Technical Document Details
Introduction:
N/A
Background:
N/A
Environment:
Windows
Instructions:
The following is to be executed to get this working properly.
 
1a. In computer/properties/system variables, add variable RPT_HOME
1b. Set this variable value with C:\Program Files\CA\Service Catalog
2. Start SC/Admin/Report Builder/Data Object
2a. In data object, select radio button CSV file
2b. In 'CSV File' field set: %RPT_HOME%\DataObject_CSV\pdm_load_ca_contact-i_2.csv and get error:
>>> File not found on the server: C:\PROGRA~1\CA\SERVIC~1\reporting\DataObject_CSV\pdm_load_ca_contact-i_2.csv
>>> Note: the 'reporting' folder added automatically.
 
3. Copy the local DataObject_CSV folder into %RPT_HOME%\reporting folder.
4. The data object then works properly.
  
Another solution can be.
5. Create the DataObject_CSV folder under %USM_HOME% path
6. And then in data object, set in 'CSV File' field:
   %USM_HOME%\DataObject_CSV\pdm_load_ca_contact-i_2.csv 
7. This works too. The 'reporting' folder is not used/needed this way.
 
Nothing has to be restarted on my local server.
The system variable is to be used immediately after it was defined in step 1.
It could be that you need to reboot (OS dependent) to get the system variable activated and to be used in SC Data Object settings.
After you defined the system variable, you can run the 'set' command in a commandprompt, to see whether it is available or not. 
Meaning, check whether a reboot is needed or not.
 
Select field options are a value/label pair so you need two columns in your csv. 
The value is the first column and the label (what is displayed in the UI) is the second column.
And After adding a second column in my csv file the label was presented correctly.