Create service request through attachment

[Vishnupriya15]

Hello,

I have a requirement to create a service request from another catalog item XYZ.

If XYZ catalog item will be submitted with Attachment(This attachment has data to create request like  user name and hardware details) and post approval of this XYZ request, we need to create RITM's automatically based on the data given in the attachment. If this attachment has 4 Rows of data - we need to create 4 RITM

Any help Appreciated!!

Thanks!!

[Ubada Barmawar · Accepted solution]

Hi @Vishnupriya15 

I really hope this solution will workout.

its better to use flow designer for this task

step 1 : trigger flow on catalog item, get catalog variables if wanted.

step 2 : use a custom action with script to check if the submitted record has any attachment(glide to sys_attachment table and filter by current sys_id)

step 3 : upon approval, copy the attachments from submitted record to the data source(create data source, transform map, and scheduled data import(inactive), and include post import script to delete the attachments after import) and execute the scheduled import.

this may help: Automate Data import from Excel File Attachment vi... - ServiceNow Community

for scoped: post import script can be:

var dataSourceSysId = data_source.getValue('sys_id');

var attObj = new GlideRecord('sys_attachment');

attObj.addQuery('table_name', 'sys_data_source');

attObj.addQuery('table_sys_id', dataSourceSysId);

attObj.query();

if (attObj.next()) {

    attObj.deleteMultiple();

}

please mark as accepted if this helps, Im very sure that this will workout.

regards,

Ubada Barmawar.

[Ubada Barmawar · Accepted solution]

the no of rows doesnt matter, all rows will be imported. just copy the attachment to data source using 

var attachment = new GlideSysAttachment();

var attached = attachment.copy('table_name', 'TablesysID', 'sys_data_source', 'datasource_sysID' );

    if(attached){

            gs.executeNow('Scheduleimportrecord');//execute the scheduled data import

        }

map all the data in excel to the target record properly using transform map and Import set, you'll get the import set execution in scheduled data import related list

please mark this as accepted and helpful

[Ubada Barmawar · Accepted solution]

Hi @Vishnupriya15 

I really hope this solution will workout.

its better to use flow designer for this task

step 1 : trigger flow on catalog item, get catalog variables if wanted.

step 2 : use a custom action with script to check if the submitted record has any attachment(glide to sys_attachment table and filter by current sys_id)

step 3 : upon approval, copy the attachments from submitted record to the data source(create data source, transform map, and scheduled data import(inactive), and include post import script to delete the attachments after import) and execute the scheduled import.

this may help: Automate Data import from Excel File Attachment vi... - ServiceNow Community

for scoped: post import script can be:

var dataSourceSysId = data_source.getValue('sys_id');

var attObj = new GlideRecord('sys_attachment');

attObj.addQuery('table_name', 'sys_data_source');

attObj.addQuery('table_sys_id', dataSourceSysId);

attObj.query();

if (attObj.next()) {

    attObj.deleteMultiple();

}

please mark as accepted if this helps, Im very sure that this will workout.

regards,

Ubada Barmawar.

[Vishnupriya15]

Hi,

My requirement is quite different .

Since am new to this, can you help me with the except scripts

This excel has data like ( user name, manager name, hardware asset name and etc) and the data can be many rows

once XYZ request is submitted with this attachment, I have to create as many as RITM's as the data mentioned in the attachment, if its has 5 rows- there should be 5 new request created

[Ubada Barmawar · Accepted solution]

the no of rows doesnt matter, all rows will be imported. just copy the attachment to data source using 

var attachment = new GlideSysAttachment();

var attached = attachment.copy('table_name', 'TablesysID', 'sys_data_source', 'datasource_sysID' );

    if(attached){

            gs.executeNow('Scheduleimportrecord');//execute the scheduled data import

        }

map all the data in excel to the target record properly using transform map and Import set, you'll get the import set execution in scheduled data import related list

please mark this as accepted and helpful

[Vishnupriya15]

Hi,

Could you pls let me know, if we can achieve this through BR and can you help with the scripts instead flow designer