First we need to download the list from the State. Go to:
https://portalx.bisoex.state.me.us/pls/doe_sfsr/sfsrdev.logon_screen.user_login
and enter the username and password (William Shuttleworth and Ellen Beal are the keepers)
Click "Direct Certification List"
Select the appropriate choices from the pull-downs and click "Generate Student List"
After the list is created, scroll to the very bottom and click "Export Student List as: Excel Spreadsheet".
Save the resulting file somewhere you can find it.
Open the saved file and ensure the data looks correct.
Remove any unnecessary rows (i.e. Town Names), but leave one Header Row
Change Cell E1 to read "Last Name"
Change Cell E2 to read "=LEFT(A2,(FIND(",",A2,1)-1))"
Change Cell F1 to read "First Name"
Change Cell F2 to read "=RIGHT(A2,(LEN(A2)-LEN(E2)-2))"
Select Cell E2, then scroll down to the last cell in Column F for the last student and Shift-Click to select all cells in between
Choose Edit->FillDown
Scan and verify that all the last Names and FirstNames look correct.
Choose File->SaveAs and from the Format pull-down select "CSV (Comma Delimited)" and save the file as "DirectCert.csv"
In Infinite Campus navigate to:
Index->FoodService->"Eligibility Import Wizard"
Click "New Import Mapping"
Enter a name such as "2010.DirectCert.csv"
Set "What is the file type?" to "Comma Delimited"
Set "Which fields in the data file will map to student identifiers?" to "LastName, FirstName, Birthdate"
Tick the checkbox for "Source File Includes Header: "
Below "Upload a sample file", click the Browse button to find your saved file "DirectCert.csv", then click "Upload and Continue"
In the next screen, ensure the "Raw Data File Sample:" looks correct.
Click the "New" button
***** Ran into difficulty here with pull-down menus not properly populated, filed a support ticket with Infinite Campus *****
https://portalx.bisoex.state.me.us/pls/doe_sfsr/sfsrdev.logon_screen.user_login
and enter the username and password (William Shuttleworth and Ellen Beal are the keepers)
Click "Direct Certification List"
Select the appropriate choices from the pull-downs and click "Generate Student List"
After the list is created, scroll to the very bottom and click "Export Student List as: Excel Spreadsheet".
Save the resulting file somewhere you can find it.
Open the saved file and ensure the data looks correct.
Remove any unnecessary rows (i.e. Town Names), but leave one Header Row
Change Cell E1 to read "Last Name"
Change Cell E2 to read "=LEFT(A2,(FIND(",",A2,1)-1))"
Change Cell F1 to read "First Name"
Change Cell F2 to read "=RIGHT(A2,(LEN(A2)-LEN(E2)-2))"
Select Cell E2, then scroll down to the last cell in Column F for the last student and Shift-Click to select all cells in between
Choose Edit->FillDown
Scan and verify that all the last Names and FirstNames look correct.
Choose File->SaveAs and from the Format pull-down select "CSV (Comma Delimited)" and save the file as "DirectCert.csv"
In Infinite Campus navigate to:
Index->FoodService->"Eligibility Import Wizard"
Click "New Import Mapping"
Enter a name such as "2010.DirectCert.csv"
Set "What is the file type?" to "Comma Delimited"
Set "Which fields in the data file will map to student identifiers?" to "LastName, FirstName, Birthdate"
Tick the checkbox for "Source File Includes Header: "
Below "Upload a sample file", click the Browse button to find your saved file "DirectCert.csv", then click "Upload and Continue"
In the next screen, ensure the "Raw Data File Sample:" looks correct.
Click the "New" button
***** Ran into difficulty here with pull-down menus not properly populated, filed a support ticket with Infinite Campus *****