Importing a GA event - unseated issue

Hi all

I'm trying to do an order import for a general admission event. From what I've read on the forums this is entirely possible so long as the section, row, first seat and last seat columns are empty in my data import file and the number of seats is populated.

I've done all that, but now I get the "No matchup can be determined for a package, performance, section, or pricetype. Order will be skipped." error message. This makes sense, because there is no section in the data file.

I've checked TW_ORDER_IMPORT and can see that package is null (ok), performance has been picked up correctly (ok), section is null (ok - but perhaps not?) and pricetype has been picked up correctly (ok).

Is there any trick to get the order import working for these unseated GA events?

I'm on 11.0.4.

Cheers

David Geoffrey Hall

Parents
  • Hi David,

    I've not done an import for a GA event, but I'm pretty sure you still need a section. From the order import documentation:

    Each row in the import data is evaluated for performance, mode of sale (if mode of sale data is included in the import data), section, zone, and price type matches in Tessitura. If any of this data cannot be matched, a row will not be imported.

    Let us know how you go!

     

    Patrick.

  • Hi Patrick,

    I figured this out yesterday actually. I needed to match up the zone in the data file with the correct zone in the GA venue. That doesn't explicitly get stated anywhere in the documentation but when I changed the zone into the same as I get when I do a test order export for the same event, it goes in fine.

    Hopefully that'll help someone else out there - thanks for your tip though.

    dgh

Reply
  • Hi Patrick,

    I figured this out yesterday actually. I needed to match up the zone in the data file with the correct zone in the GA venue. That doesn't explicitly get stated anywhere in the documentation but when I changed the zone into the same as I get when I do a test order export for the same event, it goes in fine.

    Hopefully that'll help someone else out there - thanks for your tip though.

    dgh

Children