Direct Cert Import

From EDgearWiki
Revision as of 16:43, 19 August 2015 by Egadmin (talk | contribs)
Jump to navigationJump to search

This program will import the Direct Cert file that the district must get from the DOE site. It will import Free/Reduced lunch codes based on information gathered by the DOE.


  1. You must have access to the Direct Cert file via your computer whether it is saved to you computer, on a shared drive on you network, or on an external drive.
  2. On the left, go to the Student Master module.
  3. Expand Loaders and select Direct Cert Import.
  4. If you need instructions for setup values to be used, follow the link for Standard Setup Options.
  5. Click Choose File and select the file downloaded from DOE.
  6. Indicate whether you want to do each of the following actions by checking the item(s) necessary:
    • Update Lunch Code
    • Skip Students with State/Food Stamp Mismatch
    • Match on two of three elements.
  7. Click OK and you will get a warning that previous lunch codes will be removed.
  8. Respond Yes to proceed; respond No to stop the process.


Definitions of Column Headers

To find definitions of commonly used columns follow this link: Common Column Headers.
The following column headers are not found on the Common Column Headers document.
  • Last Name--Student's last name
  • Suffix--Student's suffix such as Jr., II, III, etc.
  • First Name--Student's first name
  • Middle Name--Student's middle name
  • SIDNO--Local ID number
  • Data Changed--new data entered, existing data replaced


Buttons at the Bottom of the Report

  1. Setup: Click to go back to the Setup box.
  2. Print: This button allows the user to print the screen information in a variety of formats.
  1. Help: Opens the JCampus documentation which includes written instructions and/or videos.


To Print this document use the following steps

    • Click the Print button at the bottom of the screen.
    • A popup will appear with a set of document print options--PDF, XLS, CSV, HTML.
    • The default print option will be PDF.
    • Click the print button on this popup and a print preview window will appear.
    • To get the print icon on this window, hover the mouse in the bottom right area of the preview. A grey rectangle will appear with several icons.
    • Click the print icon at the right end of this rectangle. Another print preview will appear.
    • Click the print button at the top left to print the report. Close the print preview.
Retrieved from EDgear Wiki