Hey there.
Firstly, the 5000+ constituents didn't have an FName to import - that's not the issue. :)
I'm going to add a . to the Fname field in T_CUSTOMER for anyone with a NULL in the Fname field using SQL, and my question is this - how can I get Tessitura to update the Gen Sal field for me? So rather than Mr. White it will say Mr. . White. The reason I'm asking this is that we have a custom report that won't run without something in the Fname field. Odd, I know.
I've done a test and I can make changes to the Fname field but I can't work out how I can get the new Fname to show up in the Salutation 1 field without having to go into each constituent record and clicking the Gen Sal button.
Any pointers would be appreciated.
Paul,
UP_REBUILD_SALUTATIONS will rebuild all salutations for a list (or the whole db if you don't pass a list_no). So I would make a list of the imported names and generate the salutation for that list.
Anna
Hi Anna, that's perfect!
And you've answered what my next question would have been about running it for a 'List' - so that's brilliant!
Thank you so much!