Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Import Link Fixer

...

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
FWImport
FWImport

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
titleBrowsers
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.

...

  1. 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.
  2. 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
  3. Import the additions file received from ODE
  4. 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 fileIf 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. 

Image Added

GV data
Anchor
GVImport
GVImport

...