- Posts: 4
- Thank you received: 0
Bulk Changes to Roles in Agendas
10 years 3 months ago #49119
by ebenben
Erin Benbennick
VP-E, Hunter Mill Club (#7571)
VP-E, StorySmiths (#4645158)
Website Admin, District 29
Bulk Changes to Roles in Agendas was created by ebenben
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
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
- Visitor
-
10 years 3 months ago #49135
by LindaMann
Replied by LindaMann on topic Bulk Changes to Roles in Agendas
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
Linda
The topic has been locked.
10 years 3 months ago #49137
by ebenben
Erin Benbennick
VP-E, Hunter Mill Club (#7571)
VP-E, StorySmiths (#4645158)
Website Admin, District 29
Replied by ebenben on topic Bulk Changes to Roles in Agendas
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/
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
- Visitor
-
10 years 3 months ago #49144
by LindaMann
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
Replied by LindaMann on topic Bulk Changes to Roles in Agendas
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
- Offline
- Administrator
-
Less
More
- Posts: 11526
- Thank you received: 3050
10 years 3 months ago #49149
by SteveTheTechie
Replied by SteveTheTechie on topic Bulk Changes to Roles in Agendas
Erin, please send me a private message about this.
The topic has been locked.
Time to create page: 0.100 seconds
Copyright © 2025 FreeToastHost 3 Support. All Rights Reserved.