Automatically add reports to category

[Former Member]

Hi,

Nightly, I'd like to automatically add all reports within a folder structure to a category.  What is the recommended method to do this?  I found some sample code with a .jsp which I could modify, but I'd rather write an application that doesn't need a web server to function.

We are at BOXI 3.1

Thanks,

Sam

[Former Member]

I made a little progress on this.  I found the SDK documentation for .net and managed to authenticate against the CMC and get back some properties of the server.  I couldn't get much farther then that.  Certain classes seem to be missing from my references.  The sample code in the help files does not work without changes and additions, but maybe that due to my using visual studio 2010.  I'm also targeting .net 3.5.  That seems to show the greatest number of assemblies for including as a reference. 

[former_member182521]

Hello Sam,

Do you have any limitation to use only .Net SDK. You can achieve the requirement in in Java SDK as well.

Your approach should go something like this.

1. Identify set of reports in a particular folder. You can get these reports using this query

     Select * from ci_infoobjects where SI_PARENTID= {SI_ID of your Folder}

2. Identify the SI_ID of your Category.

3. Update the SI_CATEGORY field of each report object which you got from Step1 Hope this helps.

Regards

Mani

[Former Member]

We primarily use .net, so it would be a better fit for my organization, long term.  Do the .net assemblies have a bad reputation?

Thanks for the pseudocode Manikandan.

[former_member182521]

Sam, please be informed most of the custom developments are made in Java or Restful web services SDK now a days. Keep this in mind always. refer here http://scn.sap.com/docs/DOC-32303 Regards Mani

[Former Member]

Mani,

Are you able to use these jars in a java executable that can be run from the command line?  Most examples are of .jsp type. 

Thanks,

Sam