Export filtered Data wont work

Hello,

 

What am I doing wrong when the exported data is never filtered? I always get just the whole Table in my csv instead of the filtered Data?

any suggestions?

 

In the isntalled Demo it works but i can't figure out what's the problem :(

 

best regards

GOT IT! BUT... ... there is

GOT IT! BUT...

... there is still a little problem left ;)

It was something in the Template files - but i can't explain it what it definitly was.
I copied the grid.tpl from the EASY sample and modified it.

 

BUT:
When I try to color the line with my workaround the excel export fails again (instead of the searched records all records are in the csv sheet)

...
         {elseif $counter is odd}
           <tr class=rowodd id={$form.name}-{$dataPanel.ids[$counter]} normal=rowodd select=rowsel
               onclick="CallFunction('{$form.name}.SelectRecord({$dataPanel.ids[$counter]},{$form.hasSubform})');">
         {else}
...
 

to

...
         {elseif $counter is odd}
           <tr  {foreach key=name item=cell from=$row}
                            {if $cell != ''}
                                 {if $name == 'fld_art'}
                               
                                    {$cell|replace:'<span STYLE=\'\' >':'class="rowodd '|replace:'</span>':'"'}
                                 {/if}
                            {/if}
                           {/foreach}  
                      id={$form.name}-{$dataPanel.ids[$counter]} normal=rowodd select=rowsel
               onclick="CallFunction('{$form.name}.SelectRecord({$dataPanel.ids[$counter]},{$form.hasSubform})');">          
         {else}
...

do you have an easy Solution for this "strange" solution?

For example {row.fieldname} - but i have no idea how to access the value in smarty

pleaaassee :)

 

best regards

 

 

EDIT!

Found it!!
A little Change in the foreach statement (in the template file - in my case grid_report.tpl located in common/templates - is an edited version of the grid.tpl file)

{foreach key=name item=cell from=$row}

to

{foreach item=cell from=$row}

but why? i don't know - but i think my workaround will help some users
 

 

This is a known issue.

This is a known issue. "name" seems to be a reserved keyword by smarty. DONOT use "name" as variable. If you update the grid.tpl from openbiz svn, you can see the change.

- support

Even when i create an new

Even when i create an new view (including forms and dataobjects) with the appbuiler i'm not able the export the filtered values (i have always ALL Values in the Excel-CSV)

Were can I check the form Class or mus i extend some values (or replace an entry, "easy" to "mymodulename") ?

 

best regards

As the demoapp works, there

As the demoapp works, there might be some special logic in your Form code. You can trace openbiz/service/excelService.php to check how the spreadsheet is exported.

- support

The demo works - I think it

The demo works - I think it is because form object save SearchRule in the session. Please check if your form class save SearchRule.

- support