I have an order import set of data from an external agency. The data has been formatted correctly but many of the rows are failing.
The Tessitura report details the reason as "50000 Error occurred during import, check log.". If I check the table T_IMPORT_SESSION_LOG the corresponding message is consistently "Duplicate: Potential duplicate for existing ID 61050360: Abbott, Penelope. Match using Name and Primary Address." - obviously with a change of customer_no, lname and fname as appropriate. The report itself does not detail any potential duplicates so the only thing I can think of is that it is the potential duplicate that is causing the row to fail.
Can anyone offer any insight into what is happening here?
Martin
There is a setting on the Import Set called Create Potential Duplicate. When checked, potential duplicates will be allowed to be created. This setting defaults to unchecked (‘N’ in the db).
By default the Order Import will fail for a data row if the constituent data is flagged as a potential duplicate.
=>Ryan Creps
@Tessitura Network
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Martin Keen Sent: Thursday, February 27, 2014 11:58 PM To: Ryan Creps Subject: [Tessitura Technical Forum] Order import failure
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Ryan,
Thanks for pointing this out!
Just so I am clear on this, with "Create Potential Duplicate" ticked, even if the utility identifies a potential duplicate, it creates the duplicate anyway and that there is no switch which causes the order to be attached to the existing constituent record?