[closed] RRC Import artifacts from CSV file - CRRRW7571E
Hi,
When attempting to import some artifacts from a CSV file we get the following:
The comma-separated values (CSV) file cannot be imported.
ID CRRRW7571E The file does not meet the requirements to be imported. For example, one or more rows might contain a type that is not found in the type system. Update the file, the project type system, or both. To learn more about the CSV format and importing CSV files, see the help system.
Errors were received while importing the CSV file:
Validation Errors:
Row Number: 1
Error Message: ropagated exception; original message [CRRRS8657E An invalid value was specified for the attribute definition URL https://rtc.customs.govt.nz:9443/rm/types/_ZGrAUURpEeStdvELQQsDIA#b7a5c421-a2d8-447d-8e6d-a77c78780c1f.
I am able to import this csv file into another project (which was seeded from the same template as the current project I am having trouble importing the csv file into .... I believe one of my colleagues has possibly removed some attributes or something).
Where can I get more info from my system as to what may be wrong? or where is a good place to start debugging the problem ...... I am not that experienced with RRC (DNG). We have RRC 4.0.7 installed.
Dave Flynn
When attempting to import some artifacts from a CSV file we get the following:
The comma-separated values (CSV) file cannot be imported.
ID CRRRW7571E The file does not meet the requirements to be imported. For example, one or more rows might contain a type that is not found in the type system. Update the file, the project type system, or both. To learn more about the CSV format and importing CSV files, see the help system.
Errors were received while importing the CSV file:
Validation Errors:
Row Number: 1
Error Message: ropagated exception; original message [CRRRS8657E An invalid value was specified for the attribute definition URL https://rtc.customs.govt.nz:9443/rm/types/_ZGrAUURpEeStdvELQQsDIA#b7a5c421-a2d8-447d-8e6d-a77c78780c1f.
I am able to import this csv file into another project (which was seeded from the same template as the current project I am having trouble importing the csv file into .... I believe one of my colleagues has possibly removed some attributes or something).
Where can I get more info from my system as to what may be wrong? or where is a good place to start debugging the problem ...... I am not that experienced with RRC (DNG). We have RRC 4.0.7 installed.
Dave Flynn
The question has been closed for the following reason: "Problem is not reproducible or outdated" by rschoon Jan 10 '24, 4:42 a.m.
3 answers
Hi Dave,
It sounds like you're attempting to import artifacts containing attribute values that do not exist in the new project. I'd suggest putting this in your browser:
https://rtc.customs.govt.nz:9443/rm/types/_ZGrAUURpEeStdvELQQsDIA?accept=*&private=true
Then in the response you get back from the request above, look for the literal after the hash in the URL you posted (#b7a5c421-a2d8-447d-8e6d-a77c78780c1f). The error is telling you that somewhere in your CSV, you're attempting to import a value that is not defined in the project you're importing to.
The data might be overwhelming, so feel free to contact support if you need help going through it. Hope it helps!
It sounds like you're attempting to import artifacts containing attribute values that do not exist in the new project. I'd suggest putting this in your browser:
https://rtc.customs.govt.nz:9443/rm/types/_ZGrAUURpEeStdvELQQsDIA?accept=*&private=true
Then in the response you get back from the request above, look for the literal after the hash in the URL you posted (#b7a5c421-a2d8-447d-8e6d-a77c78780c1f). The error is telling you that somewhere in your CSV, you're attempting to import a value that is not defined in the project you're importing to.
The data might be overwhelming, so feel free to contact support if you need help going through it. Hope it helps!
Hi Dave,
It sounds like the projects type system has been modified or is different from the one reflected in the CSV.
I would suggest to check the Artifact type and attribute names in the CSV file with the type and attribute names as reflected in the project. You can do this by creating a different CSV file from the project.
Adjust your CSV file with the correct names, and try importing again.
Hope it helps!
It sounds like the projects type system has been modified or is different from the one reflected in the CSV.
I would suggest to check the Artifact type and attribute names in the CSV file with the type and attribute names as reflected in the project. You can do this by creating a different CSV file from the project.
- go to the project
- create a new artifact of the type you are trying to import (from your sample above it seems like it is Requirement)
-
Locate the artifact at the Artifacts page
-
Display in columns, the attributes you are interested in by using. (you can do this by selecting Configure page settings > Configure columns to display)
- From the artifacts edit options (little pencil icon between the selection box and the ID of the artifact), select Export artifact
Adjust your CSV file with the correct names, and try importing again.
Hope it helps!
Comments
Hi Jianoula,
Thanks for your suggestion ... a good (& logical) place to start. I did this but still experienced the same problem ( plus warnings that 2 attributes were not imported as they were SYSTEM_MAINTAINED .... as expected).
I am going to open a PMR to get further assistance in diagnosing my problem.
regards
Dave
Hi:
Dave Flynn
Through my multiple experiments, I have come to the conclusion that when exporting a module containing table content from DNG in Excel format, the first modification and export back to DNG can update the module content, but the second time it will report an error, which is similar to the error content you reported. I feel that it is a bug.
Currently using ELM 7.0.2 version, I would like to know if there is a perfect response to your case
Currently using ELM 7.0.2 version, I would like to know if there is a perfect response to your case
Comments
Dave Flynn
Sep 30 '14, 7:34 p.m.The CSV file looks like:
Artifact Type,Name,Primary Text
Requirement,SOW05-F3 Auditing,Auditing
Requirement,SOW05-F4 Support Legacy Interface,Support legacy Interface
Requirement,SOW05-F6 Online User Interface for Lodgement & Registration,Online user interface requirements - Partially completed Lodgements or Registrations
Requirement,SOW05-F7 Online User Interface for Helpdesk,Online user interface requirements - Helpdesk support access