Excel Importer

0
Hi all! I am working with the Excel importer in Mendix 8. If I import a simple Excel with attributes it is going well. But now I have an Excel with associations. The structure is: - Attribute1 → Key - Attribute2 - Association1 to object 1  → Key of associated object - Attribute 3 - Attribute 4 If I import my Excel now, I have the error below. It looks like he is trying to fill attribute 3 in object 1. When I remove attribute 3, the message is the same, but now with attribute 4. Can anyone help me with this problem?   replication.ReplicationSettings$MendixReplicationRuntimeException: The given member name 'Attribute 3' has no corresponding member in this object of type 'Object 1' | VERSION: Mx5_20161013     at replication.MetaInfoProcessor.processAssociatedObjects(MetaInfoProcessor.java:450) Caused by: java.lang.IllegalArgumentException: The given member name 'Attribute 3' has no corresponding member in this object of type 'Object 1'     at com.mendix.basis.objectmanagement.MendixObjectImpl.getMember(MendixObjectImpl.java:233)     at com.mendix.basis.objectmanagement.MendixObjectImpl.getMember(MendixObjectImpl.java:240)     at com.mendix.basis.objectmanagement.MendixObjectImpl.getMember(MendixObjectImpl.java:39)     at replication.MetaInfoProcessor.updateMemberAndSetState(MetaInfoProcessor.java:629)     at replication.MetaInfoProcessor.changeMembersForBatch(MetaInfoProcessor.java:487)     at replication.MetaInfoProcessor.processAssociatedObjects(MetaInfoProcessor.java:388)     at replication.MetaInfoProcessor.storeChangedObjects(MetaInfoProcessor.java:126)     at replication.MetaInfoProcessor.startProcessing(MetaInfoProcessor.java:66)     at replication.MetaInfo.startProcessingObjects(MetaInfo.java:743)     at replication.MetaInfo.finished(MetaInfo.java:768)     at excelimporter.reader.readers.ExcelRowProcessor.finish(ExcelRowProcessor.java:169)     at excelimporter.reader.readers.ExcelXLSXDataReader.readData(ExcelXLSXDataReader.java:48)     at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:451)     at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:120)     at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:54)     at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:25)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:54)     at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:147)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)     at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:152)     at com.mendix.basis.component.InternalCoreBase.execute(InternalCoreBase.java:379)     at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:53)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:201)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:54)     at com.mendix.basis.actionmanagement.DefaultActionMonitor$.$anonfun$run$1(CustomMonitoredAction.scala:18)     at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)     at com.mendix.basis.actionmanagement.IMonitoredAction.monitor(IMonitoredAction.scala:49)     at com.mendix.basis.actionmanagement.IMonitoredAction.monitor$(IMonitoredAction.scala:25)     at com.mendix.basis.actionmanagement.CustomMonitoredAction.monitor(CustomMonitoredAction.scala:22)     at com.mendix.basis.actionmanagement.DefaultActionMonitor$.run(CustomMonitoredAction.scala:18)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.runMonitoredAction(CoreActionHandlerImpl.scala:60)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:47)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:54)     at com.mendix.basis.actionmanagement.ActionManager.$anonfun$execute$1(ActionManager.scala:118)     at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:659)     at scala.util.Success.$anonfun$map$1(Try.scala:255)     at scala.util.Success.map(Try.scala:213)     at scala.concurrent.Future.$anonfun$map$1(Future.scala:292)     at scala.concurrent.impl.Promise.liftedTree1$1(Promise.scala:33)     at scala.concurrent.impl.Promise.$anonfun$transform$1(Promise.scala:33)     at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:64)     at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)     at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)     at java.base/java.lang.Thread.run(Thread.java:834)    
asked
3 answers
0

Did you follow the following learning path?

https://gettingstarted.mendixcloud.com/link/path/44 
I did it yesterday and the importing part worked perfectly. However, exporting associations didn’t work.

answered
0

Did you update your template correctly? It looks like the template isn't properly configured.

answered
0

Hey Wout,

I know this is 6 months late but I came across something similar recently and when I unchecked the commit unchanged objects option in the settings tab this resolved my issue.

 

answered