- This topic has 3 replies, 4 voices, and was last updated 7 years, 1 month ago by .
Viewing 4 posts - 1 through 4 (of 4 total)
Viewing 4 posts - 1 through 4 (of 4 total)
- You must be logged in to reply to this topic.
Home › Forums › eaDocX queries › Adding child elements via Excel import
Home › Forums › eaDocX queries › Adding child elements via Excel import
Hi!
I am trying to do some simple imports to my EA model.
What I would like to do is to add some new elements which are destined to be children of other (existing) elements. Doing a “straight” import, all the elements are inserted at the same level, and I have to go back in and create the parent/child relationships.
In deconstructing the export spreadsheet, I see that there is a hidden column for ParentID and, for existing parent/child relationships, this column is populated (with a 4 digit string). I assumed(?) that ID would be available as an attribute of the element, but that does not seem to be the case (at least, I couldn’t find it in the eaXL profile). I’m assuming I could go into the database and find this somewhere, but it seems like it should be easier than that.
My further (untested) assumption is that, if I were to add a new row to my eaXL spreadsheet which contained a valid value in the ParentID column, that the import would create the new element as a child of the identified parent.
I am guessing that it is not possible to import both a new element and children at the same time (if it’s even possible at all).
Am I missing something? Am I asking too much?
Thanks for any advice or information!
Tom
The use case you are trying to use is not currently supported by eaDocX/Excel.
I will add it to the backlog of requests for v4, which we are currently designing: what you want to do seems like a very reasonable thing!
This feature is available in the native EA CSV importer.
Hmmm…
Not sure if I have discovered a hidden feature/capability, but this is what I found.
I did an extract of a package which contained several sub-packages. in the extract file, I inserted a number of blank rows and filled them with elements I wanted to import. When I did the import, the new rows were all inserted properly as children of the parent sub-package. This is precisely what I had intended.
Further investigation indicates that this does NOT work when I attempt to export/import children of elements. The only solution in that case is to import the children to the parent package and then move them to the appropriate element. I have yet to see if doing that will cause issues in crafting eaDocX extracts of the target elements.
Download eaTeamWorks today for several free for life features, plus no obligation, 30-day trials of all the products: eaDocX, ea Revision Manager, eaSheets, Model Expert and PortfolioManager. Discover for yourself why we sell the world’s best-selling Enterprise Architect extension.
Download