Sidebar
utilities:importfiletea
This is an old revision of the document!
Import External File
TSDS > Utilities > Import External File
This utility updates data in PEIMS tables from a text flat file created outside TxEIS. Each row in the file corresponds to a PEIMS record. The only PEIMS record types available for importing are:
- Organization-District (010)
- Organization-Campus (020)
- Finance-Budget (030)
- Finance-Actual (032)
- Finance-SSA Actual (033)
All other records are skipped.
Import file:
| Field | Description |
|---|---|
| File |
Click Browse to select the file to import.
The first letter of the filename indicates the submission period and must be one the following in order to be imported:
|
Click Import.
When the import is complete, results are displayed, including counts of errors, records read, records skipped, and records by type.
Valid records are imported. Records marked with errors are not imported.
Correct any errors, and then run the Delete Tables utility to clear out the imported data; otherwise duplicate record errors will occur when you attempt to import a second time for the valid records that were imported originally.
Other functions and features:
| Print Report | Click to print the PEIMS Import External File Report. Records that resulted in an error are listed. The line number in the file corresponding to the record that caused an error is displayed in the first column, and the record itself is displayed in the second column. A summary of the import is printed on the last page of the report. |
|---|
Contact the PEIMS Coordinator at your regional education service center for further assistance.
utilities/importfiletea.1505762179.txt.gz ยท Last modified: 2017/09/18 14:16 (external edit)