State Reporting

User Tools

Site Tools

Trace: • print • extended_extract • fall_extract_staff • extended_import • fall_extract_budget • ecds_pk_extract • fall_extracts
academy:fall_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:fall_import [2018/08/10 16:40] – jstanfordacademy:fall_import [2021/02/23 13:28] (current) – apape
Line 1: Line 1:
-\\  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.\\  \\  +\\   
 +[[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 ASCENDER where each row in the file corresponds to a TSDS record.\\  \\  
 The only TSDS record types available for importing are:\\  \\   The only TSDS record types available for importing are:\\  \\  
-  * Organization-District (010) +  * Organization-District (010) (10010 - //LocalEducationAgencyExtension// complex type) 
-  * Organization-Campus (020) +  * Organization-Campus (020) (10020 - //SchoolExtension// complex type) 
-  * Finance-Budget (030) +  * Finance-Budget (030) (20030 - //BudgetExtension// complex type) 
-  * Finance-Actual (032) (not used for Fall) +  * Finance-Actual (032) (20032 - //ActualExtension// complex type) **(not used for Submission 1)** 
-  * Finance-SSA Actual (033) (not used for Fall)+  * Finance-SSA Actual (033) (20033 - //SharedServiceArrangementExtension// complex type) **(not used for Submission 1)**
 \\   \\  
 <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>
  
-[[utilities:importfiletea|State Reporting > Utilities > Import External File]]\\  \\  +</WRAP> 
 + 
 +++++File layout| {{page>general:import_external_file_layout&inline}} ++++ 
 + 
 +\\  \\   
 + 
 + 
 +{{:images:screenshots:asc_extended_import_external.png|Import External File utility page}}\\  \\   
 + 
 +^File|{{page>general:file_fall}}| 
 + 
 +Click **Import**.\\  \\    
 +When the import is complete, results are displayed, including counts of errors, records read, records skipped, and records by type.\\  \\   
 + 
 +{{:images:screenshots:asc_utility_import_external_file_results.png|Import Completed}}\\  \\   
 +<WRAP box> 
 +Valid records are imported. Records marked with errors are not imported.\\  \\    
 +Correct any errors, and then run the [[utilities:deletetables|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. 
 +</WRAP> 
 + 
 +---- 
 + 
 +^Print Report|Click to ++print the PEIMS Import External File Report.|{{page>general:print&inline}}++|  
 +^:::|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.| 
 +^:::|{{:images:screenshots:asc_utility_import_external_file_report.png|Import report}}| 
 +\\   
 +Contact the TSDS PEIMS Coordinator at your regional education service center for further assistance.
  
-1. Next to File, click Browse to select the file to import. 
-The first letter of the filename indicates the submission period. For Submission 1, the 
-file name should begin with F. 
-2. Once a file has been selected the Import button is enabled. Click Import. 
-zz When the import is complete, results are displayed, including counts of errors, 
-records read, records skipped, and records by type. 
-zz If any errors are encountered, no updates occur. Note that skipped records are not 
-counted as errors. 
-3. Click Print Report to print the Import External File Report. 
academy/fall_import.1533919229.txt.gz · Last modified: 2018/08/10 11:40 (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.