Error importing requirements from Excel - Parent not found?
I am trying to import some requirements in ALM 11.52 via Excel. I have requirement types in a folder, and able to create folders, and other requirement types just fine as part of the export.
There is a need, however, to have parent-child relationship between requirements without involving folders. A buiness requirement, for example, might be covered by 5 functional requirements so I am trying to have 5 functional requirements appear under 1 business requirement as part of the export.
When I provide "path" (like below) for the 5 functional requirements (to appear under 1 business requirement), ALM throws error (-3) saying parent not found when parent path and the parent Business Requirement are there. In QC 10 we were able to import requirements using this parent-child relationship between requirements without involving folders but in ALM this is not working .. maybe I am doing something wrong?
Here is the path I am using for 5 functional requirements, and these folders are already there as well as the BusinessRequirement1:
Parent Folder\Child Folder\BusinessRequirement1
Any help is greatly appreciated.
Are you able to create the child requirements manually? Try that to confirm that the relationship is allowed. If it can be done manually, you should be able to import that heirarchy.
In other threads where the same error was reported, users found that they had leading or trailing blank spaces in the path specification in Excel. Make sure you don't have any leading or trailing blank spaces in your data.
(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
I faced the exact similar issue Yesterday. After some R&D, I realized cell format that is on 'Business' requirement row causing issue. So I deleted the cells on that row and re-formated. Then it worked fine. You may try the same way. Or provide the excel sheet, I will let you know where the issue is.