Downloading bulk webi instances to excel or pdf

[mhmohammed]

Everyone,

I've a requirement to download bulk Webi instances (150 each from 10-15 Webi reports) in excel or pdf format. How can we do this using Java SDK, any idea?

Thanks,
Mohammed

[DellSC]

This is actually not that difficult to do - and you could do it using either the Java or, depending on the version of BOBJ that you're using, the RESTful Web Services SDK. Are the instances already in Excel or PDF format or do you need to convert them prior to saving? And which version of BOBJ are you using?

[mhmohammed]

Hi dell.stinnett-christy,

Appreciate the quick response!

We're using BO Version 4.2 SP7 Patch 7, and about the reports/instances, we've a requirement with all 3 scenarios, we've instances in Excel, PDF, and there are a lot of reports where instances are in Webi, and we need to convert them to Excel/PDF and then save those files.

It'd be ideal if you have some code handy, or if you could point me to a step by step blog post, as I'm not a Java Programmer and haven't worked with RESTful Web Service SDK.

Thanks,
Mohammed

[DellSC]

I have some old C# code that does some of this for Crystal reports, but nothing in Java right now. However, I should be able to provide some basics for getting the files that are already in PDF or XLS/XLSX format with code samples. The challenge is going to be code to open and convert the .WID files from Webi. What format do you want those in or how will you determine which format to export them to?

I'm pretty busy with client work and facilitating internal training until Friday, but I'll see what I can come up with for you.

-Dell

[mhmohammed]

Hi Christy,

The instances with Webi output format need to be downloaded in Excel.

Really appreciate your help on this!

Thanks,
Mohammed