Retrieve A List Of Paths Of All The Folders And Sub Folders From the Content Server

Greetings,

I was wondering if there is a way to get a list of all the paths of the folders and their sub folders that the root folder has (DataID = 2000)?
I'm not sure there is, that's why I'm asking. In the meantime I was thinking of a way to do it. I'm not sure it's easy.

An idea was to use recursion and live reports in order to go deeper in a root folder and each time to retrieve the folders names of a given ParentID.
Each time I will be combining the given folder with it's previous one until I'll get null from a report which then will be assumed that there is no need to get deeper.

My goal is eventually to get a list of path from the content server and then compare it to a list which I have in windows directories.

Any help or thoughts will be grateful.
Thank you.

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

All comments

Jean Philippe Forti

From the UI you can hijack the Outline function of a project item:
?func=Projects.ProjectOutline&objid=

This is not fully supported by OpenText. I would not try it from the root on a large system.

Using a Webreport with a "Connect by Prior" query would do the job. But pay attention to performance on a large system.
On a large system we are using a nice little tool from an OpenText Third party Blubaker DMC2. From there we can extract the path and the permissions to share this in an Excel file (on a large screen) with a pivot table to review the taxonomy with the end users.

Appu Nair

@Forti_Jean-Philippe said:

Using a Webreport with a "Connect by Prior" query would do the job.

That particular Construct is Oracle Specific. Most of the OT SQL customers will create a DB Function

WebReports has an inbuilt NODEINFO:PATH tag as well

An esteemed OT Programmer Hans @Hans_Stoop once provided the old KB Forum an alternative to all of us using the recursive methods by using DTreeAncestors.Unfortunately, the KB has since been switched around so I cannot find it. I even have many bookmarks that are yielding duds . A tremendous loss to the community Perhaps you may have to do a brute search for Hans's posting

Appu Nair

I found the Han's Post https://forums.opentext.com/forums/discussion/comment/927229#Comment_927229