Export Couse Grading Information
  1. Click Export.
  2. Click New > Click Course
  3.  Select Comma-Separated Values for Format,  Mark Include Header 
  4. Click Create now.
  5. Choose any preferred filters if appropriate. 
  6. Click Output.
  7. Expand Course and double click the following fields: Course Name*, Course ID, and Import ID.
  8. Expand Grading and double click Import ID.
  9. Enter the preferred number of Grading Years to export.
  10. Click on the Filters tab>  Filter on the preferred Academic Year**  
  11. Click Okay
User-added image User-added image
 
  1.  Expand Grading [already expanded], Expand Grades  and double click Marking Column***. 
  2. Enter the preferred number of marking columns to export*> Click Okay.
User-added image
  1. Double click Translation table from the Grades section.
  2. Preview the Export.
  3. Export Now.
    User-added image

Note: * Course Name  can be included as well to help identify the courses. Course name and Course ID would need to be deleted from the import file prior to import. If the fields remain in the import, they should not be mapped in our import parameter. 

** Please refer to your course records' grading tab to view their setup. If you only have one session, then it would not be necessary to filter on a specific session. For example, If your setup has multiple sessions, then it would be necessary to filter on specific sessions.  In the example below, my school is set up so it only has one session. 

***
This fields refers to how many marking columns our course records have. For example, if we our school only uses Sem1, Sem2, we would only enter 2. Please refer to the course records' grading tab to find the total number of marking columns used based on your school's setup.

 

User-added image


Update the Excel File

 

  1. Open the CSV file.
  2. Update the translation tables fields with the preferred translation table *
  3. Delete the column for Course ID by right clicking on the Column> Delete.
  4. Save the file.
    User-added image

Note: *If the translation table is the same for all records, the drag down method in excel would work to update multiple fields in the Translation table column. If you have multiple translation tables, you can use the Find and Replace function to update the translation tables fields in the excel file. In the example below, Standard Translation [old translation table] is being replaced with the new translation table in the excel file.

User-added image

 

Update Existing Course Records by Importing

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. Carefully read all of the instructions listed below before proceeding. If you are new to importing, also refer to How to import - the basics of importing.

Prior to importing, we suggest marking Validate Now on the General tab.: Validating the data will not import the information in the system. This is a test run of the import.

We recommend marking all available checkboxes on the Options/Summary tab.. At the very least, mark the Create control report option.

  1. In Administration > click Import. 
  2. Click Grading information (located in Courses section) > Click New.
  3. Mark Update existing records.
  4. Browse to the CSV file in the Import file field.
  5. Select Grading Information Import ID as the field to use to match records

User-added image

  1. Select the File Layout tab > Mark the Import File does not contain field names option ONLY if your import file does not have header. If yourImport File contains the field names, mark Fields names are on the first line of the import file. 

* Although headers are not required in The Education Edge, we recommend using them. Otherwise, you must manually map the fields in the data file to the corresponding fields in The Education Edge.
In Excel, use Text as the column type for any field with leading zeroes. Otherwise, Excel drops the leading zeros.

  • User-added image
  1. Select the Fields tab and map the fields 
    • Course Import ID: Mapped to Import ID which is located in the Course Section
    • Grading Import ID: Mapped to Import ID which is located in Grading Information Section
    • Marking Column: Mapped to Marking Column which is located in the Grades Section 
    • Translation Table: Mapped to  Translation Table which is located in the Grades section.
  • Note: Extensions will be used in this import. Each marking column and translation table grouped together for this import in pairs. For example, Q1 (marking Column) and  Standard Translation are grouped together (01 Extension).  Q2 and  Standard Translation are grouped together (02 Extension) and so on until all marking columns/translation tables are paired together. 
  1. Save the import parameters.
  2. Click Validate now (if we marked Validate data only on the general tab) or Import Now

 

User-added image