Import excel files to DOORS : baseline.inc Tool

Hello, 

I'm looking for way to import excel file into doors while keeping most of the text format.

I came across many similar question on this forum (or somewhere else), and the best solution seems to use a tool form baseline.inc :

http://www.baselinesinc.com/dxl-repository/?filerepoaction=showpost&filepost_id=13

Unfortunately, the site seems to be broken since several month. I managed to acces the post using web.archive.org : http://web.archive.org/web/20180527100444/http://www.baselinesinc.com/dxl-repository/?filerepoaction=showpost&filepost_id=13

but the download part is still broken.

Did anyone have this tool on hand (and dxl excel function from the same source) and can upload them on a reliable place ? 

Re: Import excel files to DOORS : baseline.inc Tool
rmoskwa - Mon Jun 24 12:07:37 EDT 2019

Hi Jaun

See the attached zip file.

Re: Import excel files to DOORS : baseline.inc Tool
Jaun Makenro - Tue Jun 25 03:42:20 EDT 2019

Thanks a lot ! That's exactly what I was looking for.

In ExcelFunction.inc, there is this include line :

#include <\user\defibtools\ole.inc>

I updated it to the standard ole.inc located in "...\IBM\Rational\DOORS\9.6\lib\dxl\utils"

When I run the import from excel script, I got 215 dxl errors... ( on call to ole.inc functions : put, OleGet, checkResulst ...) 

For exemple : 

-E- DXL: <addins/user/ExcelFunctions.inc:367> Arguments incorrects pour la fonction (put)
 

It seems the tool is made for an older version of the ole.inc file. I use doors 9.6.1.9.

If the script is working fine for you, can you tell me your doors version and send your old.inc ?

Re: Import excel files to DOORS : baseline.inc Tool
rmoskwa - Tue Jun 25 13:30:34 EDT 2019

Hi Juan,

sorry for the delay.

I use DOORs v9.202

I have attached my ole.inc file.

The

#include<\user\defibtools\ole.inc>

path is where I located the ole.inc file on my server.

I provide this tool to all my users, so it is not on my C: drive.

Re: Import excel files to DOORS : baseline.inc Tool
Jaun Makenro - Thu Jun 27 04:14:50 EDT 2019

Thanks again for your help !

Using this ole.inc, the Import parameter window open, after handling various error about column name and such.

I always get a "EXCEPTION_ACCESS_VIOLATION in module  at 000000000063000B" error as son as the import process start.

Each time, the error seems to be in the "getCell" function from ExcelFunctions.inc on :

  closeIfNonNull(objCell);

I have no idea how to solve this...

I will continue to perform more test, and maybe find someone used to the ole functions. 

Edit :

Ok, now it works. It probably was a problem with my excel file.