Hello,Celebrity Series is a performance presentation company that uses several venues. We have our own box office and tickets we sell here, but we also give a portion of the tickets to sell at the venue, using their systems and ticket stock. After the performance we receive a list of patrons and their information (address, email, etc) from the venue, which we import using the Constituent Import Utility. However, the problem arises when we want to connect an imported patron with a particular performance. Order Imports have been ruled out because we get our financial information from the venue way before we get the list of patron names. I've considered using interests (which would have to be added manually,) attributes (which you can't have more than 1 of the same type), and lists (which you can't see on a patron profile.) Has anyone had any experience with third-party box office information? Help!
-Jane
We use an attribute. You select the attribute type when running the report. Ours is the equivalent of “ticket sold at venue.” The value gets imported, so we list the fiscal year and title of show as the value to import.
Lucie
______________________________Lucie SpielerIT Development and Training ManagerFLORIDA GRAND opera
Lucie,Thanks for the reply! Are you able to have more than one "ticket sold at venue" attribute per patron though? I thought you could only have a type of attribute used once. How do you handle a patron who has bought multiple "ticket sold at venue"?Thanks!-Jane
HI, Jane:
You need to make sure that they keyword you use has the Multiple Value box checked in its setup.
Here’s our attribute setup in T_KEYWORD:
Keyword No: [automatically generated]
Description: Arsht Center-FGO Ticket Buyer [whatever description you want goes here]
Data Type: String
Edit Mask: None
Detail Tbl: TX_CUST_KEYWORD
Detail Col: !.key_value
Ref Tbl: t_kwcoded_values
Ref Idcol: key_value
Ref Descol: key_value
Ref Where: keyword_no = ### [keyword_no at the beginning of the table row]
Ref Sort: [we’ve left this one blank]
Category: [we’ve placed this in Attributes]
Use for List: [we’ve placed this in Attributes]
Multiple Value: [checked]
Control Group: [whatever is necessary for your business environment, if any]
The only other item we’ve added to this row is a description, “theater imports,” under Keyword Desc.
When I import constituents, I intentionally create duplicate accounts, then go through the resulting report and make sure I merge them. That way, I get multiple values. You could, though, just add those attributes manually.