Custom Excel export for link analysis

I am somewhat new to using the export functions with DOORS. I am trying to create a custom Excel export that will allow my customer to export a view that contains the results of the Link Analysis Wizard.

For example: I run the In-Link Analysis  Wizard and get the results that REQ1 has 3 in-links. I want to export this new view to Excel and have all 3 of the in-links reside in separate cells. Currently, when I export to Excel all 3 in-links are in the same cell. I want to create an export that has the in-links listed in separate cells, preferably in new rows (see below).

This is the current export format I am working with:

This is the desired format:

I will also add that my customer will need to run this report on many formal modules, multiple times, so I would rather not just tell them to make edits to the default excel export.

Is there a way to do this? I am running the DOORS 9.6.0.0 client. I am willing to explore DXL solutions if enough explanation is provided (I am new to programming).

Any help is greatly appreciated. Thanks!

Re: Custom Excel export for link analysis
DOORSHAM - Tue Apr 05 18:50:41 EDT 2016

Simple solution if your situation will permit is do the following.

Delete 1st column then to the layout dxl in second column add somethingsimilar to following that display the in-link info

display   "\""  obj."Object Text"    "\",\""    sINLINK_Info

Note  sINLINK_Info should be plain text instead of richtext.

Then export the view to text file; rename text file  to have .csv extension. such as  Links.csv

You double click on Links.csv and excel will display info in your prescribed format.

Caviate consider the above as pseudo code -- you may have to tweak a bit to work.

Re: Custom Excel export for link analysis
MacCleirich - Wed Apr 06 10:33:39 EDT 2016

Thanks for the input. I'll give it a try.

Thanks,

Re: Custom Excel export for link analysis
fmz007 - Mon Jul 22 10:52:16 EDT 2019

Hello

I have the same situaltion where I need to print line by line for the trace for more than one level down. Is this technique will work for trace more than one level down. 

To clearify, Is sINLINK_info an attribute in the module or variable in the code. Deleting first column means deleting the object text column. please elaborate your feedback.

Thanks

Re: Custom Excel export for link analysis
fmz007 - Mon Jul 22 12:24:43 EDT 2019

Bryce McClurg MacCleirich,

Have you found a solution for your request?

If so, please share your experience with me.

Thanks,

Re: Custom Excel export for link analysis
DOORSWizard - Fri Jul 26 15:56:18 EDT 2019

Using the above suggestion I was able to do the following:

Ran the Analysis > Wizard to show me the Object Identifier for the incoming links (keeping it simple). Then went into the properties of the Layout column to replace the DisplayRich with:

            s = (identifier othero)        

            display "\"" s "\","

In the above s is the line I didn't change but in theory you could make this line into anything you want to show up on a single line for example it could be s = (identifier othero) " - " othero."Object Text"

Once you make the update your single cell  (of the analysis wizard) will now look something like this:

"ABC_123",

"BCD_456",

"EFG_789",

You can then export this to .csv using File > Export > Spreadsheet.

Then open up an empty excel spreadsheet and open/browse to the file from above. Select comma as your delimiter when prompted and voila you will have a file which now shows 3 lines instead of 1 for those incoming links.

Re: Custom Excel export for link analysis
Cliff Sadler BTI - Tue Jul 30 15:18:41 EDT 2019

Funny, I took a real low tech approach.

Export your RTM view showing however many columns you need for trace levels

Use export to plain text, select Table, un-check the DOORS Heading Numbers inclusion.

Under the Advanced tab, use Tab for your delimiter, and most importantly, make sure you build a file with enough width that no line word wraps on you.  I chose 8000 characters

This builds a text file with LOTS of spaces in it.

Open Excel, select the Data tab, and get data from Text.

Set the importer to use Tab for a delimiter, and import to your spreadsheet.

Then I ran a simple Replace <space> <space> for <space> on the whole sheet about 10 times to remove all the extra spaces.  It was real quick.

Re: Custom Excel export for link analysis
fmz007 - Tue Aug 06 16:35:32 EDT 2019

Cliff,

I am encountering issues while trying to implement your approach.

I have "," in object text,  and after following your approach the text is breaking into separate columns. Do you have any other suggestion. Or Can we talk over the phone.  714.296.2533.

I liked your approach which is simpler.

thanks,

fmz

Re: Custom Excel export for link analysis
Cliff Sadler BTI - Tue Aug 06 20:21:10 EDT 2019

Are you using tab as your delimiter?  try that.

when you paste the data into the spread sheet, you may see a lot of blank fields.  select the sheet and in the home tab, set line formatting to TOP (Bottom is default)  Then set Word Wrap to true.

No go after the extraneous spaces with find/replace.