Asking the experts...
Does anyone have experience in customizing/modifying the local procedure LP_CONSTITUENT_IMPORT as it pertains to using/mapping the ten optional Local Use fields that are available in the Constituent Import Utility?
I've searches all the "usual" Tessitura resources and was not able to find any information on how this procedure is to be modified or any sample code.
Any assistance would be greatly appreciated.
Regards,
Normal 0 false false false EN-US X-NONE X-NONE
Brad Staples Database Reporting Specialist – IT Services Canadian Opera Company 227 Front St. E. Toronto, ON M5A 1E8
Office: 416-306-2320 Cell: 416-523-8466 Email: brads@coc.ca
BTT
Hi Brad,
We do use lp_constituent_import, although not with the local 10 fields. However, based on what I am seeing, it looks like you would find your local data by querying the tw_constituent_import table based on @session_id.
Here is an example assuming Local Use 0 is some value that needs to get inserted into a simple custom table called lt_const_custom:
if @run_mode = 1 and @mode = 'A'
begin
insert into lp_const_custom
(customer_no, custom_stuff)
Select a.customer_no, a.local_use0
From dbo.tw_constituent_import a
Where a.session = @session_id
And a.customer_no = @customer_no
And a.success_ind = 'Y';
end
Basically, the insert only fires when the import is actually running (@run_mode=1) and after the standard constituent data has been imported (@run_mode=’A’). You could also choose to add validation code when @run_mode in (1,2) and @mode=’B’.
I hope that helps.
Thanks,
David
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brad Staples Sent: Monday, June 22, 2015 6:40 AM To: David Frederick Subject: Re: [Tessitura Technical Forum] Constituent import & the Local Use Fields...
From: Brad Staples <bounce-bradstaples7413@tessituranetwork.com> Sent: 6/19/2015 1:06:22 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!
Thanks David, this looks promising.
Much appreciated,
Brad