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

          Activity

          Hide
          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
          Hide
          tjohnson added a comment -

          Exporting datatable to csv will be sufficient.

          Show
          tjohnson added a comment - Exporting datatable to csv will be sufficient.
          Hide
          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
          Philip Breau added a comment -

          prototype demo

          Show
          Philip Breau added a comment - prototype demo
          Hide
          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
          Hide
          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
          Hide
          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).
          Hide
          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
          Hide
          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
          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
          Hide
          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

            People

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

              Dates

              • Created:
                Updated:
                Resolved: