Dynamic loading of field data from an external CSV file - tested in 14.2 version
Requirement:
Load data to additional fields dynamically from an external CSV file based on another field value.
Usecase:
Assume, a request template includes three additional fields: 'Client Code,' 'Client Name,' and 'Client Address.' When a pick-list value for the 'Client Code' field is selected, the corresponding field values for the 'Client Name' and 'Client Address' data must be dynamically populated by retrieving it from an externally stored CSV file. This will be useful when the number of field values increases.
Steps to follow:
1. Create 3 Additional fields and include these in the required template
- Client Code - Picklist additional field - Content has to be pre populated with all the client codes(use script1) or Single Line additional field - we can load this content from CSV as well(use script2)
- Client Name - Single line additional field - Content will be populated from the CSV File
- Client Address - Single line additional field - Content will be populated from the CSV File.
2. Compose a CSV file with first column as the "Client Code", then "Client Name" and finally "Client Address". Place this CSV File in "<SDP_Home>\custom" Folder
3. Download the attached script and update the UDF Field names & CSV file headers in the script.
Hint : Use the FAFR script area to get the
4. Configure the script on Field change for the first additional field : Client Code.
5. Other fields will be auto populated.
If you are still unable to view the file despite retaining it in the custom folder, replace the attached security xml in location: <SDP_Home>\custom\WEB-INF\security folder
PS : Works for both incident and service
New to ADSelfService Plus?
Related Articles
Query to get software data in CSV format.
Steps to export Software data in CSV format 1. Login to ServiceDesk Plus MSP/AssetExplorer. 2. Click on the Reports tab and then click on New Query Report button. 3. Copy and paste the following query and click Run Report. select swm.name "Scanned ...How to connect to external postgres(external DB)
1. From the postgres installed path navigate to bin folder and open a command prompt 2. Execute the command --> pg_ctl -D "C:\Program Files\PostgreSQL\10\data" start (Postgres server gets started) 3. Connect to DB using the command-->psql -U postgres ...Import and update Requester from CSV (Comma Separated Value) Files
Import Requester from CSV (Comma Separated Value) Files You can also add requesters by importing from CSV files. To import requesters from CSV file Step 1: Locate the CSV file Click Import from CSV link in the Requester List page. The Import ...How to import requests data into ServiceDesk Plus MSP ?
You can import your existing helpdesk Requests (tickets) into ServiceDesk Plus MSP (SDP MSP) using XLS format. Requests can be migrated to SDP MSP with basic details. Assets data can be scanned again through SDP MSP windows domain scan or using ...How to migrate data from SDP to SDP MSP.
Below are the only details which can be exported from SDP and imported to SDP MSP application. 1) You can export request data from ServiceDesk Plus (SDP) using XLS format. Requests -> Goto Admin -> Reports -> New custom report -> Tabular reports -> ...