Top Ten from multiple teamraisers

Matt Tinker · July 2011

Is there a way to pull the a Top Ten type listing of fundraisers from multiple teamraisers and have it display on your page. Our events will be sectioned out by Divsion and it would be great to show the top fundraisers as a whole.

Thanks!

Brian Mucha · July 2011

I think your only option is to do this with the API.

Regards, Brian

Matt Tinker · July 2011

Brian Mucha:
I think your only option is to do this with the API.

Regards, Brian

I was thinking that was probably the case. Thanks Brian!

Noel Beebe · July 2011

Hi Matt and Brian,

This is coming in the summer release... http://community.customer.convio.com/docs/DOC-3281. Be sure to check it out!

Thanks,

Noel

Matt Tinker · July 2011

Noel Beebe:
Hi Matt and Brian,

This is coming in the summer release... http://community.customer.convio.com/docs/DOC-3281. Be sure to check it out!

Thanks,

Noel

Good to hear, thank you Noel.

Brian Mucha · July 2011

Matt Tinker:
Good to hear, thank you Noel.

You can use the S42 tag to get the top XX participants in a teamraiser. In the interrim, perhaps you could do something like...

<h1>Top Participants</h1>

<h3>TeamRaiser One</h3>

]

<h3>TeamRaiser Two</h3>

]

<h3>TeamRaiser Three</h3>

]

So, its really the top 4 in each TR, not the top 10 across all TRs.

Regards, B

Francis Lim · February 2016

Hi there,

I'm hoping to revive this discussion and find a way to display Top Ten Participants or Teams from multiple teamraisers like a multy-city walk events created using Blueprint and multiple child TeamRaisers.

Noel in an earlier message mentioned that the feature was added back in 2011 but link to the document is broken and I haven't been able to find the information anywhere. Is there an S-Tag for Top Ten from multiple teamraisers like events of the same Type or Affiliated Events?

Can someone please share updated link or share method you can use to list Top Ten from multiple teamraisers?

Thanks,

Francis

Unknown · February 2016

Hi Francis,

We had HJC create this for us in 2014 for our Parkinson SuperWalk event (setup with a blueprint event and many child events). Not sure if you still have the code for this on your end or not? If not, let me know and I can send something to you.

Cheers,

Meghan

Francis Lim · February 2016

Meghan Christiansen:

Hi Francis,

We had HJC create this for us in 2014 for our Parkinson SuperWalk event (setup with a blueprint event and many child events). Not sure if you still have the code for this on your end or not? If not, let me know and I can send something to you.

Cheers,

Meghan

Hi Meghan,

Yes, I do have the code. The solution we came up with was very hacky and relying on S36:top_participants_list to list every single location (hidden) and then using custom JavaScript plugin to sort through the html strings to recompile the new list. We have also tried TeamRaiser API, but it's very resource demanding and not ideal for events with over 10 locations.

I was hoping someone, especially Blackbaud team might have more informaiton on the broken document link "http://community.customer.convio.com/docs/DOC-3281" that supposed to have solution for this. Perhaps there's an S-Tag that we are not aware of that could display the Top Ten from multiple teamraisers such as Blueprint events. These are very common lists and almost every organization has done some Blueprint events. It's been years since we've started using S-Tag, I thought I might have missed some update that added this feature. Or perhaps there's a better way of doing things.

Thanks,

Francis

Shiloh Fallon · January 2017

Hi, Francis,

We do not currently have an S tag that does this, because it would be too demanding on the database, similar to the issue with using the API to do this. What some clients have done is create this list from reporting and update the page manually or by using an s tag to pull the csv file from the FTP server. That may have been the solution that was referred to in the older community article. This solution is employed here: http://fightcf.cff.org/site/PageServer?pagename=gs_homepage

Shiloh Daniel

Customer Success Engineer

Francis Lim · January 2017

Shiloh Daniel:

Hi, Francis,

We do not currently have an S tag that does this, because it would be too demanding on the database, similar to the issue with using the API to do this. What some clients have done is create this list from reporting and update the page manually or by using an s tag to pull the csv file from the FTP server. That may have been the solution that was referred to in the older community article. This solution is employed here: http://fightcf.cff.org/site/PageServer?pagename=gs_homepage

Shiloh Daniel

Customer Success Engineer

Hi Shiloh,

The top lists for multi-teamraiser BluePrint events are common requirements for many clients we have helped. We have been using API and other method to generate the lists. The manual method you suggested is often not acceptable to clients because it requires resources to manage the updates, and it's not dynamic. I hope this feature is added to S-Tag in the near future.

If anyone reading this post interested in the same feature, please go to Idea portal to vote on the idea:

https://luminateonline.ideas.aha.io/ideas/LUM-I-972

Thanks,

Francis

Francis Lim · February 2017

Shiloh Daniel:

Hi, Francis,

We do not currently have an S tag that does this, because it would be too demanding on the database, similar to the issue with using the API to do this. What some clients have done is create this list from reporting and update the page manually or by using an s tag to pull the csv file from the FTP server. That may have been the solution that was referred to in the older community article. This solution is employed here: http://fightcf.cff.org/site/PageServer?pagename=gs_homepage

Shiloh Daniel

Customer Success Engineer

Hi Shiloh,

I'm exploring your suggestion for using custom report CSV and s-tag. Sounds like a great idea. I created custom report but I don't understand how to make it available in the FTP server, I can't find any old post about that. I was hoping you could elaborate a bit more on that.

Can you point me to the post or share the help information on creating FTP custom report?

What is the s-tag to use to access the report CSV file in FTP?

Luminate experts: please chime in if you have any knowledge about this.

Much appreciated,

Francis

Romany Nassief · March 2017

I think the only way to have this result without any manual process is using API which will send multiple ajax call based on number of events you have.I have another solution by using YQL (Yahoo Query Language) that executes all requests once, sort the result and return the top participants you are looking for.

The example below showing how we used API to get top 5 participants across 15 events.

$.getJSON('https://query.yahooapis.com/v1/public/yql', {

    q: 'select participant from json where url in ( ' +

            'select url from uritemplate where ' +

            'template="https://secure2.convio.net/afirst/site/CRTeamraiserAPI?method=getParticipants&fr_id={fr_id}&last_name=%%%&list_page_size=5&list_ascending=false&list_sort_column=total&list_filter_column=private_page&list_filter_text=0&api_key=afrist&response_format=json&suppress_response_codes=true&v=1.0"' +

            'and fr_id in ("1202", "1210", "1211", "1212", "1213", "1214", "1215", "1216", "1217", "1218", "1219", "1220", "1221", "1222", "1223")' +

            ') | sort(field="participant.amountRaised") | reverse() | truncate(count=5)',

    format: 'json'

}).done(function (data) {

    // Your callback to render participants goes here ...

    alert(JSON.stringify(data.query.results));

});

Romany Nassief · March 2017

Another example by getting all blueprint child events instead of providing many fr_id values:

$.getJSON('https://query.yahooapis.com/v1/public/yql', {

    q: 'select participant from json where url in ( ' +

            'select url from uritemplate where ' +

            'template="https://secure2.convio.net/afirst/site/CRTeamraiserAPI?method=getParticipants&fr_id={fr_id}&last_name=%%%&list_page_size=5&list_ascending=false&list_sort_column=total&list_filter_column=private_page&list_filter_text=0&api_key=afrist&response_format=json&suppress_response_codes=true&v=1.0"' +

            'and fr_id in (' +

'select teamraiser.id from json where url="https://secure2.convio.net/afirst/site/CRTeamraiserAPI?method=getTeamraisersByInfo'+
'&event_type=stroll_roll&list_category_id=1061&list_page_size=500&name=%25%25%25&api_key=afrist&response_format=json&suppress_response_codes=true&v=1.0")' +

            ') | sort(field="participant.amountRaised") | reverse() | truncate(count=5)',

    format: 'json'

}).done(function (data) {

    // Your callback to render participants goes here ...

    alert(JSON.stringify(data.query.results));

});

Top Ten from multiple teamraisers

Comments

Categories