Critical 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)
[FORMS-632] Column order is wrong when exporting form entries
James Hawken
made changes -
| Status | Original: Resolved [ 5 ] | New: Closed [ 6 ] |
| Resolution | New: Fixed [ 1 ] | |
| Status | Original: Ready to merge [ 10208 ] | New: Resolved [ 5 ] |
Magali Franchet
made changes -
| Assignee | New: Loïc Bouchet [ lbouchet ] |
Magali Franchet
made changes -
| Status | Original: Code review OK [ 10206 ] | New: Ready to merge [ 10208 ] |
| Assignee | Original: Loïc Bouchet [ lbouchet ] |
| Status | Original: Available for review [ 10005 ] | New: Code review OK [ 10206 ] |
| Status | Original: Reopened [ 4 ] | New: Available for review [ 10005 ] |
David Cartier-Michaud
made changes -
| Resolution | Original: Fixed [ 1 ] | |
| Status | Original: Resolved [ 5 ] | New: Reopened [ 4 ] |
David Cartier-Michaud
added a comment - 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 - 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
tested: works on nightly demo