Hi Homer,

there exists an Excel Addin https://www.microfocus.com/marketplace/appdelivery/content/microsoft-excel-add with which you can upload your testcases. You need to map the columns to ALM fields.

If you choose the right subjekt path (ending with \ ) for your test case only the changing fields are updated. Works even with Version Control activated

Thanks, that works well, but I was also wondering when I export the test case how can I get the complete path of the script (ie if the script in in the subfolder Login of SIT main folder when I export the case the subject is only SIT? I have scripts that are many levels deep in the directory tree and would like to export the full directory path for the scripts. thanks  

Hi Homer,

that depends, how you export your Tests & Steps. I've defined a Business View, based on "Tests with Design Steps", and added multiple Instances of Test Folder with Releation Name "Test folders to parent Test Folder" and with Attribut Name. So I have ALL names of the Test Plan tree and concatinate them in Excel with [@parent1];"\";[@parent2];"\";[@parent3];"\"; as Subject path for each Test Case

Hi Homer ;-)! Each test folder has a field called 'Absolute Path' which you can use for selecting a parent folder and all its subfolders and all tests those folders. 

You should first find the absolute path of the test case folder (the kind of root folder) you are interested in and then use % in the end of the path to point the query to subfolders too.

Example of BV DQL Query Builder:

From test
Right Join test_folder On test_folder.id = test.parent_id
Left Join design_step On test.id = design_step.parent_id
Where test_folder.hierarchical_path Like 'AAAAAN%'

Hope this tip would help you in your export actions.