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
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.
Lucie
______________________________Lucie SpielerIT Development and Training ManagerFLORIDA GRAND opera