• Replies 3 replies
  • Subscribers 338 subscribers
  • Views 29 views
  • Users 0 members are here
Related

Re - Importing Data

Jana Miller
$organization

We had our constituency records put through the National Change of Address by a third party. We now have 5000 address that need to be updated back into Tessitura without causing duplicates??

I hoping other must have done the similar thing   - any idea?

 

 

Parents Reply Children
  • $organization in reply to Ranie Daw (Past Staff Member)

    Thanks it is always nice when someone replies, but we do not have any strong SQL users within the company

  • Former Member
    Former Member $organization in reply to Jana Miller
    If the file that was sent to your NCOA provider included the customer_no, then hopefully the file returned will have it too.  Then you can perform an update by joining the two recordsets on customer_no.
     
    I don't think this can be done, or even attempted, by anyone who doesn't have DBA experience.  You may have to hire a consultant.
     
    Good Luck!


    >>> bounce-janamiller7562@tessituranetwork.com 7/23/2009 3:01 AM >>>

    Thanks it is always nice when someone replies, but we do not have any strong SQL users within the company

    From: Ranie Daw <bounce-raniedaw3224@tessituranetwork.com>
    Sent: 7/22/2009 6:59:07 PM

    You could write a SQL matching on fist initial of first name, 4 initials of surname and because the address has been 'updated' and most likely formatted in the same way a 5 letter match on the address.

    Thats pretty much what we did with the help of the Tessitura gang - but your DBA should be able to do that if they know SQL?




    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!