Incident creation through excel sheet.

[amIT152]

 I have a requirement to create incident tickets from excel sheet.Sheet contains the details like: caller, category, sub-category, configuration item. But configuration item column contains many records say: 2 or more.

How to create incident by uploading excel sheet. 

Excel sheet have rows and columns, say: 1 st row contain single CI, 2nd row contains 5 different CI's.

[sachin_namjoshi]

Configure data source and transform map, transform script to create incident from spreadsheet.

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/import-sets/concept/c_DataSources.html

Regards,

Sachin

[amIT152]

thank you , it would great if you elaborate more.

[Varsha21]

Hi,

please go through incident table and check one record,

here configuration item is reference field,here we can display only one item,so how can we import  more than 1 value here?

other wise configuration item table we can insert those as record.

then 

go to 

data source 

create data source and  create new record ,attach file excel file,

the fill all the required details and right click and save

click field map

using auto field map then check whether it is corrected or not.

(if needed create script before,after etc.)

load data and transform.

and check into your targate table data.