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.
There's an address field in t_customer. If I recall that's what populates the general tab. That gets automatically updated when you update the primary from the client, but if you did it from sql server, you might have to update that as well.
Those people probably have multiple addresses with primary='y', one of which is the inactive one.
A-HA! You are quite right. One wonders why the need for a primary_ind field in T_ADDRESS, if it has to be noted in T_CUSTOMER as well. Can I assume there's a sort of clean-up procedure to fix this in T_CUSTOMER or should I write my own?
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.
Oh yeah - also what Amanda said. I'd check to see if you have addresses where the primary_ind = 'Y' and inactive = 'Y'
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
From: Brian Graham <bounce-briangraham8283@tessituranetwork.com> Sent: 8/11/2011 4:04:56 PM
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!