TracCloudTechImport: Difference between revisions
From Redrock Wiki
No edit summary |
No edit summary |
||
(9 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{{TracCloudGuideTabs}} | |||
<div class="tcWidgetPage"> | |||
<div class="category"> | <div class="category"> | ||
{{TracCloudTechTOC}} | {{TracCloudTechTOC}} | ||
</div> | </div> | ||
<b | <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. | 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. | ||
Line 13: | Line 15: | ||
File names must be static, with each import upload overwriting the previous copies of the files. | 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. | 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". | |||
</span> | </span> | ||
Line 25: | Line 28: | ||
Click the buttons below to view or download example files. The Section Schedule file is optional. | 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 | |||
|- | |||
| Failover || 44.228.245.56 | |||
|} | |||
|- | |- | ||
Line 34: | Line 52: | ||
|- | |- | ||
| style="vertical-align:top; font-size:100%; " | | | style="vertical-align:top; font-size:100%; " | | ||
{| | {| class="wikitable" border="1" style="margin:auto" | ||
!Type!!Description | !Type!!Description | ||
|- | |- | ||
Line 53: | Line 71: | ||
|- | |- | ||
| style="vertical-align:top; font-size:100%; " | | | style="vertical-align:top; font-size:100%; " | | ||
{| | {| class="wikitable" border="1" style="margin:auto" | ||
!Name!!Type!!Required!!Field Description!!Example | !Name!!Type!!Required!!Field Description!!Example | ||
|- | |- | ||
Line 143: | Line 161: | ||
|- | |- | ||
| style="vertical-align:top; font-size:100%; " | | | style="vertical-align:top; font-size:100%; " | | ||
{| | {| class="wikitable" border="1" style="margin:auto" | ||
!Name!!Type!!Required!!Description!!Example | !Name!!Type!!Required!!Description!!Example | ||
|- | |- | ||
Line 150: | Line 168: | ||
|Course.Course||A20||Yes||The course number.||100 | |Course.Course||A20||Yes||The course number.||100 | ||
|- | |- | ||
|Course.Title||A120||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".||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.||Intro to Accounting | |||
|- | |- | ||
|Section.Code||A80||Yes||The section code.||03 | |Section.Code||A80||Yes||The section code.||03 | ||
Line 187: | Line 207: | ||
|- | |- | ||
|Registration.RegStatus||A40||||An optional registration status that can be used to deactivate certain enrollments.||Dropped | |Registration.RegStatus||A40||||An optional registration status that can be used to deactivate certain enrollments.||Dropped | ||
|- | |||
|Registration.ValidFromDT||Date||*||The start date of the registration. Not strictly required, but highly recommended.||2023-08-15 | |||
|- | |||
|Registration.ValidToDT||Date||*||The end date of the registration. Not strictly required, but highly recommended.||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.||? | ||
Line 196: | Line 220: | ||
| style="vertical-align:top; font-size:100%; " | | | style="vertical-align:top; font-size:100%; " | | ||
{| | {| class="wikitable" border="1" style="margin:auto" | ||
!Name!!Type!!Required!!Description!!Example | !Name!!Type!!Required!!Description!!Example | ||
|- | |- | ||
Line 219: | Line 243: | ||
[[Category:TracCloud]] | [[Category:TracCloud]] | ||
</div> |
Latest revision as of 10:50, 16 April 2024
TracCloud Technical Documentation
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. 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.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Description of Import fields | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Available Student Import Fields | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Available Registration Import Fields | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Section Schedule Import Fields (Optional) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|