[jira] [Commented] (OFBIZ-12089) Invoice import is not visible from UI and not working

[Nicolas Malin (Jira)]

    [ 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)