Per the latest NCOA update, I've 1) inactivated the primary address 2) changed the type to NCOA update type, and 3) made the new uploaded addresses the new primary addresses.
However, several customers are showing the inactivated addresses in the general tab (in the envelope area), rather than the new primary ones. My question is, what exactly makes a given address show up on the envelope in the general tab?
I've already tried adjusting the Label column to no positive effect. Any thoughts or should I open a ticket?
Thanks, Tessiturians.
Also, to find customers with more than one primary addresses you can run
SELECT customer_no, NumberOfPrimaryAddresses = COUNT(*)
FROM t_address a
WHERE a.primary_ind = 'Y'
AND a.inactive = 'N' --This is if you only want to find active duplicates
GROUP BY customer_no
HAVING COUNT(*) > 1
Fernando Margueirat Business Analyst The National Ballet of Canada 470 Queens Quay West Toronto, Ontario M5V 3K4 P: 416 345 9686 x453 F: 416 345 8323
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Graham Sent: August-11-11 5:09 PM To: Fernando Margueirat Subject: Re: [Tessitura Technical Forum] Address Weirdness
Oh yeah - also what Amanda said. I'd check to see if you have addresses where the primary_ind = 'Y' and inactive = 'Y'
From: Brian Graham <bounce-briangraham8283@tessituranetwork.com> Sent: 8/11/2011 4:04:56 PM
I don't think there's a clean up proc. I would do a search in sql on t_address where primary_ind = 'Y' and address_no not in(select address_no from t_customer)
just to see what you're dealing with, then edit the query into an update statement.
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!