Course Catalog Mass Update Page

You can mass update data for selected courses. If you select to update an area that stores multiple records per course in a separate table, you can select to add new records or delete records.

Caution

Once you complete a mass update, there is no way to undo your changes unless you back up database tables.

Back up your database tables before running a mass update. You can restore data from the backup if you are not satisfied with the mass update results.

Mass update courses

1. Back up your database.
2. Select Scheduling > Utilities > Setup Mass Updates > Course Catalog Mass Update.
3. On the Prompts panel:
   • In the Area field, select the information to update.
   • To change the value of a field, select the field and then specify the new value.
   • To insert a new record for an area that stores multiple records in a separate table (such as House Team), select Add New and then enter the code in the New Value field.
   • To delete a record for an area that stores multiple records in a separate table (such as House Team), select Delete and then enter the code you delete in the New Value field.  to insert a record or Delete to remove a record. 
4. To identify an additional field and the new value to assign, click the Add button, then repeat Step 3.
5. On the Filter panel, enter criteria to search for the records to update, then click Load to run the search.
6. Review the courses on the Records To Be Updated panel.
   • If a record should not be included in the update, select its

     

      (Delete) checkbox, then click

     

      (Delete) on the panel's title bar.
7. On the Run panel, select Now to run the mass update immediately or Once to schedule the process for a specified Time and Date.
8. Click Run.

After the process runs, use the Tasks/Reports options on the Navigation Bar to retrieve the mass update log.

Fields

Prompts Panel

This panel enables you to identify one or more fields for mass updating.

Field	Description
Actions	Use the following Actions buttons as needed: Add Adds a blank row above the current row. (Delete) Deletes the current row.
Area	Select the table for the field you want to update.
Field Name	Options for this field depend on the area selected. If the Area has multiple fields to update, select the field you want to update. If the Area stores multiple records in a separate table (such as House Team), you can select Add New or Delete.
New Value	Enter the value to use. If you selected a field name, then the value you enter will replace the existing value for the field. If you selected Add New, then the value you enter will be inserted into the table as a new record. If selected Delete, then the record for the value you entered will be deleted. For example, you could change the department for your English courses from English to Language Arts by using the following selections: Area: Course Catalog Field Name: Department New Value: LA - Language Arts Use the Filter panel to search for the courses you want to change. Before running the mass update, verify that the courses on the Records To Be Updated panel are the correct courses.

Filter Panel

Use the Filter panel to select the courses to update. After you enter your criteria, click Load to run the search and display the results on the Records To Be Updated panel.

Records To Be Updated Panel

After using the Filter panel to enter criteria, click Load to run the search and display the results on this panel.

Field	Description
(Delete)	Checkbox for deleting records. To delete a course, select its (Delete)checkbox, then click (Delete) on the right side of the panel's title bar to remove the course.
Building	Identifies a course's building. If a building code and description display, the field identifies a specific Building Course Catalog. If the code and description displays as -1 - District Course, the field identifies the District Course Catalog.
Course	Code identifying a course in the course catalog.
Description	Description of the course.
Department	Department of the course.