Page Comparison

1. ..

1. .
   

   Image Modified

2. Choose a location on your local drive or network to save the file. The file should be in .xml format.
   

   Image Modified

Establish Export Settings

1. Login to Franklin.

2. From the 

1. Admin & Maintenance tab, select the Advanced Setup menu, and choose the Exports option.

2. Click on the Import Settings button and locate the Colorado.xml fileon your local or network drive. Click Open once you have located the file.
   

   Image Modified

3. In the Configure Export window, enter a description name. Then, click the Setup button.
   

   Image Modified

4. Establish export criteria.
   

1. The file

1. name must

1. be DISTRICT.txt

1. for this process to work.

1. If your filename is not DISTRICT.txt, highlight the filename before the .txt extension and type DISTRICT. Then,

1. click Save.

   1. In the Export Criteria window, choose a designated location on your workstation by clicking the ellipses

1. 1. button.

   2. Next, click the Edit Layout button.
      

      Image Modified

   3. In the Setup Export Specification window, locate the first Format column in the Filler row and enter the school site number. Then, click Ok.
      

      Image Modified

2. Click Ok in the Export Criteria window.

3. Click Ok in the Configure Export window.

4. You should now see the Colorado DC file in the Export window. Click the red "x"

1. to close the export window.
   

   Image Modified

Export Data from Franklin

1. In the Utilities tab, locate and click on the Advanced button. Then, click Export Data.

2. Select the Colorado DC file and click Run.
   

   Image Modified

    

Password Change

1. Navigate to the CDE Child Nutrition section of the CDE website and click on the Online Claims and Services link.
   

1. Image Added

2. Click the Online Claim System button to update your Direct Cert password.
   

1. Image Added

2. Sign in using the initial User ID and Password you were sent for Direct Certification.
   

1. Image Added

2. Click on the Change Password button.
   

1. Image Added

2. Change the password.

   1. In the Old Password field, type in the initial password you were given.

   2. In the New Password field, type in the new password.
      

1. 1. Password Requirements

1. 1. - Keep in mind you will need to use both upper and lower case alpha characters as well as at least one

1. 1. numeric character and one

1. 1. symbol. The uppercase and numeric characters cannot be the first or last character

1. 1. or your password. e.g. State*1 is not acceptable; however, sta*1Te is acceptable.

   2. In the New Password (verify) field, re-enter your new password.

   3. Click Save when you are done.
      

1. 1. Image Added

Anchor
CDE Direct Cert CDE Direct Cert

CDE Direct Certification Process

1. Navigate to the CDE Child Nutrition section of the CDE website and click on the Free and Reduced Processes link.
   

1. Image Added

2. Click on the Direct Certification link.
   

1. Image Added

2. Click on Online Direct Certification System.
   

1. Image Added

2. Log on with your User ID and Password.
   

1. Image Added

2. Perform the upload and download procedures.
   

   1. Click on Upload District File.

   2. Using the Browse button, locate and select the formatted district file named DISTRICT.txt from your workstation. Do not add your district's name to the file name.

   3. Click the Upload File box. You will see processes running in the File Upload Status window.
      

      Image Modified

   4. If the upload is successful with no errors, you should receive a message stating Congratulations! File upload successful.
      

1. 1. You will receive a notification message if you have errors. Please refer to your State and District policies for regulations on how to handle this type of issue. If you believe the error is related to MCS Software, please contact Support

1. 1. .

      Image Modified

2. Once you have successfully uploaded the file, proceed with the download process.

3. 1. Using the drop-down arrow, select Fixed Length.
      

      Image Modified

   2. Click on the Download District file button. (This returns the District file with the Direct Certification match codes (1, 2, 3, or 4) in field position #202.

   3. The File Download window will appear asking if you want to Open or Save the file. Save the file and take note where it is saved.
      

      Image Modified

   4. After you have successfully downloaded the District file, click on the Matches Detail Report and select the Save button.
      

1. 1. 🔴 This step is required by the State.

      Image Modified

2. Once the report has been downloaded, you will need to print it for reviewing purposes.

Importing and Running the DC File

1. From the Utilities tab, select the Direct Certification menu and choose the 

1. Import File option.
   

1. If you already have DC Import Configurations established, you may be asked to select which one to use. Choose an Import Configuration and click Ok if this is the case.

2. Select the

1. ellipsis and locate the DC Filename on your computer or network. Select Ok to begin the import.
   

   Image Modified

2. Review Updates and Adds and the types of changes. Then, click Ok to continue.

3. From the Utilities tab, select the Direct Certification menu and choose the Apply State

1. Match option.

2. The Apply Direct Certification State Matching window will appear notifying you the process to match the imported DC file will be run against the student database. There is NO UNDO available.

   1. You should review the settings you have chosen before proceeding. The ID Field to Match is setup in System Settings.

   2. You will be informed that "Letters WILL be queued" or "Letters WILL NOT be queued." Letter printing options are setup in System Settings.

3. Click Ok when you are ready to proceed with running the state match process.
   

   Image Modified

   
   

   Image Modified

4.  In the Confirm DC State Match Results window, you will receive a message as to the percentage of correct matches. Questionable matches appear in red. If you are sure a student in red is a match, click the apply box to include the student in the match. When you are done, click Ok.

   _{(All names have been changed to protect the identity of students.)}
   Image Modified
   

Print DC Notification Letters

1. From the Home tab, locate and click on Print Letters in the Letters group.

2. Choose which letter type to print and how to sort the letters. When you have completed setting up print options, click Ok.

   1. Kinds of Letters to Print - If you have setup a separate template for DC Letters, use the drop-down menu to select the correct letter, otherwise, leave the Normal Letters default selected.

   2. Letter Sort Order - Use the drop-down menu to choose how letters should be sorted for printing.
      Image Modified

3. The print batch window will appear notifying you of the number of letters that remain to be printed. Click OK to open the print preview screen.
   

1. Selecting Cancel in the Print Next Batch window or clicking Close Print Preview

1. prior to printing letters will leave the unprinted letters in the queue. Letters will only move out of the print queue when a print job is executed.

   Image Modified