TechImport

From Redrock Wiki

    The legacy Trac 4.0 version of TutorTrac/AdvisorTrac/FitnessTrac is no longer receiving updates and will be end-of-life in 2025. All Trac 4.0 customers are encouraged to migrate to TracCloud. TracCloud has been designed from the ground up for speed, power, and security. Click here to schedule a TracCloud demo or reach out to sales@go-redrock.com for migration pricing or contract details. For more details about the migration process, click here.



TracCloud
For over two decades, Redrock’s TutorTrac has been a trusted solution used by thousands of centers worldwide. Now, we have completely redesigned TutorTrac using the latest, most sophisticated development tools to bring you TracCloud. Rebuilt from the ground up, TracCloud has been rigorously tested and proven effective in real-world production environments for over four years.

This transformation began with a fresh foundation — a new database (MySQL), a cutting-edge web hosting platform (AWS on Apache), and a robust development environment (PHP). But the improvements don’t stop there. TracCloud features a sleek, modern user interface designed to be exceptionally intuitive and user-friendly, making it easier than ever to navigate and manage your operations. Plus, TracCloud is fully optimized for mobile devices, allowing users to access and utilize its powerful features seamlessly from anywhere. We are now hosted on Amazon Web Services and we are taking advantage of modern cloud security, alert monitoring, and performance monitoring with automatic scalability for on-demand needs.

We are also excited to introduce new modules designed to enhance your campus’s ability to support students effectively. TracInsights for predictive analysis, Wellness Check-ins, and Reflective Prompts empower your campus to stay connected with students across your district. These tools provide instant alerts when students are struggling, allowing you to respond swiftly. Additionally, our TracFlow Automations can initiate timely interventions and connect students with the appropriate services your campus offers, ensuring no student falls through the cracks.

Guided by invaluable customer feedback, we preserved the features that made TutorTrac and AdvisorTrac so popular while embracing an ambitious vision: How can we elevate every great feature from the 4.0 version to be ten times better in the TracCloud version?

We are confident we achieved that vision. TracCloud is now a more powerful, intuitive, and versatile system while remaining affordable for every level of your institution. Whether you are a small writing center using our software for just $2,500 per year, a large multi-center support services department for under $6,000, or an extensive district with multiple campuses utilizing our comprehensive retention bundle (call for pricing), we have the ideal solution to meet your needs.

Most importantly, we are deeply grateful for the ongoing support and loyalty of our customers over the past 25 years. Your feedback and trust have been instrumental in making TracCloud what it is today. As we look to the future, we are excited to continue innovating and finding new ways to make TracCloud even more powerful and effective as a retention tool for your campus.

Training and Assistance for Your Migration
We understand that migrating from your existing, proven solution to a new platform can feel daunting. To make this transition as smooth as possible, we offer personalized one-on-one training sessions and handle the data migration for you. Our team will seamlessly convert your TutorTrac data into the TracCloud format, scheduling both training and migration to ensure minimal downtime and disruption. More importantly, we will perform the training and migration at no additional cost to you.

Unparalleled Tech Support
Redrock has built a strong reputation for responsiveness and availability. Our team remains dedicated to providing the same top-tier, unlimited support that no other company in this industry can match. Our experienced professionals are ready to assist you via support ticket, email, or phone, often responding within hours—if not minutes—of receiving your request. Over the past 25 years, our reputation for stellar support has been well-proven, and we will continue to earn our place as the leader in higher education software through our unwavering commitment to excellence.

Annual Redrock Conference
We will continue to offer in-person training and exclusive previews of the latest features and modules of our software at our annual conference. Customers have consistently reported that this experience provides a valuable opportunity to connect with Redrock team members, network with peers in their industry, share experiences, and gain insights into best practices for using the TracCloud platform effectively at their campuses.

TracCloud: Enhanced Capabilities and Continuous Innovation
TracCloud has been completely rebuilt from the ground up, retaining all existing features while significantly enhancing their performance and usability. Our comprehensive suite of capabilities includes advanced reporting, intuitive scheduling, feedback surveys, online whiteboard meetings, early alert systems, text messaging, study table management, payroll tracking, resource check-in/out, workshop tracking, task management, success plans, terms and conditions waivers, support for unlimited centers, asynchronous appointments, custom fields, custom forms, custom views, work plans, certifications, instructor attendance tracking, testing center group appointments, watch lists, student photos, batch visits, Supplemental Instruction (SI) visit tracking, email templates, and batch emails. All of these powerful features have been further improved and seamlessly integrated with new functionalities, ensuring a more streamlined user experience.

A Modern, Mobile-Friendly Interface
The enhanced TracCloud system offers a responsive, mobile-friendly interface designed for convenience and accessibility. Students can effortlessly schedule appointments by scanning a QR code and tapping a button. Similarly, they can confirm their attendance at a center by scanning a QR code and pressing a single button, providing a smoother, more enjoyable user experience. Every component of TracCloud is now accessible through this sleek, user-friendly interface, enhancing efficiency for both students and administrators.

TracCloud Reporting System is Second to None
Our reporting system capitalizes on the data we receive and generate from the operations that TracCloud manages. Because of the data capture, our reports can comprehensively indicate what resources are needed and how operations can be streamlined to maximize the help that students receive. Reports can be generated automatically by all staff, and data results may be automatically exported on a daily or weekly basis. Reports may be securely emailed on an automated schedule to the people who need the results regularly and timely. Faculty can receive automated reports on student activities, research departments can obtain raw or summarized data indicating important trends, and center administrators can gather feedback on how students are being assisted. All reports utilize the sleek, user-friendly interface that TracCloud is now known for.

Commitment to Continuous Improvement
Since the launch of TracCloud nearly four years ago, we have remained dedicated to enhancing and expanding the platform. This year, we are introducing several new modules that are easy to incorporate into your existing configuration. The Predictive Analytics module helps identify and monitor at-risk students, while the Wellness Check-In module provides valuable insight into students’ emotional well-being. Additionally, our Reflective Prompts feature encourages students to reflect on their educational journey and the steps they are taking to achieve success. All functionalities can be integrated with our TracFlow automation module, enabling timely early alerts and automated student interventions. The newly introduced AI MoodMeter field links allow proactive identification of students who may require additional support. These enhancements are just the beginning, with many more planned for release throughout the year.

TracCloud: An Enterprise Solution that still works for smaller Centers
TracCloud supports single, small centers with limited budgets while providing powerful scalability for large districts with multiple campuses. Our modular approach allows institutions to add features and functionalities as needed, seamlessly integrating them into a cohesive, robust, and user-friendly system. TracCloud continues to provide a comprehensive solution tailored to meet the evolving needs of institutions of all sizes.

A Commitment to a Holistic Approach to Student Well-Being
TutorTrac has historically been a center operations management tool. Our latest improvements with the new TracCloud have focused on the student experience and how centers truly help students succeed. Future modules of TracCloud will strengthen the connection between centers, students, and faculty, while also providing tools for Deans, Provosts, and VPs to oversee the integration of student support services from a high-level perspective. With our extensive experience in center management and student support, TracCloud is uniquely positioned to provide these essential reporting capabilities, thanks to our ability to gather data directly from the source.

Now, we proudly introduce TracCloud — our latest innovation in student retention and engagement, designed to streamline the management of your learning, writing, advising, or other support centers on your campus.

New, easy to use interface
TracCloud features a modern, easy to use, and mobile-friendly interface, allowing you to easily find and manage your data as you need. Students, staff, and faculty will have a much easier time navigating through the system and accessing the data they need. The new dashboard offers many easy to access widgets to view and manage your data.



New Features
Export almost any report into Excel. Static and dynamic QR codes for touchless-kiosk environments. Unlimited custom data fields in student records, visits, appointments, and more. Customizable views of listing pages. Student timelines. Twig and HTML-supported emails and system messages. Customizable log listing and kiosk views. Center descriptions. New reports. Student success plans as a new module, along with work plans for staff. The full list of changes couldn't fit in this article, and more is being added all the time. Relating to the schedule specifically, you'll find a new appointments listing, availability badges, custom search appointment links and QR codes, unlimited customizable max appointment rules, asynchronous appointment support, and more.



Customizable
With Twig support, you can personalize system messages, upcoming appointment lists, emails, and more based on the users who are viewing/receiving them. From simple changes like greeting the user by name to completely changing an email based on if the related appointment was in-person or online, in a certain center, for a certain reason, even if a certain custom field in the student's profile has a specific value. This extends to the log listing and kiosks as well, where you can add or remove fields, rearrange the data that's displayed, and add custom formatting with HTML and Twig.



Faster
Rewritten from the ground up hosted on AWS, using a MySQL database, TracCloud is faster in every way. This performance increase compared to TutorTrac or what we now call Trac 4.0 can be noticed throughout the entire system, with reports being especially improved. Even the biggest reports in TracCloud load within a few seconds.



Migrate Existing Data
Migrate your existing data from Trac 4.0, allowing you to pick up right where you left off. We'll work with you to plan out your migration, coordinating with your IT, and training your system administrators to get you started in TracCloud.



Although we now bid the old TutorTrac a fond farewell this year, we appreciate how successful it was for so many centers around the world. The new, easy to use interface of TracCloud will make our current TutorTrac users happy to move to this new version. Moreover, our support team will make the transition easy and painless!

Click here to schedule a TracCloud demo!


Tech Documentation

• Installation

• Windows DEP

• Service Setup

• TLS Encryption

• Mail Server

• SSO Authentication

• Data Imports

• Barcode Scanners

• Trac 4.0 Updates

• Migrating to TracCloud


Import Student, Course, and Instructor Information

The Trac application can import data from any source as long as it is provided in the correct format. The data needs to be provided in a flat file format, tab or comma delimited are preferred. The Trac application will not import data from Excel files. The order and delimiter of the fields is completely up to your preference. However, the format, order, and delimiter of the fields must remain consistent with every import.


Using your current registrar’s Student Information System (such as Banner, PeopleSoft or DataTel) as a source, create files to be imported into your Trac System. We prefer two files - a student file (e.g., "TracStudents.csv") and a course enrollment file (e.g., "TracCourses.csv"). Create sample files with 5-10 lines of data and header rows with the fields you would like to import. Send us this sample data and we will create a custom import script for your Trac System to import data from these files. Once our script is ready, you will need to either place the import files in your Trac System's Import folder on the server itself or upload these files to our SFTP server (if hosted). We will then work with you to determine an automatic import schedule going forward.

Description of Import fields

Code Field Types
A## Alpha field of a certain maximum length (you do not have format to this length)
#L Long Integer (-2.1 billion to +2.1 billion)
#R Real Value (decimal # with 12 digits precision)
# Small Integer (-32676 to +32676)
B Boolean (Yes/No)
D Date (mmddyyyy or yyyymmdd or mm/dd/yyyy), please specify format utilized



Student Import Fields

Name Type Required Field Description
ID #L Yes The unique numeric ID of the student. This needs to be in the first column of the import file.
Other ID A40 * A secondary ID (or barcode) for the student - may be required if you plan on utilizing a barcode scanner or magnetic card reader to sign in your students
Last Name A60 Yes The last name of the student
First Name A60 Yes The first name of the student
Middle A20 The middle name/initial of the student
Street Address A80 The street address of the student
City A50 City of the student address
State A2 The state code of the student address
Zip A10 The zip code of the student address
Email A80 * The email address of the student - required if you plan to send emails to your students, including automatic appointment reminders
Full Name A80 The student name formatted as Last, First Middle. If the rest of the import file is comma or tab delimited, this field will need to be surrounded with quotes (e.g., "000001,"Last, First Middle",FirstName,LastName,...").
Home Phone A20 The student home phone number
Work Phone A20 A secondary phone number for the student
Gender Male B The gender of the student is stored as a boolean - the only options are Male or Female and all students default to Female
Birthdate D The student birthdate
Ethnicity A80 Ethnicity (could be a code or complete name)
Grad Und A80 A code that indicated Graduate or Undergraduate (usually "G" or "U")
College A80 What college the student is attending
Class A80 The student's class: Freshman, Sophomore, etc. or FR, SO, JR, SR or 2003, 2004, etc.
Cohort A80 Used to custom group the student records. Use of this field is determined by the TutorTrac administrator.
Major A80 The student's major. May be a code or complete description.
Handle A60 * The student's username to log in to your Trac application online - required if you plan to log students in through LDAP, Active Directory, or Single Sign-On
Password A40 The student's local password to log in to the Trac System. This is typically excluded in favor of a single sign-on solution.
ReferredBy A80 Who referred the student to the center.
Degree Goal A80 Either the Degree Earned or the Degree Goal.
Overall GPA #R The Overall GPA for the Student (EMCCGPA)
Total Hours #R Total Accumulated Hours for the Student (BMI1)
HS Name A30 Name of the High School Attended
Custom Field1 A80 A custom field that may be used for any purpose.
Custom Field2 A80 same as above
Custom Field3 A80 same as above
Custom Field4 A80 same as above
Custom Field5 A80 same as above
Custom Field6 A80 same as above
Custom Field7 A80 same as above
Custom Field8 A80 same as above
Custom Field9 A80 same as above
Special Status A80 A student status field: may be a code or description.



Registration Import Fields

Name Type Required Description
Student ID #L Yes The unique numeric ID of the student. In some cases the ID is the secondary alphanumeric ID - please indicate to us which ID will be utilized.
Course Subject A40 Yes The course in which the student is enrolled
Course Section A40 Yes The section in which the student is enrolled
Course Title A80 Yes The name of the course in which the student is enrolled
Term # Yes The term code for the semester that the student is enrolled in: 032 might be the year 2003 Spring, and 034 might be the year 2004 Summer.
Instructor ID A20 * Unique identifier to find and create unique faculty instructors
Instructor First Name A40 * The first name of the course instructor
Instructor Last Name A40 * The last name of the course instructor
Instructor Email A80 * The Email address of the instructor - required if sending automatic emails to instructors
Instructor Phone A20 The phone number of the instructor
Instructor Sal A8 The Salutation or Degree for the instructor (Phd, etc.)
Instructor Username A20 * The instructor's username to log in to your Trac application online - required if you plan to log faculty in through LDAP, Active Directory, or Single Sign-On
Course Grade A20 The Grade received for this course.
Value # The Numeric grade value
Date D Date grade/report issued.
Type A40 The report type (midterm, final, etc.) In some cases it is simply a flag used by the system to indicate the disposition of the course (REGISTERED, DROPPED, WITHDRAWN).


Registration Date Range

Name Type Required Description
Date Begin D MM/DD/YYYY – date the course begins
Date End D MM/DD/YYYY – date the course ends


If you plan on using the optional Class Schedule feature, click the "Expand" button to view the additional fields available.

Registration Import Fields With Class Schedule
Name Type Required Description
Date Begin D Yes* MM/DD/YYYY – date the course begins
Date End D Yes* MM/DD/YYYY – date the course ends
Monday A2 Yes* Populate with “MO” if the class is in session on Monday.
Tuesday A2 Yes* Populate with “TU” if the class is in session on Tuesday.
Wednesday A2 Yes* Populate with “WE” if the class is in session on Wednesday.
Thursday A2 Yes* Populate with “TH” if the class is in session on Thursday.
Friday A2 Yes* Populate with “FR” if the class is in session on Friday.
Saturday A2 Yes* Populate with “SA” if the class is in session on Saturday.
Sunday A2 Yes* Populate with “SU” if the class is in session on Sunday.
Start Time A6 Yes* ##:## - Time of day the individual class begins. Military time is preferred.
End Time A6 ##:## - Time of day the individual class ends. Military time is preferred.
Duration # Yes* Number of minutes the individual class is in session. (Class start time minus class end time).

*Only required if you're planning on using the Class Schedule feature.


Manually Running the Import

Go to Trac Navigation > Trac Man > Utilities and Prefs > Auto Events.



Click on the Link for the “Auto Import” Event. This will open the Event Entry screen.

To configure the auto event to run on a scheduled basis, check the "is Pending" box, set the schedule (Daily, Weekly, Monthly), set a time, and save.


You can also manually start the import a single time by clicking on the green execute button on the right side.


In addition you can also run the import and check on its status from the Custom Utility tab. Set the category to "Standard" and choose "Import Student Data" or "View Import Status".

This will display information on your most recent import.

← Previous Page Next Page →
Retrieved from "https://wiki.go-redrock.com/index.php?title=TechImport&oldid=9827"