History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: DISPL-292
Type: Bug Bug
Status: Open Open
Priority: Critical Critical
Reporter: Jaume Guillamon
Votes: 6
Watchers: 6
Operations

If you were logged in you would be able to see more operations.
DisplayTag

Export to Excel, PDf y RTF doesn't export all the LIST

Created: 22/Feb/06 04:39 AM   Updated: 25/Aug/08 02:32 AM
Component/s: Export
Affects Version/s: 1.1
Fix Version/s: 1.3

Time Tracking:
Not Specified

File Attachments: 1. Text File DISPL-292-displaytag-patch.txt (0.7 kb)
2. Java Archive File displaytag-good-1.1.1.jar (200 kb)
3. Java Archive File DisplayTag_1.1.ExportAll_Jaume.jar (206 kb)


Application server: Tomcat 5.0.28


 Description  « Hide
When I use the Export utility and I code the line <display:setProperty name="export.excel.export_amount" value="list"></display:setProperty>, or I use the propertites, displaytag only exports the PAGE (10 records), not the LIST. but it only happens when I export to EXCEL, PDf y RTF.

When I export to XML and CSV all runs fine (1604 records are exported).

Any of you with the same problem ?

Thx,
Jaume

 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Jorge L. Barroso - 22/Feb/06 07:24 AM
I'll have a look.

Bob Barney - 28/Feb/06 02:04 PM
I am also having this problem. I verified that adding the export filter does not help. This is a big problem, as I am currently writing a story about Displaytag for an online magazine, and I planned to highlight the export feature in the article. Please give this problem your highest attention.

Much thanks!

Stephen

Jorge L. Barroso - 28/Feb/06 04:30 PM
I'll have a solution soon.

The conflict lies in that the new Excel, PDF, and RTF table writers are meant to behave just as the HTML table writer does. So it defaults to observing the list size, sorting, and grouping of the html page to suport WYSIWYG exports. But the "legacy" exporting configuration properties should definitely be supported.

Perhaps, adding the following kind of functionality would be the best solution in the end. From: http://jira.codehaus.org/browse/DISPL-245
=======================================================
4. Export just the current page, a page range, or all data, especially if
   paging is used.
   The ui may look like this:

Export options: Excel | PDF | RTF | From: [1] To: [1] (default to this page Export options: Excel | PDF | RTF | From: [1] To: [max] (default to all)

Defaults to exporting what's on the page currently. Default would be
   configurable through property.
=======================================================

But for now the easiest solution might be to introduce non-WYSIWYG Excel, PDF, and RTF exports that simply obey all the "legacy" exporting config properties. Users can then choose one or the other.

Bob Barney - 09/Mar/06 06:17 PM
> But for now the easiest solution might be to introduce non-WYSIWYG Excel, PDF, and RTF exports that simply obey all the "legacy" exporting config properties. Users can then choose one or the other.

I am afraid that I don't know how to do this. Do you have any examples that I could mimic?

Stephen

Jorge L. Barroso - 26/Mar/06 08:55 PM
This patch makes WYSIWYG exports observe the export.amount config setting.

The distrubution default setting for export.amount is list. To export just the current page, change this setting to export.amount=page.

Jorge L. Barroso - 27/Mar/06 09:49 AM
The line numbers in the patch I submitted depend on the the patch for http://jira.codehaus.org/browse/DISPL-298 .

sujatha ganesh - 13/Jun/06 08:08 PM
I need this fix to export the whole list to excel. When will 1.1.1 version be released? I need the displaytag1.1.1.jar please.

Thanks
-S

Jorge Blázquez - 08/Mar/07 01:57 PM
Hi to all,

Jorge, is the jar file you have posted compiled with a 5.0 JVM?

I tried to replace the displaytag distribution with the jar you posted nad i got version incompatibilities issues.
Most exactly, this error: "java.lang.UnsupportedClassVersionError:(Unsupported major.minor version 49.0)"

Maybe I'm doing something wrong.

thanks in advance
Jorge

Jorge Blázquez - 08/Mar/07 01:59 PM
Sorry, it seems Celso posted the jar but was not able to see his message.

Javier D L - 09/May/07 11:51 AM
Hi.
i also have this error "java.lang.UnsupportedClassVersionError:(Unsupported major.minor version 49.0)", i need a jar that work with minor version that 49.0. i have a 1.4 java version, i think that the version of jvm is 48.0.
thanks
Javi

Javier D L - 15/May/07 05:36 AM
Fixed by Jaume,
This jar show all list in pdf
work with j2sdk1.4.2_07 and Tomcat 4.1

 thanks Jaume

fabio canepa - 06/Sep/07 04:52 AM
+ 1 for this patch. I've tested also on the trunk version and it seems to works...

Harry - 20/Aug/08 03:15 AM
Hi All,

I've just started using display tag Libraries. I successfully managed to do everything with the libraries. But now I'm having the same export problem as mentioned above. Can you please let me know how to handle this problem. Should I download the patch, that's mentioned here and then change my displaytag library jar version 1.1.1 to this jar file. Please advice.

The jar file that I'm using is more recent then the patch jar file mentioned here.

Thanks,
Harry

Jaume Guillamon - 25/Aug/08 02:32 AM
Hi Harry,

Just download my patch file.

I'm using java 1.5 and runs fine.

Best regards.