Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Importing an Excel Spreadsheet that has multiple tabs into DOORS NG

Questions
Tags
Users
Badges
Mary Miller
(87●2●32) Jun 14 '19, 1:04 p.m.
Good day,

I have a different question.  I am looking to see what the best option is.  I have a set of Excel spreadsheets that have multiple tabs in it.  One tab contains the requirements.  The remaining tabs contain textual DoDAF Views.  The organization wants to put all of these into DOORS NG.

I suspect that I am going to have to save each tab off as a separate csv file, and import each csv file into DOORS NG.  Would that be the only way to import the Excel file (with multiple tabs) into DOORS NG or is there a way to get the whole thing imported?

Thanks!

Mary

0 votes

1 answer
1,870 views
0 votes

Accepted answer

Permanent link
Sean F
(1.3k●2●52●162) Jun 15 '19, 8:37 a.m.
Hi Mary,

Saving each tab as a separate CSV or XLSX would be the normal approach.

You can then import each separate spreadsheet as a module.

If there are extra columns then you need to create the corresponding attributes first as DNG does not auto-create attributes like DOORS Classic does.
Mary Miller selected this answer as the correct answer

0 votes

Comments
Mary Miller
Jun 17 '19, 1:40 p.m.

Ok.  I was hoping their would be a simpler way.  Thanks!  -Mary

Your answer

Register or log in to post 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,026

Question asked: Jun 14 '19, 1:04 p.m.

Question was seen: 1,870 times

Last updated: Jun 17 '19, 1:40 p.m.

Confirmation Cancel Confirm