![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: Problems while importing a CSV file Topic Summary: Created On: 3-Sep-2007 17:54 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
I am having some troubles when importing a CSV file.
One of them is the following: When a string value to be imported contains a raising to a power (e.g. km²) the following comma delimited valued is skipped and the import process fails. Has anybody experienced that? Client version: 8.0.0.6 Server version: 8.0.0.0 |
|
![]() |
|
![]() |
|
Just a correction to my previous post.
When a string value to be imported contains a raising to a power (e.g. km²) the following comma delimited valued is sometimes truncated and sometimes skipped. In the second case the import process fails because the CSV value counter and attribute counter are not "aligned" any more (values inserted in wrong attributes). |
|
![]() |
|
![]() |
|
CSV files are flat text files and they don't support the "to a power" formatting that you are speaking of.
You shoul,d change instances of km2 to km^2 or something and then you can write a DXL script to convert this back in DOORS. ------------------------- Kevin Murphy http://www.baselinesinc.com The Requirements Management Experts |
|
![]() |
|
![]() |
|
Thanks for explanation Kevin.
So, since the only way (as far as I can understand) to import a MS Excel file is to save it as CSV, I will always have to remove all not supported formatting before starting the import process, right? Sorry if my question sounds stupid... |
|
![]() |
|
![]() |
|
Not going to be desperately helpful here I'm afraid, but I share your annoyance at the lack of a powerful import option. If you assume an excel spreadsheet or word table with an even number of columns and rows and with column headers corresponding to attribute names then you should be able to create or update a doors module from it. I use a fairly ugly kludge to turn a rtf table into a rich text encoded csv file and import it to DOORS using a slightly modified copy of the import spreadsheet - not very satisfactory and more than a bit slow (caused by the deciphering rich text).
The right way to do this would be to use a vba macro where you could specify the module location maybe using an URL and then select a "key" column to match a unique identifier such as the "absolute number" in the DOORS module. You would then you use a vba macro to pass DOORS a "runStr" command for each row in the table/spreadsheet, the vba code would be very similar for both Excel and Word. I have had this down as a useful thing to do for years, but never got round to it, It would be interesting to know if someone on this forum has done this - I think its likely that someone has. Sorry for the lack of constructive help! ------------------------- Regards, Richard Good |
|
![]() |
|
![]() |
|
Well, if someone has done this, please speak up.
Otherwise, it sounds like a project I could take a look at in my spare time.... ------------------------- Kevin Murphy http://www.baselinesinc.com The Requirements Management Experts |
|
![]() |
|
![]() |
|
Hi Andrea,
It seems to be a problem of incorrect codepage ... Please see my posting here for more information. Hope that helps, Greetings Reik ------------------------- Evosoft GmbH for Siemens Industry Sector Berlin, Germany |
|
![]() |
|
![]() |
|
Reik,
Are you saying that you can have formatting like km² in a CSV file, and it'll transfer to DOORS correctly? I had always believed that "²" was not in the standard ASCII set, but it seems that it could be based on some copy/paste functions I am doing. ------------------------- Kevin Murphy http://www.baselinesinc.com The Requirements Management Experts |
|
![]() |
|
![]() |
|
Hi Kevin,
yes, yes ... This formating can be in CSV file, but it is not standard ASCII. ASCII defines only a 7 Bit code so the first 128 characters .... The codes above that are defined by many different character encodings See Wikipedia So it depends, if both tools are speaking the same language ;-)) I've tried to import from Excel the "km²" and "m³" and came to different results depending on selected codepage on the machine: with CP 850 it worked well and both strings where imported correctly, with cp 437 only the first one "km²" worked and the second one failed ... Hope that helps you to understand it better ![]() Greetings Reik ------------------------- Evosoft GmbH for Siemens Industry Sector Berlin, Germany |
|
![]() |
Telelogic DOORS
» Defect/Issue Tracking
»
Problems while importing a CSV file
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.