Some quick assistance to solve a wee mystery please. I have used User Defined Format From A List , and saved as an excel spreadsheet - all good. When I run an Output Set on the same list and save it to excel I get numerous double ups ie same constituent file in excel even though they there are no doubles on the orginal list - very annoying HELP!
Thank you Beth – I see now its where files have been merged and the file ends up with 2 addresses (the same) - is there a way around this with Output Sets? We have’t been using Output Sets particularly but now want to include any organization/corporation name (which User Defined Format from a List doesn’t do).
Darrell Jones | Assistant Box Office Coordinator | Tasmanian Symphony Orchestra
1 Davey Street, Hobart, Tasmania | GPO Box 1450 Hobart, Tasmania 7001
Tel 03 6232 4404 | Fax 03 6232 4455 | Email jonesd@tso.com.au | Website: www.tso.com.au
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Beth GillilandSent: Monday, 9 September 2013 11:54 AMTo: Darrell JonesSubject: Re: [Tessitura Ticketing Forum] Output Set
Darrell -
You probably have a field in your output set that is returning a field that contains multiple rows for a constituent. For instance, if you chose to add the email address (not just the *primary* email address) - and the customer has more than one active email address, they'd have two rows in your output set.
See troubleshooting in Help:
http://www.tessituranetwork.com/Help_System/Content/Output%20Sets/OUtput%20Set%20Troubleshooting.htm
Beth
From: Darrell Jones <bounce-darrelljones8445@tessituranetwork.com>Sent: 9/8/2013 8:25:50 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!
Depends on where you are storing your organization/corporation name. If you are just referring to the name at the top of the screen, it is stored in Last Name, and that shouldn't cause duplicates on it's own. If the corp name is in Salutations or one of the Address fields, then it's possible you'll get multiple rows.
I'm not sure if you have access to edit or view the Output Set you're trying to use - or even create one of your own. But if you can open it up, any field you add that has an asterisk next to it can possibly add multiple rows. The only other thing I can think of is if you are choosing a particular address type or salutation type when you run the report - and that organization has more than one of that type, you might still see multiple rows.
Check your output again, and see if you can find the field where the content *differs* for a particular customer. *THAT* is most likely the field that is the culprit.
Not sure exactly what you mean by "merged files", but I hope this can guide you in the right direction. That being said, I'm not logged into Tessitura at the moment, so these answers are just by recall...YRMV. :)