Hello,
We are looking to append our state's school ID # to the school account in Tessitura for use in connecting demographic data. I created the attribute and we have a spreadsheet containing the Tessitura ID as well as the school number. I found an old forum post from a few years back where someone was doing a similar thing importing demographic data but when I attempt to follow what they did I get the following error:
Msg 547, Level 16, State 0, Line 12The INSERT statement conflicted with the FOREIGN KEY constraint "TX_CUST_KEYWORD_FK_customer_no". The conflict occurred in database "impresario", table "dbo.T_CUSTOMER", column 'customer_no'.
I was able to import the data into a local table (customer_no, keyword_no, key_value) from excel and each row is unique.
The recommended code was:
insert dbo.TX_CUST_KEYWORD(customer_no, keyword_no, key_value)select customer_no, keyword_no, key_valuefrom LT_SCHOOL_ID
I have a very cursory knowledge of SSMS and SQL so any help would be great.
Thanks
Michael
Hi Michael - that error likely means that you have at least one customer_no value in your LT_SCHOOL_ID table that does not exist in t_customer. If you run this query, you should be able to pinpoint the row(s) that are problematic:
select *from LT_SCHOOL_ID awhere not exists(select 1 from t_customer b where a.customer_no = b.customer_no)
I hope this helps!
David
Thank you so much. That was it. Apparently there was one record there the ID number had a typo. All good now.
Mike