Notification widget service portal with transform map
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-10-2025 05:32 AM
Hi team,
I have a process, that work, with transform map in service catalog
The process consists in create, automatically, categories and subcategories with transform map once the user attach the excel template in the catalog
My question here is, I would like a solution to inform the user case some category or sub not create
I’ve thought in user a g_form.addInformation with a msg and a link to guide directly a widget in service portal where is possible to see the rows that not create
Well I don’t know if this is the best approach. If anyone has another alternative I appreciate.
Thanks in advance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-10-2025 08:06 AM
Hello @Rafael Batistot ,
I assume the transformation of the Excel file starts after the request is submitted, and not immediately after attaching it, correct?
In that case the best approach would be to send a notification to the user who submitted the request if something goes wrong.
You could add an "onComplete" Transform Script to the Transform Map, which checks if there were any skipped/ignored rows in the Import Set, and if so, triggers an Event/Notification.
You can find a solution for a similar scenario here, but some adjustments to the code would be required.
Regards,
Robert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-10-2025 09:48 AM
That’s correct Robert,
When I submitted the catalog with the attach a business rule run and copy the attached from RITM generated, insert in the custom Data Source and run a schedule script that run the transform map and generate the categories
i will try this solution and let you know. Thank you so far