Author Topic: csv import of requirements - hierarchy failure  (Read 1198 times)

Jamie_Campbell

  • EA Novice
  • *
  • Posts: 10
  • Karma: +0/-0
    • View Profile
csv import of requirements - hierarchy failure
« on: April 12, 2011, 12:22:27 am »
I'm trying to import a csv file of requirements (as described in http://www.sparxsystems.com/downloads/whitepapers/Requirements_Management_in_Enterprise_Architect.pdf) and I can only preserve the hierarchy to one level (everything lower than level 1 is placed at the top level).
I've tried creating the structure in Enterprise Architect, exporting the file (which looks fine), clearing out the structure and then importing the same file and I get the same results.
I could be doing something wrong but I can't see what and I think it's a bug.
Can anyone help?

AlanT

  • EA User
  • **
  • Posts: 66
  • Karma: +0/-0
    • View Profile
Re: csv import of requirements - hierarchy failure
« Reply #1 on: April 18, 2011, 02:32:51 am »
Jamie,

    I just struggled through this for the first time. . . . .

Did you create a CSV specification first?
Do all your rows have a unique value in the CSV_Key row?
Do all your rows have a TYPE column value of "Package" or "Requirements"?
Do all of your requirements rows have a CSV_PARENT_KEY column value that matches the CSV_KEY value of the package in which you want them contained?

    Hope this helps.  We can exchange sample CSV files, if you like.

                                   Alan

Jamie_Campbell

  • EA Novice
  • *
  • Posts: 10
  • Karma: +0/-0
    • View Profile
Re: csv import of requirements - hierarchy failure
« Reply #2 on: April 18, 2011, 06:47:26 pm »
Alan,
Thanks for the help.
Yes, I've followed all those steps (so you've confirmed I'm not going mad, which is a relief!).
I even tried creating the csv file from the model (by exporting it) and then re-importing the same file. I get the same problem.
I'm on Enterprise Architect v7.5.843. Maybe that's the problem?

Here's my file:

NAME,TYPE,NOTES,Version,PRIORITY,STATUS,CSV_KEY,CSV_PARENT_KEY
Package 1,Package,Notes Package1,,,,Package1,
Package 2,Package,Notes for package 2,,,,Package2,
Package 3,Package,Notes for package 3,,,,Package3,
Package 4,Package,Notes for package 4,,,,Package4,
Package 5,Package,Notes for package 5,,,,Package5,
REQ1,Requirement,Notes on REQ1,1,High,Approved,REQ1,Package1
REQ2,Requirement,Notes on REQ2,1,High,Approved,REQ2,Package2
REQ2.1,Requirement,Notes on REQ2.1,1,High,Approved,REQ2.1,Package2
REQ2.2,Requirement,Notes on REQ2.2,1,Med,Approved,REQ2.2,Package2
REQ2.3,Requirement,Notes on REQ2.3,1,High,Approved,REQ2.3,Package2
REQ3,Requirement,Notes on REQ3,1,High,Approved,REQ3,Package3
REQ3.1,Requirement,Notes on REQ3.1,1,High,Approved,REQ3.1,Package3
REQ3.2,Requirement,Notes on REQ3.2,1,High,Approved,REQ3.2,Package3
REQ4,Requirement,Notes on REQ4,1,High,Approved,REQ4,Package4
REQ4.1,Requirement,Notes on REQ4.1,1,High,Approved,REQ4.1,Package4
REQ4.2,Requirement,Notes on REQ4.2,1,High,Approved,REQ4.2,Package4
REQ4.3,Requirement,Notes on REQ4.3,1,High,Approved,REQ4.3,Package4
REQ5,Requirement,Notes on REQ5,1,Med,Approved,REQ5,Package5
REQ5.1,Requirement,Notes on REQ5.1,1,High,Approved,REQ5.1,Package5
REQ5.2,Requirement,Notes on REQ5.2,1,High,Approved,REQ5.2,Package5

AlanT

  • EA User
  • **
  • Posts: 66
  • Karma: +0/-0
    • View Profile
Re: csv import of requirements - hierarchy failure
« Reply #3 on: April 18, 2011, 10:24:19 pm »
Jamie,

      Import works with the latest EA v. 8 build.  

      When you created the CSV specification, did you check the "Preserve Hierarchy" box?  This is the most likely problem.

                    Alan

Jamie_Campbell

  • EA Novice
  • *
  • Posts: 10
  • Karma: +0/-0
    • View Profile
Re: csv import of requirements - hierarchy failure
« Reply #4 on: April 18, 2011, 10:43:19 pm »
Alan,
Yes, I ticked that box.
Apologies, I gave you the wrong file. The one above works on my version too. I think it's because everything only goes down one level.
This version doesn't work tho'. It creates the packages correctly and puts the REQ1->REQ5 requirements in the right place. However, all the REQx.x requirements are put at the same level as Packages 1 -> 5 rather than under the relevant REQx.
I suspect I'll need to get our Internal Systems department to upgrade my version.

NAME,TYPE,NOTES,Version,PRIORITY,STATUS,CSV_KEY,CSV_PARENT_KEY
Package 1,Package,Notes Package1,,,,Package1,
Package 2,Package,Notes for package 2,,,,Package2,
Package 3,Package,Notes for package 3,,,,Package3,
Package 4,Package,Notes for package 4,,,,Package4,
Package 5,Package,Notes for package 5,,,,Package5,
REQ1,Requirement,Notes on REQ1,1,High,Approved,REQ1,Package1
REQ2,Requirement,Notes on REQ2,1,High,Approved,REQ2,Package2
REQ2.1,Requirement,Notes on REQ2.1,1,High,Approved,REQ2.1,REQ2
REQ2.2,Requirement,Notes on REQ2.2,1,Med,Approved,REQ2.2,REQ2
REQ2.3,Requirement,Notes on REQ2.3,1,High,Approved,REQ2.3,REQ2
REQ3,Requirement,Notes on REQ3,1,High,Approved,REQ3,Package3
REQ3.1,Requirement,Notes on REQ3.1,1,High,Approved,REQ3.1,REQ3
REQ3.2,Requirement,Notes on REQ3.2,1,High,Approved,REQ3.2,REQ3
REQ4,Requirement,Notes on REQ4,1,High,Approved,REQ4,Package4
REQ4.1,Requirement,Notes on REQ4.1,1,High,Approved,REQ4.1,REQ4
REQ4.2,Requirement,Notes on REQ4.2,1,High,Approved,REQ4.2,REQ4
REQ4.3,Requirement,Notes on REQ4.3,1,High,Approved,REQ4.3,REQ4
REQ5,Requirement,Notes on REQ5,1,Med,Approved,REQ5,Package5
REQ5.1,Requirement,Notes on REQ5.1,1,High,Approved,REQ5.1,REQ5
REQ5.2,Requirement,Notes on REQ5.2,1,High,Approved,REQ5.2,REQ5

AlanT

  • EA User
  • **
  • Posts: 66
  • Karma: +0/-0
    • View Profile
Re: csv import of requirements - hierarchy failure
« Reply #5 on: April 18, 2011, 10:53:41 pm »
   I see what you`re trying to do: a hiearchy of the requirements, not just packages.   REQ2.1 is sub to REQ2, etc.

   Your CSV file imports fine into EA 8, so try an upgrade.

                                 Alan

Jamie_Campbell

  • EA Novice
  • *
  • Posts: 10
  • Karma: +0/-0
    • View Profile
Re: csv import of requirements - hierarchy failure
« Reply #6 on: April 18, 2011, 10:58:06 pm »
Many thanks Alan.

Jamie_Campbell

  • EA Novice
  • *
  • Posts: 10
  • Karma: +0/-0
    • View Profile
Re: csv import of requirements - hierarchy failure
« Reply #7 on: April 19, 2011, 12:01:43 am »
I've just had v8.0.864 installed. The import now works correctly ;D

AlanT

  • EA User
  • **
  • Posts: 66
  • Karma: +0/-0
    • View Profile
Re: csv import of requirements - hierarchy failure
« Reply #8 on: April 19, 2011, 12:03:01 am »
Great!  I`m glad that helped.    Alan