Important: when posting, please provide your Club Number at a minimum, and as many details as possible.
For further info, please read This page before posting.

Bulk Changes to Roles in Agendas

  • ebenben
  • ebenben's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 4
  • Thanks: 0

Bulk Changes to Roles in Agendas

11 years 2 weeks ago
#49119
I'm trying to clean up our agendas so I can get more concise information about member roles. To do this, I need to go into past agendas and standardize the way roles are named - because I didn't know about the use of asterisks (for example) to eliminate double counting.

Is there a way to access the underlying database so I can make bulk changes rather than modifying one agenda at a time? The one-line-at-a-time approach is excruciatingly slow.

Or is there a better (and faster) way to do this?

Erin Benbennick
VP-E, HP Herndon Toastmasters
Club #3286765
Erin Benbennick
VP-E, Hunter Mill Club (#7571)
VP-E, StorySmiths (#4645158)
Website Admin, District 29
The topic has been locked.
  • LindaMann
  • LindaMann's Avatar
  • New Member
  • New Member
  • Thanks: 0

Re: Bulk Changes to Roles in Agendas

11 years 2 weeks ago
#49135
Make your changes in the Admin section to the agenda. That way when you add a new agenda, the changes will be there each time...

Linda
The topic has been locked.
  • ebenben
  • ebenben's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 4
  • Thanks: 0

Re: Bulk Changes to Roles in Agendas

11 years 2 weeks ago
#49137
I've incorporated the changes into the template - it's the past data I want to clean up. Here's an example of what I'm trying to fix:

  • Toastmaster (CL 4, 5, 7, 8, 10)
  • Toastmaster Welcome and Introductions
  • Toastmaster Present Award(s)
  • Toastmaster Closes Meeting

  • By adding the asterisks before and after *Toastmaster*, I'll only see one instance of Toastmaster for each meeting. Right now I have as many as four. Yech! However, since the template does not retrofit, I'm looking for a faster way to scrub the data - if one exists.

    Eventually, I'd like to get out of this role and I want to make sure this is an easy handoff to someone who's not a much a data geek as I am myself. ;)

    Erin Benbennick
    VP-E, HP Herndon Toastmasters
    Club #3286765
    hpherndon.toastmastersclubs.org/
    Erin Benbennick
    VP-E, Hunter Mill Club (#7571)
    VP-E, StorySmiths (#4645158)
    Website Admin, District 29
    The topic has been locked.
    • LindaMann
    • LindaMann's Avatar
    • New Member
    • New Member
    • Thanks: 0

    Re: Bulk Changes to Roles in Agendas

    11 years 2 weeks ago
    #49144
    ebenben wrote: I've incorporated the changes into the template - it's the past data I want to clean up. Here's an example of what I'm trying to fix:

  • Toastmaster (CL 4, 5, 7, 8, 10)
  • Toastmaster Welcome and Introductions
  • Toastmaster Present Award(s)
  • Toastmaster Closes Meeting

  • By adding the asterisks before and after *Toastmaster*, I'll only see one instance of Toastmaster for each meeting. Right now I have as many as four. Yech! However, since the template does not retrofit, I'm looking for a faster way to scrub the data - if one exists.

    Eventually, I'd like to get out of this role and I want to make sure this is an easy handoff to someone who's not a much a data geek as I am myself. ;)

    Erin Benbennick
    VP-E, HP Herndon Toastmasters
    Club #3286765
    hpherndon.toastmastersclubs.org/

    The only way to not see so many is to not add so many or to delete the extra... As far as what I am understanding of this right now you can fix it so that no one else can sign up for the duplicate role in the admin section.

    Linda
    The topic has been locked.
    • SteveTheTechie
    • SteveTheTechie's Avatar
    • Offline
    • Emeritus
    • Emeritus
    • Posts: 11492
    • Thanks: 3057

    Re: Bulk Changes to Roles in Agendas

    11 years 2 weeks ago
    #49149
    Erin, please send me a private message about this.
    The topic has been locked.
    Moderators: BrianHeniPamrhtaylor3marc33NotLiableNSBjgavinLcala305peterb323DebbieT
    Time to create page: 0.148 seconds