Service Desk Practitioners Forum
cancel

Relations Data exchange in SD 4.5 SP 18

SOLVED
Go to solution
Highlighted
Maximo 5
Super Contributor.

Relations Data exchange in SD 4.5 SP 18

Hi,

I want to import persons registrer with workgroup existing relation but I don't know do it. The attach example doesn't work

Help me please.

2 REPLIES
Vasily Kamenev
Acclaimed Contributor.

Re: Relations Data exchange in SD 4.5 SP 18

Sokre_1
Respected Contributor.
Solution

Re: Relations Data exchange in SD 4.5 SP 18

Hi,

First you have to create a proper .ini file and then map the attributes using import mapping.

You can use the following .ini file as an example. It exports person, workgroup and person-workgroup relations data from Excel table.

[DSN]
NAME=CMDB-excel
USR=
PWD=

[SYSTEM]
LOG=TRUE
XML=TRUE
DUMP=FALSE
TXT=FALSE

[CLASSES]
NAME=PERSON, WORKGROUP, WG_MEMBERS

[PERSON]
SOURCE=[person] [PERS]
ATT=[FIRSTNAME], [LASTNAME], [SC], [EMAIL]
COLUMNS=DISTINCT [PERS].[Firstname] AS [FIRSTNAME], [PERS].[Lastname] AS [LASTNAME], [PERS].[Search_code] AS [SC], [PERS].[E-mail] AS [EMAIL]
LOADTABLE=TRUE

[WORKGROUP]
SOURCE=[workgroup] [WG]
ATT=[SC], [NAME], [TECH], [PROC_ROLE]
COLUMNS=DISTINCT [WG].[Search_code] AS [SC], [WG].[Name] AS [NAME], [WG].[Technology] AS [TECH], [WG].[Process_Role] AS [PROC_ROLE]
LOADTABLE=TRUE

[WG_MEMBERS]
SOURCE=[workgroup] [WG_MEMB]
ATT=[NAME]
COLUMNS=[WG_MEMB].[Members] AS [NAME], [WG_MEMB].[Search_code] AS [workgroup_Search_code]
LOADTABLE=TRUE
PARENT=WORKGROUP
PARENT_RELATION=[WG_MEMB].[Search_code]=[SC]

Sokre