Hello Champs,
I want to get the list of all the reports from the repository in BOV5 and BOXIR2.
After which I will check the missing reports from both the list and then accordingly migrate and then convert the BOV5 reports to BOXIR2.
Has anyone cam across a macro/way to get the list of reports from each of the repository.
OR is there already a macro to compare between the 2 versions.
Best Regards,
Milind D. Kadam
milind.kadam (BOB member since 2006-07-07)
In version 5.x the best approach consists of doing a universe on the repo itself. The table OBJ_M_DOCUMENTS has all you need. Just hack into it and you’ll find what you need.
For instance, here you have a SQL that will retrieve your DeskI (aka FC) reports:
select M_DOC_C_NAME from OBJ_M_DOCUMENTS
where
M_DOC_N_TYPE=1
In case you are dealing with a migration involving security subsystem too, and in case this security subsystem is huge and difficult to restore, keep in mind that you can still recover it in a XIr2-like way, without losses on your security model, and without hassles on XIr2 administration side.
CLS69 
(BOB member since 2009-06-11)
and for XIr2 document list ; there is several way to do that :
[list]
BOXI Repository Documentor excel vba to extract the list of doc
several third parties tools
[/list]