Upload

For users with the appropriate OEDS access, there will be a Upload option from the CNDC drop down menu of the navigation bar.

This option of Child Nutrition and Direct Certification is provided for both non-public and traditional districts. 

Districts must choose the school year they are uploading data for at the navigation bar. The school year selected must match the school year in the file used for the upload.

Upon initial entry to the screen the user will have to read the information, check the I agree checkbox and then click on the Confirm button.

Open

Once the user has agreed and confirmed an upload form will display.

Open

The upload file needs to be in a CSV (Comma Separated Value) format.  The column names within the file need to match the column names listed below and must not include any spaces or tabs.  The column data can be in any order.  Please see the list below of which columns are optional for creating and updating records.  Also, please see the list of valid date formats to be used for date values within the upload file.

After the file has been uploaded and processed a message will appear below the upload form indicating how many records were created and/or updated from the upload file along with the total number of records within the upload file.  If any errors have occurred during processing a list of those errors will display below the file upload message.  The error message will give the file record line number (line number one is for the heading which can also have errors).  The file errors can be exported to a file so that information can be shared with whomever provided the upload file for error correction.  File records may contain multiple errors.  The upload process will attempt to validate as much of the record as possible before rejecting it for containing errors.  The error message will try to give detailed information as to why the error occurred and may also give a possible solution as how to correct it.  An upload file may be corrected and uploaded multiple times.  Any records that did not change will not be affected.  Any record uploaded that did not change will display in the file errors to let the user know that the data provided within the upload file did not change the existing student data.

Non-Public Districts - Includes all National School Lunch Program participants that do not report their student enrollment data into EMIS

Non-public districts can use this functionality to add student enrollments or to update enrollments previously added.   The non-public should reference the table below to determine what elements are required to be included in the CSV and what are optional.   The Elements with "RA" in column #2 are required for an add, all others are optional.   When updating already added records, districts should reference column #3 below.  The elements with "RU" in this column are required, all others are optional. 

The district must create a comma separated value file (CSV) utilizing the headers of the elements they wish to add or update.

Public Districts and Schools

Traditional districts can only update non-EMIS reporting fields on their enrolled students.  The elements with "RU" in column #2 below are required for matching purposed, all elements that can be updated have "U" in column #2 below.   The elements blank in Column #2, can not be updated from within this option of the Child Nutrition module.   

A traditional district can add or update student enrollments for kids attending a non-public if these students are part of their Federal Child Nutrition reporting requirements.  For these students, the traditional district can utilize all fields as marked in column 3 below.  The elements with "RA" are required for an add.  All other elements are optional.     When updating already added records for these non-public students,  districts should reference column #4 below.  The elements with "RU" in this column are required for matching purposes, all others are optional. 

A traditional district can not add new enrollment records  for students attending a attending/building IRN within their district.    For a traditional district student all adds and modifications to students enrolled in their own buildings need to be managed with the SIS and reported thru the SCR collection request.

A traditional district can not add new enrollment records  for students with an attending IRN not within their district.

In cases where a Public District or School needs to add or update students from a Non-Public  they support for Child Nutrition Benefits, the attending/building IRN must be that of a Non-Public entity. 

There could be special student enrollment situations were an Education Service Center (ESC) operates a K-12 program. The ESC only reports pre-school enrollment through EMIS and will need to conduct an upload of student data for the K-12 students.  If a district has this situation, the attendingirn should be populated with '555555' rather than a DEW assigned IRN.

Cell Formatting

This section describes valid formats for the different cell value types

Date Fields

• mm/dd/yyyy (09/01/1999)

• mm/dd/yy (09/01/99)

• yyyy/mm/dd (1999/09/01)

• yyyy-mm-dd (1999-09-01)

• mm-dd-yyyy (09-01-1999)

Phone Number

• 123456789, no formatting

Upload Examples for Non-Public Districts

• Adding a non-public student to the CNDC data.

• Update multiple elements.  In this example, updating the guardian information.

• Update of a single element. In this example, updating a phone number.

Upload Examples for Public Districts and Schools

• Update of a single element. In this example, updating a phone number.

• Update a single element.  In this example, updating a local ID.

• Update multiple elements.  In this example, updating a local ID and guardian information.

• Adding a non-public student to the CNDC data at a public district.  This could be used if the Public entity sponsors the meals for the Non-public.