Integration with Learndash Reports

Resolved syew91
(@syew91)

4 years, 8 months ago

Hi admin/devs,

I loved your plugin a lot and so far it has been very helpful for me.
I ran into a small bump, and I was hoping that you could help me out. I am using your plugin, along side with LearnDash in my intranet. While I have a lot of information that is acquired when users register, I wanted to get some of the information to be displayed in LearnDash’s report when it generate the CSV. My question is, how do I make other plugins, in this case Learndash, to pull information from the User Registration plugin? (i.e. retrieving the registered data).

Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)

Thread Starter syew91
(@syew91)

4 years, 8 months ago
Additional information:
I can actually control the default WP information that goes into the report, with the following string:
```
function report_column( $column_value = '', $column_key, $report_item, $report_user ) {
			
			switch( $column_key ) {
				case 'user_id':
					if ( $report_user instanceof WP_User ) {
						$column_value = $report_user->ID;
					}
					break;

				case 'user_name': 
					if ( $report_user instanceof WP_User ) {
						$column_value =  $report_user->display_name;
						$column_value = str_replace("’", "'", $column_value );
						
					}
					break;

				case 'user_email':	
					if ( $report_user instanceof WP_User ) {
						$column_value = $report_user->user_email;
					}
					break;
```
But that is as far as I can get. By default, the WP_users are all tables within the phpmyadmin itself. Thus it is possible for me to retrieve it without sweat. Now the problem is, I can’t seem to be able to find any tables created by User Registration, thus I am not sure on where to retrieve it.
Sanjeev Aryal
(@sanzeeb3)

4 years, 8 months ago
Hello @syew91,

We are glad you liked our plugin. The extra information are stored in usermeta table in the database. You can get all the extra information registered by user registration plugin with this query:
```
global $wpdb;
$usermeta = $wpdb->get_results( "SELECT user_id, meta_key, meta_value FROM $wpdb->usermeta WHERE meta_key LIKE 'user_registration\_%';" );
```
Also, you can use the action hook user_registration_after_register_user_action, which provides 3 parameters to the callback function, $form_data, $form_d and $user_id
```
add_action( 'user_registration_after_register_user_action', 'ur_get_form_fields', 10, 3 );
function ur_get_form_fields( $form_data, $form_id, $user_id) {
     // get data here
}
```
Hope this helps. If you are still facing issues, We’ll look into the working process of LearnDash LMS.

Best Regards,
WPEverest Support
Sanjeev Aryal
- This reply was modified 4 years, 8 months ago by Sanjeev Aryal.
Thread Starter syew91
(@syew91)

4 years, 8 months ago

Hi Sanjeev,

Thanks for the explanation. And where would I put the lines into? Was it in the wp-include or user-registration plugin?

Thread Starter syew91
(@syew91)

4 years, 8 months ago

@sanzeeb3

Yo my man can I check with you on the top query?

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Integration with Learndash Reports’ is closed to new replies.

Views