NCOA

The session number does not matter but the result code is very important.  The code determines how the data is processed by the utility.  Here’s an excerpt from the document for this utility:

Result codes are specific to the NCOA Update vendor used.  Codes are mapped to actions in the TX_NCOALINK_RESULT_ACTION system table, which is populated by default with the result codes used by MBS.  If MBS is not the vendor, the codes used by the chosen vendor must be added to the TX_NCOALINK_RESULT_ACTION system table.

So you can make up a code, but you have to then map it to the action you want to take for entries with that code.

You can access the document for this utility through the help system or using this link:

http://www.tessituranetwork.com/~/media/Documentation/Reports/NCOA_Processing.ashx

Kevin Sheehan

Documentation & Learning Resources Specialist

Tessitura Network

1 888 643 5778 ext 329 Office

ksheehan@tessituranetwork.com

I'm about to try and use this utility to import address changes.  The excel I'm working with was not exported from the NCOA utility so it does not have a session ID (column 1) and I also have no NCOA Reulst Code (Column 55).  Both these columns are required to have data.  If I just throw in random numbers will it still work?  Thanks

Chris

BONUS TRIVIA:  I love Matt's Bonus Trivia.  Seriously!

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!

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.13.114/2402 - Release Date: 09/29/09 05:54:00

The session number does not matter but the result code is very important.  The code determines how the data is processed by the utility.  Here’s an excerpt from the document for this utility:

Result codes are specific to the NCOA Update vendor used.  Codes are mapped to actions in the TX_NCOALINK_RESULT_ACTION system table, which is populated by default with the result codes used by MBS.  If MBS is not the vendor, the codes used by the chosen vendor must be added to the TX_NCOALINK_RESULT_ACTION system table.

So you can make up a code, but you have to then map it to the action you want to take for entries with that code.

You can access the document for this utility through the help system or using this link:

http://www.tessituranetwork.com/~/media/Documentation/Reports/NCOA_Processing.ashx

Kevin Sheehan

Documentation & Learning Resources Specialist

Tessitura Network

1 888 643 5778 ext 329 Office

ksheehan@tessituranetwork.com

I'm about to try and use this utility to import address changes.  The excel I'm working with was not exported from the NCOA utility so it does not have a session ID (column 1) and I also have no NCOA Reulst Code (Column 55).  Both these columns are required to have data.  If I just throw in random numbers will it still work?  Thanks

Chris

BONUS TRIVIA:  I love Matt's Bonus Trivia.  Seriously!

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!

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.13.114/2402 - Release Date: 09/29/09 05:54:00