I have a client who is developing design requirements in Microsoft Access, and I want to be able to bring that set of requirements into my DOORS project requirements management database. What is the best way to import requirements from Microsoft Access? Can it even be done? Is there a good method to work together (integrate) somewhat with DOORS data and Microsoft Access data? I am hoping that there is some easy method for import and/or export with DOORS to Access. I would appreciate any ideas on this issue. kottkl - Mon Jun 30 18:56:18 EDT 2014 |
Re: DOORS import and export Export in CSV or Word and import on DOORS client?? Unfortunately IBM Rational DOORS does not fully integrate with MS Access. |
Re: DOORS import and export knobutan - Mon Jun 30 20:52:04 EDT 2014 Export in CSV or Word and import on DOORS client?? Unfortunately IBM Rational DOORS does not fully integrate with MS Access. MS Access for requirements! Yuk. To get data from MS Access into DOORS you need to export to Excel, save as CSV then import into DOORS. Going the other way is not easy. I am assuming that the client does not have access to DOORS. I would recommend that you persuade your client to work in Excel rather than MS Access. Keep the "master" data in DOORS and export to Excel with the Object Identifier in a column for them to update. They return the spreadsheets to you. You save as CSV an import into DOORS using the Object Identifier as the unique key. Then export again so they have the latest version. I do this sort of round tripping a lot to capture requirements from multiple authors who do not have access to DOORS or where there are insufficient licences available. I find that it works well as long as you are strict about controlling work-flow. i.e. don't let them work on copies of copies etc
|
Re: DOORS import and export Hello You can use a dxl-script and an ole-object created by OleAutoObj oleAdoConnection = oleCreateAutoObject("ADODB.Connection"); This object allows you to perform sql-commands on the access-db directly. Then you can read the data and use dxl to write it to a module. It is not easy, but it works. Best regards Wolfgang |
Re: DOORS import and export Thanks for the information as it has been very helpful. It sounds like the best approach will be to attempt to persuade the client to use Excel instead of Access. At least this will save a step in the process. However, if they maintain their use of Access I at least I know that I have a path to migrate requirements into the DOORS system. Thanks again |