Notification widget service portal with transform map

[Rafael Batistot]

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 

[Robert H]

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

[Rafael Batistot]

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