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