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! |
7 answers
Hello Renee,
Couple of thoughts: 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? |
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 |
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. 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. |
I've opened a defect on csv import. 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... |
|
Hi everyone, in case anyone still needs to import .csv in 3.0.x , we figured out that if we switched to an IE browser, it would work (same rules apply though).
|
|
Hi everyone, in case anyone still needs to import .csv in 3.0.x , we figured out that if we switched to an IE browser, it would work (same rules apply though).
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.