Open nicocins opened 3 years ago
Hi @nicocins ,
I was faced with the same issue and found the following solution. Assuming you have Devices and DeviceStatuses tables. The following did help me:
$data = $this->Devices->find()
->select([
'Devices.id', 'Devices.name', 'Devices.ip_address',
'status' => 'DeviceStatuses.name'
])
->contain([
'DeviceStatuses'
]);
With 'status' => 'DeviceStatuses.name'
I was finally able to use the depending information and export it to csv.
And in the $_extract
array I put the following - as already mentioned in the doc:
$_extract = [
'Devices.id',
'Devices.name',
'Devices.ip_address',
function (array $row) {
return $row['name'];
},
Hope this helps
Thanks for your help ! i ll try !
It used to work in the older version, why is not working in this one? Need to update plugin so can work with associated models again.
We should add a note into the docs here I guess.
Dear all,
I have an issue when I export data with csvview.
I want to export data from two associated table :
When I export data from only one table (Details) it works, but when I add “Scans” table I got this message:
Notice (8): Array to string conversion [ ROOT\vendor\friendsofcake\cakephp-csvview\src\View\CsvView.php , line 333 ]
It’s like he s trying to display an array instead of my field Scans.nb_elements.
I check my variable $details and everything is ok.
Could you help me about this ?
Thanks in advance.