Excel Importer trying to set an attribute on referenced entity

-1
Hi All, I am encountering a strange issue when using the Excel importer (App store version 5.4 with Mendix 5.18.0). I've got two entities, A and B, with a one-to-many association. I set up my import template so that I use some linking attribute to create the association. Let's say that the attribute is called 'LinkingKey' on object B. Object A has an attribute called 'Name', and when I try to import my file, I get an error telling me that the membername 'Name' can't be found on EntityB. There isn't an attribute 'Name' on EntityB because I am importing into Entity A. I would think the only thing that needs to be on Entity B is 'LinkingKey.' Has anyone seen an issue like this before? Have I configured the parameters incorrectly? Thanks, Rob The error is below: Sept 8 15:18:44.221 127.0.0.1 tr10000: INFO - ExcelXLSReader: Error while importing 35 - **ENTITY A** link109301 ms Sep 8 15:18:44.235 127.0.0.1 tr10000: ERROR - ImportTemplateDocument: The following error occured when importing document: Spreadsheet.xlsx Sep 8 15:18:44.237 127.0.0.1 tr10000: ERROR - ImportTemplateDocument: (1/70) com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: replication.ReplicationSettings$MendixReplicationRuntimeException: The given member name 'Name' has no corresponding member in this object of type **'Module.EntityB**' | VERSION: Mx5_20150416 Sep 8 15:18:44.237 127.0.0.1 tr10000: ERROR - ImportTemplateDocument: (2/70) at com.mendix.core.component.InternalCore.execute(InternalCore.java:237) Sep 8 15:18:44.237 127.0.0.1 tr10000: ERROR - ImportTemplateDocument: (3/70) Sep 8 15:18:44.237 127.0.0.1 tr10000: ERROR - ImportTemplateDocument: (4/70) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: replication.ReplicationSettings$MendixReplicationRuntimeException: The given member name 'Name' has no corresponding member in this object of type 'Module.EntityB' | VERSION: Mx5_20150416 Sep 8 15:18:44.238 127.0.0.1 tr10000: ERROR - ImportTemplateDocument: (5/70) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:202) Sep 8 15:18:44.238 127.0.0.1 tr10000: ERROR - ImportTemplateDocument: (6/70) Sep 8 15:18:44.238 127.0.0.1 tr10000: ERROR - ImportTemplateDocument: (7/70) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreException: Document could not be imported, because: replication.ReplicationSettings$MendixReplicationRuntimeException: The given member name 'Name' has no corresponding member in this object of type 'Module.EntityB' | VERSION: Mx5_20150416 Sep 8 15:18:44.238 127.0.0.1 tr10000: ERROR - ImportTemplateDocument: ...
asked
2 answers
1

I had a similar issue, and I fixed it by making sure I had at least one key field specified as applicable to BOTH main object and reference.

answered
0

Name should not be marked as "Key for associated object" or "Key for both...."

Did you change the way references/associations are handled?

Can you provide a screenshot of the excel importer screen?

answered