Advanced pack - > List Report-> Get CSV

[info@jaguarsoft.com]

Hi There,

I need to export to CSV List Report . But there is no link 'Get CSV' like Grid Report.
Is there any reason not to export List report ?

Action-Export to CSV not useful, export all the columns..:-(

As far as I can see, EntryPoint->ReportAsCSV.php can support list Repost result , How can I add Get CSV forList Repor Result Set?

thnx & rgds

Selcuk

[yuri]

You can select all result and then Action > Export

[info@jaguarsoft.com]

Hi, I know but I get all the DB columns in that case and also gets only diso-played (20) records..

take it easy

[yuri]

I will look.

[yuri]

Will be fixed in the next update. Thank you.

[yuri]

You can download the new 1.6.1 version. It should work ok now.

[info@jaguarsoft.com]

Hi, Thanks for quick(est) response, but it looks same, I have Espo 3.7.0 & Adv 1.6.1, I rebuilt , clear cache(s) etc. It gets all columns and first 20 for Action-Export,
There is no Get CSV for List Report , FYI..

[yuri]

I just tested and it worked fine.

Select All result (from checkbox, not all shown cheboxes). And export. It exported to me more than 20 records.

[info@jaguarsoft.com]

Yes, I see hidden down arrow now, :-) , but still gets all DB columns not displayed cols.! am I missing something?
And also I have unicode problem on csv , is there any solved this issue ?

cheers,

Selcuk

[yuri]

It is designed such a way so it will export all columns.
Try to re-save exported fine in needed encoding. It should always export in UTF-8

[info@jaguarsoft.com]

Hi,
For excel UTF-8 Iproblem , I added Excel DOM to Espo/EntryPoints/Download.php as follows, Now Excel display Int. chars corerctly.. Just For Info.. ob_clean();
flush();
//***
if ($type === 'text/csv') echo"\xEF\xBB\xBF"; //selcuk Excel BOM for Windows

readfile($fileName);
exit;

[info@jaguarsoft.com]

For Column Filtering I try to get app->getContainer()->get('layout')->get($MyEntity,'list');
So could you give me some tip pls, How can I access the list Layout in Espo/Services/Record.php. ?
this->????->get($MyEntitiy,'list') or how can I get the container for $this in Record.php
thanks in advance

Selcuk

[yuri]

I don't understand what do you mean. maybe
$list = $this->getEntityManager()->getRepository('MyEntity')->order('createdAt', 'ASC')->where(array('status' => 'Hello'))->find();

[info@jaguarsoft.com]

Newer mind.! Igot it. I was trying to get list view selected columns for entity to filter CSV cols. I added container as injection. And then I get access to container - layout - list
Now I filter list view columns only. I added follwoiıng to Record.php now everything is ok. thanks. //selcuk get only my fields in CSV
if (!in_array($field, $fieldsToInclude)) {
continue;
}