• Replies 10 replies
  • Subscribers 414 subscribers
  • Views 91 views
  • Users 0 members are here
Related

extracting large amounts of data

Former Member
Former Member $organization

Is there a way to extract large amounts of data without locking up Tessitura or getting the "Tessitura not Responding" message?  I work in a large arts organization and often need to pull combined data from all of our divisions for large time frames.  There has to be an easier way than running many shorter reports, downloading, and then piecing them together so that I can work with the data.

Thanks so much!
Mark

Parents
  • Former Member
    Former Member $organization

    Thanks so much Nicholas!  This is all good information. 

     

    Mark Frey  |  Woodruff Arts Center  |   P: 404.733.4277

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Nicholas Walls
    Sent: Wednesday, September 16, 2015 3:44 PM
    To: Mark Frey
    Subject: RE: [Tessitura Development Forum] extracting large amounts of data

     

    Hi Mark,

    I used Power Query at Seattle Opera to do exactly this type of data analysis - it's a huge time saver and an amazing tool. That said, if your organization is a RAMP organization, then you cannot directly connect Excel to Tessitura using Power Query. There are database and privacy issues. I checked with Tess at TLCC and there is no possible way to make the connection. 

    Here at Seattle Symphony, we are a RAMP organization and I have been exploring how you work with data and Power Query when you can't access the live data from Tess. Basically, I have pulled data out using a combination of reports and output set elements (heavily leaning on custom elements) and then used Power Query and Power Pivot tables to turn that data into something I can combine and produce analysis on. Its not as fluid as before but it's still better than anything else I have been able to do.

    Nicholas  

    From: Mark Frey <bounce-markfrey7157@tessituranetwork.com>
    Sent: 9/16/2015 6:20:35 PM

    Thanks Tom!  That sounds amazing!  I’m going to investigate further to see if I can get that here.  I appreciate your offer to talk.  I’ll email you if I have any questions.

     

    Mark Frey  |  Woodruff Arts Center  |   P: 404.733.4277

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Tom Brown
    Sent: Wednesday, September 16, 2015 2:05 PM
    To: Mark Frey
    Subject: RE: [Tessitura Development Forum] extracting large amounts of data

     

    Mark,

     

    We are using a method based on Microsoft Power Query & Power Pivot here at BAM.

     

    I have a spreadsheet in front of me at the moment with all 7.25 million seats we have made available over the last 13 years here at BAM.

     

    In just a few moments, I can pull the 225,000 + contributions in our systems. Just did it… It took about 1 minute start to finish.  I know that the Seattle Opera is doing the same thing.

     

    I’d be glad to talk with you about our approach.

     

    --Tom

    …

    718.724.8135

    tbrown@BAM.org

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Mark Frey
    Sent: Wednesday, September 16, 2015 1:22 PM
    To: Thomas Brown <tbrown@bam.org>
    Subject: [Tessitura Development Forum] extracting large amounts of data

     

    Is there a way to extract large amounts of data without locking up Tessitura or getting the "Tessitura not Responding" message?  I work in a large arts organization and often need to pull combined data from all of our divisions for large time frames.  There has to be an easier way than running many shorter reports, downloading, and then piecing them together so that I can work with the data.

    Thanks so much!
    Mark




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • Former Member
    Former Member $organization

    Thanks so much Nicholas!  This is all good information. 

     

    Mark Frey  |  Woodruff Arts Center  |   P: 404.733.4277

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Nicholas Walls
    Sent: Wednesday, September 16, 2015 3:44 PM
    To: Mark Frey
    Subject: RE: [Tessitura Development Forum] extracting large amounts of data

     

    Hi Mark,

    I used Power Query at Seattle Opera to do exactly this type of data analysis - it's a huge time saver and an amazing tool. That said, if your organization is a RAMP organization, then you cannot directly connect Excel to Tessitura using Power Query. There are database and privacy issues. I checked with Tess at TLCC and there is no possible way to make the connection. 

    Here at Seattle Symphony, we are a RAMP organization and I have been exploring how you work with data and Power Query when you can't access the live data from Tess. Basically, I have pulled data out using a combination of reports and output set elements (heavily leaning on custom elements) and then used Power Query and Power Pivot tables to turn that data into something I can combine and produce analysis on. Its not as fluid as before but it's still better than anything else I have been able to do.

    Nicholas  

    From: Mark Frey <bounce-markfrey7157@tessituranetwork.com>
    Sent: 9/16/2015 6:20:35 PM

    Thanks Tom!  That sounds amazing!  I’m going to investigate further to see if I can get that here.  I appreciate your offer to talk.  I’ll email you if I have any questions.

     

    Mark Frey  |  Woodruff Arts Center  |   P: 404.733.4277

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Tom Brown
    Sent: Wednesday, September 16, 2015 2:05 PM
    To: Mark Frey
    Subject: RE: [Tessitura Development Forum] extracting large amounts of data

     

    Mark,

     

    We are using a method based on Microsoft Power Query & Power Pivot here at BAM.

     

    I have a spreadsheet in front of me at the moment with all 7.25 million seats we have made available over the last 13 years here at BAM.

     

    In just a few moments, I can pull the 225,000 + contributions in our systems. Just did it… It took about 1 minute start to finish.  I know that the Seattle Opera is doing the same thing.

     

    I’d be glad to talk with you about our approach.

     

    --Tom

    …

    718.724.8135

    tbrown@BAM.org

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Mark Frey
    Sent: Wednesday, September 16, 2015 1:22 PM
    To: Thomas Brown <tbrown@bam.org>
    Subject: [Tessitura Development Forum] extracting large amounts of data

     

    Is there a way to extract large amounts of data without locking up Tessitura or getting the "Tessitura not Responding" message?  I work in a large arts organization and often need to pull combined data from all of our divisions for large time frames.  There has to be an easier way than running many shorter reports, downloading, and then piecing them together so that I can work with the data.

    Thanks so much!
    Mark




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data