Hello All,
I am trying to import our existing Archtics information (that has already been collected into a central repository, so the data is not coming directly from Archtics) into Impresario via a series of scripts. The place that's giving me the most issue is getting our unconventional Event structure (each Event is a single Event, there are no strings of performances of a specific work that happen on a regular occasion) first into T_INVENTORY and then into the rest of the tables T_TITLE, T_PRODUCTION, etc.
We have worked out a way to fit the two disparate sources but the code that I have created is not working the way I want it to. It doesn't loop properly, and doesn't increment the inv_no the way that it needs to (even using the AP_GET_NEXTID_FUNCTION procedure)
Once the above is successful, I can pull over the ticket and package information (which works, incidentally, it's the performance information that’s the issue).
One thing to note, we don't sell tickets through Tessitura, we use it for Development, and are doing this to be able to attach the Archtics ticketing information to the appropriate donors.
Has anyone out there in Tessyland been through this process or is in the middle of it? Any help would be GREATLY appreciated!
Thanks,
Jamy