Share
Report
437ok. I am importing incidents (called tickets in my world).'
There are 3 lookups Tier 1, Tier 2, Tier 3 which are Operational Category records.
In the application, The dropdown for Tier 2 is populated based on the what the user selected in Tier 1. Tier 3 is populated based on what was selected in Tier 2.
example operational category:
Tier Value Parent Category
Tier 1 Central (blank)
Tier 2 Case Mgmt Central
Tier 2 Software Central
Tier 3 Question Case Mgmt
Tier 3 Install Software
There are duplicates at the Tier 2 and Tier 3 levels. NOTE: THERE ARE NO :DUPLICATES IN THE VALUES FOR TIER 1.
An import template was created by doing an export from the Data Management/Templates for Data Import. This put all of the columns for the Ticket record in the template.
Data from a legacy system was used to populate the excel file. of course, there were some manual transformations done, but not to the operateional categories.
When I import the tickets, I am getting "A duplicate lookup reference has been found" on Tier 1 and tier 2 and Tier 3 values
in the datamap, for the Tier 1, 2, 3 I changed the lookup to include the field and its primary key. (tried other unique fields as well) and the errors persist.
From what I have read, I thought that putting the field and primary key on the lookup for the related record in the datamap would allow the import to find a unique operational category, but alas the errors still occur.
Who has the super knowledge to resolve this issue????? Does anyone have deep knowledge on how the import looks for the realted records?
Thanks! DJ
All responses (
Answers (
