Question

Problem occured while creating Template for Excel Importer

0

Hi guys, Im using Excel Importer V5.1. Im creating a template using this and i am not able to see all the associations of an object that was selected as Mendix object(Target objects whose instances will be created for each row of the excel sheet). Ex: 1. I Have an entity in a module(Ex: Entity1 in module1) 2. Another entity in another module( Entity2 in module2) and i have an association like Entity1_Entity2(one Entity2 object is associated with multiple Entity1 Objects ) This association was not shown in the references tab

asked 2014-09-08

Shiva

4 answers

Chris de Gelder · Answer 1 · 2014-09-08

Did you refresh MxModel reflection?

Shiva · Answer 2 · 2014-09-09

I refreshed it.. still not showing all the associations. It is showing all the association which are owned by other entities and referencing the target entity like . anyEntity_Entity1 for the above mentioned example

But it is not showing any assocations which are owned by Target Entity like Entity1_anyEntity (these type of associations were not shown there)

Purandare Amey · Answer 3 · 2014-09-11

In such situations, the workaround is to use many:many relation. Then, you can make bidirectional reference, where both entities are owners, and it will be possible to "navigate" from Entity-2 to Entity-1 and vice versa.

Of course, the downside is that you have to add logic to make it "one:many" in the application. For example, in company:employee, to make it one:many, prevent association of more than one companies to one employee through form validations, or Before-Commit event handlers.

Good luck!

Ronald Catersels · Answer 4 · 2014-09-11

May be not the right sollution, but I also have found that the restrictions that are set on the selections where a bit to strict in some versions of the Excel importer. You could simply remove the restriction from the select forms (remove the contrained by). There is a drawback though. These restrictions prevent you from easy mistakes. When you can select anything, you can also select things that are simply not possible. The result would be that the import will not work.

Regards,

Ronald