- This topic has 3 replies, 4 voices, and was last updated 8 years, 2 months 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.
eaDocX
High quality smart documents - fast
eaSheets
Spreadsheet tools for EA modelers
ea Revision Manager
Round-trip model updates direct from document reviews
Model Expert
AI enhanced quality validation & verification
Portfolio Manager
Plan and collaborate real-time across projects
Sparx in the Cloud
Model EA in your browser
eaDocX
High quality smart documents - fast
eaSheets
Spreadsheet tools for EA modelers
ea Revision Manager
Round-trip model updates direct from document reviews
Model Expert
AI enhanced quality validation & verification
Portfolio Manager
Plan and collaborate real-time across projects
Sparx in the Cloud
Model EA in your browser
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 free for life features, plus no obligation, 30-day trials of all the products: eaDocX, Revision Manager, eaSheets, Model Expert and PortfolioManager. Discover for yourself why eaTeamWorks is the world’s best-selling Enterprise Architect extension.
Download