I having isssues importing organizational data, parent child relationships into sevice desk on SQL database. I am receiveing all sorts of errors when doing the import, is there anybody that has succefully done this wo can help me please. Thanks in advance.
here is the excel spread sheet. I can create the xml file without any errors but it does not work when importing into database. the import mappins file has only 3 fileds seachcode name1 and parent and seachcode is my unique key.
I don't understand the lack of an export log. Normally you would have an ODBC Data Source set up to the excel file and then the data exchange export will use the ini file to create the XML in the correct format.
Can you attach the XML?
But looking at the import log the orgs already exist and it is only the setting the parent that is failing??? Check that the import mapping for the Parent field is a "Reference" to the Name field as Parent in the excel is listed using the name not the searchcode.
Reference is the drop down list shown below - it tells the import that you are providing the Parents Name so it can find the right one.