User Tools

Site Tools


academy:midyear_import

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
academy:midyear_import [2018/11/15 15:46] jstanfordacademy:midyear_import [2020/10/22 19:32] (current) emoreno
Line 1: Line 1:
 \\   \\  
 [[utilities:importfiletea|State Reporting > Utilities > Import External File]]\\  \\   [[utilities:importfiletea|State Reporting > Utilities > Import External File]]\\  \\  
-<WRAP round intro>Some districts may update data in TSDS tables from a text flat file created outside TxEIS where each row in the file corresponds to a TSDS record. **This only applies to Student-only districts.**\\  \\  +<WRAP round intro>Some districts may update data in TSDS tables from a text flat file created outside ASCENDER where each row in the file corresponds to a TSDS record. **This only applies to Student-only districts.**\\  \\  
 The only TSDS record types available for importing are: The only TSDS record types available for importing are:
  
Line 9: Line 9:
   * Finance-Actual (032) (20032 - //ActualExtension// complex type)    * Finance-Actual (032) (20032 - //ActualExtension// complex type) 
   * Finance-SSA Actual (033) (20033 - //SharedServiceArrangementExtension// complex type)   * Finance-SSA Actual (033) (20033 - //SharedServiceArrangementExtension// complex type)
 +\\  
  
 <WRAP box>**IMPORTANT!** Only these record types can be imported. All other records are skipped.</WRAP> <WRAP box>**IMPORTANT!** Only these record types can be imported. All other records are skipped.</WRAP>
 </WRAP> </WRAP>
 +\\  \\  
 +
 +
 +^File|Click **Browse** to select the file to import.\\  \\  <div indent>
 +The first letter of the filename indicates the submission period. For the midyear submission, the file name should begin with M.\\  \\  </div>|
 +
 +
 +Once a file has been selected the **Import** button is enabled.\\  \\  
 +VCV Click **Import**.\\  \\  
 +<div indent>
 +When the import is complete, results are displayed, including counts of errors, records read, records skipped, and records by type.\\  \\  
 +If any errors are encountered, no updates occur. Note that skipped records are not counted as errors.</div>\\  \\  
 +VCV Correct any errors, and then run the [[utilities:deletetables|Delete/Clear 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.\\  \\  
 +
 +^Print |++ Print the Import External File report.|{{page>general:print}}++|
academy/midyear_import.1542296776.txt.gz · Last modified: 2018/11/15 10:46 (external edit)