import spread sheet hierarchy issue in DOORS

Hi DOORS gurus!

I am trying to import the attached file to DOORS but DOORS module is not keeping the hierarchy instead it is keeping all object at level 1. I also tried by adding object numbers attribute but couldn't succeed. Any recommendations will be appreciated!


Zaman001 - Mon Nov 20 15:05:47 EST 2017

Re: import spread sheet hierarchy issue in DOORS
Mike.Scharnow - Mon Nov 20 15:10:59 EST 2017

https://www.ibm.com/developerworks/community/forums/html/topic?id=b5aea864-b013-4d43-b0a2-1ad244c29c9c

Re: import spread sheet hierarchy issue in DOORS
Zaman001 - Mon Nov 20 15:47:50 EST 2017

Mike.Scharnow - Mon Nov 20 15:10:59 EST 2017

https://www.ibm.com/developerworks/community/forums/html/topic?id=b5aea864-b013-4d43-b0a2-1ad244c29c9c

I looked at the thread but to me my problem looks bit different as I am not getting any hierarchy at all everything is at level-1. 

Re: import spread sheet hierarchy issue in DOORS
DOORSWizard - Tue Nov 21 10:46:33 EST 2017

Zaman001 - Mon Nov 20 15:47:50 EST 2017

I looked at the thread but to me my problem looks bit different as I am not getting any hierarchy at all everything is at level-1. 

Let me clarify Mike's answer, the import into DOORS from excel is always going to place things at level 1 and/or at the level following the last object it updated (more advanced use case, not what you are doing here). In the post there is a rebuild hierarchy script that is attached (DXL) so you would need to follow the instructions in the post to add the necessary column(s) to your spreadsheet, then import and then open the module and go to Tools > Edit DXL ...load the script and click Run. All goes well your objects will be moved to the right locations and you will no longer have everything at level 1. Hope that helps.