Need Help - receiving error message when trying to import
Need Help - receiving error message when trying to import a CSV file.
Error message:
ID CRRRW7570E The comma-separated values (CSV) file was not imported.
Error 400: Bad RequestError 400: Bad Request"CRRRS4213E CSV data is not valid, either the encoding of the content is not supported or the content is missing the required fields: null" (More info found at entry in RRS server log)Requirements Management/3.0.1.2
Requirement trying to upload (tried to import around 20 - received message. I then tried just this one trying to narrow down the issue..i am at a lost right now. There are no special characters, etc)
Requirement 527649 527649 - Receive Case Number when you select Trip Advance f Receive Case Number when you select Trip Advance for Submitted FB
Any help would be appreciated!
Error message:
ID CRRRW7570E The comma-separated values (CSV) file was not imported.
Error 400: Bad RequestError 400: Bad Request"CRRRS4213E CSV data is not valid, either the encoding of the content is not supported or the content is missing the required fields: null" (More info found at entry in RRS server log)Requirements Management/3.0.1.2
Requirement trying to upload (tried to import around 20 - received message. I then tried just this one trying to narrow down the issue..i am at a lost right now. There are no special characters, etc)
Requirement 527649 527649 - Receive Case Number when you select Trip Advance f Receive Case Number when you select Trip Advance for Submitted FB
Any help would be appreciated!
7 answers
In addition to Stef's ideas, I suggest carefully reading the help topic in the information center and searching this forum for past threads on this topic.
Common oversights include these:
1. Data with special characters (especially single and double quotation marks) are not properly escaped
2. A required field/column is missing
Common oversights include these:
1. Data with special characters (especially single and double quotation marks) are not properly escaped
2. A required field/column is missing
In addition to Stef's ideas, I suggest carefully reading the help topic in the information center and searching this forum for past threads on this topic.
Common oversights include these:
1. Data with special characters (especially single and double quotation marks) are not properly escaped
2. A required field/column is missing
1) Is the CSV file UTF-8 encoded? This is required -
2) Are you importing the CSV file into a project that was migrated from RRC 2.x? -
1. Data with special characters (especially single and double quotation marks) are not properly escaped -
2. A required field/column is missing - all required fields are in spreadsheet
thanks
I've opened a defect on csv import.
Hopefully I'm just doing something incorrectly but I would hope if I export an artifact in csv format with the mandatory columns it should re-import.
Mysteriously the same csv files will work on a tomcat-based system but fail on a WAS-based system.
We get even less error text than 'gators1959' did. We just get the one line of:
ID CRRRW7570E The comma-separated values (CSV) file was not imported.
We can't find any more hints on the error in the log files and the error code links to a missing page in the help system.
Hopefully I'm just doing something incorrectly but I would hope if I export an artifact in csv format with the mandatory columns it should re-import.
Mysteriously the same csv files will work on a tomcat-based system but fail on a WAS-based system.
We get even less error text than 'gators1959' did. We just get the one line of:
ID CRRRW7570E The comma-separated values (CSV) file was not imported.
We can't find any more hints on the error in the log files and the error code links to a missing page in the help system.
I've opened a defect on csv import.
We get even less error text than 'gators1959' did. We just get the one line of:
ID CRRRW7570E The comma-separated values (CSV) file was not imported.
We can't find any more hints on the error in the log files and the error code links to a missing page in the help system.
Hey Andrew thanks for posting, I will be following your defect up with another here shortly as I too just experienced both messages (I'm hoping that we can get some attention on it). Just wanted to note that at first, I received the same error that gators had, then using Notepad-> Save As, I found that my .csv file was indeed not UTF-8 (it was ANSI encoded). I was elated... then, after trying the newly-encoded file, I got the same error message you did: "ID CRRRW7570E The comma-separated values (CSV) file was not imported." :x
In case something's wonky with my file now, I'm going to try creating a new UTF-8 .csv file and paste my csv text into it. You never know...