...
For districts wishing to reload data, it will be necessary to first remove any previously stored data for the record type. This may be accomplished by using the Delete All option from the List view for the record type. Once all of the records for the record type have been deleted, the Import option may be used to reload the data for the record type.
...
Five Year Forecast Assumptions may not be Imported into EMISFFE using the Import option. EMISFFE will convert text into the proper detail format for EMIS-R reporting using the Forecast Assumptions (QN) entry screen. For specific details on converting QN data, please refer to the Forecast Assumptions/Notes page.
FW
...
data
| Anchor | ||||
|---|---|---|---|---|
|
Beginning in school year 2022-23, ODE will be releasing the FW (Exiting Student Follow-Up) data through the EMIS data collector, Reports Tab, Received Files Details. If ITCs will be importing data for all their districts, they may find all their districts FW source files using the filter options from the Reports tab, Received Files Details.
| Note |
|---|
| Please note that the file ODE releases through the data collector for importing into EMISFFE is a flat file even though it has a CSV extension in the data collector. There is a restriction within the data collector that prevents ODE from using a different file extension on these files. |
File name includes FW
Note that the file name may differ if ODE publishes additions. Use the appropriate name for the FW source file you are wishing to import into EMISFFE.
Click List Files
This will result in a listing of all the FW source files for the ITC's member districts.
...
Left mouse click on the filename and Save file
| Note | ||
|---|---|---|
| ||
| Note that each browser behaves differently when Saving files. |
Name the file as desired with a .SEQ extension and Save.
The file with the .SEQ extension will now be able to be imported into EMISFFE. During the import any warnings on the header row can be ignored. The remaining data rows will import if in the proper format.
FW - Additions/Appeals
Some districts may receive a second file containing additional students to be added to the Exiting Student Follow-up reporting data. In some cases, the second file may contain corrections to students that had been included in the original FW data file from ODE.
If the additional file contains only additions, the file may simply be imported into EMISFFE following the instructions above. The additional students will be added to the existing FW data in EMISFFE.
If the additional file contains students which were updated from the original FW source file, special steps need to be taken. EMISFFE will not update a record during import, it will only write records if the record does not already exist. An error would be issued during the import indicating there was already a record on file with a matching key and the corrected record from the additions file would be ignored. To get these corrected records into EMISFFE, the following steps should be taken.
- Extract the existing FW data from FFE and save the resulting extraction file to an easily accessible location as you will be needing it in a future step. This will retain any updates that the district has already made to this data.
- Once you have verified you have a good extraction file from the first step, use the 'Delete All' to delete all of the current FW data from EMISFFE
- Import the additions file received from ODE
- Import the extraction file from step 1. An error will be generated for each record that was updated and resent in the additions file (step 3). Those duplicate key errors may be ignored as the corrected record will now be loaded into EMISFFE from step 3. Districts may have to re-enter any follow-up data on the students generating the duplicate key errors
FW - Populate Names
The FW Listing has a menu option labeled 'Populate Names' that will update the first, last and middle name elements using the Student Identification Data string from ODE's source file. If both the first and last name elements are empty, it will attempt to update the name fields using the parsed data from the Student Identification Data string. Districts may execute this function as needed. If additions were imported, it may be executed without fear of harming existing data that has already been updated.
GV data
| Anchor | ||||
|---|---|---|---|---|
|
...