Clarity Service Management

Expand all | Collapse all

Create a Dropdown from a csv File

Jump to Best Answer
  • 1.  Create a Dropdown from a csv File

    Posted 03-14-2018 03:05 PM

    Hey guys!

     

    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:

     

     

     

     

    Many thanx!



  • 2.  Re: Create a Dropdown from a csv File

    Posted 03-15-2018 03:17 AM

    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 Catalog
    2a. 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.csv
    Note: 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% path
    6. 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.



  • 3.  Re: Create a Dropdown from a csv File
    Best Answer

    Posted 03-15-2018 09:57 AM

    Hey Diego,

     

    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.

     

    Thanks,
    Jason



  • 4.  Re: Create a Dropdown from a csv File

    Posted 03-15-2018 10:06 AM

    Many thanks again, Jason and Louis!

     

    After add a second column in my csv file the label was presented correctly.