[FORMS-632] Column order is wrong when exporting form entries

Type: Bug
Resolution: Fixed
Priority: Critical
Fix Version/s: 2.18.0, 2.17.6
Affects Version/s: None
Component/s: None
Labels:
None

Sprint:
4.8.0 M7

Environment:
Ametys 4.7.5

Steps to reproduce bug:

-Create a new form with the standard form workflow
-Create 3 dropdown fields
-Hide the 2nd dropdown field
-Submit an entry
-Export form entries

Bug:
Some of the form entries are in the wrong columns (in the .xls file)

- - Sort By Name
  - Sort By Date
  - Ascending
  - Descending
  - Thumbnails
  - List
  - Download All

image-2023-12-14-15-45-16-609.png
5 kB
14/Dec/23 15:45
image-2023-12-14-15-46-13-754.png
22 kB
14/Dec/23 15:46
image-2023-12-14-15-46-40-546.png
10 kB
14/Dec/23 15:46
image-2023-12-14-15-47-31-446.png
57 kB
14/Dec/23 15:47

James Hawken added a comment - 21/Mar/24 10:12 - edited

tested: works on nightly demo

James Hawken added a comment - 21/Mar/24 10:12 - edited tested: works on nightly demo

David Cartier-Michaud added a comment - 23/Jan/24 11:58

Error when try to export data, here is error message :

URI de la requête : /plugins/forms/forms/entries.xls
Message : Failed to process pipeline
    at <map:serialize type="xml"> - resource://org/ametys/plugins/forms/sitemap.xmap:696:44
    at <map:generate type="entries-to-export"> - resource://org/ametys/plugins/forms/sitemap.xmap:693:56
    at <map:serialize type="html-xls"> - resource://org/ametys/plugins/forms/sitemap.xmap:850:53
    at <map:transform type="i18n"> - resource://org/ametys/plugins/forms/sitemap.xmap:846:48
    at <map:transform> - resource://org/ametys/plugins/forms/sitemap.xmap:845:81
    at <map:mount> - resource://org/ametys/workspaces/cms/sitemap.xmap:203:81
    at <map:mount> - resource://org/ametys/workspaces/web/sitemap.xmap:522:105
    at <map:mount> - resource://org/ametys/runtime/kernel/sitemap.xmap:189:109
Emplacement : org.apache.cocoon.util.log.SLF4JLoggerAdapter.error(SLF4JLoggerAdapter.java:46)

Pile d'appels :
org.apache.cocoon.ProcessingException: Failed to process pipeline
at <map:serialize type="xml"> - resource://org/ametys/plugins/forms/sitemap.xmap:696:44
at <map:generate type="entries-to-export"> - resource://org/ametys/plugins/forms/sitemap.xmap:693:56
at <map:serialize type="html-xls"> - resource://org/ametys/plugins/forms/sitemap.xmap:850:53
at <map:transform type="i18n"> - resource://org/ametys/plugins/forms/sitemap.xmap:846:48
at <map:transform> - resource://org/ametys/plugins/forms/sitemap.xmap:845:81
at <map:mount> - resource://org/ametys/workspaces/cms/sitemap.xmap:203:81
at <map:mount> - resource://org/ametys/workspaces/web/sitemap.xmap:522:105
at <map:mount> - resource://org/ametys/runtime/kernel/sitemap.xmap:189:109
at org.apache.cocoon.ProcessingException#throwLocated:145
at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline#handleException:955
at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline#processXMLPipeline:585
at org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline#processXMLPipeline:301
at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline#process:782
at org.apache.cocoon.components.source.impl.SitemapSource#toSAX:414
at org.apache.cocoon.components.source.SourceUtil#toSAX:101
at org.apache.cocoon.components.source.SourceUtil#parse:321
at org.apache.cocoon.sitemap.ContentAggregator#generate:125
at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline#processXMLPipeline:581
at org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline#processXMLPipeline:301
at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline#process:483
at org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode#invoke:144
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:47
at org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode#invoke:139
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:47
at org.apache.cocoon.components.treeprocessor.sitemap.MatchNode#invoke:108
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69
at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode#invoke:143
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69
at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode#invoke:93
at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:236
at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:178
at org.apache.cocoon.components.treeprocessor.TreeProcessor#process:254
at org.apache.cocoon.components.treeprocessor.sitemap.MountNode#invoke:118
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:47
at org.apache.cocoon.components.treeprocessor.sitemap.MatchNode#invoke:108
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69
at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode#invoke:143
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69
at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode#invoke:93
at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:236
at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:178
at org.apache.cocoon.components.treeprocessor.TreeProcessor#process:254
at org.apache.cocoon.components.treeprocessor.sitemap.MountNode#invoke:118
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:47
at org.apache.cocoon.components.treeprocessor.sitemap.MatchNode#invoke:108
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69
at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode#invoke:143
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69
at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode#invoke:93
at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:236
at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:178
at org.apache.cocoon.components.treeprocessor.TreeProcessor#process:254
at org.apache.cocoon.components.treeprocessor.sitemap.MountNode#invoke:118
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:47
at org.apache.cocoon.components.treeprocessor.sitemap.MatchNode#invoke:108
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69
at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode#invoke:143
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69
at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode#invoke:93
at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:236
at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:178
at org.apache.cocoon.components.treeprocessor.TreeProcessor#process:254
at org.apache.cocoon.Cocoon#process:699
at org.ametys.runtime.servlet.RuntimeServlet#service:717
at javax.servlet.http.HttpServlet#service:779
at org.apache.catalina.core.ApplicationFilterChain#internalDoFilter:227
at org.apache.catalina.core.ApplicationFilterChain#doFilter:162
at org.apache.tomcat.websocket.server.WsFilter#doFilter:53
at org.apache.catalina.core.ApplicationFilterChain#internalDoFilter:189
at org.apache.catalina.core.ApplicationFilterChain#doFilter:162
at org.apache.catalina.core.StandardWrapperValve#invoke:177
at org.apache.catalina.core.StandardContextValve#invoke:97
at org.apache.catalina.authenticator.AuthenticatorBase#invoke:541
at org.apache.catalina.core.StandardHostValve#invoke:135
at org.apache.catalina.valves.ErrorReportValve#invoke:92
at org.apache.catalina.valves.AbstractAccessLogValve#invoke:687
at org.apache.catalina.core.StandardEngineValve#invoke:78
at org.apache.catalina.connector.CoyoteAdapter#service:360
at org.apache.coyote.http11.Http11Processor#service:399
at org.apache.coyote.AbstractProcessorLight#process:65
at org.apache.coyote.AbstractProtocol$ConnectionHandler#process:891
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor#doRun:1784
at org.apache.tomcat.util.net.SocketProcessorBase#run:49
at org.apache.tomcat.util.threads.ThreadPoolExecutor#runWorker:1191
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker#run:659
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable#run:61
at java.base/java.lang.Thread#run:833
Caused by: java.lang.UnsupportedOperationException: Method getStorageType doesn't be called for richText question type
at org.ametys.plugins.forms.question.types.RichTextQuestionType#getStorageType:85
at org.ametys.plugins.forms.generators.FormEntryInformationGenerator#_saxQuestion:193
at org.ametys.plugins.forms.generators.FormEntryInformationGenerator#_saxEntry:163
at org.ametys.plugins.forms.generators.FormEntriesGenerator#generate:77
at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline#processXMLPipeline:581
... 76 more

David Cartier-Michaud added a comment - 23/Jan/24 11:58 Error when try to export data, here is error message : URI de la requête : /plugins/forms/forms/entries.xls Message : Failed to process pipeline at <map:serialize type= "xml" > - resource: //org/ametys/plugins/forms/sitemap.xmap:696:44 at <map:generate type= "entries-to-export" > - resource: //org/ametys/plugins/forms/sitemap.xmap:693:56 at <map:serialize type= "html-xls" > - resource: //org/ametys/plugins/forms/sitemap.xmap:850:53 at <map:transform type= "i18n" > - resource: //org/ametys/plugins/forms/sitemap.xmap:846:48 at <map:transform> - resource: //org/ametys/plugins/forms/sitemap.xmap:845:81 at <map:mount> - resource: //org/ametys/workspaces/cms/sitemap.xmap:203:81 at <map:mount> - resource: //org/ametys/workspaces/web/sitemap.xmap:522:105 at <map:mount> - resource: //org/ametys/runtime/kernel/sitemap.xmap:189:109 Emplacement : org.apache.cocoon.util.log.SLF4JLoggerAdapter.error(SLF4JLoggerAdapter.java:46) Pile d'appels : org.apache.cocoon.ProcessingException: Failed to process pipeline at <map:serialize type= "xml" > - resource: //org/ametys/plugins/forms/sitemap.xmap:696:44 at <map:generate type= "entries-to-export" > - resource: //org/ametys/plugins/forms/sitemap.xmap:693:56 at <map:serialize type= "html-xls" > - resource: //org/ametys/plugins/forms/sitemap.xmap:850:53 at <map:transform type= "i18n" > - resource: //org/ametys/plugins/forms/sitemap.xmap:846:48 at <map:transform> - resource: //org/ametys/plugins/forms/sitemap.xmap:845:81 at <map:mount> - resource: //org/ametys/workspaces/cms/sitemap.xmap:203:81 at <map:mount> - resource: //org/ametys/workspaces/web/sitemap.xmap:522:105 at <map:mount> - resource: //org/ametys/runtime/kernel/sitemap.xmap:189:109 at org.apache.cocoon.ProcessingException#throwLocated:145 at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline#handleException:955 at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline#processXMLPipeline:585 at org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline#processXMLPipeline:301 at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline#process:782 at org.apache.cocoon.components.source.impl.SitemapSource#toSAX:414 at org.apache.cocoon.components.source.SourceUtil#toSAX:101 at org.apache.cocoon.components.source.SourceUtil#parse:321 at org.apache.cocoon.sitemap.ContentAggregator#generate:125 at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline#processXMLPipeline:581 at org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline#processXMLPipeline:301 at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline#process:483 at org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode#invoke:144 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:47 at org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode#invoke:139 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:47 at org.apache.cocoon.components.treeprocessor.sitemap.MatchNode#invoke:108 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69 at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode#invoke:143 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69 at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode#invoke:93 at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:236 at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:178 at org.apache.cocoon.components.treeprocessor.TreeProcessor#process:254 at org.apache.cocoon.components.treeprocessor.sitemap.MountNode#invoke:118 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:47 at org.apache.cocoon.components.treeprocessor.sitemap.MatchNode#invoke:108 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69 at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode#invoke:143 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69 at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode#invoke:93 at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:236 at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:178 at org.apache.cocoon.components.treeprocessor.TreeProcessor#process:254 at org.apache.cocoon.components.treeprocessor.sitemap.MountNode#invoke:118 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:47 at org.apache.cocoon.components.treeprocessor.sitemap.MatchNode#invoke:108 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69 at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode#invoke:143 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69 at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode#invoke:93 at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:236 at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:178 at org.apache.cocoon.components.treeprocessor.TreeProcessor#process:254 at org.apache.cocoon.components.treeprocessor.sitemap.MountNode#invoke:118 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:47 at org.apache.cocoon.components.treeprocessor.sitemap.MatchNode#invoke:108 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69 at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode#invoke:143 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69 at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode#invoke:93 at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:236 at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:178 at org.apache.cocoon.components.treeprocessor.TreeProcessor#process:254 at org.apache.cocoon.Cocoon#process:699 at org.ametys.runtime.servlet.RuntimeServlet#service:717 at javax.servlet.http.HttpServlet#service:779 at org.apache.catalina.core.ApplicationFilterChain#internalDoFilter:227 at org.apache.catalina.core.ApplicationFilterChain#doFilter:162 at org.apache.tomcat.websocket.server.WsFilter#doFilter:53 at org.apache.catalina.core.ApplicationFilterChain#internalDoFilter:189 at org.apache.catalina.core.ApplicationFilterChain#doFilter:162 at org.apache.catalina.core.StandardWrapperValve#invoke:177 at org.apache.catalina.core.StandardContextValve#invoke:97 at org.apache.catalina.authenticator.AuthenticatorBase#invoke:541 at org.apache.catalina.core.StandardHostValve#invoke:135 at org.apache.catalina.valves.ErrorReportValve#invoke:92 at org.apache.catalina.valves.AbstractAccessLogValve#invoke:687 at org.apache.catalina.core.StandardEngineValve#invoke:78 at org.apache.catalina.connector.CoyoteAdapter#service:360 at org.apache.coyote.http11.Http11Processor#service:399 at org.apache.coyote.AbstractProcessorLight#process:65 at org.apache.coyote.AbstractProtocol$ConnectionHandler#process:891 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor#doRun:1784 at org.apache.tomcat.util.net.SocketProcessorBase#run:49 at org.apache.tomcat.util.threads.ThreadPoolExecutor#runWorker:1191 at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker#run:659 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable#run:61 at java.base/java.lang. Thread #run:833 Caused by: java.lang.UnsupportedOperationException: Method getStorageType doesn't be called for richText question type at org.ametys.plugins.forms.question.types.RichTextQuestionType#getStorageType:85 at org.ametys.plugins.forms.generators.FormEntryInformationGenerator#_saxQuestion:193 at org.ametys.plugins.forms.generators.FormEntryInformationGenerator#_saxEntry:163 at org.ametys.plugins.forms.generators.FormEntriesGenerator#generate:77 at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline#processXMLPipeline:581 ... 76 more

Details

Description

Attachments

Attachments

Activity

Collapse comment: James Hawken added a comment - 21/Mar/24 10:12, Edited by James Hawken - 21/Mar/24 10:13

Expand comment: James Hawken added a comment - 21/Mar/24 10:12, Edited by James Hawken - 21/Mar/24 10:13

Collapse comment: David Cartier-Michaud added a comment - 23/Jan/24 11:58

Expand comment: David Cartier-Michaud added a comment - 23/Jan/24 11:58

People

Dates

Contact Product Support