...
Export Your Current Majors List from the CCCApply Administrator
From the Majors module summary Admin 2.0 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.
...
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. |
Align Your Categories to Your Majors
Editing the Export Majors CSV File
The Admin 2.0 Export Majors function produces a .csv file and the Admin 2.0 Import Majors function requires a .csv file in exactly the same format.
It is important that you maintain the Admin 2.0 format that is exported. Unless you have experience with text editors and CSV files, the best way to edit your .csv file may be with a spreadsheet application such as Microsoft Excel or OpenOffice Calc. However(NOTE: The CCCApply Support team recommends using Microsoft Excel for configuring your Export/Import files throughout Admin 2.0).
However, these applications may have default date settings in place that may apply to dates you enter, so you may have to apply the correct date format (i.e. will need to be reset when configuring your file for Import, so please be prepared to reformat your dates across Admin 2.0 in the mm/dd/yyyy ) to any new dates and/or times. Remember to save the file format. Remember to save your file in CSV format when you are finished editing it.
- Open the exported majors .csv file on your computer using the application of your choice (Microsoft 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 with new values for your CCCApply application(s). Use the table below as a guide.
...
Majors CSV File Element | Purpose/Format Rule | ||
---|---|---|---|
Header row (i.e. row 1 that reads left to right: application, code, description, etc.) | IMPORTANT: 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 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: The award type values must not contain any spaces and MUST be one of the following allowed values:
The Award Type field is required in the new system. All imported majors, and majors migrated from the legacy Admin 1.0 system, must include a value in this field. If you do not have an aligned award type for one or more majors, please enter “None”. When importing majors using the CSV file, please include a value in the awardType column on your import file. If you do not have an aligned award type for one or more majors, please enter “None” | ||
Education Goals (eduGoals) (NOT APPLICABLE in this version) |
| ||
Date Values (start or end columns) | IMPORTANT NOTE: |
...
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
IMPORTANT NOTE: Date formats for the Majors .csv file must be in the following format: mm/dd/yyyy.
...
- The “Start” date is required.
- The Start Date data in this column identifies the date when the Major starts appearing in the "Intended Major or Program of Study" menu in CCCApply applications.
- The Start Date must be configured in the following format: mm/dd/yyyy
- Cannot be after the major’s End Date or the associated Term's Term End date, else error message will display;
- Must be a valid calendar date (cannot be February 30, etc.)
...
- The “End” column identifies the major’s End Date which is the date that the major stops appearing in the "Intended Major or Program of Study" menu in CCCApply applications;
- The End Date is required, else error message.
- The major must be setup with one of the following settings:
- Major has no end date, OR
- Major has end date
- The End Date must be configured in the following format: mm/dd/yyyy
- Can be added individually by clicking on "Add Major" or "Edit Major" by an authorized user
- Must be a valid calendar date, i.e., cannot be February 30, etc. (else error message appears)
- Cannot be before the Major Start Date, else error message else error message will display
- Can be added by the Import Majors process via a properly formatted .csv file with all required Majors data fields
- If user selects "Major has no end date" THEN the Major will ALWAYS display in the "Intended Major or Program of Study" menu in CCCApply
- If user selects, "Major has end date" - THEN a valid end date must be provided in the CSV file , else error message should display
...
CSV Column Heading | Required | Important Configuration Notes | Application||||||
---|---|---|---|---|---|---|---|---|
HEADER ROW | YES | The Application column identifies the CCCApply applicationIMPORTANT: 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 | YES | YES
| Major Code |
| ||||
Major Code | YES |
| ||||||
Major Description | YES |
| ||||||
Category | NO |
| ||||||
TOP Code | NO |
| ||||||
Program Control Number | NO |
| ||||||
Award Type | NOType (AwardType) | YES | The Award Type (AwardType) field values are slightly different in the new Admin 2.0 system. The following notes pertain to implementing this field in the new system:
| |||||
CIP Code | NO | NO
| EduGoal (NOT APPLICABLE in this version) |
| ||||
EduGoal (NOT APPLICABLE in this version) | NO | NOT USED IN THIS VERSION. The EduGoal field pertains to the Education Goal Alignment Filter implementation which is out of scope for this release.
| ||||||
Start Date | YES | |||||||
End Date | YES | |||||||
Create Date | NO |
|
...