Excel Importer - Content Not Allowed in Prolog

0
I'm running 7.0.2 and trying to use the Excel Importer - my greatest complaint about Mendix. Some of the competition allows for direct import. Why on earth does it have to be so difficult? I'm trying to import a spreadsheet with 6 columns with headers. There are no special characters in any of the fields. Should be pretty straight forward, but the Excel Importer keeps choking with the following error. Any ideas? Exception while importing Excel template Master Supplier List.xlsx -------- com.mendix.systemwideinterfaces.MendixRuntimeException: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.     at com.mendix.integration.importer.xml.XmlImporter$$anonfun$importStream$2$$anonfun$apply$1.apply(XmlImporter.scala:78) Caused by: org.xml.sax.SAXParseException: Content is not allowed in prolog.     at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)     at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)     at com.mendix.integration.importer.xml.XmlImporter$$anonfun$1.apply$mcV$sp(XmlImporter.scala:53)     at com.mendix.integration.importer.xml.XmlImporter$$anonfun$1.apply(XmlImporter.scala:53)     at com.mendix.integration.importer.xml.XmlImporter$$anonfun$1.apply(XmlImporter.scala:53)     at scala.util.Try$.apply(Try.scala:192)     at com.mendix.integration.importer.xml.XmlImporter.importStream(XmlImporter.scala:53)     at com.mendix.integration.importer.xml.XmlImporter.importStream(XmlImporter.scala:32)     at com.mendix.integration.internal.InternalIntegration$class.doImportStream(InternalIntegration.scala:114)     at com.mendix.integration.internal.InternalIntegrationImpl.doImportStream(InternalIntegrationImpl.scala:27)     at com.mendix.integration.actions.microflow.ImportAction.execute(ImportAction.scala:45)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:200)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:50)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:73)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51)     at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:170)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:174)     at com.mendix.basis.component.InternalCore.execute(InternalCore.java:445)     at com.mendix.webui.actions.client.ExecuteAction.execute(ExecuteAction.java:143)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply$mcV$sp(ClientRequestHandler.scala:321)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:307)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:307)     at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.basis.actionmanagement.IMonitoredAction$class.monitor(IMonitoredAction.scala:49)     at com.mendix.webui.requesthandling.ClientRequestHandler$ClientMonitoredAction.monitor(ClientRequestHandler.scala:419)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleRequest(ClientRequestHandler.scala:307)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleActionWithSessionRequired(ClientRequestHandler.scala:238)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleAction(ClientRequestHandler.scala:202)     at com.mendix.webui.requesthandling.ClientRequestHandler.liftedTree1$1(ClientRequestHandler.scala:99)     at com.mendix.webui.requesthandling.ClientRequestHandler.processRequest(ClientRequestHandler.scala:91)     at com.mendix.externalinterface.connector.RequestHandler.doProcessRequest(RequestHandler.java:40)     at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:70)     at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:67)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.external.connector.MxRuntimeConnector.processRequest(MxRuntimeConnector.java:73)     at com.mendix.basis.impl.MxRuntimeImpl.processRequest(MxRuntimeImpl.java:875)     at com.mendix.m2ee.appcontainer.server.handler.RuntimeHandler.handle(RuntimeHandler.java:41)     at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)     at org.eclipse.jetty.server.Server.handle(Server.java:368)     at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)     at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:953)     at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1014)     at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:861)     at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)     at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)     at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)     at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)     at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)     at java.lang.Thread.run(Thread.java:745)  
asked
2 answers
0

I found lots of examples in a Google search explaining that any special characters before the <?xml… will result in this error. Check your filename that it doesn't have any special characters in front, that you are selecting the file and not the folder it is in during the import, that you properly setup the model reflection in your template for the mapping and you don't have special characters in the file, and that your excel file is properly encoded to the correct character set like UTF-8. Beyond that I would need to see your template configuration and the source file.

answered
0

The importer is called "Excel Importer" but does the file have to be in an XML format? I've tried saving the file as Excel XML but that didn't work either. The filename has no special characters in it.

If it has to be formatted as XML then it's even worse than I thought. One of the Mendix competitors allows for direct import via "Import from Excel". Why can't Mendix have that? Seems like we're in the 21st century now.

answered