Serialized array's should be correctly displayed in the CSV

[fw25]

Serialized array's are not converted to usable data in the result CSV

This is easily realized by changing user-export-with-their-meta-data/includes/class-wp-users.php

Add after line 102

public static function is_serial($string) {
    return (@unserialize($string) !== false);
}

On line 99, replace

$user_rows[ $record->user_id ][ $record->meta_key ] = $record->meta_value;

with

if ($this->is_serial($record->meta_value)) {
  $temp="";
  $space="";
  foreach (unserialize($record->meta_value) as $tempArray) {
    if (is_array($tempArray)) {
      $temp.=$record->meta_value.$space;
    } else {
      $temp.=$tempArray.$space;
    }
  }
  $user_rows[ $record->user_id ][ $record->meta_key ]=$temp;
} else {
  $user_rows[ $record->user_id ][ $record->meta_key ]=$record->meta_value;
}

Only the first level values of the array's are being converted. All the other levels remain untouched

With kind regards,

Felix Wagemakers

[loureirorg]

Thanks for reporting this and taking some time to develop a solution, Felix.

I will look at this later. It would be great to extract the serialized data, but I'm not sure what's the best way to display it. Your solution uses a space as a separator which is a good option, but I would like to check other options before deciding. For example, an alternative would be to put each unserialized item in a different column. I will check other "export-to-CSV" plugins to see how they handle serialized data, maybe this will give some insights, and I will think more about it.

Thanks again!