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

A error about importing data!

Highlighted
zhaohongxinguo_
Occasional Contributor

A error about importing data!

Hello everyone!
When I import data into sd, I meet a error:Entity Not defined ,The XML file is successful,I think that the import mapping maybe is a problem,I hope that someone can help me ,Thakns a lot!
12 REPLIES
Dan Ioan
Frequent Visitor

Re: A error about importing data!

Hi,
A sample of your mapping will be useful, to see your unique key identifier.
Regards,
Dan
zhaohongxinguo_
Occasional Contributor

Re: A error about importing data!

Thank you!Yes, I have do this according to your advice,However, Unluckly, I still not slove it, Maybe I don't understand you correctly, I am from china!Can you explain to me in detail?
Thank you very much!
Dan Ioan
Frequent Visitor

Re: A error about importing data!

Hi,
You must to check the XML file. There, you will see the entity names. Make sure that are the same names that you specified in your import mapping.
Don't forget, these are case sensitive.
Hope this helps you.
Regards,
Dan
zhaohongxinguo_
Occasional Contributor

Re: A error about importing data!

Thank you !DAN!
I find the problem that maybe cause the error!a ID that I don't know in my xml files.I don't know how to remove it!Help me!!
Dan Ioan
Frequent Visitor

Re: A error about importing data!

Hi,
You probably must to re-export data to your XML file. Before this, you should analyse your EXCEL table and your mapping. A sample of these, could helps to solve the problem, if we can see what attributes and what type of data you filled in.
Regards,
Dan
zhaohongxinguo_
Occasional Contributor

Re: A error about importing data!

HI!
I will up the my xml files ,import mapping and the error!You can see them!
Thank you for your always caring about me and the problem!
zhaohongxinguo_
Occasional Contributor

Re: A error about importing data!

it is importing mapping!
zhaohongxinguo_
Occasional Contributor

Re: A error about importing data!

it is the error!
zhaohongxinguo_
Occasional Contributor

Re: A error about importing data!

Hi!
I also find a problem when I configure the ini file by extractor configure wizard!You can see the picture!
Thank you a lot!
Mihai Tita
Occasional Visitor

Re: A error about importing data!

Hi,

Try to
- remove the spaces in the attributes and write them all in upper case
- check the key binding to see if it was defined correctly
- set both class name and your import mapping name to same name (set CLASSPERSON = PERSON_IM)

Regards,
Mihai
Mihai Tita
Occasional Visitor

Re: A error about importing data!

set PERSON_IM = CLASSPERSON
zhaohongxinguo_
Occasional Contributor

Re: A error about importing data!

Hi!
I also find a problem ,in sd database table ITSM_PERSONS LASTNAME varchar 50 ,However in extractor configure wizard ,the class LASTNAME CHAR 255
//Add this to "OnDomLoad" event