The Files tab allows you to create and download the CCGI extract files or configure a scheduled process.


Click on the Configure Scheduled Process button to set up a scheduled process to created the CCGI extract files on a regular basis. 



Check the UseFTP option and enter the required SFTP information to have the CCGI extract files automatically sent to CCGI via SFTP using these credentials based on the schedule set up.


The Scheduled Process may also be saved without checking the UseFTP option.  In this case, the CCGI files will generate on the schedule defined and are available in the download section of the Files tab.  These files may then be downloaded and sent to CCGI manually.



Options: 

  • UseFTP - Check this option and enter required fields to have files automatically sent via SFTP on the scheduled times. Please contact CCGI for any questions on how to access or upload the files to their site.
    • sFTP Server - the address to the CCGI sFTP server
    • sFTP Port - usually 22
    • Username - the username required by CCGI
    • Password - the password required by CCGI
  • UNC Filepath - Enter a path only if you would like to specify a different location other than the default to store these files, Otherwise, leave this field as is and you may download where the files from the File Download section on the page. Consult with your district technology support to complete this path if desired.
  • Days to Run Process - Select the days of the week the scheduled process should run.
  • Status- The button will toggle the process ON and OFF. Click the green Enable Scheduled Process button to enable the scheduled process to run. Once enabled, the button will change to red, with the label Disable Scheduled Process.
  • Time - Select the time of day the scheduled process should run.
  • Email Address - Enter at least one email address to be notified when the scheduled process is completed. Multiple email addresses should be separated by a comma.

The Last Processed field will display the last date and time a scheduled extract was created.


Be sure to click the blue Save button to lock in your selections.
Alternatively, click the Save & Send Now button to save the scheduled process settings and create the files now.
These files will be available in the downloads section on the Files tab and will automatically be sent to CCGI via SFTP immediately and then continue to create the files and send to CCGI via SFTP on the saved scheduled.


Click on the Create Export Files button to create the new CCGI extract files on demand. NOTE: The Create Export Files button is not available during the Recompute GPA/Class Ranks process. Please see the CCGI - Basic Info document for more information. 


CCGI Extract - Create Export Files button



While the system is creating the files a Processing message will display


CCGI Extract - Create Export Files Processing message



If you or another user attempt to run the Create Export Files before it finishes processing, then a pop-up message will appear indicating that the process is still in progress and to try again later.




Once completed, the new files will display in the File Download list. 

CCGI Extract - File Download list



Each time the Create Export Files process is run four to five CCGI extract files are created: 

  • ManifestTemplate - a listing of the files included in the extract
  • CourseGradeTemplate - transcript records and current classes (work in progress)
  • TestTemplate - college entrance test records (will only be created if there are college entrance tests to report)
  • StudentTemplate - student demographic information. The PrimaryCDSCode column is populated with the students' Primary Enrollment School's CDS code. When students are primarily enrolled in one school and their Reporting School (ENR.HS) is for a different school, then the Reporting School's CDS code will be extracted.
  • CourseCatalog - course data information. Only the courses offered at the school (based on all Course Attendance (CAR) that occurred during the year) will be added to the Course Catalog for that school.



NOTE:  If there are no students that have Parental Consent on the Verify Students to Extract tab, then check the Parental Opt-out settings on the Basic Info tab to make sure it is set up correctly.  See the CCGI - Supporting Pages and Tables document for more information regarding the Demographics, Supplemental and Authorizations tables.
The result of no students having Parental Consent is that the TestGrade Template and CourseGrade Template files will not be created during the extract process.


The High School Graduate file is not part of the CCGI Create Export Files process. Please see CCGI High School Graduate File for more information. 


Click on the Download button next to each of the export files to download the files. Depending on browser settings the file may open up as an Excel file when it is clicked. Take care not to save the file in Excel as this may reformat some of the fields, just close the file and navigate to the Downloads folder on your local computer to retrieve the csv files.


CCGI Extract - Download buttons



The downloaded files can then be imported as they are into CCGI's secure FTP site. There is no need to copy and paste the data into a new template file, the files can be used in their original state. Also, the files are named using CCGI's naming convention: DistrictName_FileTypeTemplate_YYYYMMDD.csv (for example, EagleUnifiedSchoolDistrict_StudentTemplate_20200226). Please do not rename the file before uploading it to CCGI.



Please contact CCGI for any questions on how to access or upload the files to their site.