...
- From the Majors module summary table, click on the “Export Majors” button to export your current list of college majors to a CSV file. By default, the file will export as a CSV file.
- Locate and open the file from your Downloads folder and Save As with a name that identifies it as the original exported list of majors from your Pilot environment for your college.
- Repeat this process in the Production Administrator.
| Note |
|---|
Locate your CSV file in your Downloads folder and Save As a CSV file with a filename that indicates it is the original major list for your college from a specific environment. |
Editing the Majors CSV File
...
However, these applications may have default date settings that may apply to dates you enter, so you may have to apply the correct date format (i.e. yyyy- mm-/dd/yyyy) to any new dates and/or times. Remember to save the file in CSV format when you are finished editing it.
- Open the downloaded exported majors .csv file on your computer using the application of your choice (Excel or another spreadsheet program is recommended).
- Edit the majors data as needed. It is assumed that your intention is to add new majors and/or edit the majors displayed in order to import them for with new values for your CCCApply application(s). Use the table below as a guide.
| Warning |
|---|
Note: You cannot mix CCCApply and International application majors in one .csv file at this time. |
The table below calls out specific information pertaining to the format of your CSV file.
Majors CSV File Element | Purpose/Format Rule |
|---|---|
Header row (i.e. row 1 that reads left to right: application, code, description, etc.) | The header row is required in order for your .csv file to import correctly and the values to be stored properly by the CCCApply Administrator. |
Application column (application) | The application column value must be in all caps and be either:
You cannot mix APPLY and INTERNATIONAL application majors in one .csv file at this time. |
Award Type (awardType) | The Award Type field values are slightly different in the new Admin 2.0 system. The following notes pertain to implementing this field in the new system:
AA_degree AS_degree AA_T AS_T Certificate Other None
|
Education Goals (eduGoals) |
(NOT APPLICABLE) |
| ||
Date Values (start or end columns) | IMPORTANT NOTE: |
mm |
/dd/yyyy. |
Aligning Your New Categories to Your Majors
...
- Ensure your spreadsheet contains the new column format shown in the image above.
- Each row listed represents a major or program record in your Majors table.
- Review each major listed and determine which category it should display under when selected by a student in the CCCApply application.
- A major can be aligned to more than one category; however, every major must be aligned to at least one category.
- Align one or more categories to each major in the “Category” column on your spreadsheet.
- Repeat this process for all majors listed on your spreadsheet.
| Note |
|---|
IMPORTANT: When aligning multiple categories to a single major, |
...
in the "category" column in your configuration file, separate each correctly spelled and punctuated category names by a comma |
...
WITH NO SPACES IN BETWEEN. For example, if your categories are:
|
...
These four categories should be listed like this in the category column: Mathematics,Science,Art |
...
,Communication & Design (no spaces between each category name). |
The screen shot below shows an example of a typical Majors Export file. Remember to leave the "eduGoals" column empty and the "created" column empty when you import your configured majors file.
Configuring the Major Start & End Dates
...