Re - Importing Data

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

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!

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

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!