BusinessObjects Board

[BOXIR2] Retrieve all folders of doc in Tree with VB .NET

sdk development
#1

Hi,

I need to know the tree of folders in the CMS of BOXI.
I don’t find the solution to have the same like in the DesktopIntelligence Import/export or in the left of InfoView in VB Application.

Thank you for your help.
Gilles

gcr :belgium: (BOB member since 2006-11-09)

#2

Do you want the universes or the reports folder structure ?

jp.golay :switzerland: (BOB member since 2002-06-17)

#3

Hi jp.golay,

the both if you have but the must important is the reports folder structure.

Thank you
Gilles

gcr :belgium: (BOB member since 2006-11-09)

#4

GCR,
Did you ever get the code you needed (to extract Reports Folders & their Reports)?
I could use that code right now too!

Captspeed :us: (BOB member since 2006-10-03)

#5

Hi Cptspeed,

I’m not receiving respond from ‘jp.golay’
I don’t have the code, the folder is ‘Hardcoded’ in my code.

Sorry.
Regards,
Gcr

gcr :belgium: (BOB member since 2006-11-09)

#6

Hi,

no solution are become ?

gcr :belgium: (BOB member since 2006-11-09)

#7

Hi gcr,

From what I can understand you want to retrieve all reports from the
repository and have them saved into your local machine into Corresponding
Folders. Is that correct ?

In that case you can make use of Query Builder SQL along with VBA to
do everything.

Regards,
Sandeep Kumar

sandeepkumar :india: (BOB member since 2006-06-27)

#8

yes, i need create the same architecture in local folder like in the CMS.

I need 2 functions or query:

  • lists of all documents folders
  • lists of all documents in a specific folder

thank you
gilles

gcr :belgium: (BOB member since 2006-11-09)

#9

Hi,

Possible using CMS sdk or third party tool.

Regards

#10

I know this but not find the query for have the list of document folder and any document in a specific folder.

I using the same procedure for universes and it´s work !!

The problem is the basic query to retrieve the document folder name and ID.

Kr,
gilles

gcr :belgium: (BOB member since 2006-11-09)

#11

You first need the documents SI_PARENT_FOLDER

SELECT SI_PARENT_FOLDER FROM CI_INFOOBJECTS

Use the retrieved SI_PARENT_FOLDER as SI_ID in something like the following query

SELECT TOP 1 SI_ID, SI_KIND, SI_NAME, SI_PATH FROM CI_INFOOBJECTS WHERE SI_ID = <>

The result is a collection of folders that make up the path of a document like you see in Infoview.

You can check the code of the following tool for a more detailed example:

jbo :monaco: (BOB member since 2005-07-31)

#12

can you please tell me how to retrieve complete Universe folder name/path which I’m tyring to use in designer SDK to open and import an universe?

Krish

krish.mahal (BOB member since 2006-08-03)

#13

For the universe, i using the DesignerApp.UniverseRootFolder on the Universe.application object and after, the code loop with

UniverseFolder.Folders.Count

With .Net, i don’t know, i’m using only VB6.

Kr,
gilles

[/code][/quote]

gcr :belgium: (BOB member since 2006-11-09)