meta data for this page
Welcome to the Accudemia Admin Import Selection Guide
The purpose of this guide is to help identify what imports are needed for your unique setup in Accudemia. The people who should follow this guide are the Center and College Administration so they can inform their SIS (Student Information Systems) data teams what type of imports are needed in Accudemia to make it work for their Centers and provides examples they can share. We hope that you'll find this guide beneficial and it will help get Accudemia implemented quicker by having just the data you need to be uploaded with a focused effort.
I need to report...
Use the expandable sections below to see the types of imports you'll need from your IT department or data support team based on each scenario. Each section you visit will help you build a list of imports for the IT/Data Team of the CSV extracts you need from them.
If you need this type of data in your reports, you'll need to import the Students, Courses with Classes, and Student Enrollment. See how each one looks below:
-
Students
FIRST MIDDLE LAST USER_ID ALT_ID PASSWORD EMAIL PHONE CELL_PHONE ADDRESS CITY STATE ZIP COMMENTS ACTIVE PHOTO Meccsha Ana Abbott 13207962 MAbbott MA7962 mabbott@mycollege.edu 3217668789 3217668789 456 James Road Oviedo Florida 32765 Freshman 1 13207962.jpg Thomas T Smith 35161613 TSmith TS1613 tsmith@mycollege.edu 3212140012 3212140012 7250 Red Bug Lake Rd. Oviedo Florida 32765 Senior 1 35161613.jpg Click here to download a sample CSV file.
For more explanation on each field please visit the Imports Guide on User Imports here.
Courses with Classes
NAME PREFIX CODE DESCRIPTION ACTIVE CRN SHORT_NAME POSTFIX OTHER COMMENTS CLASS_ACTIVE TERM_NAME START_DATE END_DATE Languages and Philological Science PSY 02L Explore Languages since 1200 BC. 1 35135 PSY-02L-01 01 3 Credits 1 Spring 2021 1/4/2021 5/28/2021 Physics of Astronomy SCI 04L Explore astronomic bodies & more with labs. 1 35133 SCI-04L-01 01 4 Credits 1 Spring 2021 1/4/2021 5/29/2021 Click here to download a sample CSV file.
For more explanation on each field please visit the Imports Guide on Subject Area (Courses) and Class Imports here.
Student Enrollment
STUDENT_USER_ID NAME CODE_PREFIX CODE CRN SHORT_NAME POSTFIX CLASS_ACTIVE TERM_NAME 13207962 Languages and Philological Science PSY 02L 35135 PSY-02L-01 01 1 Spring 2021 13207962 Physics of Astronomy SCI 04L 35133 SCI-04L-01 01 1 Spring 2021 35161613 Languages and Philological Science PSY 02L 35135 PSY-02L-01 01 1 Spring 2021 35161613 Physics of Astronomy SCI 04L 35133 SCI-04L-01 01 1 Spring 2021 Click here to download a sample CSV file.
For more explanation on each field please visit the Imports Guide on Subject Area (Courses) and Class Imports here.
If you need this type of data in your reports, you'll need to import the Instructors and their Instructor Assignments. See how each one looks below:
Instructors
FIRST MIDDLE LAST USER_ID ALT_ID PASSWORD EMAIL PHONE CELL_PHONE ADDRESS CITY STATE ZIP COMMENTS ACTIVE PHOTO Frank Sinatra 333555555 FSinatra FSinatra5555 fs@mycollege.edu 4757578272 3217668789 574 George Street New York NY 22363 Business Dept. 1 333555555.jpg Dean Martin 444555555 DMartin DMartin5555 dm@mycollege.edu 3151234567 3212140012 123 Main St. Las Vegas NV 41533 Business Dept. 1 444555555.jpg Sammy Davis 666555555 SDavis SDavis5555 sd@mycollege.edu 6843315344 456 Oak Terrace Chicago IL 68563 Business Dept. 1 666555555.jpg Joey Bishop 777555555 JBishop JBishop5555 jb@mycollege.edu 3216468766 7561 Ratner Pl. Atlantic City NJ 13254 Business Dept. 1 777555555.jpg Click here to download a sample CSV file.
For more explanation on each field please visit the Imports Guide on User Imports here.
Instructor Assignments
SUBJECT_AREA_NAME CODE_PREFIX CODE CRN SHORT_NAME POSTFIX CLASS_ACTIVE TERM_NAME INST_USER_ID Languages and Philological Science PSY 02L 35135 PSY-02L-01 01 1 Spring 2021 333555555 Physics of Astronomy SCI 04L 35133 SCI-04L-01 01 1 Spring 2021 444555555 Creative Writing ENG 101 56413 ENG-101-01 01 1 Spring 2021 666555555 English Comp I ENG 138 35131 ENG-138-01 01 1 Spring 2021 666555555 English Comp II ENG 228 53513 ENG-228-01 01 1 Spring 2021 666555555 BASIC MATH MAT 100 13513 MAT-100-01 01 1 Spring 2021 777555555 COLLEGE ALGEBRA MAT 110 96876 MAT-110-01 01 1 Spring 2021 777555555 STATISTICS MAT 150 50305 MAT-150-01 01 1 Spring 2021 777555555 CALCULUS I MAT 200 68168 MAT-200-01 01 1 Spring 2021 777555555 CALCULUS II MAT 220 68135 MAT-220-01 01 1 Spring 2021 777555555 Click here to download a sample CSV file.
For more explanation on each field please visit the Imports Guide on Subject Area (Courses) and Class Imports here.
If you need this type of data in your reports, you'll need to import the Students with Profiles and User Groups. See how each one looks below:
-
Students with Profiles
STUDENT_FIRST STUDENT_LAST STUDENT_USER_ID @Profile(1,1) @Profile(1,2) @Profile(1,3) Meccsha Abbott 13207962 Freshman Female Caucasian Thomas Smith 35161613 Senior Male Hispanic Click here to download a sample CSV file.
For more explanation on each field please visit the Imports Guide on User Profile/Demographic Imports here.
-
User Groups
USER_GROUP_NAME STUDENT_USER_ID Graduate Students 13207962 Graduate Students 35161613 Athletes 13207962 Athletes 35161613 Click here to download a sample CSV file.
For more explanation on each field please visit the Imports Guide on Optional Imports here.
If you need this type of data in your reports, you'll need to import the Tutors and Tutor Assignments. See how each one looks below:
-
Tutors
FIRST MIDDLE LAST USER_ID ALT_ID PASSWORD EMAIL PHONE CELL_PHONE ADDRESS CITY STATE ZIP COMMENTS ACTIVE PHOTO John Wayne 111555555 JWayne JWayne5555 JW@mycollege.edu 3217668789 3217668789 741 Winnie Way Oviedo Florida 32765 English Tutor 1 111555555.jpg Clint Eastwood 222555555 CEastwood CEastwood5555 CE@mycollege.edu 3212140012 3212140012 8529 Percipine Blvd. Oviedo Florida 32765 Math Tutor 1 222555555.jpg Click here to download a sample CSV file.
For more explanation on each field please visit the Imports Guide on User Imports here.
-
Tutor Assignments
SUBJECT_AREA_NAME SUBJECT_AREA_CODE_PREFIX SUBJECT_AREA_CODE TUTOR_USER_ID Creative Writing ENG 101 111555555 English Comp I ENG 138 111555555 English Comp II ENG 228 111555555 BASIC MATH MAT 100 222555555 COLLEGE ALGEBRA MAT 110 222555555 STATISTICS MAT 150 222555555 CALCULUS I MAT 200 222555555 CALCULUS II MAT 220 222555555 Click here to download a sample CSV file.
For more explanation on each field please visit the Imports Guide on Subject Area (Courses) and Class Imports here.
If you need this type of data in your reports, you'll need to import the Centers and Center Assignments. See how each one looks below:
-
Centers
CENTER_NAME CENTER_ACTIVE ALL_COURSES_AVAILABLE Writing Center 1 Yes Math Tutoring Center 1 No Click here to download a sample CSV file.
For more explanation on each field please visit the Imports Guide on Location Imports here.
-
Center Assignments
CENTER_NAME SUBJECT_AREA_NAME SUBJECT_AREA_CODE_PREFIX SUBJECT_AREA_CODE Writing Center Creative Writing ENG 101 Writing Center English Comp I ENG 138 Writing Center English Comp II ENG 228 Math Tutoring Center BASIC MATH MAT 100 Math Tutoring Center COLLEGE ALGEBRA MAT 110 Math Tutoring Center STATISTICS MAT 150 Math Tutoring Center CALCULUS I MAT 200 Math Tutoring Center CALCULUS II MAT 220 Click here to download a sample CSV file.
For more explanation on each field please visit the Imports Guide on Location Imports here.
If you need this type of data in your reports, you'll need to import the Classrooms and Course and Class Import with Instructor Assignments and Schedules. See how each one looks below:
-
Classrooms
CLASSROOM_NAME CLASSROOM_ACTIVE SI Room 101 1 SI Room 102 1 SI Room 103 1 SI Room 104 1 SI Room 105 1 Click here to download a sample CSV file.
For more explanation on each field please visit the Imports Guide on Location Imports here.
-
Course and Class Import with Instructor Assignments and Schedules
SUBJECT_AREA_NAME PREFIX CODE CRN SHORT_NAME POSTFIX DAYS START END CUT-OFF TARDY CLASS_ACTIVE CLASSROOM_NAME TERM_NAME Languages and Philological Science PSY 02L 35135 PSY-02L-01 01 Mon/Wed/Fri 19:00 20:00 30 10 1 SI Room 101 Spring 2021 Physics of Astronomy SCI 04L 35133 SCI-04L-01 01 Tue/Thu 20:00 21:00 30 10 1 SI Room 102 Spring 2021 COLLEGE ALGEBRA MAT 110 96876 MAT-110-01 01 Mon/Wed/Fri 14:00 15:00 30 10 1 SI Room 103 Spring 2021 Creative Writing ENG 101 56413 ENG-101-01 01 Tue/Thu 11:00 12:00 30 10 1 SI Room 104 Spring 2021 Click here to download a sample CSV file.
For more explanation on each field please visit the Imports Guide on Optional Imports here.
Typical All-in-One CSV File Import
As promised above we have a condensed version of all these individual imports that will get your Center and Services up and running quickly. Unfortunately, there are too many fields to display this import as a table on this page so we can only provide the CSV sample file and information about each field referenced in this file.
- Students with Profiles
- Instructors
- Courses (Subject Areas) and Classes
- Student Enrollment
- Terms (Semesters)
Click here to download a sample CSV file.
For more explanation on each field please visit the Imports Guide on Typical Single-File Import here.
Having trouble viewing the expandable sections? Then try this option without the code here. | Back to Admin Guides