list issues - filters + export

[arie]

Hello,

I'm under 3.0.9. and I've found these issues on a list view:

• If I use the advanced filter, and use one field (or more) to filter followed by an export
  • csv: i get a popup saying: no records to export
  • pdf: i get a sentence on the pdf saying no records
• In the same way, if I use a date filter and fill in the 2 date fields from -> to followed by an export:
  • csv: doesn't work
  • pdf: I get this error DateTime::__construct(): Failed to parse time string (31/07/2013 00:00:00) at position 0 (3): Unexpected character

Finally, the delete buttons (list view): if I select 2 records and click on one of the 2 rows delete buttons

• will prompt fo deleting the two records instead of deleting only just the one on the same row where the button is

 

[cheesegrits]

Can you give me a screenshot of your CSV settings, under the Publishing tab for the List.

If you set your list date format to Y-m-d, does it still bloew up with that DateTime::_construct) error?

-- hugh

 

[arie]

Here is the screenshot.

If i set the date format as you advised, the second bullet issue is fixed!

 

[arie]

Friendly bump

 

[arie]

friendly friendly bump, these issues are very important

 

[arie]

BYW, I'have found something similar in that thread
http://fabrikar.com/forums/index.php?threads/ill-go-crazy-with-error-500.28231/

BUMP

 

[rob]

I tested on a very simple list and couldn't replicate the issue. Is the list on the mycerfa site and if so which list id is causing the issue? Also what specific advanced search are you perfoming before the export?

 

[rob]

equally I tested with the date range filter and the csv export worked, so it must be a specific setting on your site which is different to that which I am testing

 

[arie]

1/ Here is a screencast related to the advanced search issue:
http://screencast.com/t/ev8I3T211HF

2/ Here is a screencast related to the date filter issue:
http://screencast.com/t/JJxcvnCBO5
When I change the current list date format of the filtered element from %d/%m/%y to %Y-%m-%d, the bug disappears.

On both example, the list id is 6.

 

[rob]

for the pdf export the error I see is "ID liste incorrecte" because your custom list template is hacking the pdf url and not including the list id.
If I manually change the url from
/component/fabrik/list?format=pdf&resetfilters=0

back to the URL fabrik builds itself

/component/fabrik/list/6?format=pdf&resetfilters=0

then the pdf exports as expected
So you will need to fix your template code.

As an aside its always worth checking a possible bug with a default Joomla template and a default Fabrik template, to remove the extra uncertainty that they add to the rendering


For the CSV export after a standard date range filter, a fix should be available with this commit
https://github.com/Fabrik/fabrik/commit/f5389278b81e0c6b9cb54e46adbcc898fb9a25e5


I can replicate the advanced filter and csv export issue on your test site. I'm working on that one at the moment

 

[rob]

the advanced filter issue should be fixed with this commit

https://github.com/Fabrik/fabrik/commit/b1f527d5cd6134f4d20e18ad70482cd8edabc597

 

[arie]

I have applied this fix
https://github.com/Fabrik/fabrik/commit/f5389278b81e0c6b9cb54e46adbcc898fb9a25e5
but now I get a js error in addition to the visualisation calendar that isn't loaded.
If i undo the changes applied to this js file (/media/com_fabrik/js/listfilter-min.js), it comes to normal.
Please see the attachement

About the pdf export, if i use the standard code (default_buttons.php), I get a blank screen. The generated link (for the default template) is:
/promises/list/6/pdf?format=pdf&resetfilters=0

The blank screen becomes Parse error: syntax error, unexpected 'version' (T_STRING) in /home/mycerfa/www/libraries/dompdf/include/dompdf.cls.php(586) : eval()'d code on line 1

 

[arie]

friendly bump

 

[arie]

friendly bump

 

[rob]

i believe the issue with the listfilter js was fixed with https://github.com/Fabrik/fabrik/commit/c445fa0c21f12c87016ae9bffe45e47bbd806283

About the pdf export, if i use the standard code (default_buttons.php), I get a blank screen. The generated link (for the default template) is:
/promises/list/6/pdf?format=pdf&resetfilters=0

I'm not seeing that URL If I go to the promises page: /promises/
the PDF url is /promises/list?format=pdf&resetfilters=0

which does export the pdf. From what page is the link /promises/list/6/pdf?format=pdf&resetfilters=0 being generated?

 

[arie]

I have applied the default link now. You can test it again on the copy site but it raised a bug! (I have added the datas in "my sites")

BTW, I have implemented 2 links to access the same list:
/promises => the generated pdf link is /promises/list/6/pdf?format=pdf&resetfilters=0
/promises/list => the generated pdf link is /promises/list/list/6/pdf?format=pdf&resetfilters=0

try also by using the date filter range

 

[arie]

friendly bump

 

[rob]

I couldnt log in to the copieprod site's admin with the user details provided in "my sites" could you double check that I have access and that the account details are correct?

 

[arie]

ok, so updated. There 2 accounts there, front and Back.

 

[rob]

It could be an issue with the SEF settings you have on plus the fabrik router.
The simplest solution would be to use a URL that is not sent through Joomla's router.
So in your custom template use:

<a href="index.php?option=com_fabrik&amp;view=list&amp;format=pdf&amp;listid=6&amp;resetfilters=0&amp;Itemid=204">
<img src="media/com_fabrik/images/pdf.png" class="fabrikTip fabrikImg" title="" alt="Exporter en PDF"><span>Exporter en PDF</span>
</a>