Data Migration to DOORS DNG Presented By Adam
Data Migration to DOORS DNG Presented By Adam Hammett (ahammett@htii. com) & Andrew Ridenour (aridenour@htii. com) 12/5/2020
Overview • Introduction • . CSV, Req. IF • . CSV • Video Walkthrough of CSV • . Req. IF • Video Walkthrough of Req. IF • Questions 12/5/2020
Introduction • Data formats • . CSV (Comma Separated Values) • Req. IF (Requirements Interchange Format) • A type of XML file 12/5/2020
. CSV – What is it? • Simple and transparent data format Microsoft Excel Raw. CSV Format Identifier, Artifact Type, Primary. Text, parent. Binding, module, is. Heading 1, Module, CSV Module 1, , 2, Requirement, Main, , 1, TRUE, 3, Requirement, Second Tier 1, 2, 1, , Etc… 12/5/2020
. CSV – Rules • For a CSV file to be imported successfully into DNG, the content must adhere to these rules: • Rows • Each row in the CSV file must contain the same number of cells (i. e. , same number of commas per line) • Header row • The first row must contain column headers. These headers must not contain escaped characters or apostrophes. • The following table contains the requirements for the columns of the first row. You can have as many columns as needed to correspond to the fields in an artifact type. The artifact type that the columns map to is determined by the entry in the Type column of each content row. • Source: IBM http: //www-01. ibm. com/support/knowledgecenter/SSYMRC_4. 0. 4/com. ibm. rational. rrm. help. doc/topics/r_csv_format. html? cp=SSYMRC_4. 0. 4 12/5/2020
. CSV – When to use it • For one-time creation of new modules and artifacts in Jazz DNG using a simple interface 12/5/2020
. CSV – Limitations • Only allows for basic text (text and numeric) input • No attachments, images, URL’s, text formatting*, etc • Cannot be used to update DNG artifacts • Cannot be used to import links to and from other artifacts • Poor scalability *DNG can use the is. Heading column to format text as a Heading. 12/5/2020
CSV Import 12/5/2020
Req. IF– What is it? • Requirements Interchange Format • Robust and versatile data format made available by the Object Management Group • A Form of XML Image from Object Management Group (http: //www. omg. org/spec/Req. IF/1. 1/) 12/5/2020
Req. IF– When to use it • For large scale migration of an established database (e. g. Rational DOORS) • For collection and integration of change sets to and from other databases (Interchange) 12/5/2020
Req. IF – What can be Imported • You can import several types of data from a Req. IF file: • • • Textual artifacts Graphical artifacts Attribute definitions from link types Data types Folder and folder hierarchy Links Link types Modules Object types Collections View column information, which can be imported in the first import only • The following types of data cannot be imported: • • • Tags View filtering information Comments Reviews Audit history • Source: IBM http: //www-01. ibm. com/support/knowledgecenter/SSYMRC_4. 0. 4/com. ibm. rational. rrm. help. doc/topics/t_import_reqif. html 12/5/2020
Req. IF– Limitations • Not functionally transparent or user-friendly • Requires careful pre-tailoring of source database before export • Complicates Artifact Type, Attribute, and Attribute Type definitions in DNG 12/5/2020
Req. IF– Process Summary • In Rational DOORS • Configure URI’s for Attributes and Types • E. g. https: //www. dummyserver. com/attributes/deliverydate • E. g. https: //www. dummyserver. com/types/deadline • Use Files Mappings for automated assignment attribute URI’s • Define Req. IF Package • Select Modules (Views and Data) and Link Modules to be included • Export Req. IF Package • In DOORS Next Generation • Artifacts Dropdown Import Artifacts… Import Requirements from a Req. IF File • Once complete, refresh the module view to see the imported modules. 12/5/2020
Questions? 12/5/2020
- Slides: 14