The import option from the Main menu provides a means for districts to load data into the application from a spreadsheet or an extraction from another source. The file to be imported must have an SEQ or CSV file extension and must meet format requirements.
The Import option will not Update records. During the Import process, if a record to be loaded is already found to be stored in the EMISFFE application, the record from the load file will be rejected. An error will be generated to the screen indicating that the record is already on file.
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.
Flat File Import Requirements
For those districts needing to import data utilizing a sequential file, the format of the records must follow the specifications provided in the EMIS Manual. These files must have an SEQ extension in order to load properly into EMISFFE. Multiple record types may be included in a single load file.
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.
When importing a large data file, EMISFFE may time out with a "Proxy" error. This may occur after approximately 15 minutes of importing data. However, even though this error is generated, the data continues to be imported. Depending upon the size of the data file being imported, it may take several hours for the import process to complete.
If the "proxy" error is received, do not start another import process until you have verified that the previous import has completed. After this "proxy" error has been generated, the load of records may be monitored by going to the list view for the record type being imported. At the bottom of the List view page, take note of the value that shows in the box to the left of "Next". That box/value represents the highest page number. Then click on that box for the highest page. When the list view is redisplayed, if the highest page number box shows a higher number, records are still being loaded.