Export multidimensional array of objects as CSV

Question

I have an array $csvRows like the following. I want to export that array as CSV.

Array
(
    [0] => SingleModule Object
        (
            [module:SingleModule:private] => Module Object
                (
                    [name:Module:private] => SimpleXMLElement Object
                        (
                            [0] => some string
                        )

                    [position:Module:private] => SimpleXMLElement Object
                        (
                            [0] => 1000
                        )

                    [config:Module:private] => SimpleXMLElement Object
                        (
                        )

                )

            [moduleMeta:SingleModule:private] => ModuleMeta Object
                (
                    [description:ModuleMeta:private] => description text
                    [featureOrUseCase:ModuleMeta:private] => feature or usecase text
                    [inputParam:ModuleMeta:private] => input Parameter text
                    [changedParam:ModuleMeta:private] => changed Parameter text
                    [newOutputParam:ModuleMeta:private] => new Output Param text
                    [commentOrNote:ModuleMeta:private] => comments Or Note text
                )

        )

    [1] => SingleModule Object
         (etc...)

I have already tried the solution, which I found in this link. Here is my code sample:

$fileName = "../../data/modules.csv";
$output = fopen($fileName, 'w+');
foreach ( $csvRows as $file ) {
    $result = [ ];
    array_walk_recursive($file, function ($item) use (&$result) {
        $result [] = $item;
    });
    fputcsv($output, $result);
}
fclose($output);

Then I get the following error:

PHP Recoverable fatal error:  Object of class Module could not be converted to string ...in line where fputcsv is.

I have temporarily solved the problem by manually creating a straightforward array like the following, which I found in this link:

 $csvRows = array(
        array( 'row_1_col_1', 'row_1_col_2', 'row_1_col_3' ),
        array( 'row_2_col_1', 'row_2_col_2', 'row_2_col_3' ),
        array( 'row_3_col_1', 'row_3_col_2', 'row_3_col_3' ),
    );

But I want to export my actual $csvRows array of objects as CSV. I am a newbie programmer, so any suggestion and help would highly appreciated.

Hi, I have tried your suggestion like the following: $str = json_encode($csvRows); $csvRows = json_decode($str, true); $fp = fopen("../../data/modules.csv", 'w+'); foreach ( $csvRows as $column ) { fputcsv($fp, $column); } fclose($fp); but I only have an empty csv file. Any idea? — sumion
– sumion, Commented Sep 25, 2017 at 14:14

mega6382 · Accepted Answer · 2017-09-25 15:09:19Z

1

Try the following solution:

$str = json_encode($csvRows);
$csvRows = json_decode($str, true);
foreach ($csvRows as $file) {
    $result = [];
    array_walk_recursive($file, function($item) use (&$result) {
        $result[] = $item;
    });
    fputcsv($output, $result);
}

Just convert all those object to associative array. And then add the array to CSV. Use JsonSerializable interface on SingleModule class and configure the following method:

class SingleModule implements JsonSerializable {
//YOUR CODE
    public function jsonSerialize() {
        return get_object_vars($this);
    }
}

edited Sep 25, 2017 at 15:09

answered Sep 25, 2017 at 14:10

mega6382

9,39217 gold badges52 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

sumion Over a year ago

Hi, I have tried your suggestion like the following:

$str = json_encode($csvRows); $csvRows = json_decode($str, true); $output = fopen("../../data/modules.csv", 'w+'); foreach ( $csvRows as $file ) {     $result = [ ];     array_walk_recursive($file, function ($item) use (&$result) {         $result [] = $item;     });     fputcsv($output, $result); }

but I only have an empty csv file. Any idea?

mega6382 Over a year ago

@IqbalNazir it might be due to every property of the objects being private. you can't access it outside the class.

sumion Over a year ago

yes, you are right. It's working when I have changed access modifier to public. Thanks for that. But I want to keep them private, and also export them as CSV. Any idea?

mega6382 Over a year ago

@IqbalNazir for that have a look at ReflectionClass

mega6382 Over a year ago

@IqbalNazir I have provided a solution for this in my answer.

|

Collectives™ on Stack Overflow

Export multidimensional array of objects as CSV

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related