"Affected By Defect" link import through CSV file
Hi,
kindly help us with the methods to import the csv file going forward.
Regards, Guruprakash |
One answer
Ralph Schoon (63.6k●3●36●47)
| answered Oct 12 '22, 2:19 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER edited Oct 12 '22, 3:12 a.m. The link type is determined by the column header name for the column and the value of that column would be the work item ID. I would suggest to export a CSV and have a look. Comments Include in your export an existing link of the type you want to create.
Chandra Prakash k
commented Oct 17 '22, 6:46 a.m.
Hi,
below is the table which i am using for import. but the system is not accepting. Am i missing something?
Ian Barnard
commented Oct 17 '22, 8:53 a.m.
| edited Oct 17 '22, 8:56 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Yes you are missing something - You're missing doing as Ralph says to export a view of just the artifacts you want to update - but make sure there is an already existing link in the view so you can see how to format the data - with minimal columns (to simplify the CSV as much as possible) but including a column for the link you want to create, so you see the correct way to format the CSV content.
If you want to update module artifacts then you must export from the module and re-import into the same module; otherwise export from a view of the base artifacts and import back not into a module.
When you edit the CSV be careful to ONLY CHANGE THE LINK COLUMN because if you change anything else that change will be made in DOORS Next when you import the CSV. Don't remove or add columns, don't rename columns, don't remove the metadata at the bottom of the export.
Ralph Schoon
commented Oct 17 '22, 10:28 a.m.
| edited Oct 17 '22, 10:28 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Ian, this is EWM. I gave it a shot but it did not work for me. The link was not created.
You could try the work item command line: https://github.com/jazz-community/work-item-command-line
Some observations, use tab separator and use " around the column values. seemed to be the best option for export and reimport.
Ralph Schoon
commented Oct 17 '22, 10:36 a.m.
| edited Oct 17 '22, 10:44 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
I used this file
"Id" "Summary" "Parent" "Affected by Defect"
"181" "test" "#89" "#90"
The parent was created, the Affected by Defect was not. https://github.com/jazz-community/work-item-command-line might be the option.
Ian Barnard
commented Oct 18 '22, 6:32 a.m.
| edited Oct 18 '22, 6:34 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
I don't see anywhere the OP specified EWM - yes I'd assumed DN :-o
You can certainly create links from EWM or ETM to DN artifacts using CSV import into DOORS Next :-)
showing 5 of 6
show 1 more comments
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.