Service Desk Practitioners Forum
cancel

Import Category Relations

SOLVED
Go to solution
Highlighted
Fiachra
Valued Contributor.

Import Category Relations

Hi there,

I have SD 4.5 with sp15.

I am attempting to import category's to the "Service Call Category" Field. I have set up the ini file and the import mapping and the data exchange task completes. All category's import to the field, however none of the Parent child relations have been mapped in the import? The desired relationship is :

Category
->Service
-->Issue
--->Reason

I have the attached ini file configuration and import mapping set. Can someone tell me where I am going wrong please?

Thanks
4 REPLIES
Gyula Matics_1
Acclaimed Contributor.

Re: Import Category Relations

The SERVICE class in your ini file is missing the CATEGORY field that is mapped to the parent in your import map.
Fiachra
Valued Contributor.

Re: Import Category Relations


So if I use the below as an exapmle from the ini file, what is the syntax to relate the service the category and so on..?

[CLASSES]
NAME=CATEGORY,SERVICE,ISSUE,REASON,

[CATEGORY]
SOURCE=[CC]
ATT=[CATEGORY]
COLUMNS=[CATEGORY]
LOADTABLE=FALSE

[SERVICE]
SOURCE=[CC]
ATT=[SERVICE]
COLUMNS=[SERVICE]
LOADTABLE=FALSE
Gyula Matics_1
Acclaimed Contributor.
Solution

Re: Import Category Relations

Here it is. Add the CATEGORY column to the field list in both the ATT and COLUMNS line.

[SERVICE]
SOURCE=[CC]
ATT=[SERVICE],[CATEGORY]
COLUMNS=[SERVICE],[CATEGORY]
LOADTABLE=FALSE
Fiachra
Valued Contributor.

Re: Import Category Relations

That worked Gyula Matics! Nice one! Consider the mater closed.

Thanks.