Products

Home Forums eaDocX queries Adding child elements via Excel import

Home Forums eaDocX queries Adding child elements via Excel import

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #9013
    Tom Tomasovic
    Participant

    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

    #9014
    eadocX Support
    Participant

    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!

    #9015
    Phillip Khaiat
    Participant

    This feature is available in the native EA CSV importer.

    #9016
    Tom Tomasovic
    Participant

    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.

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.

Compare licence prices

Choose the licence that’s right for you and your team

Prices

Download a free trial

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