Service Desk Practitioners Forum
cancel

Data Exchange to Relate Services to Services

SOLVED
Go to solution
Highlighted
Tulio Quinones
Outstanding Contributor.

Data Exchange to Relate Services to Services

Hi,

We would like to use data exchange to import what services are used by a service. (Serivce 1 uses Service 2)

In our import mapping we have the item type service and are using the "used services:service from" and "used services:service to" with a reference to name.

We using serivce names as the property field.

We get an error that more then 1 item is found. We have each field as unique.

Have attached print screen of import mapping
4 REPLIES
George M. Meneg
Acclaimed Contributor.
Solution

Re: Data Exchange to Relate Services to Services

Hello Tulio,

It fails because you try to import a service relation the wrong way.

So, for the SLM_SERVICES_REL_SERVICE (I assume that is the name), the item should be Service Relation and not Service.

In there you need only to define "Service From" (the service using the other service) and Service To (the service that is used by the other service). There you should define that both Service From and Service To are used as unique keys. Have a look at the attached image.

menes fhtagn
Tulio Quinones
Outstanding Contributor.

Re: Data Exchange to Relate Services to Services

AH, thanks.

I made the modifications and get the following error:


warning: While processing SLM_SERVICES_REL_SERVICES (id = 1):
com.hp.ifc.ext.ExternalException: More than one item found.
at com/hp/ifc/ext/AppExternalAccess.getMessage
at com/hp/ifc/ext/AppMappedExternalEntity.getReferencedOid
at com/hp/ifc/ext/AppMappedExternalEntity.exists
at com/hp/ifc/ext/AppSingleLoad.processEntity
at com/hp/ifc/ext/imp/AppEntityHandler.endElement
at com/jclark/xml/sax/Driver.endElement
at com/jclark/xml/parse/EntityParser.parseContent
at com/jclark/xml/parse/EntityParser.parseDocumentEntity
at com/jclark/xml/parse/DocumentParser.parse
at com/jclark/xml/parse/base/ParserImpl.parseDocument
at com/jclark/xml/sax/Driver.parse
at com/hp/ifc/ext/imp/AppImpTaskParser.parseFile
at com/hp/ifc/ext/imp/AppImpTaskParser.objectToSD
at com/hp/ifc/ext/imp/AppImpTaskParser.parseChunk
at com/hp/ifc/ext/imp/AppImpTaskParser.parseSerial
at com/hp/ifc/ext/imp/AppImpTaskParser.parse
at com/hp/ifc/ext/imp/ImportXmlCim.startImportTask
at com/hp/ifc/ext/imp/ImportXmlCim.startImportTask
at com/hp/ifc/ext/imp/ImportXmlCim.main
More than one item found.

What are you using as "a reference to item"?
George M. Meneg
Acclaimed Contributor.

Re: Data Exchange to Relate Services to Services

Hello Tulio,

We use a custom number field as reference.

Since we import OVSD services from our Geneva Billing I use geneva's package_id and product_id as custom fields in OVSD services and used them as unique ids.
menes fhtagn
Tulio Quinones
Outstanding Contributor.

Re: Data Exchange to Relate Services to Services

Thanks.

I was using the name of the service and it didnt work. When I change it to service desk id of the service it works.

We really would prefer to use the name of the service.