BusinessObjects Board

Macro to convert BO documents of version 5 to version 6

sdk development
#1

Hello,

a couple of times there were questions about any macro for batch converting of BO reports of version 5 to version 6 and their export to BO repository.
I can share my (let’s say) application written in VBA that does this.

Instructions for use:

  1. Manually retrieve all BO v5 reports that will be processed from the BO v5 repository into any working local/shared folder.

  2. Open BO_documents_v5_to_v6_converter.rep in BO 6.x (not in 5.x !!!)

  3. Click on “Enable Macros” button.

  4. If the form is not open automatically then run the macro “Start_BO_docs_v5_to_v6_converter”.

  5. Click on “insert working folder” button and insert a path to the working folder where all BO reports of version 5 to be processed are stored

  6. Click on “analyze working folder” button

  7. Click on “process REP files” button and type in the BO group/user name the BO reports will be exported to. Root group of users can be used to publish the BO reports to all.

    • all REP files in the working folder are, one by one, opened, saved and exported into the BO v6 repository. The files are also moved from local working folder into the files_processed subfolder.

Enjoy :mrgreen:

Marek
BO_documents_v5_to_v6_converter.rep (104.0 KB)

Marek Chladny :slovakia: (BOB member since 2003-11-27)

desactivate notification
Migration from DEV/QA to PROD
Migrate information form one repository to another
Migrating from 5.1.8 to 6.5
#2

Hi Marek,

Thanks for that should save me some time during these migrations!!

irish_stan :ireland: (BOB member since 2003-05-13)

#3

Marek,

Thank you for sharing. This will also save us a lot of time.

Neal

ngosz :us: (BOB member since 2003-09-25)

#4

I tried to download and it claims that I’m not authorized to open the document.

ngosz :us: (BOB member since 2003-09-25)

#5

Ups, sorry for that. I saved it again with “Save for all users” option and re-post it here. Please try now.

Marek
BO_documents_v5_to_v6_converter.rep (104.0 KB)

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#6

Hello

Thank you for your macro which seems to be very helpfull. A little question. What must we fill-in in the “process REP file” dialog box.

I have systematically a “20 Exchange domain not specified” error message and the script is cancelled.

Thank you for advance for any help about this.
Bernard

bernard timbal :fr: (BOB member since 2003-05-26)

#7

[solved - the Application.ExchangeDomain=“Document” was in comment in the script]

bernard timbal :fr: (BOB member since 2003-05-26)

#8

replace in your code the

MyDocument.Send ExportedToUser

by

MyDocument.Send ExportedToUser, , , CategoryExporter

and create a new button to set the Category (entered like ‘cat01/cat02/cat03’

Regards and thank you again for your code

bernard timbal :fr: (BOB member since 2003-05-26)

#9

Hi Bernard,

thanks for the suggestion related to the categories.

Marek

Marek Chladny :slovakia: (BOB member since 2003-11-27)

mass exporting of deski reports
#10

This sounds useful.
Is this something that could/should go into the BOB downloads area :?:
That would save people having to search through this forum when as it gets older and goes further into the archive?

Perhaps look at the posting here:

You may need to put something like this in a posting:
To get the code “noticed” by the moderator, mention in the posting that the code be considered for movement to the Bob’s Downloads forum

Best Regards,

Mark

robbinma4 :uk: (BOB member since 2005-07-31)

#11

OK, I am doing it right now:

Moderator, please notice this post and consider moving the conversion tool to the Bob’s Downloads forum.

Marek

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#12

Request noted. It’ll probably be next week though. Thanks for the suggestion.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)