Note : Before you proceed with the following instructions, back up the database. If your organization integrates multiple Blackbaud products, refer to the Additional Requirements section of the backup article.

 NOTE: If you need to Update multiple Academic Years with the GPA calculation, you will need to use Export to extract the following fields:

  • Course Import ID
  • Course ID
  • Course Name
  • Expand Course, Grading Information and select Import ID.
  • Also under Grading Information, expand GPA Weights and select GPA and Weight
     
  1. Create an import file
     
    1. Select Administration, click Import record
    2. Select Course and click New import
    3. On the General tab, select the Export records options
    4. Select the Include required fields in the file option
    5. In the Import file field, enter a file name and location for the file to be created
    6. Use Course Import ID as the record identifier, click Next
    7. Click Next to accept the defaults
    8. On the Fields tab, select the fields to include in the export:
       
      • Course Import ID
      • Course ID
      • Course Name
      • Expand Grading Information and select Import ID
      • Also under Grading Information, expand GPA Weights and select GPA and Weight
         
    9. Click Save and enter an appropriate name, click Save. Use this same name for the actual import to ensure that all fields are imported properly.
    10. Click Create Now to begin the export process
  2. Update the import file:
    1. Open the exported file
    2. Replace the GPA entries on the import file with the desired type and weight 
    3. Save and close the import file
       
  3. Import the file
    1. Select Administration, click Import record
    2. Open the saved import parameters from step 1
    3. On the General tab, select the Update existing records options
    4. Import the file