Logo
Submit a request
  1. College Kickstart
  2. Troubleshooting
  3. Uploading Data

    Exporting Reports from CIALFO, MAIA LEARNING, NAVIANCE, or SCOIR for use in College Kickstart

    Currently, College Kickstart supports uploading historical admissions data from the following sources of records:

    • Cialfo
    • Maia Learning
    • Naviance
    • SCOIR

    Note that some changes may be necessary to your file after exporting outcomes from your source of record. Please refer to this section of this article for additional tips for your file.

    NOTE: The structure of CSV files exported from our supported vendors may change over time. College Kickstart makes a best effort to support the latest version of each file. If your vendor modified their export process recently, please contact your Relationship Manager and support@collegekickstart.com. Include the CSV file, a description, and screenshots for steps to navigate to the report. If you are unable to upload your file, email us and include the CSV file, any changes you made to the file, and screenshots of the error to help our team diagnose the issue efficiently.

     

     

    Exporting Application Outcomes By Source of Record

     

    Cialfo

    Navigate to the report by going to the navigation bar on the left and find More and Insights. Under Insights, look for Applications, and click the Applications option. 

     

    To filter by classes you want to include in the report, click on the "Graduation Year" dropdown and select the classes you would like to export.

     

    Scroll down until you find a table called Applications Master List. To export the report, click on the icon with 3 horizontal dots and choose the CSV option. 

     

    The report will contain the following columns:

    • Graduation Year
    • Student Name
    • Student Email
    • College Name
    • Enrollment
    • Result
    • Student Decision
    • Round
    • Unweighted GPA (4.0) 
    • Weighted GPA (5.0)
    • High SAT 1600
    • High ACT
    • Student Cialfo ID
    • Flags

     

     

    Maia Learning

    Navigate to the report by going to the navigation bar on the left and find Reports.

     

    Next, open the College Apps tab. Set the first dropdown to Application Statistics and verify Application by College is selected in the second dropdown. Then, use the Class of... dropdown to choose the range of classes you want to include in the report.

     

    Run the report and click on the CSV icon to export the report.

     

    The report will contain the following columns:

    • University
    • Student ID
    • Class
    • GPA
    • AP / Honors
    • High SAT CR
    • High SAT M
    • High SAT WR
    • High SAT 1600
    • High SAT 2400
    • High ACT
    • Type
    • Result
    • Attend
    • Flags

     

     

    Naviance

    Navigate to the report by going to the navigation bar at the top and find Analytics and select Reports.

     

    Scroll down to find College and eDocs and choose the Applications by Student report. 

     

    Find the Class Year filter on the left side and select the classes you would like to include in your report.

     

    After the report finishes loading, click on Manage columns. Here, you can add/exclude columns for your report.

     

    While you can choose what columns to export, we recommend including the following columns:

    • Student Name
    • College Name
    • Student Class Year
    • Student Email
    • Student GPA
    • Student GPA Weighted
    • Student Highest SAT
    • Student Highest ACT
    • Application Type Name
    • Application Result Name
    • Application Flag Name
    • Application Attending Status
    • Application Waitlisted Status
    • Application Deferred Status

     

     

    SCOIR

    Navigate to the report by going to the navigation bar on the left and find the icon with 3 horizontal dots, or Show more options. Click the icon to open the submenu and click Reports.

     

    Find the Applications & Outcomes report.

     

    To choose a class range, find Filters on the left hand and select the class range you would like to include in your reports.

    After selecting your class range, click Download CSV to download the report

     

    The report will contain the following columns:

    • Student_ID_HS
    • Student First Name
    • Student Middle Name
    • Student Last Name
    • Class Year
    • College Name
    • Unweighted GPA and/or Weighted GPA
    • SAT
    • ACT
    • Application Type
    • Deferred
    • Waitlisted
    • Application Outcome
    • Enrolling
    • Test Optional
    • Hooks

     

     

     

    Changes after exporting your file

     

    Some changes may be necessary to your file after exporting from your source of record. 

    If your school is currently configured to use Rigor or Rank in College Kickstart, and your application outcomes report does not include rigor or rank data, you may have to manually add the data to your file. Review the Rigor and Rank section for instructions on how to add Rigor or Rank to your outcomes.

    If you make any changes in your CSV file, make sure to save the file as a CSV (UTF-8), following this article: How do I export a file as a CSV in UTF-8?

     

    Adding Rigor or Rank to Your CSV

    NOTE: If you are interested in using Rigor or Rank, but your high school is not configured to use Rigor or Rank, please reach out to your Relationship Manager to discuss and answer any questions.

    Rigor is only available for high schools.  

    If your high school is currently configured to use Rigor or Rank in the student academic profile and Local Context, or in reports, you may have to update your CSV file to include an additional column. 

     

    Adding Rigor

    After exporting your CSV file, open the file in your preferred application. Follow the steps below depending on the type of Rigor your school is configured to use. If you are uncertain which type you are using, please contact your Relationship Manager.

     

    Advanced Course Count

    Some files may already have an "AP/Honors" column by default. If your advanced course counts are already recorded in this column, and it fulfills the requirements listed below, then no changes are needed in your file. Otherwise, you may need to add an additional column. 

    Find the first empty column that has no header and no values. Please do not leave add empty columns between columns with headers and data. 

    NOTE: In the example above, even though the "Flags" column for example looks empty, it is not a completely empty column. There may be values further down the file, or there may be no values at all. Since the column is still titled with a header, it is not an empty column and can be left in the file.

     

    This is where you will add your Rigor column. Requirements for the Advanced Course Count column:

    • Column header may be labeled as "AP/Honors" or "Rigor". Please only include one column in your CSV file. If your file did not have an "AP/Honors" column by default, we recommend using "Rigor".

    • Rigor values can range from 0 to the maximum number of advanced courses students can take by the end of their senior year. The maximum number is based on your school's configuration. 

    • We do not support decimal Rigor values. Rows with decimal values will be accepted, but they will be rounded to the nearest whole number during the upload. 

    • Any row that has a blank or non numeric Rigor value in will be excluded during the upload. 

    • The Rigor column must be at least 80% complete. If the column is not sufficiently filled, the upload will reject your file and request to complete the column before reuploading.

    After adding the new column, make sure to save your file and read through our tips for saving below before uploading your file.

     

    Rigor Index 1-5

    Find the first empty column that has no header and no values. Please do not leave any empty columns between columns with headers and data. 

    NOTE: In the example above, even though the "Flags" column for example looks empty, it is not an empty column. There may be values further down the file, or there may be no values at all. However, since the column is still titled with a header, it is not an empty column. Please do not delete columns even if they only have a header and no data. 

     

    This is where you will add your Rigor column. Requirements for the Rigor Index 1-5 column:

    • Column header must be labeled as "Rigor". Columns named "AP/Honors" will not be accepted for this type of Rigor.

    • Rigor values can range from 1-5: 1 being the least rigorous course load, and 5 being the most rigorous course load.  Unfortunately this scale cannot be flipped.

    • Each row must have a positive integer value between 1-5 in the Rigor column.

    • We do not support decimal Rigor values. Rows with decimal values will be accepted, but they will be rounded to the nearest whole number during the upload. 

    • Any row that has a 0, blank, or non numeric Rigor value will be excluded during the upload.

    • The Rigor column must be at least 80% complete. If the column is not sufficiently filled, the upload will reject your file and request to complete the column before reuploading.

    After adding the new column, make sure to save your file and read through our tips for saving below before uploading your file.

     

    Adding Rank

    After exporting your CSV file, open the file in your preferred application, and find the first empty column that has no header and no values. Please do not leave any empty columns between columns with headers and data. 

    NOTE: In the example above, even though the "Flags" column for example looks empty, it is not an empty column. There may be values further down the file, or there may be no values at all. However, since the column is still titled with a header, it is not an empty column. Please do not delete columns even if they only have a header and no data. 

     

    This is where you will add your Rank column. Requirements for the Rank column:

    • Column header must be labeled as "Rank".
    • Rank values can range from 1-100: 1 being the top percentile of the class, and 100 being the bottom percentile of the class. Unfortunately this scale cannot be flipped.
    • Each row must have a positive integer value in the Rank column.
    • Rows with decimal values will be accepted, but they will be rounded to the nearest whole number during the upload.
    • Any row that has a 0, blank, or non numeric value in Rank will be excluded during the upload. 

     

    After Adding Rigor or Rank

    After finishing your changes, please ensure the following points to avoid issues during upload:

    • You only added no more than one column for Rank or Rigor.
    • There are no columns with data and without headers.
    • There are no completely empty columns (columns with no header nor values) in between columns with headers and data.

    Please make sure to save the file as a CSV (UTF-8) before uploading outcomes for Reports or Local Context. Instructions on how to export a CSV file can be found here: How do I export a file as a CSV in UTF-8?

    If you have any issues while uploading your file or have any questions, please contact your Relationship Manager and Support. Please include your updated CSV, the original CSV that was exported from your vendor (if possible), a description of the changes you made, and any screenshots of errors during the upload. This will help our team identify issues efficiently and assist you quickly. 

     

    Was this article helpful?
    0 out of 1 found this helpful