ICEfaces
  1. ICEfaces
  2. ICE-1623

New ice:dataExporter component

          Details

          • Type: New Feature New Feature
          • Status: Closed
          • Priority: Major Major
          • Resolution: Fixed
          • Affects Version/s: None
          • Fix Version/s: 1.8RC1, 1.8
          • Component/s: ICE-Components
          • Labels:
            None
          • Environment:
            any

            Description

            Create a new component with displayTag's functionality of exporting a dataTable to csv, excel, etc.

              Issue Links

              depends on

              Improvement - An improvement or enhancement to an existing feature or task. ICE-2892 Allow ResourceDispatcher to serve explicitly-named Resources

              • Major - Major loss of function.
              • Closed

                Activity

                Ascending order - Click to sort in descending order
                Philip Breau created issue -
                Hide
                Permalink
                Ivan Hernandez added a comment -

                i think, this component could help to applications that contains reports, without the need of having another framework like JasperReports or JfreeReports into the project

                Show
                Ivan Hernandez added a comment - i think, this component could help to applications that contains reports, without the need of having another framework like JasperReports or JfreeReports into the project
                Michael Thiem made changes -
                Field Original Value New Value
                Support Case References https://www.icesoft.ca:4443/supportilla/show_bug.cgi?id=4151
                Hide
                Permalink
                tjohnson added a comment -

                Exporting datatable to csv will be sufficient.

                Show
                tjohnson added a comment - Exporting datatable to csv will be sufficient.
                tjohnson made changes -
                Support Customer Ref. #s 6734
                Ken Fyten made changes -
                Fix Version/s 1.7 [ 10080 ]
                Ken Fyten made changes -
                Fix Version/s 1.7 [ 10080 ]
                Hide
                Permalink
                Jim Boden added a comment -

                Might as well even leverage things like iText, jexcelapi, HSSF, jasper, etc.. No need to re-invent things, but the transparent linkages would be tremendous. PDF and CVS/XLS would be a great start.

                Show
                Jim Boden added a comment - Might as well even leverage things like iText, jexcelapi, HSSF, jasper, etc.. No need to re-invent things, but the transparent linkages would be tremendous. PDF and CVS/XLS would be a great start.
                Hide
                Permalink
                Philip Breau added a comment -

                prototype demo

                Show
                Philip Breau added a comment - prototype demo
                Philip Breau made changes -
                Attachment OutputExportComponent.war [ 10977 ]
                Hide
                Permalink
                Philip Breau added a comment -

                MyEclipse project

                • prototype uses a patched ICEfaces 1.7 version using suggested changes to ICE-2892, which allows FileResources to be dispatched using original file names
                • provides both CSV and Excel 97 (via jxl api) exports
                • is extendable via an 'outputHandler' attribute that can be bound to a custom class extending OutputTypeHandler. This class only needs to implement a few methods, such as header and cell creation, file creation, and setting the mimetype.
                • performs file creation only on demand
                Show
                Philip Breau added a comment - MyEclipse project prototype uses a patched ICEfaces 1.7 version using suggested changes to ICE-2892 , which allows FileResources to be dispatched using original file names provides both CSV and Excel 97 (via jxl api) exports is extendable via an 'outputHandler' attribute that can be bound to a custom class extending OutputTypeHandler. This class only needs to implement a few methods, such as header and cell creation, file creation, and setting the mimetype. performs file creation only on demand
                Philip Breau made changes -
                Attachment OutputExportComponent.zip [ 10978 ]
                Ken Fyten made changes -
                Link This issue depends on ICE-2892 [ ICE-2892 ]
                Hide
                Permalink
                Philip Breau added a comment -
                • now checks if the data has changed, and if so, resets
                • fixed exel output number cell bug
                Show
                Philip Breau added a comment - now checks if the data has changed, and if so, resets fixed exel output number cell bug
                Philip Breau made changes -
                Attachment OutputExportComponent.zip [ 10982 ]
                Ken Fyten made changes -
                Salesforce Case []
                Fix Version/s 1.8DR#3 [ 10143 ]
                Assignee Priority P2
                Assignee Adnan Durrani [ adnan.durrani ]
                Hide
                Permalink
                Ken Fyten added a comment - - edited

                The name for this component should be "ice:dataExporter" as it's similar to the dataPaginator in that it can be applied to a UIData component (eventually).

                Show
                Ken Fyten added a comment - - edited The name for this component should be "ice:dataExporter" as it's similar to the dataPaginator in that it can be applied to a UIData component (eventually).
                Ken Fyten made changes -
                Summary New Export component New ice:dataExporter component
                Salesforce Case []
                Affects [Documentation (User Guide, Ref. Guide, etc.), Sample App./Tutorial]
                Repository Revision Date User Message
                ICEsoft Public SVN Repository #18265 Fri Jan 30 13:47:47 MST 2009 adnan.durrani Fix for ICE-1623 (New ice:dataExporter component)
                Files Changed
                Commit graph ADD /icefaces/trunk/icefaces/component-metadata/src/main/resources/conf/ice/components/DataExporter-component.xml
                Commit graph ADD /icefaces/trunk/icefaces/component-metadata/src/main/resources/conf/custom/dataExporter-renderer.xml
                Commit graph MODIFY /icefaces/trunk/icefaces/component/src/com/icesoft/faces/component/outputresource/OutputResource.java
                Commit graph ADD /icefaces/trunk/icefaces/component/src/com/icesoft/faces/component/dataexporter/DataExporterRenderer.java
                Commit graph ADD /icefaces/trunk/icefaces/component-metadata/src/main/resources/conf/custom/dataExporter-component.xml
                Commit graph MODIFY /icefaces/trunk/icefaces/component-metadata/src/main/resources/conf/extended-faces-config.xml
                Commit graph ADD /icefaces/trunk/icefaces/component-metadata/src/main/resources/conf/ice_cust_properties/cust-dataExporter-props.xml
                Commit graph ADD /icefaces/trunk/icefaces/component/src/com/icesoft/faces/component/dataexporter
                Commit graph ADD /icefaces/trunk/icefaces/component/src/com/icesoft/faces/component/dataexporter/OutputTypeHandler.java
                Commit graph ADD /icefaces/trunk/icefaces/component/src/com/icesoft/faces/component/dataexporter/DataExporter.java
                Commit graph ADD /icefaces/trunk/icefaces/component/src/com/icesoft/faces/component/dataexporter/CSVOutputHandler.java
                Commit graph ADD /icefaces/trunk/icefaces/component-metadata/src/main/resources/conf/ice/renderers/DataExporter-renderer.xml
                Commit graph MODIFY /icefaces/trunk/icefaces/component-metadata/src/main/resources/conf/faces-config-base.xml
                Hide
                Permalink
                Adnan Durrani added a comment -

                ice:dataExporter component has been committed to the trunk.

                Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter
                Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\CSVOutputHandler.java
                Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\DataExporter.java
                Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\DataExporterRenderer.java
                Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\OutputTypeHandler.java
                Modified: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\outputresource\OutputResource.java
                Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\custom\dataExporter-component.xml
                Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\custom\dataExporter-renderer.xml
                Modified: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\extended-faces-config.xml
                Modified: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\faces-config-base.xml
                Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice\components\DataExporter-component.xml
                Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice\renderers\DataExporter-renderer.xml
                Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice_cust_properties\cust-dataExporter-props.xml
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice\components\DataExporter-component.xml
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\DataExporterRenderer.java
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\CSVOutputHandler.java
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice_cust_properties\cust-dataExporter-props.xml
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\custom\dataExporter-component.xml
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\faces-config-base.xml
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\outputresource\OutputResource.java
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\OutputTypeHandler.java
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice\renderers\DataExporter-renderer.xml
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\custom\dataExporter-renderer.xml
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\DataExporter.java
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\extended-faces-config.xml
                Completed: At revision: 18265

                Show
                Adnan Durrani added a comment - ice:dataExporter component has been committed to the trunk. Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\CSVOutputHandler.java Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\DataExporter.java Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\DataExporterRenderer.java Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\OutputTypeHandler.java Modified: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\outputresource\OutputResource.java Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\custom\dataExporter-component.xml Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\custom\dataExporter-renderer.xml Modified: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\extended-faces-config.xml Modified: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\faces-config-base.xml Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice\components\DataExporter-component.xml Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice\renderers\DataExporter-renderer.xml Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice_cust_properties\cust-dataExporter-props.xml Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice\components\DataExporter-component.xml Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\DataExporterRenderer.java Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\CSVOutputHandler.java Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice_cust_properties\cust-dataExporter-props.xml Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\custom\dataExporter-component.xml Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\faces-config-base.xml Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\outputresource\OutputResource.java Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\OutputTypeHandler.java Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice\renderers\DataExporter-renderer.xml Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\custom\dataExporter-renderer.xml Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\DataExporter.java Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\extended-faces-config.xml Completed: At revision: 18265
                Repository Revision Date User Message
                ICEsoft Public SVN Repository #18270 Mon Feb 02 08:59:17 MST 2009 adnan.durrani jxl.jar added to support excel data export related to ICE-1623
                Files Changed
                Commit graph MODIFY /icefaces/trunk/icefaces/lib/versions-licenses.html
                Commit graph ADD /icefaces/trunk/icefaces/lib/jxl.jar
                Repository Revision Date User Message
                ICEsoft Public SVN Repository #18271 Mon Feb 02 09:31:54 MST 2009 adnan.durrani Excel handler added. Related to ICE-1623 (New ice:dataExporter componen)
                Files Changed
                Commit graph MODIFY /icefaces/trunk/icefaces/component/src/com/icesoft/faces/component/dataexporter/DataExporterRenderer.java
                Commit graph ADD /icefaces/trunk/icefaces/component/src/com/icesoft/faces/component/dataexporter/ExcelOutputHandler.java
                Repository Revision Date User Message
                ICEsoft Public SVN Repository #18272 Mon Feb 02 10:43:23 MST 2009 adnan.durrani Description added to TLDDocs. related to ICE-1623 (New ice:dataExporter component)
                Files Changed
                Commit graph MODIFY /icefaces/trunk/icefaces/component-metadata/src/main/resources/conf/custom/dataExporter-renderer.xml
                Commit graph MODIFY /icefaces/trunk/icefaces/component-metadata/src/main/resources/conf/ice_cust_properties/cust-dataExporter-props.xml
                Hide
                Permalink
                Adnan Durrani added a comment -

                jxl.jar added.

                Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\lib\jxl.jar application/octet-stream
                Modified: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\lib\versions-licenses.html
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\lib\jxl.jar
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\lib\versions-licenses.html
                Completed: At revision: 18270

                Show
                Adnan Durrani added a comment - jxl.jar added. Adding: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\lib\jxl.jar application/octet-stream Modified: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\lib\versions-licenses.html Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\lib\jxl.jar Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\lib\versions-licenses.html Completed: At revision: 18270
                Hide
                Permalink
                Adnan Durrani added a comment -

                Tlddocs added.

                Modified: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\custom\dataExporter-renderer.xml
                Modified: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice_cust_properties\cust-dataExporter-props.xml
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\custom\dataExporter-renderer.xml
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice_cust_properties\cust-dataExporter-props.xml
                Completed: At revision: 18272

                Show
                Adnan Durrani added a comment - Tlddocs added. Modified: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\custom\dataExporter-renderer.xml Modified: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice_cust_properties\cust-dataExporter-props.xml Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\custom\dataExporter-renderer.xml Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice_cust_properties\cust-dataExporter-props.xml Completed: At revision: 18272
                Adnan Durrani made changes -
                Status Open [ 1 ] Resolved [ 5 ]
                Resolution Fixed [ 1 ]
                Hide
                Permalink
                Adnan Durrani added a comment -

                Description corrected.
                Modified: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\custom\dataExporter-renderer.xml
                Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\custom\dataExporter-renderer.xml
                Completed: At revision: 18343

                Show
                Adnan Durrani added a comment - Description corrected. Modified: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\custom\dataExporter-renderer.xml Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\custom\dataExporter-renderer.xml Completed: At revision: 18343
                Ken Fyten made changes -
                Fix Version/s 1.8 [ 10161 ]
                Assignee Priority P2
                Ken Fyten made changes -
                Status Resolved [ 5 ] Closed [ 6 ]
                Assignee Adnan Durrani [ adnan.durrani ]

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    Philip Breau
                  • Votes:
                    38 Vote for this issue
                    Watchers:
                    13 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: