How to import a spreadsheet in IBM Rational DOORS
I have a spreadsheet in CSV format with the following three columns:
ID Attribute1 Attribute2
ID is the unique (absolute?) number that "go to" uses in DOORS. Values are in format SRD-123.
Attribute1 is a string
Attribute2 is text
I created this spreadsheet by exporting to Excel from DOORS, and adding the values for the two attributes.
The attributes already exist in DOORS with no data in them.
I'd like to import this spreadsheet into DOORS with the goal of automatically entering the values for the attributes. Specifically,
Attribute2 would be filled for an already existing ID.
I've tried the DOORS import feature but haven't had any luck with it. Is this something that DOORS can do (from the GUI) or is a DXL script required? Or do I need a more detailed hierarchy for the spreadsheet?
The DOORS GUI's built in import feature will happily accommodate a CSV spreadsheet, which you should be able to convert your excel document into (via Excel).
If you want to keep it as an excel document, you will need to use DXL script.
Importing artifacts from CSV and spreadsheet files using IBM , When you import requirements that were previously exported from IBM® Rational® DOORS® Next Generation, they can include markup text for links and Click File > Import > Spreadsheet. Select the file that you want to import and the options that you want to apply. For more information about the import options, click Help. Click Import.
In Spreadsheet Import, instead of Object ID like SRD-123, you need to use Absolute Number 123
The spreadsheet column Absolute Number must have only the number, not the prefix.
Import process for CSV and spreadsheet files, Microsoft Excel (XLS) and Office Open XML (XLSX) format. When you import requirements that were previously exported from IBM® Rational® DOORS® Next You can import and export CSV files or spreadsheets in Microsoft Excel (XLS) and Office Open XML (XLSX) format. When you import requirements that were previously exported from IBM® Rational® DOORS® Next Generation, they can include markup text for links and embedded artifacts. During the import process, this markup text is used to create or
Answer to this question is very simple
ID in DOORS is Legacy ID + Absolute number (unique for each req) Attribute name 1 --》 Let's say xyz Attribute name 2 --》 Let's say ABC
So you want to update the values of both xyz and ABC in DOORS with respect to Excel
For that the process is simple....... Save your excel file as .txt and then rename .txt to .tsv and then import into doors and content will reflect into doors
Make sure that Excel attributes name and excel attributes name must be equal
Importing data into formal modules, Use the IBM® Rational® DOORS® importers to populate modules with data from import only data that is in one of the languages that are supported by Rational The import spreadsheet tool imports comma-separated value (CSV) and tab The DOORS GUI's built in import feature will happily accommodate a CSV spreadsheet, which you should be able to convert your excel document into (via Excel). If you want to keep it as an excel document, you will need to use DXL script.
How to export contents of Rational DOORS module to spreadsheet , How do you export contents of IBM Rational DOORS module to spreadsheet, make changes and import it? Import the spreadsheet back to Rational DOORS using File -> Import -> Spreadsheet option. NOTE : If there are any new columns that are present in the spreadsheet then create attributes with the same name when the dialog box appears during the import of spreadsheet.
Importing and exporting CSV and spreadsheet files in the , For example, you can export artifacts to a CSV file, change the attribute values in the file, and then import that file back into IBM Rational DOORS Next To start an import, open the Artifacts page and at the Create or More Actions menu, click Import Artifact. Click Import requirements from a CSV file or spreadsheet. After you select a CSV file or spreadsheet, you can choose to import requirements into a folder or into a module.
CSV Roundtrip with DOORS, This tutorial describes workflow of roundtrip CSV synchronization between ReqView and a IBM Rational Answer. No, Rational DOORS is unable to import spreadsheet data with hierarchy. Although import spreadsheet is one method to bring in object information the information is brought in “flat”; meaning everything is at level one.