Page Comparison

...

Export Your Current Majors List from the CCCApply Administrator

1. 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.

2. 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. 

...

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.

1. Open the exported majors .csv file on your computer using the application of your choice (Microsoft Excel or another spreadsheet program is recommended).
2. 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.

...

...

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

...

...