TracCloud: Data Export: Difference between revisions

From Redrock Wiki

No edit summary
No edit summary
Line 22: Line 22:


[[File:3265163.png|700px]]
[[File:3265163.png|700px]]
{| class="wikitable mw-collapsible mw-collapsed"
|+ Field Type Descriptions
|-
!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, <span style="color:red>formatted as YYYY-MM-DD</span>
|-
|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
|}
{| class="wikitable mw-collapsible mw-collapsed"
|+ Field Definitions
|-
! Column !! Type !! Description !! Example
|-
| ApptID || #B || Unique identifier for appointments || 123456
|-
| VisitID || #B || Unique identifier for visits || 123456
|-
| ScheduledBy || TBD || The user who booked this appointment || SysAdmin Dave Smith
|-
| ConfirmationSent || A3 || Whether or not a confirmation email was sent (stored as blank or 'Yes') || Yes
|-
| ReminderDateTime || Date || Legacy/Unused||
|-
| ReminderNeeded || A3 || Whether or not a reminder needs to be sent for this appointment (stored as blank or 'Yes') || Yes
|-
| RequestNotes || A65535 || Legacy/Unused ||
|-
| OtherNotes || A65535 || Student cancellation reason || Student cancelled for reason: Selected wrong date
|-
| SchedNotes|| A65535 || Legacy/Unused ||
|-
| DateIn || Date || The start date of this record || 1970-12-31
|-
| TimeIn || Time || The start time of this record || 13:00:00
|-
| TimeOut || Time || The end time of this record || 14:30:00
|-
| Duration || Duration || The duration of this record stored in minutes || 90
|-
| WaitTime || Duration || Wait time before start of visit stored in minutes || 5
|-
| TotalTime || Duration || Total visit time including wait time in minutes || 95
|-
| Weekday || A9 || Day of this record || Wednesday
|-
| Fund || A80 || Visit/Appointment funding source || FWS
|-
| Location || A255 || The location of this record || Room 14
|-
| Online || A3 || Whether or not this record is online (stored as blank or 'Yes') || Yes
|-
| StudentID || #B || Student identification number || 1234567
|-
| FirstName || A80 || Student's first name || Sam
|-
| LegalFirst || A80 || Student's legal first name|| Samantha
|-
| Middle || A80 || Student's middle name or initial || S
|-
| LastName || A80 || Student's last name || Smith
|-
| Status || A80 || Appointment status || Attended
|-
| OtherID || A40 || Student's alternate ID || A1234567
|-
| OtherID2 || A40 || Student's alternate alternate ID || ssmith567
|-
| Barcode || A80 || Student's barcode ID || 9876543
|-
| Email || A80 || Student's email address || ssmith@example.edu
|-
| Street || A80 || Student's address || 1234 N Example St.
|-
| City || A80 || Student's city || Phoenix
|-
| State || A80 || Student's state || AZ
|-
| ZIP || A10 || Student's zip code || 85210
|-
| Birthdate || Date || Student's birthdate || 1970-12-31
|-
| HomePhone || A20 || Student's home phone || 333-333-3333
|-
| WorkPhone || A20 || Student's work phone || 444-444-4444
|-
| CellPhone || A20 || Student's cell phone || 555-555-5555
|-
| Gender || A80 || Student's gender || Male
|-
| Ethnicity || A80 || Student's ethnicity || Caucasian
|-
| College || A80 || Student's college || Nowhere State University
|-
| DegreeGoal || A80 || Student's degree goal || AAS
|-
| Major || A120 || Student's major || accounting
|-
| Class || A80 || Student's class || SO
|-
| Cohort || A80 || Student's cohort || 2017SP
|-
| GradUndergrad || A80 || The student's graduate status || Graduate
|-
| GPA || Double || Student's GPA || 3.5
|-
| Hours || Double || Student's accumulated hours || 67
|-
| ConsultantFirst || A80 || Consultant first name || Dave
|-
| ConsultantLast || A80 || Consultant last name || Smith
|-
| ConsultantUserName || A80 || Consultant username || dsmith
|-
| ConsultantAlias || A120 || Consultant alternate name || D. Smith
|-
| ConsultantLocation || A255 || Consultant location || Room 14
|-
| Mailbox || A80 || Legacy/Unused ||
|-
| Center || A80 || Center Name || Learning Center
|-
| Reason || A80 || Reason Name || General Tutoring
|-
| Subject || A40 || Subject || MAT
|-
| Course || A20 || Course number || 300
|-
| Title || A120 || Course title || Introduction to algebra
|-
| Section || A80 || Section code || 04
|-
| CRN || A20 || Course Reference Number || 12345
|-
| Term || A80 || Term code || SU2022
|-
| SubjectSectionTerm || A250 || Combination of Subject, Course, Section, Term || MAT300 04 SU2022
|-
| Salutation || A80 || Faculty salutation || Dr.
|-
| FacultyFirst || A80 || Faculty first name || Jeff
|-
| FacultyLast || A80 || Faculty last name || Daniels
|-
| FacultyUserName || A80 || Faculty username || jdaniels
|-
| FacultyUserID || A80 || Faculty ID || F1234567
|-
| VisitNotes || A65535 || Visit notes, typically entered by consultant || Helped student with assignment
|-
| ScheduleNotes || A65535 || Legacy/Unused ||
|-
| StudentNotes || A65535 || Legacy/Unused ||
|-
| ExportDate || Date || Date of export || 1970-12-31
|}


<hr>
<hr>

Revision as of 10:40, 5 August 2022

TracCloud Technical Documentation

• Contents

• Mail Server

• Data Import

• Data Export

• Single Sign-on

• Custom URL

• SFTP SSH Keys

• Migration from 4.0


TracCloud Data Exports
This portion of our technical documentation covers the possible ways to export data from your Trac System. If you have any questions about this, you're more than welcome to reach out to us at helpdesk@go-redrock.com.

1. Reports

Applies to: Visits, Appointments, Availabilities, Payroll, Staff, Resource Usage, Referrals, Surveys.

Almost every report in TracCloud can be exported as a .CSV file. For Staff and Profile admins, this may be the preferred option for exporting data. For more information, take a look at our Reports Wiki.

2. SFTP Export

Applies to: Visits, Appointments.

If you're looking for a complete data export, or a scheduled export, this is where the Visit and Appointment Export utility comes in. The exports will be made available on our SFTP server (same location that you're uploading import files to). You have a few configuration options here, including how the data is formatted and when/what is exported. The files will be in a .csv format.

This option can be found in Other > Other Options > Visits/Appointments Export.

File:3265163.png

Field Type Descriptions
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
Field Definitions
Column Type Description Example
ApptID #B Unique identifier for appointments 123456
VisitID #B Unique identifier for visits 123456
ScheduledBy TBD The user who booked this appointment SysAdmin Dave Smith
ConfirmationSent A3 Whether or not a confirmation email was sent (stored as blank or 'Yes') Yes
ReminderDateTime Date Legacy/Unused
ReminderNeeded A3 Whether or not a reminder needs to be sent for this appointment (stored as blank or 'Yes') Yes
RequestNotes A65535 Legacy/Unused
OtherNotes A65535 Student cancellation reason Student cancelled for reason: Selected wrong date
SchedNotes A65535 Legacy/Unused
DateIn Date The start date of this record 1970-12-31
TimeIn Time The start time of this record 13:00:00
TimeOut Time The end time of this record 14:30:00
Duration Duration The duration of this record stored in minutes 90
WaitTime Duration Wait time before start of visit stored in minutes 5
TotalTime Duration Total visit time including wait time in minutes 95
Weekday A9 Day of this record Wednesday
Fund A80 Visit/Appointment funding source FWS
Location A255 The location of this record Room 14
Online A3 Whether or not this record is online (stored as blank or 'Yes') Yes
StudentID #B Student identification number 1234567
FirstName A80 Student's first name Sam
LegalFirst A80 Student's legal first name Samantha
Middle A80 Student's middle name or initial S
LastName A80 Student's last name Smith
Status A80 Appointment status Attended
OtherID A40 Student's alternate ID A1234567
OtherID2 A40 Student's alternate alternate ID ssmith567
Barcode A80 Student's barcode ID 9876543
Email A80 Student's email address ssmith@example.edu
Street A80 Student's address 1234 N Example St.
City A80 Student's city Phoenix
State A80 Student's state AZ
ZIP A10 Student's zip code 85210
Birthdate Date Student's birthdate 1970-12-31
HomePhone A20 Student's home phone 333-333-3333
WorkPhone A20 Student's work phone 444-444-4444
CellPhone A20 Student's cell phone 555-555-5555
Gender A80 Student's gender Male
Ethnicity A80 Student's ethnicity Caucasian
College A80 Student's college Nowhere State University
DegreeGoal A80 Student's degree goal AAS
Major A120 Student's major accounting
Class A80 Student's class SO
Cohort A80 Student's cohort 2017SP
GradUndergrad A80 The student's graduate status Graduate
GPA Double Student's GPA 3.5
Hours Double Student's accumulated hours 67
ConsultantFirst A80 Consultant first name Dave
ConsultantLast A80 Consultant last name Smith
ConsultantUserName A80 Consultant username dsmith
ConsultantAlias A120 Consultant alternate name D. Smith
ConsultantLocation A255 Consultant location Room 14
Mailbox A80 Legacy/Unused
Center A80 Center Name Learning Center
Reason A80 Reason Name General Tutoring
Subject A40 Subject MAT
Course A20 Course number 300
Title A120 Course title Introduction to algebra
Section A80 Section code 04
CRN A20 Course Reference Number 12345
Term A80 Term code SU2022
SubjectSectionTerm A250 Combination of Subject, Course, Section, Term MAT300 04 SU2022
Salutation A80 Faculty salutation Dr.
FacultyFirst A80 Faculty first name Jeff
FacultyLast A80 Faculty last name Daniels
FacultyUserName A80 Faculty username jdaniels
FacultyUserID A80 Faculty ID F1234567
VisitNotes A65535 Visit notes, typically entered by consultant Helped student with assignment
ScheduleNotes A65535 Legacy/Unused
StudentNotes A65535 Legacy/Unused
ExportDate Date Date of export 1970-12-31

3. Listing CSV Exports

Applies to: Students, Registrations.

The Student and Registration Listing both offer the ability to Export the current list to CSV. This will immediately start downloading your queried records to a .csv file in your browser.

8844377.png

4. Print or PDF Export

Applies to: Students, Student Timelines, Visits, Courses, Course Lists, Registrations, Sections, Documents, Faculty, Staff, Work Types, Appointment Requests.

On these listings, under the Hamburger icon (File:Hamburger.png), you'll find a print option. This can be used to either print the data or save it to a PDF file. In the case of the Student Timeline, you'll need to use your browser's print function (likely CTRL + P).

2792571.png

5. Starfish Export

Applies to: Visits.

We have an additional module available for purchase that provides a Starfish-compatible data export for your Trac System. For more information, reach out to sales@go-redrock.com.

Retrieved from "https://wiki.go-redrock.com/index.php?title=TracCloud:_Data_Export&oldid=5702"