User Tools

Site Tools


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
student:registration_import [2024/08/12 20:41] lrosdahlstudent:registration_import [2024/08/13 13:49] (current) lrosdahl
Line 8: Line 8:
 **Notes**: **Notes**:
   * The export filename should be saved as: //enrollment.csv//.   * The export filename should be saved as: //enrollment.csv//.
-  * Headers are required. The data **MUST** 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**: 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.     * **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**: 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 below, the student will not import into ASCENDER and will produce an error.     * 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 lines. 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.+    * 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.
  
student/registration_import.1723495264.txt.gz · Last modified: 2024/08/12 20:41 by lrosdahl