BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Launch Works 
Launch Works (Opens a new window)  

General Notice: No events within the next 45 days.

New ver of Mass Updating object descriptions in universe
1 members found this topic helpful

 
Search this topic... | Search BOB's Downloads... | Search Box
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Author Message
robbinma4
Senior Member
Senior Member



Joined: 31 Jul 2005

Posts: 68
Location: Berkshire


flag
PostPosted: 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



Universe - Object Names & Descriptions.zip
 Description:
Updated version with commands for XI R2 login & extra instructions

Download
 Filename:  Universe - Object Names & Descriptions.zip
 Filesize:  13.34 KB
 Downloaded:  2228 Time(s)

Back to top
malc001
Senior Member
Senior Member



Joined: 26 Sep 2005

Posts: 82
Location: London


flag
PostPosted: 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
Senior Member



Joined: 31 Jul 2005

Posts: 68
Location: Berkshire


flag
PostPosted: 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
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8639
Location: Plano, TX USA


flag
PostPosted: 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
Senior Member



Joined: 31 Jul 2005

Posts: 68
Location: Berkshire


flag
PostPosted: 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
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8639
Location: Plano, TX USA


flag
PostPosted: 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
Senior Member



Joined: 26 Sep 2005

Posts: 82
Location: London


flag
PostPosted: 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
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8639
Location: Plano, TX USA


flag
PostPosted: 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
Senior Member



Joined: 26 Sep 2005

Posts: 82
Location: London


flag
PostPosted: 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
Forum Member



Joined: 20 Sep 2011
ASUG Icon
Posts: 13
Location: Tampa, FL


flag
PostPosted: 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
Senior Member



Joined: 31 Jul 2005

Posts: 68
Location: Berkshire


flag
PostPosted: 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
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0668 seconds using 20 queries. (SQL 0.0187 Parse 0.0377 Other 0.0104)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo