The attached file is an updated version of the workbook for mass updating of object descriptions (Mass Updating object descriptions in universe).
My vewrsion is based on Dwayne’s version and that is gratefully acknowledged.
This new version includes a patch that should make it work with BO XI R2.
A user has reported a problem with it when it tries to login. Both versions use an old login method that is now depreciated.
My version includes the new method and instructions on how to edit the code to use it.
I don’t have BO XI R2 so I haven’t been able to test it but having read the documentation here (http://devlibrary.businessobjects.com/BusinessObjectsXIR2/en/en/BO_SDK/dessdk_com_doc/default.htm) I am happy that this should work without any problems.
If someone could test the login part I would be very grateful.
Rather than put a third version up could this replace my existing version.
If you the moderators (only) have any queries then please contact me via my account on this system.
No any warranty (implied or otherwise) is supplied for this software etc.
Firstly thanks for this tool, I’ve used it extensively for 6.5 and its great.
I’m currently developing our first XIr2 universe and have downloaded the latest version of your tool.
Unfortunately when I run the “GetInfo” macro Designer 6.5 is opened. I’ve never learned VB although I looked at your code and tried to follow the instructions within it, it was beyond me.
Uninstalling 6.5 isn’t really an option at this time.
Glad to hear that you have used it successfully.
I have just updated and tweaked Dwayne’s version so I can’t take the credit.
This could get a little tricky.
You will need to make a copy of the XL file so you have one that works with 6.5 (the current version) and another that works with XI.
Unfortunately I don’t have access to XI at the moment to give you complete instructions but I may be able to talk you through it.
I’ll send you an email so we can try and get this working.
For other readers - if I can get this working then I aim to post some instructions in this thread.
With all due respect to robbinma4, I must have missed this posting originally and I’m not sure I see a difference between this version and the instructions / utilities posted here … Mass update to object names / descriptions. Malc001, have you tried the original versions?
I have sent you an email about the differences between this version and your original version.
I am happy to look at folding my changes back into your original code as they add extra value to the tool.
Indeed there are more enhancements than were stated in your original message … “My version includes the new [logon for XI] method and instructions on how to edit the code to use it.”
I’ll go ahead and describe those additional enhancements here for the benefit of others that might be interested …
[quote:3f0a92070e=“robbinma4’s email to Dwayne”]· Capability to retrieve certain universe information (from memory universe description/stats)
· Ability to add comments to classes and the ability to rename classes/objects
· Performance improvement as it only updated those objects that had changed
· Addition of a page of instructions to help new users
· Code comments about how to make it compatible for the different BO versions
[/quote]
Dwayne, it was your original version for 6.5 that I have been using I went hunting for an XI version as I remembered seeing one and found Marks.
Dwaynes works straight from the download, and I managed to get Marks working with the help of a colleague, however both fail at the point of copying columns B and C to D and E.
The error occurs at
Range(“Objects”).Columns(“D:E”).Value = Range(“Objects”).Columns(“B:C”).Value
And after about copying 270 rows of B-C to D-E
The universe I am developing has over 1200 objects (not my design), I have tried Dwaynes tool on a smaller 550-object universe and it works with no errors.
Hi Dwayne, I was starting to wonder if it was something to do with that. I checked the length and its 952 character’s (with spaces).
The descriptions ‘import’ to column C with no problem but fail when trying to copy to column E. I’ve also managed to paste the description about 30 times into one cell which gave a character count of 32,000 ish.
Could it be a limit related to the VB Macro copying?
(BOB member since 2005-07-31)
(BOB member since 2005-09-26)
(BOB member since 2002-09-19)