Custom Widget for Bulk Updating (Requests, Changes, Problem, Project, Release, Task, User, Technician) from a XLS
Requirement:
The Custom Widget enables users to efficiently perform bulk updates on requests, changes, releases, problems, or projects. Users can upload an XLS file containing entity IDs and provide the input JSON in a text box. The system processes this data to update the corresponding entities seamlessly, significantly reducing manual effort.
Steps to configure:
- Extract the ZIP file (xlsx.js.zip) and move the JavaScript file (xlsx.js) to the <SDP_Home>/custom folder.
- Add the attached html file (generic_update.html) as a new dashboard widget.
Login to SDP application as SDAdmin role --> Click on Dashboard tab --> Click on New Widget --> External Widgets --> Give some widget name --> Select the widget type as File and upload the downloaded html file (generic_update.html) --> Click add button and save the configuration - Based on the module to be update, we need to select the entity type.
- In the 'JSON Input' field, provided the required update data as a json format as per the api documentation.
- In the XLS, select the required field in the widget, and click on the process data button.
- Once that button is clicked, the widget will start processing data and the results will be printed in the widget itself.
- We can scroll down and see the result.
New to ADSelfService Plus?
Related Articles
Script to send notifications to project owner when (Project is edited, task is added, Milestone is added)
Last tested in Build: 10602 1. Send mail project owner Please follow the below steps. 1.. Go to Admin --> Project Custom Functions --> Custom Actions --> Paste the content from the attachment (1. Project_sendmail.txt) and save it with a name. 2. ...Query to show requests and its associations with Problems, Changes and Projects (MSSQL)
Working on Builds: 14500 and above Database: MSSQL SELECT wo.WORKORDERID AS "Request ID", pim.problemid "Associated Problem ID", icm.changeid "Associated Change ID", wtp.projectid "Associated Project ID", CASE WHEN (wo.is_catalog_template) = 'false' ...How to email pending requests list to technician periodically
This post describes the use of a python script to email pending requests to each technician in a periodic interval using Custom Schedules.This showcases the use of a feature called 'Custom Schedules' that was released in the build 9300 of ServiceDesk ...Document for Request Custom Menu and Custom Triggers
Attached a PDF file explaining with screenshots on how Request Custom Menu & Custom Triggers work.Query to show total requests and changes with its total worklog hours of a technician- MSSQL
Working ON Builds: 14500 MSSQL: Requests: SELECT rctd.first_name "Technician", count(wo.workorderid) "Sum of tickets handled by him", ...