Import issues characters / punctuation in CSV format to IBM Doors
Hello everyone,
Just a short question about importing requirements via CSV to IBM Rational Doors Next Generation.
At the moment, I have to separate the different attributes by commas. This works fine, and I'm able to import artifacts. But the problem occurs when I'm using specific characters.
Of course, the comma is the best example. If I have a sentence in a requirement with commas and I want to import the requirement, I'm getting an error because IBM thinks it's a separator between attributes.
Other errors occur with the use of quotation marks, question marks, enters etc. All characters (and enters), except a dot will trigger an error.
The funny thing is that if I export a few artifacts, I'm getting a CSV file with quotation marks, and enters and every other character. If I want to import the same file again, I'm overloaded with errors.
What am I doing wrong and how can I solve this, because adjusting all imported atrifacts is not worth the effort?
Thank you in advance!
Kind regards,
Bart
|
3 answers
First, you should better familiarize yourself with the rules for CSV, especially in terms of commas, quotes, and newlines. https://en.wikipedia.org/wiki/Comma-separated_values#Basic_rules Second, experiment. Make some artifacts in a DNG sandbox area. Put some commas, (single/double) quotes, newlines, etc in the strings of their attributes and then export them to CSV. Review the CSV (not with Excel, with a text editor) to see how DNG exported the data. That's how DNG expects an import to look. Then make minor changes (not with Excel, with a text editor) to the exported CSV and import to DNG, see how it affects the data in DNG. Rinse and repeat until you understand. :) Comments Ha M K,
Thank you for your answer. I'm aware of the rules for CSV, but thanks for the heads up.
If I import artifacts with all the characters it seems to work if I save the file via notepad, instead of Excel.
But what I was wondering:
All my artifacts (requirements) are in Excel. I can of course make a CSV file from that, open it in notepad, adjust a few things and than import it in DNG. This works for a few requirements. But the requirements I have to import, are more than a 1000. If I have to go through every requirement and adjust them where ever it is needed, this will take a while.
Also, at the moment we are still working in Excel, and DNG in parallel. Sometimes it is needed to update DNG with the changes made in Excel. If I want to import everything again, I have to do it all over again. (or I have to keep track of the changes made in Excel, but still...).
Is there a way to do this faster? I there is not, I understand, but then I don't have the feeling I do a lot of extra work for nothing.
(Notepad doesn't understand for example the place where double quotes are standing and it is also not really possible to make a VBA code for it).
Thanks again for all the help!
Grts,
Bart
|
|
Hmmm... I created this CSV:
id,Primary Text,Artifact Type ,"This is a testing artifact. I will test ""Quotation marks"", of course comma's, question? marks, das-hes, numerical 1002 and last but not least: this one; and we will and with a dot.",Generic Text ,"And another 1, ""quotation"" mark and the question? with a slash / and also some :.",Generic Text Imported it into DNG, it created two new artifacts, exported the two artifacts, and got back the same (plus id's of course). Can you give me the exact text from DNG (not filtered through Excel or your adjustments) that is causing the problem? And can you use "pre" tags around it? |
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.