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

Import CSV Method - Combine Worksheets or Upload Separately?

Hi! First question I've asked here. Hoping the good forum members here can offer their input! We are using DOORS Next Generation version 6.0.2.


As the title states, we're at a bit of an impasse with our DNG ingestion technique. It seems that  the approach to workbooks containing multiple worksheets would be splitting those sheets and importing one by one. However, since these workbooks are now dissociated from their original book, clean up and placing said documents into modules could be lengthy and/or inefficient.

Is there a prevailing method to uploading documents with multiple worksheets? Would it be more beneficial to combine the worksheets into one excel book of all worksheets? Furthermore: how would document generation work for a multi-sheet workbook? 

Any input or advice would be greatly appreciated!

0 votes

Comments
* Places tongue firmly in cheek *

Since no one deemed this a worthy question, I'll provide the answer that we came up with. 


Short answer: yes, uploading in bulk is encouraged. 

Long answer: https://jazz.net/wiki/bin/view/Main/DNGCSVImpExp; Use your VBA skills and the "module" column to associate groupings of artifacts together. Update increment fields as needed (p-binding, identifier).

Still unsure of what generating a multi-doc workbook would look like. 


Be the first one to answer this question!

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.

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

Question asked: Jun 28 '17, 2:15 p.m.

Question was seen: 3,538 times

Last updated: Jul 07 '17, 4:23 p.m.

Confirmation Cancel Confirm