Multi Select Field populated by a csv file

Multi Select Field populated by a csv file

I requested this during some professional services while setting up SDP v14.9 Build 14960
Figured I would post the script here.
What I wanted was a Multi-Select field that I could populate from a CSV file.
For us this was a listing of every file share a user could be granted access to.
I generated the .csv file from a PowerShell script.  I run the PowerShell script daily to pull in any new shares that are created.  I stored the CSV file in the C:\Program Files\ManageEngine\ServiceDesk\custom\ folder.   Note that the attached sample has 3 columns that match the columns you might see when importing values into fields from a CSV manually.

On my Service Catalog Template, I created a custom field that must be a single-line text field (not a multi-select field). The script does the work to make this happen. Once you have that created, copy down the API Field Name from Settings Additional Fields to be used in the script.

On your template, create a Field and Form Rule.  Name it whatever you want, choose Execute Script, and paste in the script, replacing your field name.  It is the first line in the script.

That is it.  You will now have a field in your template that has all the selectable values pulled in from the CSV file.   You should be able to customize this for just about anything you need to do a multi-select for.


      • Sticky Posts

      • Upgrading to ServiceDesk Plus 15100: Important Information

        We are pleased to announce that the 15100 patch file for ServiceDesk Plus is now made available to our customers. To ensure a smooth transition, we conduct a thorough sanity check on each customer's ServiceDesk Plus setup before providing the patch. If
      • ManageEngine Supportcenter Plus - version 14.8 - Build - 14830 is available

        Dear User(s) Greetings for the day. We released Supportcenter Plus - version 14.8 - Build - 14830. Behaviour Changes: SCP-3505 : From this release, the customer portal will show only the latest announcements. Earlier, all announcements including the past
      • Ability to Assign Technician in another group from Dropdown.

        We currently have an On-Prem instance with multiple groups. All of the tickets default to the Tier 1 group. Many times, the Tier 2 team forwards in tickets for themselves. It would be beneficial if you could assign multiple tickets from the Requests' Assign dropdown no matter what group the technician is in. SDP should be smart enough to automatically change the group based on what technician you select. When I select the technician I'd like to assign to, *the technician themselves* it gives me an
      • Steps to secure MSSQL database connection

        Hello folks, This post explains you the steps that need to be followed to secure the database connection in ServiceDesk Plus. How to connect secure MS SQL Server?  Summary of Steps:          1. Create SSL certificate            2. Import the SSL certificate to SDP setup.          3. Enable SSL Encryption in SQL Server Step 1 & 2:          To start this process, we need to create an "SSL Certificate" it could be either self-signed or third party certificate.          Do follow the below steps in MS
      • SDP SAML SSO

        Hi, is possible to use SAML authentication for SSO? Your Version : 9.3 Build 9327 Thank you Jacir

                        New to ADSelfService Plus?