hi |
Re: to import Excel to DOORS. 1. Open the module you want the imported data to be held in Exclusive Edit. 2. Select File->Import->Spreadsheet 3. On the Import Spreadsheet dialog, browse to the required CSV file. 4. Leave the default radio button values (By Column Labels, Update Existing Objects, All Objects) 5. When dialogs appear asking "Create new Text attribute ID", etc., select "Confirm". 6. When dialog appears asking "Select Key", select "ID". These steps will create 4 new objects. BUT, the object text will be shown as blank, because the object text you have imported has actually been stored in an attribute called DES, because that was the name of the column in the spreadsheet. If you want to import the four columns into specific attributes in your module, at step 4 above change the radio button to "From List", and then select the 4 attributes you want to populate, in the order left-to-right in the spreadsheet, from the Existing attributes list and press Add. IT IS VITAL THAT YOU DEFINE THE SAME NUMBER OF ATTRIBUTES AS COLUMNS IN THE SPREADSHEET, otherwise you might encouter a lot of errors that you have to click through. Try it on a small sample first. I hope this helps. If you still have problems, if you specify the problem we might be able to help further. |
Re: to import Excel to DOORS. regards, bhuvana |
Re: to import Excel to DOORS. bhuvanaperiyasamy - Tue Mar 08 00:25:06 EST 2011 I think you might be misunderstanding the concept of DOORS Objects and Attributes. You will also need to understand how the object hierarchy works in a DOORS module. A DOORS module object is a record of data that consists of many attributes. So when you import data from a csv spreadsheet, each row in the csv spreadsheet will become an object, and each column represents the data to be copied into specific attributes in that object. The "DES" column in your example csv file looks like the Main Column of DOORS - it contains headings and text. The Main Column of DOORS is very special - it is made up of two object attributes named "Object Text" and "Object Heading". If text is copied into the "Object Heading" attribute DOORS will automatically add a heading number to that text and apply a font to make it look like a heading in the Main Column. The heading number that DOORS applies will be based on where that object is in the hierarchy of the document. Because you are importing from a csv spreadsheet, DOORS will create objects all at the same level so these heading numbers may seem to be strange. You can manually move the objects into the correct hierarchy and the heading numbers will automatically change. If text is copied into the "Object Text" attribute, DOORS will show this as normal text in the Main Column. So you need to split the DES column into two columns - one column for rows that contain text that you want to be headings, and one column for rows that contain ordinary text. When you import, just make sure that each column is mapped to the correct attribute in DOORS. Paul Miller Melbourne, Australia |
Re: to import Excel to DOORS. bhuvanaperiyasamy - Tue Mar 08 00:25:06 EST 2011 It might be easier to do as Paul suggests and split out the Heading and the Text in the CSV file as two separate columns and then map these onto Object Heading and Object text attributes during the import. |
Re: to import Excel to DOORS. Hi there,
i am trying to Import this file (see attachment) into DOORS. I need this to be reflected as is. Is this possible? In my excel Spreadsheet i have put in quotation mark the attributes created in DOORS. Is the problem the option i am choosing in Rational DOORS when i am doing the Import or is the problem the formatting of my spreadsheet? Sorry my English is really bad .... Thanks Bianca Attachments ListeBesoinsDesPartiesPrenantes100.csv |
Re: to import Excel to DOORS. Miss - Thu Apr 02 14:38:47 EDT 2015 Hi there,
i am trying to Import this file (see attachment) into DOORS. I need this to be reflected as is. Is this possible? In my excel Spreadsheet i have put in quotation mark the attributes created in DOORS. Is the problem the option i am choosing in Rational DOORS when i am doing the Import or is the problem the formatting of my spreadsheet? Sorry my English is really bad .... Thanks Bianca Hi Miss, The .csv file format is not OK. I opened it with Excel. I selected the first 5 columns, and I formatted the Cells to be Alignment->Top, Wrap Text You do not have column headings in columns B, C, D ... Only in Column-A do you have a Heading. The data in the cells do not look correct. BTW Go to http://www.baselinesinc.com/dxl-repository/ and look for "Import from Excel" to download a DXL that allows you to directly import into DOORs from Excel. You will need to get ExcelFunctions.inc from the same site. ~Russ |
Re: to import Excel to DOORS. rmoskwa - Fri Apr 10 15:14:21 EDT 2015 Hi Miss, The .csv file format is not OK. I opened it with Excel. I selected the first 5 columns, and I formatted the Cells to be Alignment->Top, Wrap Text You do not have column headings in columns B, C, D ... Only in Column-A do you have a Heading. The data in the cells do not look correct. BTW Go to http://www.baselinesinc.com/dxl-repository/ and look for "Import from Excel" to download a DXL that allows you to directly import into DOORs from Excel. You will need to get ExcelFunctions.inc from the same site. ~Russ Hello Russ, Hello Bianca, The problem comes with the fact that there are different csv-Formats around the world. In parts of Europe including France, values are separated with ; whereas an American Excel and DOORS excpects the values to be separated with , Bianca, You could either temporarily change the settings of your computer to the regions of USA, or export the file in "tab separated" format. The latter works fine for me (Germany). You should then remove the " again, as currently, as you see if you look at your csv fie in a text editor, Excel changes the " to """. And it might be a good idea to remove the # at the beginning of attribute "# STRQ". Plus, I see that the attributes »Partie prenante«, »Statut« and »Priorité« are really empty. Don't know if this was intentional.
BR, |
Re: to import Excel to DOORS. rmoskwa - Fri Apr 10 15:14:21 EDT 2015 Hi Miss, The .csv file format is not OK. I opened it with Excel. I selected the first 5 columns, and I formatted the Cells to be Alignment->Top, Wrap Text You do not have column headings in columns B, C, D ... Only in Column-A do you have a Heading. The data in the cells do not look correct. BTW Go to http://www.baselinesinc.com/dxl-repository/ and look for "Import from Excel" to download a DXL that allows you to directly import into DOORs from Excel. You will need to get ExcelFunctions.inc from the same site. ~Russ Hello Russ, Hello Bianca, The problem comes with the fact that there are different csv-Formats around the world. In parts of Europe including France, values are separated with ; whereas an American Excel and DOORS excpects the values to be separated with , Bianca, You could either temporarily change the settings of your computer to the regions of USA, or export the file in "tab separated" format. The latter works fine for me (Germany). You should then remove the " again, as currently, as you see if you look at your csv fie in a text editor, Excel changes the " to """. And it might be a good idea to remove the # at the beginning of attribute "# STRQ". Plus, I see that the attributes »Partie prenante«, »Statut« and »Priorité« are really empty. Don't know if this was intentional.
BR, |
Re: to import Excel to DOORS. Hi All,
I am facing currently some problem while importing excel files. 1. When I am trying to import excel (already converted .csv) into DOORs, some of its content is lost like tables, images. 2. while importing through LIST I am not able to get all the columns like in excel sheet.
BR, Akku |