Change Team Names via upload

Matt E

Hi,



A large amount of our Teams have undergone slight variations of their name in recent years (Previously, our org did not have persistent team functionality enabled), which causes problems with historical reporting.



I need to change the team's names in previous years to match this years identically, but there is a lot of them.



Is it possible to do this via upload?



Thanks in advance,

Brian Mucha

I don't think so, but I've done similar repetitive editing.



One thing you can do is pull a report of all your teamraiser teams, so you know each FR_ID and TEAM_ID.



It's then pretty easy to make an Excel spreadsheet with hyperlinks to manage each team page. The format of the link to edit the team name is:



https://secure3.convio.net/abc/admin/TRManage?tr.manage=fr_edit_team&team_id=12345&fr_id=1234



(The red items should be customized for your org, and the blue for each team.) So you could just click each link and go directly to the admin page to update the team name.



Now it would be really cool to pass the new team name somehow. Unfortunately there are no URL Setters for the admin UI. But you could create a GreaseMonkey (https://addons.mozilla.org/en-US/firefox/addon/greasemonkey/) script to do this, if you know some javascript or JQuery.



https://secure3.convio.net/abc/admin/TRManage?tr.manage=fr_edit_team&team_id=12345&fr_id=1234&newteam=New%20Name



So you'd click the link, the Greasemonkey script would see the newteam param and set the team_namename field. All you do is click 'Save'. (And repeat XX times.)



EDIT: I attached an old GreaseMonkey script I created to reset donation form autoresponders back to the default content. Might be useful as a starting point.

Mark Kindy

Sadly, it looks like doing that via a bulk upload isn't possible -- just tried it myself in a test, keeping the TEAM_ID the same but changing the TEAM_NAME field in the upload, but it ignored the content of the TEAM_NAME field instead of overwriting.

If it's not absolutely needed to go in and manually update the names of the teams in the TeamRaisers, I'd probably just pull all the reports I needed as CSV and use a text editor like Notepad++ or Sublime Text, or just use Excel, and do a replace on the team names and stow the reports someplace safe.

Depending on how many you have, though, Brian Mucha's suggestion for using a script could be faster.