I want to be able to load a list of names into a course by using excel, is that possible?
excel
Forum Discussion
Yes, if you have the list in excel you can do an import into your child table.
I'm going to assume you have 3 tables.
Courses
Students
Enrollments
Each Course and Student will have many enrollments. This basically will connect your two tables.
Then you import your names into the enrollment table, and connect them to the student and course.
If you have more details I can provide more guidance, but I had to guess a lot.
I'm going to assume you have 3 tables.
Courses
Students
Enrollments
Each Course and Student will have many enrollments. This basically will connect your two tables.
Then you import your names into the enrollment table, and connect them to the student and course.
If you have more details I can provide more guidance, but I had to guess a lot.
Ok. I only have 2 tables, courses and participants (students). I am hoping to click on the "participants" option in the course and be able to upload an excel spreadsheet of my roster. I am trying to avoid having to go in one by one. Do I need to make another table for enrollments and then it will automatically connect it to the course? Along with all the course info that I have uploaded?
Maybe if I explain what I need it will help. :) We conduct leadership programs for military groups as well as corporations. We receive a list of up to 30 participants for each class with their emails so that we can send precourse work. What we are needing is a system to upload the scheduled courses and have the rosters, with all pertinent info saved within that course. We often need reports on certain levels of the course or what customer the course was provided for, such as Air Force, Army National Guard, Xator corporation etc. Or may need reports on all the classes for the year for a certain branch. We may also need to find something with only limited info, such as a participants name or what month they took the course. We are trying to find a way to not only store all our info, but also be able to pull certain reports quickly and easily. I am just now diving into this system and it seems it be useful for what we need. Any help you can provide will be greatly appreciated!!!
Maybe if I explain what I need it will help. :) We conduct leadership programs for military groups as well as corporations. We receive a list of up to 30 participants for each class with their emails so that we can send precourse work. What we are needing is a system to upload the scheduled courses and have the rosters, with all pertinent info saved within that course. We often need reports on certain levels of the course or what customer the course was provided for, such as Air Force, Army National Guard, Xator corporation etc. Or may need reports on all the classes for the year for a certain branch. We may also need to find something with only limited info, such as a participants name or what month they took the course. We are trying to find a way to not only store all our info, but also be able to pull certain reports quickly and easily. I am just now diving into this system and it seems it be useful for what we need. Any help you can provide will be greatly appreciated!!!
