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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

XI3.1 - Recurring Instance Detail List - Excel 2007 Macro
1 members found this topic helpful
Goto page 1, 2  Next
 
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
alpha1145
Principal Member
Principal Member



Joined: 04 Jan 2006

Posts: 181
Location: Salt Lake City, UT


flag
PostPosted: Wed Apr 06, 2011 4:56 pm 
Post subject: XI3.1 - Recurring Instance Detail List - Excel 2007 Macro

Author: Jim McGregor, james.mcgregor@zionsbancorp.com

Author notes:
I wrote this macro to be able to retrieve certain information about recurring instances, specifically event dependency and destination email addresses (if applicable to the schedule). This program is an Excel macro that will extract a list of all recurring instances in the repository and provide some stats about each : Name, update date, create date, parent report folder path, name of event dependency, destination email addresses and output type. This is yet another macro in my series of excel macros I've developed for extracting list-type information on reports or instances in my repository.

Credits:
- Julien Bras - I used Julien's code from the "BOXI UserList & Group Extraction" as a base for this macro.

General Code Description: This selects the SI_ID's of all the recurring instances in the repository (I had 4000+) and loops through them all getting certain information about the parent report template (name, folder path, etc) then it loops through and extracts any information about event dependencies and destination email addresses.

NOTE: This code assumes you have no more than 50,000 instances. That's the limit I set. You are free to adjust that by editing the code. This is also designed to work only with XI3.1, but you could adapt it to XIR2 by changing the library references. You must also be running Microsoft Office 2007 as this is an ".xlsm" file. If you are still running MS2003, this is a good excuse to get an upgrade from your company.

Enjoy! icon_biggrin.gif



Report Recurring Instance Info Macro with Events.zip
 Description:

Download
 Filename:  Report Recurring Instance Info Macro with Events.zip
 Filesize:  34.96 KB
 Downloaded:  6392 Time(s)


_________________
BOE 4.1 SP6
3 Server Cluster - 24 CPU, Front-End Load Balancing
Teradata : Oracle : SQL Server : DB2 : Greenplum : SAS : Hadoop
Back to top
Evil Miyagi
Senior Member
Senior Member



Joined: 06 Mar 2006

Posts: 51
Location: Rochdale, Lancs


flag
PostPosted: Tue Jun 21, 2011 5:36 am 
Post subject: Re: XI3.1 - Recurring Instance Detail List - Excel 2007 Macr

Hi Jim,

Do you have the file available?
I can't see it to download icon_sad.gif

Cheers
Damian
Back to top
robgt
Forum Member
Forum Member



Joined: 21 Apr 2010

Posts: 4
Location: West Midlands, UK


flag
PostPosted: Mon Nov 21, 2011 9:16 am 
Post subject: Re: XI3.1 - Recurring Instance Detail List - Excel 2007 Macr

Is this hosted anywhere else for download? Could really (really!) use it... icon_question.gif
Back to top
Nits
Principal Member
Principal Member



Joined: 09 Nov 2008

Posts: 158


flag
PostPosted: Mon Nov 21, 2011 9:33 am 
Post subject: Re: XI3.1 - Recurring Instance Detail List - Excel 2007 Macr

Is this Macro uploaded somewhere else? Couldn't see it here. Please refer as this will be really useful for us!

Thanks,
Nits
Back to top
BoB LoblaW
Forum Enthusiast
Forum Enthusiast



Joined: 23 Oct 2007

Posts: 1167
Location: Cincinnati, OH


flag
PostPosted: Mon Nov 21, 2011 11:11 am 
Post subject: Re: XI3.1 - Recurring Instance Detail List - Excel 2007 Macr

FYI, attachments are not visible in the Uploads forum for non-administrators. They are only visible once they are approved by a site administrator and moved to the Downloads forum.
_________________
"She wanted to get a cat...I didn't want to get a cat...so...we compromised and got a cat."
Back to top
FionaCasey
Senior Member
Senior Member



Joined: 22 Jan 2007

Posts: 73
Location: Dublin, Ireland


flag
PostPosted: Tue Jan 17, 2012 5:08 am 
Post subject: Re: XI3.1 - Recurring Instance Detail List - Excel 2007 Macr

This would be really helpful, any chance it will be available to download soon?
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19269
Location: Bratislava


flag
PostPosted: Wed Jan 18, 2012 12:36 pm 
Post subject: Re: XI3.1 - Recurring Instance Detail List - Excel 2007 Macr

Moderator note:
Approved, and moved to BOB's Downloads.
Back to top
techytechy
Forum Member
Forum Member



Joined: 03 Dec 2009

Posts: 17



PostPosted: Mon Nov 12, 2012 6:44 pm 
Post subject: Re: XI3.1 - Recurring Instance Detail List - Excel 2007 Macr

Jim,
Your macro is very helpful.

As oScheduleInfo.Properties("SI_DESTINATIONS").Properties("1").Properties("SI_DEST_SCHEDULEOPTIONS").Properties("SI_MAIL_ADDRESSES").Properties("1").Value is being used to get the value, could you please guide me how to set this value to my desired dest email?

Thanks.
Back to top
SandiR
Principal Member
Principal Member



Joined: 20 Dec 2004
ASUG Icon
Posts: 273
Location: By the sea


flag
PostPosted: Wed Feb 13, 2013 8:55 am 
Post subject: Re: XI3.1 - Recurring Instance Detail List - Excel 2007 Macr

Hi there seeya.gif

I am running this excellent utility at BI4 but I was wondering if anyone had the code to allow it to extract multiple email addresses & the cc addies too?

_________________
Sandi

Available for contract work throughout the UK from 1st September 17
uk.linkedin.com/pub/sandi-rocca/1b/262/776/

BI4 - Windows/Tomcat/SQL Server 2008
XI 3.1 - Solaris/Netezza
XIR2, 6, 5.1.9 - Solaris/Weblogic/Oracle

WebI, CMC, Xcelcius/Dashboards4, BI Mobile, CR, BI Explorer, DeskI
Back to top
Captspeed
Principal Member
Principal Member



Joined: 03 Oct 2006

Posts: 242
Location: Florida


flag
PostPosted: Fri May 03, 2013 1:58 pm 
Post subject: Re: XI3.1 - Recurring Instance Detail List - Excel 2007 Macr

Instead of showing the destination being an email id, is it possible to tweak the code to instead show the destination folder path (if/when a report is being exported to a network folder, instead of being emailed)?

ie. export destination folder path & file name = "\\Server\Folder\Subfolder\xxx.xls"
Back to top
jbloomfi
Forum Member
Forum Member



Joined: 14 Mar 2013

Posts: 13



PostPosted: Wed Aug 21, 2013 9:38 am 
Post subject: Re: XI3.1 - Recurring Instance Detail List - Excel 2007 Macr

Okay, I am probably missing something completely obvious, but I am trying to pull back the SI_NEXTRUNTIME field instead of SI_CREATION_TIME and and can't seem to get it to work. I simply changed the 5th row to the new field, but that field doesn't return any data (note that when I randomly try using other fields in the 5th row it seems to work fine).

I can bring back the same information using Query Builder without issue, so I don't know what I am doing wrong...

Here is the VBA code with the desired change:

RowNum = RowNum + 1
Rng(1, 5) = RowNum - 2
Rng(RowNum, 1) = Mid(rsRow2.Properties("SI_PROGID"), 19, Len(rsRow2.Properties("SI_PROGID")))
Rng(RowNum, 2) = rsRow2.Properties("SI_ID")
Rng(RowNum, 3) = rsRow2.Properties("SI_NAME")
Rng(RowNum, 4) = rsRow2.Properties("SI_UPDATE_TS")
Rng(RowNum, 5) = rsRow2.Properties("SI_NEXTRUNTIME")
Back to top
deep
Senior Member
Senior Member



Joined: 23 Jul 2007

Posts: 61



PostPosted: Fri Oct 04, 2013 5:50 pm 
Post subject: Re: XI3.1 - Recurring Instance Detail List - Excel 2007 Macr

Hi jbloomfi

How to add Prompts Information and Output Path Information to this version of Macro.

"Recurring Instance Info Macro" has this information but its not working with XI 3.1

Also adding recurrence information (Weekly (or) Monthly Run).

Your help is highly appreciated.

-Thanks,
Deepu.
Back to top
billa
Forum Member
Forum Member



Joined: 11 Jun 2008

Posts: 18



PostPosted: Tue Apr 29, 2014 3:10 pm 
Post subject: Re: XI3.1 - Recurring Instance Detail List - Excel 2007 Macr

Hi,

Did any one had a chance to modify this Macro to pull the FTP: output path location and Paramaters used in the schedules.

If so could any one upload the Macro or guide me where and how can I get it.

Thank you in Advance.
Back to top
jpenelope
Forum Member
Forum Member



Joined: 17 Oct 2008

Posts: 1



PostPosted: Wed May 07, 2014 8:12 am 
Post subject: Re: XI3.1 - Recurring Instance Detail List - Excel 2007 Macr

Thank You for your work.
It saved me time... icon_biggrin.gif

_Jerome_
Back to top
Fiona
Principal Member
Principal Member



Joined: 16 Dec 2002

Posts: 399
Location: Cornwall


flag
PostPosted: Fri Oct 03, 2014 10:55 am 
Post subject: Re: XI3.1 - Recurring Instance Detail List - Excel 2007 Macr

I have tried running this but get an error and it returns nothing, if I put in random info in the login screen it gives when you click 'Connect CMS' I get the same error, so its like it not even connecting.

I'm I missing something here, I take it by CMS its the same details I would enter under 'System' when I login to Designer, and username and pw are login you would use to login to CMC say as an Admin, and not the repo db login / pw ?

_________________
BO 5.1.6, 6.5, XIR2, XIR3

BO still as flakey as it was 7 years ago icon_smile.gif
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 1 of 2 All times are GMT - 5 Hours
Goto page 1, 2  Next
 
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.0555 seconds using 19 queries. (SQL 0.0258 Parse 0.0025 Other 0.0272)
CCBot/2.0 (https://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