question Re: Coping an attachment from RITM to Data source in Developer forum

Coping an attachment from RITM to Data source

kumar86 — Thu, 28 Jun 2018 13:05:31 GMT

Hi Folks ,

I have a requirement like ----> When a user uploads attachment from catalog form with asset details . I have fetch the data and add the information to asset table . I followed below steps

1. Create a data source for that attachment --> Created a data source

2. Load data using related link --> 1st time i loaded data manually

3. Create Transform map and field mappings. --> Done with transform map and field mappings

4. Create a scheduled import of type 'On Demand' --> Created one scheduled import for the data source which we created earlier in step 1 . But the attachment which was uploaded by user via catalog form is not attaching to data source . Below is the BR which I wrote to copy the attachment automatically to data source by using scheduled import .

Table : sys_attachment

When to run : After insert

Script :

(function executeRule(current, previous /*null when async*/) {

gs.info("===== BR running =====");

var rec = new GlideRecord('scheduled_import_set');
rec.get('name', 'Scheduled Data Import for this data source');
SncTriggerSynchronizer.executeNow(rec);

})(current, previous);

Please let me know where exactly I am mistaken , Thanks in advance .

Re: Coping an attachment from RITM to Data source

Saikiran Gudur1 — Thu, 28 Jun 2018 13:08:54 GMT

https://community.servicenow.com/community?id=community_question&sys_id=56b747e9db1cdbc01dcaf3231f961984&view_source=searchResult

https://community.servicenow.com/community?id=community_question&sys_id=ff550baddbd8dbc01dcaf3231f961941&view_source=searchResult

Re: Coping an attachment from RITM to Data source

kumar86 — Thu, 28 Jun 2018 13:18:45 GMT

Thanks Saikiran for sharing the info , But I already saw these post but didnt worked for me . 😞

Re: Coping an attachment from RITM to Data source

Saikiran Gudur1 — Thu, 28 Jun 2018 13:31:40 GMT

Hi,

1) Have business rule after insert on RITM table which runs only for that particular CatalogItem.

2) Have a data source, transform map and field map created as usual. coalesce etc will bepresent

3) Have scheduled import created with this data source with active= false, run as administratorsince it will be triggered from script. In left nav type Scheduled Imports and create new

4) in the business rule condition check whether the RITM has attachment then only run the business rule and have following script

Business rule condition:

current.hasAttachments()

//extra check you can have is whether it is csv or xls based on data source attachment file typeBusiness rule

script:

var dataSourceSysId = ''; // sys_id of the data source you created in step 2
var schImp_GR = new GlideRecord('scheduled_import_set');
schImp_GR.addQuery('data_source',dataSourceSysId);
schImp_GR.query();
if(schImp_GR.next()){
gs.executeNow(schImp_GR);
// use this if it is in scoped app //SncTriggerSynchronizer.executeNow(schImp_GR);
// if in non-scope app i.e. global// the above 2 lines will start the import process, etc automatically
}

Thanks,
Saikiran Guduri (NOW)
Associate Certificate Engineer | ServiceNow Store Apps
(Please mark the answer as correct answer/helpful/accept the solution if it helps)

Re: Coping an attachment from RITM to Data source

Saikiran Gudur1 — Thu, 28 Jun 2018 13:34:24 GMT

If you are not developing any scoped app use this :

gs.executeNow(schImp_GR);

in place of

SncTriggerSynchronizer.executeNow(schImp_GR);

Re: Coping an attachment from RITM to Data source

kumar86 — Thu, 28 Jun 2018 13:56:54 GMT

Hi Kiran,

I wrote same logic on RITM table but its not working , I can clearly see the file is falling in RITM table , but I am not able to understand why this attachment is coping to data source . Below is the code that my BR has

Table : RITM

When : After Insert

Script :

(function executeRule(current, previous /*null when async*/) {

var dataSourceSysId = 'c52aee08db03130094649b81ca961974';
var schImp_GR = new GlideRecord('scheduled_import_set');
schImp_GR.addQuery('data_source',dataSourceSysId);
schImp_GR.query();
if(schImp_GR.next()){
gs.executeNow(schImp_GR);
// use this if it is in scoped app
//SncTriggerSynchronizer.executeNow(schImp_GR);
// if in non-scope app i.e. global// the above 2 lines will start the import process, etc automatically
}

})(current, previous);

Can you please suggest me with correct process , If I am doing wrong.

Thanks for knowledge sharing,

Dinesh

Re: Coping an attachment from RITM to Data source

kumar86 — Fri, 29 Jun 2018 04:38:15 GMT

Hi Kiran ,

Any suggestions ?

Regards,

Kumar