TracCloud: Student Data Import: Difference between revisions

From Redrock Wiki

m (1 revision imported)
No edit summary
 
(66 intermediate revisions by the same user not shown)
Line 1: Line 1:
<!-- here is a table for the content of the page -->
{{TracCloudGuideTabs}}
{| style="width:100%; vertical-align:top; "
<div class="tcWidgetPage">
| style="vertical-align:top; font-size:160%; color:#0C3773; " | '''Importing Student Data into TracCloud''' <HR>
<div class="category">
{{TracCloudTechTOC}}
</div>
<b><big>Importing Student Data into TracCloud</big></b>
 
TracCloud can import data from any source as long as it's provided in the correct format. Using your current Student Information System (Banner, PeopleSoft, DataTel, etc) as a source, create files that match the specifications below. We will require at least two files- A student file and an enrollment/registration file. It's generally recommended to send data for the current term and one prior term in your registrations file, in case past registrations need to be kept active through the semester changeover.
<section begin="fileRequirements" />
* <span style="color:red>Import files must be in a flat-text format (.csv or .txt), comma or tab delimited, UTF-8.</span>
* <span style="color:red>Comma delimited files must have quotes surrounding <b>every</b> field. </span>
* <span style="color:red>A header row is required, and custom fields must be coordinated with Redrock Software to ensure assignment to the correct data field. </span>
* <span style="color:red>File names must be static, with each import upload overwriting the previous copies of the files.</span>
* <span style="color:red>If you anticipate section's linked faculty changing, let us know, as this may require additional changes to your import process.</span>
* <span style="color:red>Lab courses should be designated in the course information rather than the section. For example, "BIO100L".</span>
<section end="fileRequirements" />
 
There are no restrictions on column order, and optional columns can safely be excluded from your file if preferred.
 
<HR>
 
Click the buttons below to view or download example files. The Section Schedule file is optional.
 
<div class="guideTabs" style="min-width:170px">
[[Media:Students.txt|View Student File]]
</div>
<div class="guideTabs" style="min-width:170px">
[[Media:Courses.txt|View Course File]]
</div>
<div class="guideTabs" style="min-width:170px">
[[Media:Schedule.txt|Section Schedule File]]
</div>
 
<HR>
 
All import files will be uploaded to our SFTP server. The IP addresses for our SFTP server are listed below if you need to whitelist them.
{| class="wikitable"
| Primary || 3.135.4.128
|-
|-
| style="vertical-align:top; font-size:120%; " |
| Failover || 44.228.245.56
TracCloud can import data from any source as long as it's provided in the correct format. Using your current Student Information System (an SIS like Banner, PeopleSoft, or DataTel) as a source, create files to be imported into your Trac System. We will require two files- A student file and course enrollment file.
|}
<BR>
 
<span style="color:red>The import file provided to TracCloud must be a flat-text .csv file, either comma or tab delimited. Comma delimited files must have quotes surrounding <b>every</b> field, including numeric fields.<BR>
<HR><section begin="FieldTypes" />
All custom fields must be coordinated with Redrock Software so that the assignment to the proper data field may be properly setup.
'''Description of Import fields'''  
</span>
 
|-
{| class="wikitable" border="1" style="margin:auto"
| style="vertical-align:top; font-size:120%; color:#0C3773; " | '''Description of Import fields''' <HR>
|-
| style="vertical-align:top; font-size:100%; " |
{| cellpadding="5" cellspacing="0" border="1"
!Type!!Description
!Type!!Description
|-
|-
Line 20: Line 51:
|#B||Big Integer, maximum value of about 9 quintillion, or a 16-digit numeric value
|#B||Big Integer, maximum value of about 9 quintillion, or a 16-digit numeric value
|-
|-
|Date||Date, formatted as YYYY-MM-DD
|Date||Date, <span style="color:red>formatted as YYYY-MM-DD</span>
|-
|-
|Double||Decimal # with up to 12 digits precision
|Double||Decimal # with up to 12 digits precision
|}
<br />
|-
|-
| style="vertical-align:top; font-size:140%; color:#0C3773; " | '''Student Import Fields''' <HR>
|Time||A specific time using a 24-hour format (HH:MM:SS), e.g., 13:45:00
|-
|Duration||A duration stored in number of minutes, e.g., 90
|}<section end="FieldTypes" />
 
<HR>
<section begin="RequiredFields" />
'''Explanation on Required Fields'''
 
The TracCloud import process can be fairly flexible, but some fields are absolutely required, some are conditionally required, and others aren't required but <i>are</i> highly recommended.
 
{| class="wikitable" border="1" style="margin:auto"
!Type!!Description
|-
|Yes||Required.
|-
|[Yes]||Required only if you're importing that data. E.g., Faculty.First_Name is required only if you're importing faculty in the first place. These groups of fields will have matching colors when necessary.
|-
|(Yes)||Technically not required, but highly recommended. Functionality will be lost if this field isn't imported. E.g., you don't <i>need</i> to import student email addresses, but students will not be able to receive emails without it.
|-
|-
| style="vertical-align:top; font-size:100%; " |
|{Yes}||Conditionally required based on whether or not you're importing other fields. For example, Section.Title and Course.Title. You can import both, you can import one or the other, but you cannot import neither.
{| cellpadding="5" cellspacing="0" border="1"
|}
<section end="RequiredFields" />
<HR>'''Available Student Import Fields'''
 
{| class="wikitable" border="1" style="margin:auto"
!Name!!Type!!Required!!Field Description!!Example
!Name!!Type!!Required!!Field Description!!Example
|-
|-
|ID||#B||Yes*||The unique numeric ID of the student, required if Other_ID isn't being used.||19310045
|ID||#B||{Yes}||The unique numeric ID of the student, required if Other_ID isn't being used.||19310045
|-
|-
|Other_ID||A40||Yes*||A secondary ID or handle for the student, required if ID isn't being used.||A19310045
|Other_ID||A40||{Yes}||A secondary ID or handle for the student, required if ID isn't being used.||A19310045
|-
|-
|Other_ID2||A40|| ||An optional tertiary ID or handle for the student.||dsmith1990
|Other_ID2||A40|| ||An optional tertiary ID or handle for the student.||dsmith1990
Line 40: Line 91:
|Barcode||A80|| ||A barcode ID for the student, required if scanners are used to log students in.||A2609376378
|Barcode||A80|| ||A barcode ID for the student, required if scanners are used to log students in.||A2609376378
|-
|-
|Status||A80|| || The status of the student.||Active
|OtherStatus||A80|| || An optional secondary status. Primary status is set automatically.||Registered
|-
|-
|OtherStatus||A80|| || An optional secondary status.||Active
|Legal_First||A80|| ||The legal first name of the student.||David
|-
|Legal_First||A80||Yes||The legal first name of the student.||Dave
|-
|-
|First_Name||A80||Yes||The preferred first name of the student.||Dave
|First_Name||A80||Yes||The preferred first name of the student.||Dave
Line 52: Line 101:
|Middle||A80|| ||The middle name or initial of the student.||L.
|Middle||A80|| ||The middle name or initial of the student.||L.
|-
|-
|Street||A80|| ||The street address of the student.||1234 E. Nowhere St.
|Street||A250|| ||The street address of the student.||1234 E. Nowhere St.
|-
|-
|Apt||A80|| ||Apartment Number.||#46
|Apt||A80|| ||Apartment Number.||#46
|-
|-
|City||A80|| ||City of the student address.||Tempe
|City||A120|| ||City of the student address.||Tempe
|-
|-
|State||A80|| ||The state of the student address.||Arizona
|State||A80|| ||The state of the student address. Two-letter formatting displays best.||AZ
|-
|-
|Zip||A10|| ||The zip code of the student address.||88881
|Zip||A20|| ||The zip code of the student address.||88881
|-
|-
|Country||A10|| ||The country of the student address.||USA
|Country||A80|| ||The country of the student address.||USA
|-
|-
|Home_Phone||A20|| ||The student's home phone number.||555-555-5551
|Home_Phone||A80|| ||The student's home phone number.||555-555-5551
|-
|-
|Work_Phone||A20|| ||The student's work phone number.||555-555-5552
|Work_Phone||A80|| ||The student's work phone number.||555-555-5552
|-
|-
|Cell_Phone||A20|| ||The student's cell phone number.||555-555-5553
|Cell_Phone||A80||(Yes)||The student's cell phone number. Required for students to receive [[TracCloudTA|TextAlerts]].||555-555-5553
|-
|-
|Email||A80|| * ||The student's email address. Required if students are going to be receiving emails from TracCloud.||dsmith@school.edu
|Email||A120||(Yes)||The student's email address. Required if students are going to be receiving emails from TracCloud.||dsmith@school.edu
|-
|-
|Preferred||A20|| ||The student's preferred phone number, 'Home', 'Work', or 'Phone'.||Home
|Preferred||A80|| ||The student's preferred phone number, 1 = 'Home', 2 = 'Work', 3 = 'Cell', 4 = 'Email', 5 = 'Phone'||3
|-
|-
|Username||A80|| * ||The student's username or handle, required if students are going to be logging into TracCloud.||dsmith
|Username||A120||(Yes)||The student's username or handle. Required if students are going to be logging into TracCloud.||dsmith
|-
|-
|Birthdate||Date|| ||The student's birthdate.||1970-01-01
|Birthdate||Date|| ||The student's birthdate.||1970-01-01
|-
|-
|Gender||A8|| ||The student's gender.||Male
|Gender||A80|| ||The student's gender.||Male
|-
|-
|Ethnicity||A80|| ||The student's ethnicity.||Caucasian
|Ethnicity||A150|| ||The student's ethnicity.||Caucasian
|-
|-
|Major||A120|| ||The student's major.||Accounting
|Major||A120|| ||The student's major.||Accounting
Line 86: Line 135:
|Class||A80|| ||The student's class.||SO
|Class||A80|| ||The student's class.||SO
|-
|-
|DegreeGoal||A80|| ||The student's class.||AAS
|DegreeGoal||A80|| ||The student's degree goal.||AAS
|-
|-
|Cohort||A80|| ||The student's cohort.||2017SP
|Cohort||A80|| ||The student's cohort.||2017SP
Line 115: Line 164:
|-
|-
|}
|}
<br /><br />


|-
<HR>'''Available Registration Import Fields'''  
| style="vertical-align:top; font-size:140%; color:#0C3773; " | '''Registration Import Fields''' <HR>


|-
{| class="wikitable" border="1" style="margin:auto"
| style="vertical-align:top; font-size:100%; " |
{| cellpadding="5" cellspacing="0" border="1"
!Name!!Type!!Required!!Description!!Example
!Name!!Type!!Required!!Description!!Example
|-
|-
Line 129: Line 174:
|Course.Course||A20||Yes||The course number.||100
|Course.Course||A20||Yes||The course number.||100
|-
|-
|Course.Title||A128||Yes||The name of the course in which the student is enrolled.||Intro to Accounting
|Course.Title||A120||{Yes}||The name of the course in which the student is enrolled. The course title is only tied to the subject, such as "ACTG100". Required if Section.Title is not imported.||Intro to Accounting
|-
|Section.Title||A120||{Yes}||The name of the section in which the student is enrolled. This overrides the course title if provided, allowing different sections to have unique titles. Required if Course.Title is not imported.||Intro to Accounting
|-
|-
|Section.Code||A80||Yes||The section code.||03
|Section.Code||A80||{Yes}||The section code. Required if Section.CRN is not imported.||03
|-
|-
|Section.CRN||A20||Yes||The course reference number.||123456789
|Section.CRN||A80||{Yes}||The unique course reference number (cannot be reused). Required if Section.Code is not imported.||123456789
|-
|-
|Section.Custom1-X||A80|| ||Optional custom fields relating to this section. Multiple custom fields can be used.||?
|Section.Custom1-X||A80|| ||Optional custom fields relating to this section. Multiple custom fields can be used.||?
|-
|-
|Term.Code||A80||Yes||Term number for this course.||2022SP
|Term.Code||A80||Yes||Term number for this enrollment.||2022SP
|-
|-
|Term.ActiveFrom||Date||Yes||Active start date.||2022-10-01
|Term.ActiveFrom||Date||(Yes)||Active start date. Required to use max appointment rules, center status, and term dates in reports.||2022-10-01
|-
|-
|Term.ActiveTo||Date||Yes||Active end date.||2022-12-31
|Term.ActiveTo||Date||(Yes)||Active end date. Required to use max appointment rules, center status, and term dates in reports.||2022-12-31
|-
|-style="color: green;"
|Faculty.OtherID||A80||Yes||Faculty ID.||J25059
|Faculty.OtherID||A80||[{Yes}]||Faculty ID. Required if another identifier is not imported, such as email or username.||J25059
|-
|-style="color: green;"
|Faculty.FirstName||A80||Yes||Faculty First Name.||Jane
|Faculty.FirstName||A80||[Yes]||Faculty First Name.||Jane
|-
|-style="color: green;"
|Faculty.LastName||A80||Yes||Faculty Last Name.||Doe
|Faculty.LastName||A80||[Yes]||Faculty Last Name.||Doe
|-style="color: green;"
|Faculty.UserName||A80||[{(Yes)}]||Faculty Username. Required if another identifier is not imported, such as ID or email. Required if faculty need to login to TracCloud.||JDoe
|-style="color: green;"
|Faculty.Salutation||A40|| ||Faculty's salutation.||Dr.
|-style="color: green;"
|Faculty.Department||A60|| ||Faculty Assigned Department.||M262
|-style="color: green;"
|Faculty.Phone||A80|| ||Faculty's phone number.||555-555-5555
|-style="color: green;"
|Faculty.Email||A120||[{(Yes)}]||Faculty's email address. Required if another identifier is not imported, such as ID or username. Required for faculty to receive emails.||jdoe80@school.edu
|-style="color: green;"
|Faculty.Custom1-X||A80|| ||Faculty custom fields. Multiple custom fields can be used.||?
|-
|-
|Faculty.UserName||A80||*||Faculty Username, only required if faculty members will be logging into TracCloud.||JDoe
|Student.ID||A40||Yes||The ID/OtherID of the student this registration is assigned to.||A123456789
|-
|Faculty.Salutation||A80||Yes||Faculty's salutation.||Dr.
|-
|Faculty.Department||A80|| ||Faculty Assigned Department.||M262
|-
|Faculty.Phone||A80|| ||Faculty's phone number.||555-555-5555
|-
|-
|Faculty.Email||A80||Yes||Faculty's email address.||jdoe80@school.edu
|Registration.Grade||A40||||The final grade/withdraw code for this registration. Redrock will require a list of possible grades/codes to properly set this up.||B+
|-
|-
|Faculty.Custom1-X||A80|| ||Faculty custom fields. Multiple custom fields can be used.||?
|Registration.RegStatus||A40||||An optional registration status that can be used to deactivate certain enrollments.||Dropped
|-
|-
|Student.OtherID||A40||Yes||The ID/OtherID/OtherID2 of the student this registration is assigned to.||A123456789
|Registration.ValidFromDT||Date||(Yes)||The start date of the registration. Required to activate registrations by date instead of term.||2023-08-15
|-
|-
|Registration.Grade||A4||Yes||The final grade/withdraw code for this registration. Redrock will require a list of possible grades/codes to properly set this up.||B+
|Registration.ValidToDT||Date||(Yes)||The end date of the registration. Required to activate registrations by date instead of term.||2023-12-15
|-
|-
|Registration.Custom1-X||A80|| ||Registration custom fields. Multiple custom fields can be used. A common example would be midterm grades.||?
|Registration.Custom1-X||A80|| ||Registration custom fields. Multiple custom fields can be used. A common example would be midterm grades.||?
|}
|}
<br>
|-
| style="vertical-align:top; font-size:120%; color:#0C3773; " | '''Section Schedule Import Fields''' <HR>
|-
| style="vertical-align:top; font-size:100%; " |


Section Schedule data is optional.
<HR>'''Section Schedule Import Fields''' <span style="color:black">[Optional]</span>


{| cellpadding="5" cellspacing="0" border="1"
{| class="wikitable" border="1" style="margin:auto"
!Name!!Type!!Required!!Description!!Example
!Name!!Type!!Required!!Description!!Example
|-
|-
Line 182: Line 230:
|Course.Course||A20||Yes||The course number.||100
|Course.Course||A20||Yes||The course number.||100
|-
|-
|Section.Code||A80||Yes||The section number.||45
|Section.Code||A80||{Yes}||The section number. Required if Section.CRN not provided.||45
|-
|-
| colspan="5" | Alternatively, a section CRN number can be used instead of the basic course information:
|Section.CRN||A80||{Yes}||The course reference number. Required if Section.Code not provided.||123456789
|-
|-
|Section.CRN||A20||Yes||The course reference number.||123456789
|Term.Code||A80||Yes||The term code.||2022SP
|-
| colspan="5" | Plus, the schedule data:
|-
|-
|Schedule.Days||A30||Yes||Days of the week, formatted as MONTUEWEDTHUFRISATSUN.||MONFRI
|Schedule.Days||A30||Yes||Days of the week, formatted as MONTUEWEDTHUFRISATSUN.||MONFRI
Line 194: Line 240:
|Schedule.Time||Time||Yes||Schedule start time, military/24-hour format.||13:00:00
|Schedule.Time||Time||Yes||Schedule start time, military/24-hour format.||13:00:00
|-
|-
|Schedule.EndTime||Time||Yes||Schedule end time, military/24-hour format.||13:50:00
|Schedule.Duration||Duration||Yes||The duration of this section schedule in minutes. ||50
|}
|}


<!-- here is the end of the content table -->
[[Category:TracCloud Manual]]
|}
</div>
{{DISPLAYTITLE:<span style="position: absolute; clip: rect(1px 1px 1px 1px); clip: rect(1px, 1px, 1px, 1px);">{{FULLPAGENAME}}</span>}}

Latest revision as of 11:44, 25 November 2024

TracCloud Technical Documentation

• Contents

• Mail Server

• Data Import

• Data Export

• Single Sign-on

• Custom URL

• SFTP SSH Keys

• Migration from 4.0


Importing Student Data into TracCloud

TracCloud can import data from any source as long as it's provided in the correct format. Using your current Student Information System (Banner, PeopleSoft, DataTel, etc) as a source, create files that match the specifications below. We will require at least two files- A student file and an enrollment/registration file. It's generally recommended to send data for the current term and one prior term in your registrations file, in case past registrations need to be kept active through the semester changeover.

  • Import files must be in a flat-text format (.csv or .txt), comma or tab delimited, UTF-8.
  • Comma delimited files must have quotes surrounding every field.
  • A header row is required, and custom fields must be coordinated with Redrock Software to ensure assignment to the correct data field.
  • File names must be static, with each import upload overwriting the previous copies of the files.
  • If you anticipate section's linked faculty changing, let us know, as this may require additional changes to your import process.
  • Lab courses should be designated in the course information rather than the section. For example, "BIO100L".


There are no restrictions on column order, and optional columns can safely be excluded from your file if preferred.

Click the buttons below to view or download example files. The Section Schedule file is optional.

View Student File

View Course File

Section Schedule File

All import files will be uploaded to our SFTP server. The IP addresses for our SFTP server are listed below if you need to whitelist them.

Primary 3.135.4.128
Failover 44.228.245.56

Description of Import fields

Type Description
A## Alphanumeric field with a specified maximum length
#B Big Integer, maximum value of about 9 quintillion, or a 16-digit numeric value
Date Date, formatted as YYYY-MM-DD
Double Decimal # with up to 12 digits precision
Time A specific time using a 24-hour format (HH:MM:SS), e.g., 13:45:00
Duration A duration stored in number of minutes, e.g., 90

Explanation on Required Fields

The TracCloud import process can be fairly flexible, but some fields are absolutely required, some are conditionally required, and others aren't required but are highly recommended.

Type Description
Yes Required.
[Yes] Required only if you're importing that data. E.g., Faculty.First_Name is required only if you're importing faculty in the first place. These groups of fields will have matching colors when necessary.
(Yes) Technically not required, but highly recommended. Functionality will be lost if this field isn't imported. E.g., you don't need to import student email addresses, but students will not be able to receive emails without it.
{Yes} Conditionally required based on whether or not you're importing other fields. For example, Section.Title and Course.Title. You can import both, you can import one or the other, but you cannot import neither.
Available Student Import Fields
Name Type Required Field Description Example
ID #B {Yes} The unique numeric ID of the student, required if Other_ID isn't being used. 19310045
Other_ID A40 {Yes} A secondary ID or handle for the student, required if ID isn't being used. A19310045
Other_ID2 A40 An optional tertiary ID or handle for the student. dsmith1990
Barcode A80 A barcode ID for the student, required if scanners are used to log students in. A2609376378
OtherStatus A80 An optional secondary status. Primary status is set automatically. Registered
Legal_First A80 The legal first name of the student. David
First_Name A80 Yes The preferred first name of the student. Dave
Last_Name A80 Yes The last name of the student. Smith
Middle A80 The middle name or initial of the student. L.
Street A250 The street address of the student. 1234 E. Nowhere St.
Apt A80 Apartment Number. #46
City A120 City of the student address. Tempe
State A80 The state of the student address. Two-letter formatting displays best. AZ
Zip A20 The zip code of the student address. 88881
Country A80 The country of the student address. USA
Home_Phone A80 The student's home phone number. 555-555-5551
Work_Phone A80 The student's work phone number. 555-555-5552
Cell_Phone A80 (Yes) The student's cell phone number. Required for students to receive TextAlerts. 555-555-5553
Email A120 (Yes) The student's email address. Required if students are going to be receiving emails from TracCloud. dsmith@school.edu
Preferred A80 The student's preferred phone number, 1 = 'Home', 2 = 'Work', 3 = 'Cell', 4 = 'Email', 5 = 'Phone' 3
Username A120 (Yes) The student's username or handle. Required if students are going to be logging into TracCloud. dsmith
Birthdate Date The student's birthdate. 1970-01-01
Gender A80 The student's gender. Male
Ethnicity A150 The student's ethnicity. Caucasian
Major A120 The student's major. Accounting
Class A80 The student's class. SO
DegreeGoal A80 The student's degree goal. AAS
Cohort A80 The student's cohort. 2017SP
College A80 The student's college. Nowhere State University
Grad_Und A80 The student's graduate status. Und
DateStarted Date The student's start or enrollment date. 2015-12-01
DateWithdrawn Date The student's withdrawn date. 2015-12-02
ReasonWithdrawn A128 The student's withdrawn reason. Reasons
GradDate Date The student's graduation date. 2020-10-05
GradDegree A128 The student's graduate degree. AAS
GPA Double The student's GPA. 3.2
AccumHours Double The student's total accumulated hours. 46
Fund A80 The student's fund. Federal Work Study
Pronouns A80 The student's preferred pronouns. He/Him/His
CustomData1-X A80 Custom fields, available for any purpose. Multiple custom fields can be used. ?
Available Registration Import Fields
Name Type Required Description Example
Course.Subject A40 Yes The subject in which the student is enrolled. ACTG
Course.Course A20 Yes The course number. 100
Course.Title A120 {Yes} The name of the course in which the student is enrolled. The course title is only tied to the subject, such as "ACTG100". Required if Section.Title is not imported. Intro to Accounting
Section.Title A120 {Yes} The name of the section in which the student is enrolled. This overrides the course title if provided, allowing different sections to have unique titles. Required if Course.Title is not imported. Intro to Accounting
Section.Code A80 {Yes} The section code. Required if Section.CRN is not imported. 03
Section.CRN A80 {Yes} The unique course reference number (cannot be reused). Required if Section.Code is not imported. 123456789
Section.Custom1-X A80 Optional custom fields relating to this section. Multiple custom fields can be used. ?
Term.Code A80 Yes Term number for this enrollment. 2022SP
Term.ActiveFrom Date (Yes) Active start date. Required to use max appointment rules, center status, and term dates in reports. 2022-10-01
Term.ActiveTo Date (Yes) Active end date. Required to use max appointment rules, center status, and term dates in reports. 2022-12-31
Faculty.OtherID A80 [{Yes}] Faculty ID. Required if another identifier is not imported, such as email or username. J25059
Faculty.FirstName A80 [Yes] Faculty First Name. Jane
Faculty.LastName A80 [Yes] Faculty Last Name. Doe
Faculty.UserName A80 [{(Yes)}] Faculty Username. Required if another identifier is not imported, such as ID or email. Required if faculty need to login to TracCloud. JDoe
Faculty.Salutation A40 Faculty's salutation. Dr.
Faculty.Department A60 Faculty Assigned Department. M262
Faculty.Phone A80 Faculty's phone number. 555-555-5555
Faculty.Email A120 [{(Yes)}] Faculty's email address. Required if another identifier is not imported, such as ID or username. Required for faculty to receive emails. jdoe80@school.edu
Faculty.Custom1-X A80 Faculty custom fields. Multiple custom fields can be used. ?
Student.ID A40 Yes The ID/OtherID of the student this registration is assigned to. A123456789
Registration.Grade A40 The final grade/withdraw code for this registration. Redrock will require a list of possible grades/codes to properly set this up. B+
Registration.RegStatus A40 An optional registration status that can be used to deactivate certain enrollments. Dropped
Registration.ValidFromDT Date (Yes) The start date of the registration. Required to activate registrations by date instead of term. 2023-08-15
Registration.ValidToDT Date (Yes) The end date of the registration. Required to activate registrations by date instead of term. 2023-12-15
Registration.Custom1-X A80 Registration custom fields. Multiple custom fields can be used. A common example would be midterm grades. ?
Section Schedule Import Fields [Optional]
Name Type Required Description Example
Course.Subject A40 Yes The subject. MAT
Course.Course A20 Yes The course number. 100
Section.Code A80 {Yes} The section number. Required if Section.CRN not provided. 45
Section.CRN A80 {Yes} The course reference number. Required if Section.Code not provided. 123456789
Term.Code A80 Yes The term code. 2022SP
Schedule.Days A30 Yes Days of the week, formatted as MONTUEWEDTHUFRISATSUN. MONFRI
Schedule.Time Time Yes Schedule start time, military/24-hour format. 13:00:00
Schedule.Duration Duration Yes The duration of this section schedule in minutes. 50
Retrieved from "https://wiki.go-redrock.com/index.php?title=TracCloud:_Student_Data_Import&oldid=11729"