where do you want to export? what format? or do you need to copy to another proyect?

regards

The export (excel file with CSV format) will be used to import to another test tool.

tests cases and each steps are not a problem, with  a sql could be easy to do. the main probem or question are the attachment files.  for download them, you will need use a api rest or ota api and a custom development

So any ALM admin could take the report of test cases + steps with an SQL? 

without attachments, anyone with report permission can get all test cases with their own steps, just create a excel report with the next sql

where the  "where PTH like '\Subject\%' is the path where you want to start getting testcases (leave like the code for full test cases.

SELECT PTH, TEST.TS_TEST_ID , TEST.TS_NAME , TEST.TS_STATUS , TEST.TS_DESCRIPTION , TEST.TS_RESPONSIBLE ,  TEST.TS_CREATION_DATE,  DESSTEPS.DS_STEP_NAME, DESSTEPS.DS_DESCRIPTION, DESSTEPS.DS_EXPECTED

--SELECT TEST.TS_TEST_ID
FROM      TEST
inner join
(
--SubQuery que devuelve el Test_ID y su Path
SELECT PTH, TS_TEST_ID ID_TEST FROM
(select AL_ITEM_ID, sys_connect_by_path(AL_DESCRIPTION, '\') PTH
from ALL_LISTS connect by prior AL_ITEM_ID = AL_FATHER_ID
start with AL_FATHER_ID = 0 and AL_DESCRIPTION = 'Subject')
left join TEST on TS_SUBJECT = AL_ITEM_ID
WHERE TS_TEST_ID IS NOT NULL
) on  TEST.TS_TEST_ID = ID_TEST

inner join DESSTEPS on DESSTEPS.DS_TEST_ID = TEST.TS_TEST_ID

--Ruta de donde se quieren sacar los CPU
where PTH like '\Subject\%'

order by pth

this type of report is here, and if it not appearing, you need to enter the next site-amin parameter in the site-adminnistrator site.

ENABLE_CREATE_LEGACY_EXCEL_REPORT to ‘Y’

(you can find here: https://admhelp.microfocus.com/alm/api_refs/site_params/metadata.htm)

If you are still looking for a solution please reach out privately.  We've done something like this before with the API to export defects with comments, attachments etc for importing to another database.

The best route is to write 1st OTA for downloading Test Cases with Steps and 2nd OTA to download attachments from Test cases.

There are many threads about both need. Some thread have "ready to use OTA/tool" for both purposes. Please search for them in this form.

Hello, 

i'm also with same requirement of exporting ALM data along with attachments. Please help me

Please reach out to me privately and I'd be happy to discuss your requirement.