Process excel attachment and fill out form

[a_g_rodriguez]

I have a a form where i want to be able to attach my form and a business rule gets the form and fills out a table i have to update the information I already have.

Instead of manually importing the data each time. What kind of scripts do i need in my business rule or script include to be able to get the excel file and fun it through the transform map I already have? My goal is to able to attach my excel submit it and have my business rule/script include handle it. Also without the use of service catalogs and not all solely on scheduled imports because I want to be able to do it manually not timed.

Please, Anything helps!

[Sashi K1]

Did you try using Email Inbound Action? Thats almost manual, you have to send an Email to ServiceNow by attaching your Excel spreadsheet.

Your inbound action does everything that BR does (or move logic to a script include as a best practice) and attach that file which ever record that you want after processing data.

Hope that helps!

[a_g_rodriguez]

Yeah I haven't tried that, I'm more stuck on the scripting part.

Once I submit a form with an attachment, how do i go about find the attachment to go through the data to add it to a table?

[Sashi K1 · Accepted solution]

Email inbound action would work for it. You can send attachment manually for each attachment.

[Sashi K1]

Following link provides you info on how to do that

Loading data from an email attachment