|
webtheorydesigns
|
July 11, 2023 at 9:00 pm
Hi EE4 Gurus,
I would like to know if its possible to create a report that pulls data from the registrations from EE4 and Courses in LearnDash.
We would like to build a report with the following parameters:
1. Type of Report: Dropdown – 2 options(Courses, Quizzes)
2. Venue: Checklist – 3 Locations (You can select all)
3. Time Range: Calendars (To, From)
4. Scheme: Checklist – 2 options (IRATA, SPRAT) or both
5. Level: Checklist – 3 options (Level1, Level2, Level3)
The report would need to be tied to the “Student” which in this case is the user who registered for the course through EE4 and Learndash.
The report would include details about the progress of the student.
Columns Example:
-First Name
-Last Name
-Scheme
-Level
-Course Progress – % completed
-Quiz Results – Not Taken, or % completed
Any help would be greatly appreciated.
LSaldana
|
|
Tony
|
July 12, 2023 at 5:51 pm
Hi there,
We don’t have this kind of reporting or anything similar that could be used to add the values to built into Event Espresso.
It would very likely be possible to do but would require something built from the group up with custom code from a developer.
You could try contacting one of the developers listed here:
https://eventespresso.com/developers/event-espresso-pros/
Those have experience working with Event Espresso and may be able to build this custom reporting for you.
|
|
webtheorydesigns
|
July 12, 2023 at 6:18 pm
Hi Tony,
Thanks for your answer. I know there is nothing natively built into EE4 to accomplish this.
Would you be able to point me to the Database tables that are used to connect Event Espresso with LearnDash? I am hoping that we could tie the student that way.
|
|
Tony
|
July 13, 2023 at 4:45 am
LearnDash themselves created the integration so I don’t have in-depth knowledge of how it works.
I know that have a custom table to store the course assignments for tickets:
{$wpdb->prefix}learn_espresso
The courses are stored on the user account and updated using:
ld_update_course_access( $user_id, $course_id, false );
Thats set when payment is complete.
This means they likely rely on the WP User integration add-on’s functionality of linking the EE_Attendee to the WP User account using the ‘EE_Attendee_ID’ user option value saved within the user.
Other than that you would need to work through the LearnDash and EE LearnDash integration add-on.
|
