Details
-
Type:
New Feature
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: EE-4.1.0.GA, EE-3.3.0.GA_P04
-
Fix Version/s: EE-4.2.0.GA, EE-3.3.0.GA_P05
-
Component/s: ACE-Components
-
Labels:None
-
Environment:All
-
Assignee Priority:P3
-
Support Case References:Support Case #13982 - https://icesoft.my.salesforce.com/5007000001gOGZD
-
Affects:Sample App./Tutorial
Description
Feature Request: Add support to export data that is used in an ace:list component using the ace:dataExporter.
Activity
Field | Original Value | New Value |
---|---|---|
Assignee | Arturo Zambrano [ artzambrano ] | |
Fix Version/s | 4.2 [ 12870 ] | |
Fix Version/s | EE-3.3.0.GA_P05 [ 13082 ] | |
Affects | Documentation (User Guide, Ref. Guide, etc.),Sample App./Tutorial [ 10003, 10001 ] | |
Assignee Priority | P2 [ 10011 ] |
Fix Version/s | EE-4.2.0.GA [ 13071 ] | |
Fix Version/s | 4.2 [ 12870 ] | |
Fix Version/s | EE-3.3.0.GA_P05 [ 13082 ] |
Fix Version/s | 4.2 [ 12870 ] | |
Fix Version/s | EE-4.2.0.GA [ 13071 ] | |
Assignee Priority | P2 [ 10011 ] | P1 [ 10010 ] |
Fix Version/s | EE-4.2.0.GA [ 13071 ] | |
Fix Version/s | 4.2 [ 12870 ] |
Summary | ace:dataExporter - Add support for exporting ace:list data | Create a new ace:listExporter component for exporting ace:list data |
Repository | Revision | Date | User | Message |
ICEsoft Public SVN Repository | #51329 | Tue Mar 14 15:46:38 MDT 2017 | art.zambrano | |
Files Changed | ||||
![]() ![]() ![]() ![]() ![]() ![]() |
Repository | Revision | Date | User | Message |
ICEsoft Public SVN Repository | #51364 | Mon Mar 20 18:23:36 MDT 2017 | art.zambrano | |
Files Changed | ||||
![]() |
Attachment | Capture1.PNG [ 22488 ] |
Comment |
[ I did various tests with various combinations of the poi library versions 3.7 and 3.9 and its dependencies, and this is what I found out.
* The poi 3.9 version will also require the Apache commons codec library in order to perform the custom operations in the preprocessor and postprocessor methods, for both formats XLS and XLSX. This library is 72 KB in size. The poi 3.7 version doesn't require this library for those operations. * Supporting the XLSX format will require one additional library, the Apache XMLBeans library. This is required with either version of poi, 3.7 or 3.9. I had read about this library being a dependency for XLSX, but in the tests I made in the showcase it wasn't necessary for some reason, so I didn't include it at first. I found the other dependencies (ooxml and ooxml-schemas) that are compatible with poi 3.7, but they still need this XMLBeans library as well. The size of this library is about 2.5 MB. There's the option of maybe staying with the old 3.7 version of poi, now that compatible dependencies have been found, but the only benefit would be to avoid the Apache commons codec library, which is very small. So, we will include these two additional libraries and update the documentation regarding those libraries. ] |
Comment |
[ r51365: added Apache commons codec and Apache XMLBean libraries to support XLSX exporting (4.2 trunk)
r46717: added Apache commons codec and Apache XMLBean libraries to support XLSX exporting (QA DataExporter app) ] |
Repository | Revision | Date | User | Message |
ICEsoft Public SVN Repository | #51365 | Tue Mar 21 12:41:39 MDT 2017 | art.zambrano | |
Files Changed | ||||
![]() ![]() |
Repository | Revision | Date | User | Message |
ICEsoft Public SVN Repository | #51367 | Tue Mar 21 13:19:44 MDT 2017 | art.zambrano | |
Files Changed | ||||
![]() |
Repository | Revision | Date | User | Message |
ICEsoft Public SVN Repository | #51370 | Tue Mar 21 17:19:52 MDT 2017 | ken.fyten | |
Files Changed | ||||
![]() |
Repository | Revision | Date | User | Message |
ICEsoft Public SVN Repository | #51372 | Wed Mar 22 12:42:02 MDT 2017 | art.zambrano | |
Files Changed | ||||
![]() |
Status | Open [ 1 ] | Resolved [ 5 ] |
Resolution | Fixed [ 1 ] |
Resolution | Fixed [ 1 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Status | Reopened [ 4 ] | Resolved [ 5 ] |
Resolution | Fixed [ 1 ] |
Resolution | Fixed [ 1 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Status | Reopened [ 4 ] | Resolved [ 5 ] |
Resolution | Fixed [ 1 ] |
Repository | Revision | Date | User | Message |
ICEsoft Public SVN Repository | #51608 | Thu Jun 08 12:08:33 MDT 2017 | art.zambrano | |
Files Changed | ||||
![]() |
Resolution | Fixed [ 1 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Fix Version/s | EE-3.3.0.GA_P05 [ 13082 ] |
Assignee Priority | P1 [ 10010 ] | P3 [ 10012 ] |
Status | Reopened [ 4 ] | Resolved [ 5 ] |
Resolution | Fixed [ 1 ] |
Repository | Revision | Date | User | Message |
ICEsoft Public SVN Repository | #51705 | Mon Jul 03 21:42:14 MDT 2017 | art.zambrano | |
Files Changed | ||||
![]() ![]() ![]() ![]() ![]() |
Resolution | Fixed [ 1 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Assignee | Arturo Zambrano [ artzambrano ] | Judy Guglielmin [ judy.guglielmin ] |
Assignee | Judy Guglielmin [ judy.guglielmin ] | Arturo Zambrano [ artzambrano ] |
Status | Reopened [ 4 ] | Resolved [ 5 ] |
Resolution | Fixed [ 1 ] |
Summary | Create a new ace:listExporter component for exporting ace:list data | New ace:listExporter component for exporting ace:list data |
Issue Type | Improvement [ 4 ] | New Feature [ 2 ] |
Resolution | Fixed [ 1 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Affects | Documentation (User Guide, Ref. Guide, etc.),Sample App./Tutorial [ 10003, 10001 ] | Sample App./Tutorial [ 10001 ] |
Assignee | Arturo Zambrano [ artzambrano ] | Judy Guglielmin [ judy.guglielmin ] |
Status | Reopened [ 4 ] | Resolved [ 5 ] |
Resolution | Fixed [ 1 ] |
Resolution | Fixed [ 1 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Attachment | export1.PNG [ 22575 ] | |
Attachment | export2.PNG [ 22576 ] |
Assignee | Judy Guglielmin [ judy.guglielmin ] | Arturo Zambrano [ artzambrano ] |
Attachment | after.PNG [ 22578 ] | |
Attachment | before.PNG [ 22579 ] |
Status | Reopened [ 4 ] | Resolved [ 5 ] |
Resolution | Fixed [ 1 ] |
Status | Resolved [ 5 ] | Closed [ 6 ] |
To support exporting ace:list data, it is more feasible and more convenient to create a new component ace:listExporter specifically for such task, following the unix philosophy.
Despite the fact that ace:list is a UIData descendant, all the code in ace:dataExporter is geared toward exporting ace:dataTable data. Most of the methods are long and have complex logic aimed at satisfying the various requirements, options, and different scenarios for exporting ace:dataTable data, including features such as multiple headers, spanning rows, child rows, tree datamodel, etc. A key difference is that ace:list doesn't use columns, while most of the code in ace:dataExporter is closely dependent on column objects.
Making all these methods even more intricate and complex in order to support exporting ace:list data would make the component harder to understand and to maintain, and it would make the code more error prone and harder to test as well.
From the development perspective, it would be easier and faster to develop a new component exclusively for exporting ace:list data. The code from ace:dataExporter that would actually apply to ace:list is actually a small percentage, and this would give us more flexibility in supporting various features and scenarios that are exclusive to ace:list, such as also supporting ace:listControl.
From the user perspective, it would be easier and more intuitive to use, since many of the attributes would be exclusive to exporting ace:list data, and ace:listExporter wouldn't have any of the ace:dataTable-specific attributes, also avoiding the need to clarify in the documentation what each attribute applies to.
This also aligns better with the planned ace:scheduleExporter component (
ICE-11238), having separate exporter components to suit specific needs.