Requirements Gateway define excel covers

[Cbro]

Hi,again I put this question at Labview.....

I have a problem to connect my testspecification in excel to the requirements in word, i tried to add an column with [Covers: xxx] and when testing the expression i get all column but not connected to req.spec

1. How to get only the text in column x

2. How to connect the [Covers:xxxx]

Could it be that I convert the word template to use Header2, Header 3 as requirement, because not to change the original req doc. 

Example in word

1.10 Download software

 type expression requirement: ^Heading 2\t(?[\d\.]+)[ \t](.+))$

Excel:

|1                         |2                                           |3                             |4                                     .......

[Covers:1.10]      1.10 Download software      Test with.....             070927/pv0.23               ........

Type expression covers reference: \|1 (\[Covers.+)

The excel should cover Excel.

Best regards CB

[AllenP]

The first step is to determine if your type is correctly reading the requirements into Word.  I was able to create a sample document and used your regular expression and correctly was able to parse the document.  I did have to remove the "section" objects in Word since it appears that you are using Heading X to hold requirements.  You may need to do this if you have not already.

If your requirements are showing up correctly, then we can move on to Excel.  The expression you have typed for the Excel document will not correctly return the identifier as a field.  I changed the expression to the following and it worked properly.  You will notice that the group returned is only the identifier field of the requirement (1.10 in your example).
\|1 \[Covers: (.+)\]

Allen P.
NI

[Cbro]

Hi,

Is it not possible to have both section and requirement as in my case as header 1, but if i read in the selection info it says: Requirement is not covered.... for the types "section" I used _ ^Heading 2\t(? : ([\d\.]+)[ \t](.+)|([^\d\n].+))$ and for the requirement type_ ^Heading 2\t(? : ([\d\.]+)[ \t](.+))$ and i had also to use 3 requirement types heading 2, 3 and 4 to be able to use the original requirement spec.

I will tested your req type for excel it didn't help it could not cover the requirement 1.10

If I test the expression: see added picture

[Cbro]

New test...

With the type: \|1 \[Covers_([^\]]*) it worked and of course i had to change in excel to [Covers_1.10] then it suddenly worked. Even with the req as header 2, 3, 4 type.

Now some work to fix this together..... i hope.

//CB

[Cbro]

Hi, more features...

If i define an attribute testresult OK, NOK, TBD and try to find this in Excel in a defined worksheet say's testing, in my exampel i have the result in column |14, so if I use the [covers reqxxx] i can not filter this out, in the attribute. When i use the analyser and tried with ^Worksheet.* I will recieve all worksheets only in text column if i try to add |14 it just add one group... is it possible to sort out if existing on the same row as [cover requirement] but in for example column |14 were the test result is with result OK, NOK, TBD or empty

Worksheet: testing

|1 [covers REQ_1] .......................................|14 OK         

Any ideas someone

Br Conny

[AllenP]

You will need to add a reference attribute to your Excel type.  I used the regular expression:
\|1 \[Covers: ([^\]]+)\](.*)\|14 (.+)\|15 to get it.  Be sure to right-click on the expression, and set fields 1 and 2 to "text", and field 3 to be the identifier.

Allen P.
NI

[Cbro]

Hi again, and thanks for the support

But i have an hard time to understand the type expression i NIRG, i will add the .types i use because I am very confused.

when I used the \|1 \[Covers_ ([^\]]+)\](.*) | \|5 (.+)\|6 with the excel demo i added, i will recieve the result in group 3 but how to connect this to the requirement, is there i need to use the reference attribute.

Sorry but to find this in the manual and the expression is hard.. i have not understand the semantic completly

If i guess:

\1 \[Covers_  .... I filter the expression all columns with this, and two groups ([^\...) (.*) then I added an or function | \5

Can I find anywhere how this is working, or more ideas...

And the reference attribute I tried with no success.

Best regards Conny

[AllenP]

I am not exactly sure what you are trying to accomplish, but based on my best guesses, a reference attribute sounds correct.  If each column in the Excel Spreadsheet you attached is an attribute of a given reference, you want to use a reference attribute.  I have made changes to the types you attached.  First, in the Word type, you are having duplicates between sections and requirements since Heading 2 is used for both.  I removed the sections since it appears that you aren't using them for this purpose.  In the Excel type, I added a section for each line that contains a requirement.  I also added a reference attribute for each of the other columns and used the proper regular expression.

If you are confused by the regular expressions, I recommend reading more about the topic.  One of my favorite sites to get started is http://www.regular-expressions.info/tutorial.html.  This will get you used to the basics of understanding the expression language used.

Allen P.
NI

[Cbro]

Thanks!

Now I hopefully can understand, that was exactly what I was looking for, because I have to manage old specification into NIRG and I do not wan't to rewrite all specifications, and I test the .types file and works great.

Best regards Conny