State Reporting

User Tools

Site Tools

Trace:
academy:midyear_import

Differences

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

Link to this comparison view

Next revision		Previous revision
academy:midyear_import [2018/11/15 15:44] – created 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:
-  * Organization-District (010) + 
-  * Organization-Campus (020) +  * Organization-District (010) (10010 - //LocalEducationAgencyExtension// complex type) 
-  * Finance-Budget (030) (not used for Midyear) +  * Organization-Campus (020) (10020 - //SchoolExtension// complex type) 
-  * Finance-Actual (032) +  * Finance-Budget (030) (20030 - //BudgetExtension// complex type) **(not used for Midyear)** 
-  * Finance-SSA Actual (033)+  * Finance-Actual (032) (20032 - //ActualExtension// 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.1542296648.txt.gz · Last modified: 2018/11/15 10:44 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.