Import from Excel/csv and create web links - "Link To" link attribute
For DNG...
Has anyone successfully created web links, each with a label, at the time of import from Excel/csv?
The format in my Excel/csv is...
| id | Name | Owner | Artifact Type | Link To |
| 201481 | AI/CV/ML/DL | "Temp" | Module | {LINK id=389860 uri=https://rtc.intel.com/ccm0001001/resource/itemName/com.ibm.team.workitem.WorkItem/389860} |
I can create the links manually but not if they are in a link column of xls/csv - DOORS NG keeps throwing errors:
Errors were received while importing the CSV file or spreadsheet:
Validation Errors:
Row Number: 1
Error Message: Propagated exception; original message [BadRequestException: CRJZS0129E]
And I don't know how to specify the label for the URL in xls/csv so it displays something friendly iso just the URL when browsing the artifact links.
Manually creating links is a slow & tedious process. Any Help is appreciated.
USE CASE: We need to link DNG Modules to RTC/EWM Review tickets. Linking DNG Modules to RTC/EWM Work Items is not natively supported in the current Release. Therefore, we use Link To web links.
One answer
I'm answering my own question. After several more experiments to find a working link format.
The "Link To" format for linking DNG Module Artifacts to RTC/EWM Work Items via CSV import is
|
{uri=https://rtc.xxx.com/ccm0001001/resource/itemName/com.ibm.team.workitem.WorkItem/389860}
where the URI is the RTC/EWM resource URI in your system. |