Mass Edit & Update Game Information in Bulk

Editing your game data in bulk can be done in one of two ways:
  1. Apply the same change to multiple games at once
  2. Import an updated spreadsheet file

Mass-Edit Menu Option

This menu option will allow you to apply the same change to multiple games at once.

To use this, you'll first need to select the checkboxes for the games you want to apply the change for

You may then use the Mass-Edit option under the Automation menu to select the desired change that you'd like to make.





Import an Updated Spreadsheet
You can perform a spreadsheet import operation with an updated schedule import in order to update existing games with new information in bulk.  This is good to use if you're going to be making numerous changes on a lot of games.

Here's the steps you'll need for the updated import:
  1. Find the games you want to edit using the Schedule Filters and select Search
  2. Once displayed, Export the Game Schedule using the "Export Game Schedule" option at the top of the Master Schedule.
  3. Update the exported CSV spreadsheet provided to contain the new values.  Do not remove columns and only change items that need to be changed.
  4. Perform an updated import from Master Schedule >> Add Games >> Import from Spreadsheet. Make sure to choose the "UPDATE EXISTING GAMES" option on the import page.

Important Note:  Performing an import with an updated schedule will cause all the games to revert to an unpublished status and any existing assignments created will revert to unaccepted.  You will need to publish these games again and your officials will need to accept their assignments again after performing a mass update.

Help for Schedulers

  1. User Permissions Explained
  2. Importing Games via Spreadsheet
  3. How do I increase the number of maximum licenses?
  4. Why isn't an official showing as available?
  5. Mass Edit & Update Game Information in Bulk
  6. Cancel Games in Bulk
  7. How do I add/confirm an official AFTER a game has been completed?
  8. When are officials no longer available for more assignments on the same day?
  9. How do I add officials to my system if they don't use the internet?
  10. How can I edit my System Settings?
  11. If the user doesn't their receive initial welcome email, is there a way to resend?
  12. How to reschedule a cancelled game
  13. Is it possible to have 2+ individuals set up with administrator permissions?
  14. What are Teams?
  15. What are Locations?
  16. What are Leagues?
  17. What are Game Codes?
  18. What are Official Positions?
  19. Diagram of leagues, game codes and positions...
  20. Is there a way as a scheduler that I can mark a game as "accepted" for an official?
  21. How do I remove an official from my organization?
  22. How do I see who is available when assigning games?
  23. How do I turn on mileage calculation to be shown when assigning games?
  24. How do I change the default game start time?
  25. Is there any way to restrict what games an official can be assigned to based on the official's age?
  26. If an organization has more than one assignor who receives the Declines or Turnback notificiations?
  27. Can I force officials to accept games within a few days?
  28. How I can add our organization logo?
  29. Where do I go to make the renewal payment for my organization?
  30. Is it possible to export to excel a list of mileage for each official by location?
  31. Is there a way I can identify that two officials can't be assigned to work on the same game together?
  32. Where do I get an invoice and be able to print it out as well?
  33. How can a supervisor view all assignments?
  34. Can you export an invoice into an excel spreadsheet?
  35. How do I change the "current season" ?
  36. Is there a way to tell me how far a location is from an officials home?
  37. Who is able to send "Message from the Administrator"?
  38. Is there a way to run a report of number of turnbacks?
  39. Why do I see "no positions created yet"?
  40. How can I rank officials according to seniority?
  41. Can I reset the game counters?
  42. How can I add someone into my organization who already has an account from another organization?
  43. Can assigner accept games for the official?
  44. Can I access usernames and passwords for our member officials?
  45. "No positions created yet"
  46. How do I uncancel a game?
  47. Can a user be both an official and a coach?
  48. How do I input incidental expenses, travel and meal allowance?
  49. Erase / Remove users from your system.
  50. How long will my game info be retained in the system?
  51. Who receives Game Day email notifications?
  52. How do I change the default schedule filter?
  53. What email reminders are sent and when?
  54. What does the activation reminder email look like?
  55. How do I add users?
  56. What is the TBA System?
  57. 2018 Dwolla Pricing Changes
  58. Importing Assignments
  59. How do I make a cancelled game billable (or payable)?
  60. Saving an Excel spreadsheet (.xls or .xlsx) as a CSV file
  61. Restricting Game Levels to members of Contact Groups
  62. How to setup experience-based pay structures
  63. Can officials just self assign themselves and choose their own games?
  64. Extended Archiving Add-On
  65. How do I purchase a HorizonWebRef.com subscription?
  66. How to cancel individual games
  67. How to handle rain outs
  68. Email is undeliverable for registration
  69. How do I add another administrator?
  70. Evaluation & Ratings Systems
  71. How does Auto-Assign work?
  72. Available Add-On Services
  73. Getting Started with Sports Engine Integration
  74. Setting Up Sports Engine Integration
  75. Are cancelled games deleted from the system?

Feedback and Knowledge Base