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: 

Parent Child Relationship

SOLVED
Go to solution
Highlighted
Michael Lutfi
Frequent Visitor

Parent Child Relationship

Hello All,

Can anyone please justify why I get the error:
Cannot find parent Column SerialNumber_R

[DSN]
NAME=Server
USR=
PWD=

[SYSTEM]
LOG=TRUE
XML=TRUE
LOG_FILE=Server.log
XML_OUTPUT_FILE=Server.xml
APPLICATION_NAME=Server

[CLASSES]
NAME=Rack,Server


[Rack]
SOURCE=RACK
ATT=[Name_R],[Model_R],[Size_R],[SerialNumber_R],[Location]
COLUMNS=[Name_R],[Model_R],[Size_R],[SerialNumber_R],[Location]
LOADTABLE=TRUE
Maxrecords=5

[Server]
SOURCE=SYSTEMS
PARENT=Rack
PARENT_RELATION=[SerialNumber_SR]=[SerialNumber_R]
--[SerialNumber_R]
ATT=[SerialNumber_SR],[Name_S],[Model_S],[SerialNumber_S],[Size_S],[OS],[Weight],[Heat],[Power],[Application],[Support]
COLUMNS=[SerialNumber_SR],[Name_S],[Model_S],[SerialNumber_S],[Size_S],[OS],[Weight],[Heat],[Power],[Application],[Support]
LOADTABLE=TRUE
2 REPLIES
Solution

Re: Parent Child Relationship

Hi Michael,

I have the same problem when trying to import data to SD. So, I avoid the error deleting the relation from the ini file and giving the relation in the import mapping. There fill the reference to search code.

I'm new on this. Hope can help my answer.

Good luck.
Mariana
There's nothing impossible!
Mike Bush
Honored Contributor

Re: Parent Child Relationship

Don't PARENT and PARENT_RELATION have to come AFTER the COLUMNS?

And I always use all UPPER CASE for the ATTRIBUTE names to avoid problems with case sensitivity in the import mapping.
//Add this to "OnDomLoad" event