I'm trying to create a plugin from a csv file to use it in a select field in my forms.
I followed the "Sample Support Issues" plugin as an example, but when I created the plugin and view, and set the plugin id of the select field on my form, nothing is displayed.
Is there anything I need to do besides creating the plugin and report data views so that my information is displayed in my select form?
The plugin, report data views and my csv file:
Good Morning Diego. The following can be executed to get this working properly. 1. In computer/properties/system variables, add variable RPT_HOME set for C:\Program Files\CA\Service Catalog2a. In data object I set in 'CSV File' field set: %RPT_HOME%\Louis_CSV\pdm_load_ca_contact-i_2.csv and get error:2b. File not found on the server: C:\PROGRA~1\CA\SERVIC~1\reporting\Louis_CSV\pdm_load_ca_contact-i_2.csvNote: the 'reporting' folder added automatically. 3. Copy the local Louis_CSV folder into %RPT_HOME%\reporting folder.4. The data object then works properly. Another solution can be.5. Create the Louis_CSV folder under %USM_HOME% path6. And then in data object, set in 'CSV File' field: %USM_HOME%\Louis_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 a reboot is needed or not. Thanks in advance and kind regards, Louis van Amelsfort.
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.
Many thanks again, Jason and Louis!
After add a second column in my csv file the label was presented correctly.