Posted by
Nicolas Malin (Jira) on
URL: http://ofbiz.116.s1.nabble.com/jira-Commented-OFBIZ-12089-Invoice-import-is-not-visible-from-UI-and-not-working-tp4762596.html
[
https://issues.apache.org/jira/browse/OFBIZ-12089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17245978#comment-17245978 ]
Jacques Le Roux commented on OFBIZ-12089:
-----------------------------------------
After the above commit, both export and import should work but actually import fails:
{noformat}
2020-12-08 17:08:32,638 |jsse-nio-8443-exec-6 |ServiceEventHandler |E| Service invocation error
org.apache.ofbiz.service.GenericServiceException: Service [importInvoice] target threw an unexpected exception (A header name is missing in [invoiceId, invoiceTypeId, invoiceDate, dueDate, partyIdFrom, partyIdFromTrans, partyId, partyIdT
rans, currencyUomId, description, referenceNumber, invoiceItemSeqId, invoiceItemTypeId, productId, productIdTrans, itemDescription, quantity, amount, ])
at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:118) ~[main/:?]
at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) ~[main/:?]
at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:424) ~[main/:?]
at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) ~[main/:?]
at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:93) ~[main/:?]
at org.apache.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:253) [main/:?]
at org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:1013) [main/:?]
at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:664) [main/:?]
at org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:231) [main/:?]
at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96) [main/:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) [tomcat-servlet-api-9.0.37.jar:4.0.FR]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [tomcat-servlet-api-9.0.37.jar:4.0.FR]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.40.jar:9.0.40]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:45) [main/:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) [main/:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:156) [main/:?]
at javax.servlet.http.HttpFilter.doFilter(HttpFilter.java:52) [tomcat-servlet-api-9.0.37.jar:4.0.FR]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.11.2.jar:2.11.2]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-coyote-9.0.37.jar:9.0.37]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.37.jar:9.0.37]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.37.jar:9.0.37]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-coyote-9.0.37.jar:9.0.37]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.37.jar:9.0.37]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.37.jar:9.0.37]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202]
Caused by: java.lang.IllegalArgumentException: A header name is missing in [invoiceId, invoiceTypeId, invoiceDate, dueDate, partyIdFrom, partyIdFromTrans, partyId, partyIdTrans, currencyUomId, description, referenceNumber, invoiceItemSeq
Id, invoiceItemTypeId, productId, productIdTrans, itemDescription, quantity, amount, ]
at org.apache.commons.csv.CSVParser.createHeaders(CSVParser.java:501) ~[commons-csv-1.8.jar:1.8]
at org.apache.commons.csv.CSVParser.<init>(CSVParser.java:412) ~[commons-csv-1.8.jar:1.8]
at org.apache.commons.csv.CSVParser.<init>(CSVParser.java:378) ~[commons-csv-1.8.jar:1.8]
at org.apache.commons.csv.CSVFormat.parse(CSVFormat.java:1157) ~[commons-csv-1.8.jar:1.8]
at org.apache.ofbiz.accounting.invoice.InvoiceServices.importInvoice(InvoiceServices.java:3684) ~[main/:?]
{noformat}
Should not be a big deal, but more pressin things to do...
> Invoice import is not visible from UI and not working
> -----------------------------------------------------
>
> Key: OFBIZ-12089
> URL:
https://issues.apache.org/jira/browse/OFBIZ-12089> Project: OFBiz
> Issue Type: Improvement
> Components: accounting
> Affects Versions: Trunk
> Reporter: Jacques Le Roux
> Priority: Minor
>
> While working on OFBIZ-12080 I found an upload feature that allows to import invoices but it's not visible from UI and not working. Moreover the export feature was missing a parameters as the import .
> It has been introduced by [~hansbak] with
https://svn.apache.org/repos/asf/ofbiz/trunk@1502093 and I'm not sure the integration was completed.
> We could remove it, but I think it can be useful and does not seem to miss much to work fine.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)