| Author |
Message |
robbinma4
Senior Member
Joined: 31 Jul 2005
Posts: 68
Location: Berkshire
|
 Posted: Tue Apr 25, 2006 4:37 am
Post subject: New ver of Mass Updating object descriptions in universe |
|
|
Hello,
The attached file is an updated version of the workbook for mass updating of object descriptions (http://www.forumtopics.com/busobj/viewtopic.php?t=58935).
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.
Thanks & Best Regards,
Mark
Approved - Michael Welter 9/11/2006
| Description: |
| Updated version with commands for XI R2 login & extra instructions |
|
Download |
| Filename: |
Universe - Object Names & Descriptions.zip |
| Filesize: |
13.34 KB |
| Downloaded: |
2066 Time(s) |
|
|
| Back to top |
|
|
malc001
Senior Member
Joined: 26 Sep 2005
Posts: 82
Location: London
|
Posted: Tue Jul 29, 2008 6:29 am
Post subject: Re: New ver of Mass Updating object descriptions in universe |
|
|
Hi Mark,
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.
Hope someone can help
Thanks in advance
_________________
Working in London
Currently Webi & Universe Designer XIr3 with InfoBurst
The past is history, the future's a mystery and this moment's a gift. That's why it's called the present.... |
|
| Back to top |
|
|
robbinma4
Senior Member
Joined: 31 Jul 2005
Posts: 68
Location: Berkshire
|
Posted: Tue Jul 29, 2008 12:44 pm
Post subject: Re: New ver of Mass Updating object descriptions in universe |
|
|
Hi malc001,
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.
Mark
|
|
| Back to top |
|
|
Dwayne Hoffpauir
Forum Groupie
Joined: 19 Sep 2002
 *2 *5
Posts: 8638
Location: Plano, TX USA
|
Posted: Tue Jul 29, 2008 3:28 pm
Post subject: Re: New ver of Mass Updating object descriptions in universe |
|
|
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?
_________________
Dwayne Hoffpauir
Image link |
|
| Back to top |
|
|
robbinma4
Senior Member
Joined: 31 Jul 2005
Posts: 68
Location: Berkshire
|
Posted: Tue Jul 29, 2008 3:58 pm
Post subject: Re: New ver of Mass Updating object descriptions in universe |
|
|
Dwayne,
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.
Best regards,
Mark
|
|
| Back to top |
|
|
Dwayne Hoffpauir
Forum Groupie
Joined: 19 Sep 2002
*2*5
Posts: 8638
Location: Plano, TX USA
|
Posted: Tue Jul 29, 2008 5:13 pm
Post subject: Re: New ver of Mass Updating object descriptions in universe |
|
|
| robbinma4 wrote: | 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 ...
| robbinma4's email to Dwayne wrote: | · 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 |
_________________
Dwayne Hoffpauir
Image link |
|
| Back to top |
|
|
malc001
Senior Member
Joined: 26 Sep 2005
Posts: 82
Location: London
|
Posted: Wed Jul 30, 2008 2:30 am
Post subject: Re: New ver of Mass Updating object descriptions in universe |
|
|
Hi both and thank you for your help so far.
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.
Dwayne’s works straight from the download, and I managed to get Mark’s 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 Dwayne’s tool on a smaller 550-object universe and it works with no errors.
Thanks in advance
Malcolm.
_________________
Working in London
Currently Webi & Universe Designer XIr3 with InfoBurst
The past is history, the future's a mystery and this moment's a gift. That's why it's called the present.... |
|
| Back to top |
|
|
Dwayne Hoffpauir
Forum Groupie
Joined: 19 Sep 2002
*2*5
Posts: 8638
Location: Plano, TX USA
|
Posted: Wed Jul 30, 2008 8:04 am
Post subject: Re: New ver of Mass Updating object descriptions in universe |
|
|
| malc001 wrote: | 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 |
Check the length of the description at that "offending" row. I think Excel has an issue if it is over 1,024 characters.
_________________
Dwayne Hoffpauir
Image link |
|
| Back to top |
|
|
malc001
Senior Member
Joined: 26 Sep 2005
Posts: 82
Location: London
|
Posted: Wed Jul 30, 2008 8:15 am
Post subject: Re: New ver of Mass Updating object descriptions in universe |
|
|
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?
Thanks
Malcolm.
_________________
Working in London
Currently Webi & Universe Designer XIr3 with InfoBurst
The past is history, the future's a mystery and this moment's a gift. That's why it's called the present.... |
|
| Back to top |
|
|
Redfish
Forum Member
Joined: 20 Sep 2011
Posts: 13
Location: Tampa, FL
|
Posted: Mon Sep 26, 2011 11:29 am
Post subject: Re: New ver of Mass Updating object descriptions in universe |
|
|
| Is there an updated version for XI 3.1? I hvae scoured the forum for a compatible version of the Universe Documenter to no avail.
|
|
| Back to top |
|
|
robbinma4
Senior Member
Joined: 31 Jul 2005
Posts: 68
Location: Berkshire
|
Posted: Mon Sep 26, 2011 12:50 pm
Post subject: Re: New ver of Mass Updating object descriptions in universe |
|
|
unfortunately I don't have access to the new version of the software so I can't update it.
Dwayne may still be involved with BOXI and may be able to update either version
|
|
| Back to top |
|
|
|
