Mass uploading of Test Cases in Solution Manager
Hi Guys,
Please find the below Steps regarding how to upload multiple test cases in SAP Solution Manager in a one go (without doing any configuration)
I hope this will help you a lot for uploading Multiple Test cases in Solman at once and reduce your workload.
Mass uploading of Test Cases in SAP Solution Manager
Prerequisite:
1. Need an access for SOLAR_PROJECT_ADMIN
2. If you have your test cases in excel files please put XLS in File Extension and Tick on Blueprint Relevant or if you have a word document put DOC. (Step for how to do this :-
> Enter T.Code SOLAR_PROJECT_ADMIN
> Double click on your project
> Click on “Project Standards” Tab
> Click on “Documentation Types” Tab
> Click on “Project Template” button
> Under “Complete Directory Of Document Types” you can see Documentation Type “ATC” — Put File extension XLS – Tick on Blueprint – Relevant
> Select row “ATC” and shift it under Project Doc. Types
> You can see now in under both now
> Click on Check button – Click on Save button
Steps to upload Multiple Test cases in Solution Manager:-
Please note: In this scenario we are going to upload Six Test cases in a one go.
Step 1:
Enter T.Code SOLAR_PROJECT_ADMIN >> Double click on Project (in which you want to upload test cases.
Step 2:
Click on Edit >> Fill Business Blue Print >> Create Template File >> Select Test Cases >> Save the file in XLS format
Step 3:
Open XLS file which you have saved >> Now you can see the Business Process Scenarios under Name column.
Step 4:
Put TWTD under Test cases column (Make sure you need to put this only in front of your Business scenario >> Put a proper Node Level >> NODE_TYPE >> NODE_TEXT >> NODE_SCOPE >> NODE_ID
Step 5:
Put the file path under File Path columns. (File path of test cases which you want upload)
And don’t forget to put file extension code e.g.
Step 6:
Put all the information as below:-
Step 7:
Save and close the above excel file.
Step 8:
Login in to SAP Solman >> Enter T.Code SOLAR_PROJECT_ADMIN >> ADMIN >> Double click on your Project >> Click on Edit >> Fill Business Blue Print >> Upload File >> Test Cases >> Select your excel file >> Click on Open button >>
Click on Continue button
Click on Continue button
Click on Continue button
You will be back to Project Screen >> Save >> Got message “Data has been saved”
Step 9:
Enter T.Code SOLAR02 and you get the result as expected i.e. upload 6 test cases in the scenario which you have selected:
Thank you. I hope this help.
Regards,
Rohan Shirude
Thank you very much.
Hi, question. Does this also work if you decide later to add let's say 10 additional cases? Because if I load new cases, the existing ones get deleted...
Hi Kasper,
Yes... you can add 10 additional cases later but you need be very careful when you are modifying the Test Template which you get from SOLMAN_PROJECT_ADMIN.
Please let me know if you have any issue with the same.
Thank you.
Regards,
Rohan Shirude
Thanks Rohan, I was actually looking for a solution for adding documents to our project, because it looks similar to testcases.
We tested loading it for some word documents but that resulted that the existing ones in the project got lost. We also have multiple documents (hundreds!) to load to an existing project but we do not want to lose the existing documents (also hundreds).
Hi Kasper,
In that case would suggest to use Ecatt Test Automation tool.
Thank you.
Regards,
Rohan Shirude
Hello,
We have a requirement to upload multiple test cases in the Solution Documentation(SOLDOC transaction) of Solution Manager 7.2. Is it necessary to create a project for this?How do I get the Node ID for each node where I want to upload document.
Dear Rohan
Good morning.
I have seen persons with me on a project creating test case steps 1 by 1 from MS Excel. Is there a way to use a template and upload all the steps for a test script into Solution Manager in the Test Plan component for testing?
My head tells me there should be a way as in HPQC one can import the test case (script) steps from Excel.
Thanks for your time and assistance.
Kind regards
Hi Vincent,
Template for SAP Solution Manager 7.1 or 7.2? Please confirm.
Thank you.
Best regards,
Rohan Shirude
Hi Rohan
Thanks for your quick reply. Its version 7.2.
Kind regards
Vince
Hi Vincent,
Mass upload of documents is part of planned innovations for SP06. You can check the latest Solman roadmap for more details.
https://www.sap.com/documents/2017/06/227aaa28-c37c-0010-82c7-eda71af511fa.gate.html
(Please refer page no. 62, 62 and 68)
Thank you.
Please Accept the answer if your ok with this
Best regards,
Rohan Shirude
Dear Rohan
Thanks so much for your help. Noted thanks.
In HPQC one can import from an Excel file the test script steps and the steps are then automatically created.
This is not possible in Solution Manager?
Kind regards
Vince
Hi Vincent,
Not sure but if we can try it through by making excel macro's and upload the test cases in Solman 7.2 in mass.
but yes we need a Ms-Excel Macro expert...:)
Best regards,
Rohan Shirude
Hi Rohan
Thanks for your time and willingness to help.
Would have liked to help my colleagues. Creating 50 test cases in Excel and then copying one step description at a time to Solution Manager to create a new step, is such a waste of time and resources.
I believe there should always be a way to do things easier and simpler.
Kind regards
Vince
Hi Vincent
Looks like we'll have to wait for SP06 (if you're not on it already) for the Drag n Drop method.
Regards
Rob