Showing results for 
Show  only  | Search instead for 
Did you mean: 

Excel bulk import of Property Values

Occasional Contributor

Excel bulk import of Property Values



We're using V2R1 and have the requirement to import a set of Properties for each applications which describe information from our previous office automation EA tools that we don't want to lose. So, Property Values needs to have the same short name on each application but import fails because of short name duplication.


What is the best way to do a bulk import of 5/6 properties with over 600 applications? Any ideas? We do not want to customize (yet) the metamodel and only have a Hopex web front end (no windows Hopex UI).


Attached an Excel template file of a failed experiment.


Thank you!


2 Replies
MEGA Partner

Re: Excel bulk import of Property Values



The order of import is important. You must import and create the basic objects, like applications, Property Types, Property Values, before you link the objects together. Since you have no AbsID at the time of import, all the names also have to be unique. The Property Type you have one of each, for the Property Value, you one per Application you link them to. The excel file would look something similar to the attached

Tags (1)
Occasional Contributor

Re: Excel bulk import of Property Values

Thank you. I'll try to import property values using unique short names and renaming them later.