DXL script or VBA macros for copy-paste word to doors

Dear Doors user's

someone post DXL script or VBA macros for coping data from word file and paste into Door's object. right now i am manually doing following steps.
1) Copy Heading & ObjectText from word file
2) Insert Object
3) Select Object Property
4) Paste Heading & ObjectText into Object

I want to avoid this manual work through DXL Script or VBA macros. someone give me solution for this automation.
SystemAdmin - Mon Sep 05 04:34:51 EDT 2011

Re: DXL script or VBA macros for copy-paste word to doors
OurGuest - Mon Sep 05 22:18:10 EDT 2011

What you ask for isn't particularly easy to facilitate -- while the scripts are possible the real problem is in definining a user interface that would be useful.

Perhaps a better approach would be as follows.

Export your word document to a new scrap module. Then use the copy objects function that is already built into the DOORS GUI.

This approach would provide a user interface that would seem to me to be intuitive.

Re: DXL script or VBA macros for copy-paste word to doors
SystemAdmin - Tue Sep 06 00:05:59 EDT 2011

OurGuest - Mon Sep 05 22:18:10 EDT 2011
What you ask for isn't particularly easy to facilitate -- while the scripts are possible the real problem is in definining a user interface that would be useful.

Perhaps a better approach would be as follows.

Export your word document to a new scrap module. Then use the copy objects function that is already built into the DOORS GUI.

This approach would provide a user interface that would seem to me to be intuitive.

OurGuest Thank you for this help

Need VBA macros for importing requirements from WORD to DOORS
SystemAdmin - Thu Jan 10 17:55:34 EST 2013

OurGuest - Mon Sep 05 22:18:10 EDT 2011
What you ask for isn't particularly easy to facilitate -- while the scripts are possible the real problem is in definining a user interface that would be useful.

Perhaps a better approach would be as follows.

Export your word document to a new scrap module. Then use the copy objects function that is already built into the DOORS GUI.

This approach would provide a user interface that would seem to me to be intuitive.

Hi,
I am facing issue in importing requirements from WORD to DOORS. When I import the requirements present in a tabular format in WORD, each row of the table appers in different DOORS line (DOORS id would be different) also I would like to import 2 paragraphs in same section under single DOOR id and not in different lines in DOORS. I want to avoid the manual work of editing the imported data in DOORS (Manually cut pasting the paragraphs in 2 seperate lines into same DOORS line or DOORS id)
Is there a macro which can do this?? Please help.

Re: Need VBA macros for importing requirements from WORD to DOORS
Mathias Mamsch - Fri Jan 11 05:00:25 EST 2013

SystemAdmin - Thu Jan 10 17:55:34 EST 2013
Hi,
I am facing issue in importing requirements from WORD to DOORS. When I import the requirements present in a tabular format in WORD, each row of the table appers in different DOORS line (DOORS id would be different) also I would like to import 2 paragraphs in same section under single DOOR id and not in different lines in DOORS. I want to avoid the manual work of editing the imported data in DOORS (Manually cut pasting the paragraphs in 2 seperate lines into same DOORS line or DOORS id)
Is there a macro which can do this?? Please help.

I did something like that for Excel. A way of interactively importing stuff from Excel to DOORS by using macros, like "Import to new DOORS Object". It is pretty simple. From a word macro you grab a handle to the DOORS application using DOORS automation. You put the data you want to import to the oleResult property. Then you execute a small DXL script which will read the data from the ole result property and do the operation in DOORS that you want to do. If you need more help, just say.

Regards, Mathias

Mathias Mamsch, IT-QBase GmbH, Consultant for Requirement Engineering and D00RS

Re: Need VBA macros for importing requirements from WORD to DOORS
llandale - Fri Jan 11 10:54:56 EST 2013

SystemAdmin - Thu Jan 10 17:55:34 EST 2013
Hi,
I am facing issue in importing requirements from WORD to DOORS. When I import the requirements present in a tabular format in WORD, each row of the table appers in different DOORS line (DOORS id would be different) also I would like to import 2 paragraphs in same section under single DOOR id and not in different lines in DOORS. I want to avoid the manual work of editing the imported data in DOORS (Manually cut pasting the paragraphs in 2 seperate lines into same DOORS line or DOORS id)
Is there a macro which can do this?? Please help.

A Word EOL tells DOORS to end this object and start a new one. A word LF does not.
  • This is the 1st line of the 1st requirement. At the end of this line is a Line-Feed character.
  • This is the 2nd line of the 1st requirement. At the end of this line is a End-of-Line character.
  • This is the 1st line of the 2nd requirement. At the end of this line is a Line-Feed character.
  • This is the 2nd line of the 2nd requirement. At the end of this line is a End-of-Line character.

The above will import creating 2 DOORS objects.

In Word you should View all characters. Then use Find-Replace; replacing "\p" (an EOL character) with "\l" (Line-Feed character). Find-Next. Then individually either replace or skip each EOL character in the file.

-Louie