Bulk add a performance to a list of IDs?

Hello there everyone, 

My organization is hoping to find a way to bulk add a $0 performance to a list of patron IDs. Is this possible, or is there a SQL code that anyone would be willing to share?

Thank so much for you help!
Nicolette Latini
Mondavi Center 

  • Nicolette – two ways I can think of for this is using the Order Import Utility, or a Rollover.
     
    The order import utility would use data from a tab delimited text file that contains the customer_no field (with some other necessary data).
     
    A rollover could be used if the customers are coming from an existing performance. I don’t believe a rollover can roll people without seating them. I don’t see any seating specific options in the Rollover Set manager. But if you’re rolling specific customers that had tickets to a performance, you could roll them into the $0.00 performance. More than one source performance would probably result in seat collisions.
     
    That’s two ways to do it. Ultimately I don’t think it’s possible to create orders for performances without a batch. Please someone correct me on this if I’m wrong because there are times I’ve wished I could do exactly that.
     
    Have you checked the user submitted solutions on the Network? Maybe someone already created something custom…
     
    Have a great day and stay safe 😊
     
    Jerry Boutot | Manager, Information Technology - Data
    O: 813.222.1097 C: 352-428-4199
     
  • Hi Nicolette - You probably have this done already but we've done this several times using the Order Import utility. Once the format file and import settings are all configured, it's pretty quick!