Direct Certification - Import

Downloading the Direct Cert File

The DOE matches your students based on the SSA (studentSchoolAssociation) records submitted via the DataExchange.  

Here are the instructions for downloading the file to import

Open

Importing the Direct Cert file in Harmony

Go to Office Use…Direct Certification.   Touch Import Direct Cert

Open

Select date.  It will be a different date each time you import the file.  Choose the file location to import.  Touch Import.  

• Column F should be STN

• Column J should be TANF

• Column G should be DC Reason

This file will update the individual students that are in the file. If you look at their demographics…Office Use… Lunch Account area you will see the data imported.

Open

In addition, you will see the updated lunch status in the free/reduced status view, the textbook rental views and the cafeteria account.

1. Save the file to your computer

2. If the file is a csv file do file….open with….Notepad

   • (if it is not a csv file…rename it to a csv file)

3. Do file…save as and for the coding pick Unicode.  It should look like below. 

4. You may then import that csv file

Open