The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Data exchange of CI and relating it to users

Highlighted
Esc_1
Regular Collector

Data exchange of CI and relating it to users

Hi,
I want to export the CI items in SD and then relate it to a specific user.
And also want to make a parent child relation ship between the CI's e.g IF CPU is a Parent then the Monitor and Keyboard, mouse etc will be the child.
Is it possible by uploading it from excel.
Can i skip the manul work of adding it indivually.

please suggest as i want to do it urgently

ESC
5 REPLIES
Esc_1
Regular Collector

Re: Data exchange of CI and relating it to users

Can any one help me to solve this

ESC
Esc_1
Regular Collector

Re: Data exchange of CI and relating it to users

Can any one help me in solving this issue

ESC
Guenther Schere
Frequent Visitor

Re: Data exchange of CI and relating it to users

Hello ESC,

of course you can use a excel file to get date (CIs) into SD.

Prepare the excel file (adjust the main key CI and user, define the data range...)
Export the Excel data to xml.
Define the mapping and import the xml.

You should import the relations between the CIs in a separate import or at least in a separate class.

Please concrete where you have problems.

Best regards
Guenther
Esc_1
Regular Collector

Re: Data exchange of CI and relating it to users

Hi,
And thanks for ur reply...
I have imported the H/w and S/w details in SD, can u tell me in detail how do i make a relationship between them. (i.e. parent and child relationship)which template to use
and also i want to make relationship between the CI and the user.

ESC
Esc_1
Regular Collector

Re: Data exchange of CI and relating it to users

can any one help me in solving this
//Add this to "OnDomLoad" event