Interfaces

User Tools

Site Tools

Trace: • Merge Asset Management Text File Layout
student:registration_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
student:registration_import [2021/08/06 18:05] – lrosdahlstudent:registration_import [2024/08/13 13:49] (current) – lrosdahl
Line 1: Line 1:
-======Registration Import======+======Registration Import Guidelines====== 
 + 
 +Used with ALL external registration systems.\\ \\ 
 +Review the guidelines in [[https://wiki.ascendertx.com/pages/viewpage.action?spaceKey=TCCTD&title=External+Registration+Setup|External Registration Setup]] in TCC Technical Documentation. 
 + 
  
-Used with external registration systems. 
 **Notes**: **Notes**:
-  * The file should be named enrollment.csv. +  * The export filename should be saved as: //enrollment.csv//. 
-  * Headers are required, though the column names can be anything, the data should be in the order listed below.+  * Headers are required. The data **MUST** be in the order as shown in the table below.
   * New and returning students are loaded.   * New and returning students are loaded.
-    * New students should have a student ID that begins with an alphabetic (this is determined by the third-party vendor and is used in the export process to identify the students). +    * **New students**: The first character of the StudentID for New Students **MUST** be a single alphabetic (A-Z). This is generally determined by the third-party vendor. If one is not present in the saved export .CSV file, please append one to the existing StudentID value, as it is used in the import process to identify new students. 
-    * Returning students should have a record in ASCENDER (Student ID, Campus, Entry Date, School Year, SSN and DOB should match ASCENDER table data). The returning student should be active for the current school year.+    * **Returning students**: Returning students should already have a record in ASCENDER (Student ID, Campus, Entry Date, School Year, SSN and DOB should match ASCENDER table data). The returning student should be active for the current school year.
     * The program accepts Social Security Numbers that begin with "S".     * The program accepts Social Security Numbers that begin with "S".
   * Errors:   * Errors:
-    * If a returning student does not have matching data in the fields listed above, the student will not be added in the import.+    * If a returning student does not have matching data in the fields listed below, the student will not import into ASCENDER and will produce an error. 
 +    * Before attaching a .CSV file to the Jira ticket requesting an import, please review the saved export file for extra commas at the end of each line. Extra commas will cause the import to fail. Remove the extra commas manually using an application such as //Notepad// on Windows and resave the file before attaching to Jira ticket.
     * Students should have an active code of //1// and a status code of less than //4// in the campus for the current school year.     * Students should have an active code of //1// and a status code of less than //4// in the campus for the current school year.
  
 +===Required Fields:===
 |Student ID|6 char for existing students; longer for new|Student ID.| |Student ID|6 char for existing students; longer for new|Student ID.|
 |School Year|4 char|School Year.| |School Year|4 char|School Year.|
Line 41: Line 47:
 |Student Home AC|3 char|Student Phone Area Code.| |Student Home AC|3 char|Student Phone Area Code.|
 |Student Home Phone Nbr|7 char (no hyphen)|Phone Number.| |Student Home Phone Nbr|7 char (no hyphen)|Phone Number.|
-|Ethnicity Hispanic|Y or N|Hispanic.| +|Ethnicity Hispanic|Y or N|Hispanic (Y or N).| 
-|Race Black|Y or N|African American.| +|Race Black|1 Char|African American (Y or N).| 
-|Race White|Y or N|White.| +|Race White|1 Char|White (Y or N).| 
-|Race Pacific Islander|Y or N|Pacific Islander.| +|Race Pacific Islander|1 Char|Pacific Islander (Y or N).| 
-|Race Am. Ind/Alaskan|Y or N|Native American/Alaskan.| +|Race Am. Ind/Alaskan|1 Char|Native American/Alaskan (Y or N).| 
-|Race Asian|Y or N|Asian.|+|Race Asian|1 Char|Asian (Y or N).|
 |Student Previous District Name|13 char|Previous District.| |Student Previous District Name|13 char|Previous District.|
 |Student Previous Campus Name|34 char|Previous Campus.| |Student Previous Campus Name|34 char|Previous Campus.|
student/registration_import.1628273139.txt.gz · Last modified: 2021/08/06 13:05 (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.