Non-unique meta fields

@ntd – you can download and try with the latest development version hosted on github – https://github.com/qstudio/export-user-data

Please let us know any feedback here and we’ll try and get this fixed up.

Hey,

Thanks, but it’s still only exporting one line.

So what I have in the db in the wp_usermeta table are distinct rows with the same meta_key value (and user_id value), but different umeta_id values (and meta_value values).

What I get in the Excel file is just the meta_value of the row with the lowest umeta_id.

Hope this helps and thanks for the effort!

If you check the plugin code on export-user-data:1575 you will see a new method:

known_arrays()

This returns an array of meta fields which are known to contain arrays of data – it’s a bit of a hack for now – this returned array is filterable – so you could add something like to following to your functions.php ( untested code.. ):

function my_export_user_data_known_arrays( $array ) {
    return array_push( $array, 'my_user_meta_key' );
}
add_filter( 'export_user_data_known_arrays', 'my_export_user_data_known_arrays' );

Where “my_user_meta_key” is the key that you know contains an array of data.

The code above is untested and will need some changes – read here for more info on using filters:

https://code.tutsplus.com/tutorials/writing-extensible-plugins-with-actions-and-filters–wp-26759

As I mentioned, this is likely a short term fix, for an odd bug – but if it works, please let us know.

The value itself is not an array (the value of meta_value), so this doesn’t work – it throws a PHP warning:

“PHP Warning: in_array() expects parameter 2 to be array, integer given in”

I’ll try to explain myself more clearly. Here’s my wp_usermeta table:

umeta_id | user_id |       meta_key     |    meta_value
--------------------------------------------------------------
      1       |    966    | wpcf-something | A string
--------------------------------------------------------------
      2       |    966    | wpcf-something | Another string
--------------------------------------------------------------
      3       |    966    | wpcf-something | One more string
--------------------------------------------------------------

In the export options, I’ve selected ‘wpcf-something’ as a field to be exported. Only ‘A string’ appears in the exported Excel file, under the column ‘wpcf-something’.

Unfortunately I don’t really have time at the moment to go through your code (I’ll gladly help later), but you don’t seem to use ‘get_user_meta’, which directly supports non-unique meta keys.

The plugin uses get_users, which itself uses WP_User_Query – this is the source of the issue, in regards to your question – because the user meta data is returned from this function call.

We might need to change this to return specific user_meta fields to see if this deals more correctly with keys which have non-unique values.

But, like you – we don’t have a lot of free time at present to look into this further.

When we do, I’ll be sure to upload an update to github – when it’s good, we’ll push it to wp.org.

Q

Cool, I ended up just modifying your plugin to include another filter that uses get_user_meta when applicable, with the same logic you provided.

public function known_not_unique() {

    return apply_filters( 'export_user_data_not_singular', array() );

}

// check if field is known not to be unique
if ( in_array ( $field, $this->known_not_unique() ) ) {

    $value = get_user_meta($user->ID, $field, false);

}

and in my functions.php

function my_export_user_data_not_singular( $array ) {
    array_push( $array, 'wpcf-keskeiset-something' );
    return $array;
}
add_filter( 'export_user_data_not_singular', 'my_export_user_data_not_singular' );

BTW there’s a slight error with your code example, array_push returns the number of items in the array, not the array itself ??

So this works for me know.

Thanks!

Good news – that’s the most important!

Q

@ntd – we’ve pushed another update to github to try and address this issue, please can you try this and see if your exports run correctly and give us some feedback?

Thanks

Q