How to import test cases from MicroSoft Test Manager into Version One
June Lin
I've downloaded the template (Excel) and I try sever times to upload
the test cases, at the end, I always got an message - No valid data
found....
Is there anyone who knows how to exactly import the test cases or had
similar experiences?
Steve Paro
Which edition of VersionOne are you using? Ultimate, Enterprise or Team?
Steve Paro
Hi,
--
You received this message because you are subscribed to the Google Groups "VersionOne-users" group.
To post to this group, send email to versiono...@googlegroups.com.
To unsubscribe from this group, send email to versionone-use...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/versionone-users?hl=en.
June Lin
No matter what I put, it always gives me an error below:
VersionOne Warning: The attribute Project is required and was not supplied. This change was not saved. Please alert your administrator if you continue to have an issue.
Is there anyone else looking for this issue right now or... This is kind of urgent for us. Also, within the Community, I haven't seen anyone proposed the same question: Import test cases from TM into VersionOne.
Thanks to let me know the status or the progress...
Regards,
June
June Lin
We are using VersionOne Ultimate. I've been spending many hours to find out how to import test cases from TM into VersionOne.
If you can please help to solve the problem I have, it would be greatly appreciated.
June
-----Original Message-----
From: versiono...@googlegroups.com [mailto:versiono...@googlegroups.com] On Behalf Of Steve Paro
Sent: January-17-12 2:39 PM
To: versiono...@googlegroups.com
Steve Paro
I think I know what the issue is. As you are using Ultimate, I'm guessing that you are trying to import these tests as Regression Test assets. The provided Excel import template is only setup to import Acceptance Test assets. As Acceptance Tests only exist as a child of a Workitem (backlog item/defect), there is column to be used to designate project. To get your import to work, you will need to add a column labeled Scope to the existing Test Import template. In this column you will need to specify the project name where you want your tests to reside. You will also need to set the values in the AssetType column to RegressionTest. This should get you going.
June Lin
Thank you for your solution.
What I did try in the last few days, I added a column - Scope at the end. And I put my project = A\B\C , but it is not working.
I saw one of the gentleman replied to one the question, he suggested to put A>B>C.
I'd like to double confirm what is the RIGHT format for the project.
The following fields I am going to put in the standard excel format:
- AssetType = RegressionTest
- Name = Test Case name
- Scope = A\B\C (I will correct after your confirmation for the project format)
Please correct me if anything is missing in the above. Thank you greatly.
June Lin
First of all, please discard my previous email sent to confirm the format and data..
It is working now after I tried again. However, there is a little bit concern and I am not sure this is the key that caused 'Upload' function failed.
I did add a column - Scope at the end of the last column in the standard excel format. But then I failed.
Today, I added this column right before 'Parent' and it works.
Also the Scope, I put A\B instead of A>B (I read one of the email exchange.) and it works.
- One last thing for this subject is the "Steps" and "Expected Results". I have to copy ALL the steps in ONE column, same as Expected Results.
Else it will create 1 Test Case per 1 Step with the same Test Case Name in VersionOne. Do you have any solution for this??????
Thanks greatly for your helps.
June Lin
I tried another way for Steps and Expected Results.
I used the excel file that I downloaded from TFS to Excel. I just modified the Title and some column name to be EXACTLY match the standard format in VersionOne.
After I fixed few typo mistakes in the excel file, I click on 'Upload'. Since then, it is still uploading because this button is still greyed out but no error message is complained so far...
The reason why I asked or I tried is to safe some works of modifications either in the excel file OR in the VersionOne after uploading successfully.
Hopefully you and your team can help us....
Thank you greatly for your helps.
June Lin
Update for the following subject:
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I used the excel file that I downloaded from TFS to Excel. I just modified the Title and some column name to be EXACTLY match the standard format in VersionOne.
After I fixed few typo mistakes in the excel file, I click on 'Upload'. Since then, it is still uploading because this button is still greyed out but no error message is complained so far...
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Because there is no message displayed to show either there is an error OR 'Upload is successful..', so I thought it is still uploading. But, in fact, it is done long time ago.
For the rest of issues: Steps + ExpectedResults are active.
Thanks,
Steve Paro
I'm happy to hear that you are making progress. Unfortunately, I do not have any better way of recording the steps and Expected results info. VersionOne stores both Steps and Expected Results in rich text field attributes on the Regression Test record. Using the import, each row in excel is treated as a unique record, as you have discovered. The only way to import all of the Steps and Expected Results for a test is to ensure that those values are in the appropriate cell for the appropriate record. If it helps, In Excel using Alt+Enter while inside a cell will create a new line within the cell. At least this way you can format the Steps and Expected Results in the worksheet to appear in more of a list format.
June Lin
Thanks for your helps.
Unfortunately, the way I am trying (as you've recommended) is not working either.
What that happened is the VersionOne ONLY take the first row with the cell (test case name) into VersionOne.
So what I am going to try is to MERGE ALL the separate cells within one single test case (one cell) into just ONE cell like the Test Case and AssetType.
I will let you know if I will succeed this way...
Have a great weekend.
Thank you & Regards,
June Lin
I discovered a way to merge all the separate cells (Steps) into one without losing data.
But, then I uploaded this excel file into VersionOne successfully. In VersionOne, it automatically deleted ALL SPACES (including CR) and put EVERYTHING in one line.
Perhaps, VersionOne can have a small fix for this topic???
Luanne
We do have a request to adjust the importing of Rich Text Fields.
It's available on our IdeaSpace: https://ideaspace.versionone.com/default/Idea/Detail/329
Please provide any feedback and vote for this feature.
-Luanne
> After I fixed few typo mistakes in the excel file, I click on 'Upload'. Since then, it is still uploading because this button is still greyed out but no error message is complained so far...
> --
> You received this message because you are subscribed to the Google Groups "VersionOne-users" group.
> To post to this group, send email to versiono...@googlegroups.com.
> To unsubscribe from this group, send email to versionone-use...@googlegroups.com.
> --
> You received this message because you are subscribed to the Google Groups "VersionOne-users" group.
> To post to this group, send email to versiono...@googlegroups.com.
> To unsubscribe from this group, send email to versionone-use...@googlegroups.com.
> --
> You received this message because you are subscribed to the Google Groups "VersionOne-users" group.
> To post to this group, send email to versiono...@googlegroups.com.
> To unsubscribe from this group, send email to versionone-use...@googlegroups.com.
> --
> You received this message because you are subscribed to the Google Groups "VersionOne-users" group.
> To post to this group, send email to versiono...@googlegroups.com.
> To unsubscribe from this group, send email to
>
>
> read more »- Hide quoted text -
>
> - Show quoted text -
June Lin
Thank you for this information. I should say it's one step closer to what we expect.
But, is it possible to have in a separate line rather than to have spaces in between two steps???
It is to say that whatever the format in the excel is, once uploaded successfully, the format in VersionOne should be the same as the input excel file.
That way all what we need to do is to copy and paste in the excel file. No more modifications in the VersionOne after uploading.
Thank you
Luanne
I received this information from one of our technical coaches. You
can add some HTML for a line break -- <br />
So it would look something like:
1. Do this first<br />2. Do this next<br />3. And then you do this
-Luanne
June Lin
Yes, I know.
But, in the VersionOne, the standard format is in Excel file.
If I convert all the test cases into HTML other than Excel, I cannot upload this file into VersionOne.
How did your technical coaches import those test cases into VersionOne from html format if it only accepts excel file format?????
Thank you.
June
Hi June,
-Luanne
Matthew Badgley
Since the Steps are captured using a Rich Text Format, you can simply add the HTML tags within the Excel file. So the Steps column in the spreadsheet will have the content similar to the example Luanne has provided. See attached example.
Thanks,
Matt Badgley
> -----Original Message-----
> From: versiono...@googlegroups.com [mailto:versionone-
> us...@googlegroups.com] On Behalf Of June Lin
> Sent: Tuesday, January 24, 2012 11:25 AM
> To: versiono...@googlegroups.com
> Subject: RE: How to import test cases from MicroSoft Test ManagerintoVersion
> One
>
> users+un...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/versionone-users?hl=en.
>
> --
> You received this message because you are subscribed to the Google Groups
> "VersionOne-users" group.
> To post to this group, send email to versiono...@googlegroups.com.
> To unsubscribe from this group, send email to versionone-
> users+un...@googlegroups.com.
June Lin
Thank you for you both. Now it is working EXACTLY like I expected in the VersionOne.
All the detail steps are in a separate lines rather than to be all in one line!!
Thank you.
June
-----Original Message-----
From: Luanne Curran [mailto:Luanne...@versionone.com]
Sent: January-24-12 11:39 AM
To: June Lin
Subject: RE: How to import test cases from MicroSoft Test ManagerintoVersion One
Matt Badgley just replied to your post with an example.
Luanne Curran
Product & Agile Coach
t: 678.648.1279
c: 402.981.8271
www.versionone.com
-----Original Message-----
From: June Lin [mailto:June...@averna.com]
Sent: Tuesday, January 24, 2012 11:34 AM
To: Luanne Curran
Subject: RE: How to import test cases from MicroSoft Test ManagerintoVersion One
Luanne,
You mean that I should add <br/> in each cell in excel file?
Can you provide a simple example???
Thank you.
June
-----Original Message-----
From: Luanne Curran [mailto:Luanne...@versionone.com]
Sent: January-24-12 11:31 AM
To: June Lin
Subject: RE: How to import test cases from MicroSoft Test ManagerintoVersion One
Within the excel content you would add the line break directly
Luanne Curran
Product & Agile Coach
t: 678.648.1279
c: 402.981.8271
www.versionone.com