Import requirements from a CSV file
I was trying to import a csv requirements file into DNG to update a module but I am getting multiple errors:
- If i try to import directly my file into DNG, I get the next error
ID CRRRW7571E This error can occur for several reasons. For example, you might not have permission to import an artifact type that is in the file, a row or resource might be locked by someone else, or the file might not meet the requirements to be imported. For instance, one or more rows might contain a type that is not in the type system. It's also possible that an incoming link cannot be created in another component because it is a baseline or requires a change set. Update the file, the type system, your user permissions, or all of these items. Also, confirm that the components allow the creation of outgoing links. If incoming links are being created in other components that require change sets, create a change set in the other component and add that change set to a personal stream along with the current stream or change set. To learn more about the CSV format or spreadsheets and importing CSV files or spreadsheets, see the product documentation in IBM Knowledge Center.
Errors were received while importing the CSV file or spreadsheet:
Validation Errors:
Row Number: 44
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 12
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 45
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 35
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 46
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 36
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 47
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 37
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 48
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 26
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 38
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 27
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 39
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 28
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 29
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 4
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 6
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 9
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 40
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 30
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 42
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 31
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 32
Error Message: CRRRS4212E The server encountered an exception: null
Row Number: 43
Error Message: CRRRS4212E The server encountered an exception: null
- If I generate a CSV from an exported view and then copy the data into that CSV and import it back, I get the next error:
ID CRRRW7571E This error can occur for several reasons. For example, you might not have permission to import an artifact type that is in the file, a row or resource might be locked by someone else, or the file might not meet the requirements to be imported. For instance, one or more rows might contain a type that is not in the type system. It's also possible that an incoming link cannot be created in another component because it is a baseline or requires a change set. Update the file, the type system, your user permissions, or all of these items. Also, confirm that the components allow the creation of outgoing links. If incoming links are being created in other components that require change sets, create a change set in the other component and add that change set to a personal stream along with the current stream or change set. To learn more about the CSV format or spreadsheets and importing CSV files or spreadsheets, see the product documentation in IBM Knowledge Center.
Errors were received while importing the CSV file or spreadsheet:
Validation Errors:
Row Number: 2
Error Message: CRRRS4212E The server encountered an exception: com.ibm.rdm.fronting.server.rrs.importer.csv.InvalidCsvException: CRRRS4204E Stream does not conform to RFC4180 formatting rules.
The following attributes were not imported:
Column: module;
Reason: NOT_FOUND
Column:
Reason: CRRRW8015W
what is the correct way to upload csv files into DNG?
2 answers
- csv file MUST be encoded as UTF8 (note: not as UTF8-BOM)
- column headers must match attribute names
- cell values for attributes with enum type must have valid values (matching enum values)
-
there are mandatory columns/attributes for an import (this list varies according to DNG version)
Comments
Ian Barnard
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Nov 03 '22, 1:04 p.m.Ian Barnard
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Nov 07 '22, 4:23 a.m.Ian Barnard
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Nov 07 '22, 4:21 a.m.