CCP Export
Overview
This export will create one or more student files and optionally include a staff file. The school selection process is different for the student file(s) and staff file. This task can also be used to export to Cafe Enterprise by Comalex as well as QSP.
Export Options
These files can be exported to a:
- SFTP (Secure FTP) Server
- FTP (Passive or Active) (Not recommended)
- Path on the server
School Selection Options for Student File
By default, all schools are included except schools designated summer schools, pre-reg schools, and inactive schools.
Name | Notes |
Exclude all OOD Schools and schools that don't count students | |
Exclude these individual schools (comma separated list) |
There is also a set of options that allow you to provide four groups of school codes and export paths. If any schools are entered in these fields, the school selection process is overridden and only the schools in those fields will used in the export. Additionally, instead of one student file being created containing multiple schools, individual files will be created for each of the schools entered in these fields.
Student File Options
Name | Notes |
Hide Column Headers | |
Include Column 'Full Name' | |
Include Column Guardian Email (CONTACTS 2 ONLY) | |
Use Alternate School Code | |
Use State ID rather than Local ID | |
Include Apartment column (Apartment will not be in Mailing Line 1) | |
Include column Guardian Email | |
Include Middle Name in the First Name Column | |
Use this Alternate School Code for 7th and 8th graders | When filled, 7th or 8th graders will have the value in this field entered as their school code. |
Include Student Medical Comments (first 50 characters - CCP Limit) | |
If medical comments are blank, fill field in with this value | |
-or- Send Cafeteria Notes in ALLERGY_COMMENTS (first 50 characters - CCP Limit) | Additional option: Do not send 'No Note' when students note field is blank |
-or- Include Medical Icon Text in ALLERGY_COMMENTS (first 50 characters - CCP Limit) | |
Exclude students with this User Flag | |
Remove 50 Character Limit for Student Medical Comments AND Cafeteria Notes | |
Include column 'Ethnicity' | |
Exclude Inactive Students: (vendor will no longer know when student goes Inactive) | |
Include Family Codes |
Staff File Options
*Staff marked as "Shared" will be skipped.
Name | Notes |
Include Staff File | |
Export to Path. Must include file name. (can leave blank) | |
Exclude Inactive Staff | |
Include these schools in staff file | Contains a list of schools in the district. |
Only include primary school assignment | (only affects members assigned to more than one school) |
Replace any 'S' characters in StaffID field with '999' | |
Prepend '99' to StaffID | |
User 'Other ID' in place of teacher/staff id |
Student File Format
The file format is a CSV delimited file.
The first row of the file optionally contains headers.
This export will automatically export data from Contacts or Contacts2 depending on which system your district is using.
Column | Notes |
STUDENT_ID | |
LUNCH_PIN | |
LAST_NAME | |
FIRST_NAME | |
CURRENT_SCHOOL_CODE | |
GRADE_LEVEL | |
HOMEROOM | |
HOMEROOM_TEACHER | |
ADDRESS_MAILING_LINE_1 | |
ADDRESS_CITY | |
ADDRESS_STATE | |
ADDRESS_ZIPCODE | |
CONTACT_NUMBER | |
DATE_OF_BIRTH | |
LUNCH_CODE | |
FULL_NAME | Optional |
GUARDIAN_EMAIL | Optional |
ALLERGY_COMMENTS | Optional |
ENROLLMENT_STATUS |
Staff File Format
The file format is a CSV delimited file.
The first row of the file contains headers.
Column | Notes |
STAFF_ID | |
LAST_NAME | |
FIRST_NAME | |
SCHOOL | |
GRADE_LEVEL | Value is always 99 |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article