Data Import Using Service Catalog

[neethu4]

Hi All,

I want to create a catalog item which will help to import the file to CMDB table.My thought is on submit of the the request trigger the data source and pass the attachment to it.

But don't know how to achieve it.

Please let me know if any suggestion on this

Thanks,

Neethu

[Ankur Bawiskar · Accepted solution]

Hi Neethu,

That's correct.

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

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

3) Have scheduled import created with this data source with active= false, run as administrator since 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 type

Business 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

}

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks

Ankur

[neethu4]

Thanks Ankur.I am going to try this.

[Ankur Bawiskar]

Sure Neethu,

Do provide us an update on this once you are done with it or any issue while trying.

Regards

Ankur

[Ankur Bawiskar]

Hi Neethu,

Any update on this?

Can you mark my answer as correct, helpful and hit like if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

Regards

Ankur