Exporting to csv file with Doctrine and Symfony

Question

I'm working on exporting from a database table using Doctrine and symfony. I've made a call to my database with

$variableTable = Doctrine::getTable('Table Name')->findAll();

then I set another variable to get data from it like so:

$variable = $variableTable->getData();

I just want to be able to loop through that so I can pull the data I need to put into a csv file but I'm stuck on that part. For some reason, when I debug, it shows that the second variable that is getting set to the value of the getData is null/0.

I'm not sure if I'm missing something.

prodigitalson · Accepted Answer · 2013-07-19 15:21:45Z

11

I think maybe you are trying to call getData on the collection instead of calling getData on the record... But that doesnt make much sense because you are still going to have to call getData on each record, so you might as well just loop over the collection. Additionally its possible there were no results from your findAll for some crazy reason so you should take that into account i think. Anyhow code similar to the following has worked for me in the past so without the details of your code its the best i can offer:

$records = Doctrine::getTable('RecordName')->findAll();

if($records->count()) {
   $csvPath = '/path/to/csv/file.csv';

   $csvh = fopen($csvPath, 'w');
   $d = ','; // this is the default but i like to be explicit
   $e = '"'; // this is the default but i like to be explicit

   foreach($records as $record) {
       $data = $record->toArray(false); // false for the shallow conversion
       fputcsv($csvh, $data, $d, $e);
   }

   fclose($csvh);

  // do something with the file
}

edited Jul 19, 2013 at 15:21

answered Feb 21, 2013 at 18:17

prodigitalson

60.6k10 gold badges106 silver badges118 bronze badges

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

3 Comments

stuzzo Over a year ago

Nice solution, please modify fuputcsv to fputcsv.

Pierre de LESPINAY Over a year ago

How well does it work with large datasets ? Isn't it going to fill up the memory ?

prodigitalson Over a year ago

With large datasets I tend to batch them.

umpirsky · Accepted Answer · 2013-11-22 15:45:34Z

1

There are existing solutions for data import\export.

Consider using one of this:

answered Nov 22, 2013 at 15:45

umpirsky

10k13 gold badges75 silver badges96 bronze badges

Collectives™ on Stack Overflow

Exporting to csv file with Doctrine and Symfony

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related