Export/Import Requirements to/from Excel missing parent_id

Hi,

I am experimenting with exporting and importing requirements to/from Excel. What I have done is roughly:

  1. Create a new project, a new model and a requirements diagram
  2. I go to Window → Configuration → “Configure Requirement Types…”
  3. I add a new requirement type, called e.g. “Requirement2”
  4. I add the properties ID, Description, and a custom Text field to Requirement2
  5. In the requirements diagram, I create an ordinary requirement, and set some value on all properties
  6. I also create a “requirement2” and set some value on all properties
  7. I add a “Containment” link between the requirements
  8. I export the diagram to excel
  9. When I open the excel file, there are columns for the requirements for all properties of both requirement types. The first columns are:
    Type, Name, "Transit From", "Transit To", "<<Requirement>>\nText", "Parent User ID", "<<Requirement>>\nID"
  10. However, the values for the Requirement2 properties are miss-aligned, like this:
  11. The first two rows are of type “Requirement” and the last two rows are of type “Requirement2”. Notice how the “Text 3” and “Text 4” are at the wrong column.
  12. It appears as if the problem is that it expected that there would be a “Parent User ID” column between the Text and ID columns. I guess the ID_2 with gray background should have been at the Parent User ID column near the start of the row.
  13. When I import this file back to VP, it will think that the Text property of all Requirement2 objects have changed.

I use VP Version 16.3 (Build 20210701) on 64bit Linux.

Hi Borisk,

Sorry about the problem. Unfortunately, we tried to follow your steps and with different export settings but still, we are unable to reproduce your problem. Would you mind giving us your project file for checking? You can upload your project to the following place:

https://files2.visual-paradigm.com/index.php/s/0GOgkmOOMtwO3ON

note: Only Visual Paradigm staff can access your file.

Best regards,
Jick Yeung

Hi Jick,

I have created a project file and an exported excel file, but the link you wrote in the forum is password protected, and I do not know the password.

Best regards,
Boris

Hi Boris,

Sorry, here is the password:
kjgfbyusdf9ds9sdgfsbi

Best regards,
Jick Yeung

Hi Jick,

Thank you, now I have uploaded the files.

Hi Boris,

Thank you for your flie. With your file, I can repeat the problem and have reported that to our team for a fix. Once a fix is available, I will let you know.

Best regards,
Jick Yeung

Hi Boris,

The problem reported under this post has also been fixed. You can try again with the latest build, and the update instruction is provided under another post you submitted earlier.

Best regards,
Jick Yeung

Hi Jick,

I have verified that this bug is solved in the update you provided.

Thanks for your help!

Best regards,
Boris

We are glad to know about it. Thank you for trying.