Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Import Category Relations

SOLVED
Go to solution
Highlighted
Fiachra
Super Collector

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
Honored 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
Super Collector

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
Honored 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
Super Collector

Re: Import Category Relations

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

Thanks.
//Add this to "OnDomLoad" event