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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: SAP BOBJ User Group DC: Nov 30.

Excel Instance Manager
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
cdupuis
Forum Member
Forum Member



Joined: 30 Nov 2015

Posts: 3


flag
PostPosted: Mon Nov 30, 2015 3:02 pm 
Post subject: Excel Instance Manager

Originally written by Rachidb
. http://www.forumtopics.com/busobj/viewtopic.php?p=570231

Updated for XI 3.0 by Joe Peters
. http://www.forumtopics.com/busobj/viewtopic.php?t=168709

Additional enhancements created while working with this great tool:
Author: Corey Dupuis
Platform: MS Excel 2010 (.xlsm)
Version: 1.1
Notes:
  • Can specify End-Time
  • Selection by status (pending, paused, funning, successful, failed, not scheduled)
  • Progress bar while processing data returned by query
  • Title, path, and frequency columns



scheduledInstances.zip
 Description:
Excel Scheduled Instance manager

Download
 Filename:  scheduledInstances.zip
 Filesize:  295.57 KB
 Downloaded:  1027 Time(s)

Back to top
aniketp
Forum Addict
Forum Addict



Joined: 05 Oct 2007

Posts: 3633
Location: Manchester


flag
PostPosted: Wed Dec 02, 2015 6:23 am 
Post subject: Re: Excel Instance Manager

This is a great tool, thanks a lot for sharing. As usual, BOB rocks.

Just needed some help in coding - Is it possible to include the particular folder as a destination? Means there are n folders in infoview and I am interested in knowing the schedule details of infoobjects present in a particular folder....

_________________
Regards
Aniket
Back to top
cdupuis
Forum Member
Forum Member



Joined: 30 Nov 2015

Posts: 3


flag
PostPosted: Wed Dec 02, 2015 4:10 pm 
Post subject: Re: Excel Instance Manager

My pleasure. For a list of schedule details the best thing is to refresh the pending status for a given timeframe.

For exmaple,
- Hit Refresh
- Start Date = today (blank)
- End Date = 12/31/2016 (reports that will run in the next year)
- Status = Pending

This should give you something you can filter on the Path (source) and Destination columns.

Corey
Back to top
MorganJ
Forum Member
Forum Member



Joined: 08 Dec 2015

Posts: 9



PostPosted: Fri Dec 11, 2015 1:55 am 
Post subject: Re: Excel Instance Manager

Hi

will this work with BO 4.1 sp6?
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19096
Location: Bratislava


flag
PostPosted: Fri Dec 11, 2015 2:47 am 
Post subject: Re: Excel Instance Manager

[Moderator Note: Moved from XI Scheduler to BOB's Downloads]
Back to top
NycPriya
Forum Associate
Forum Associate



Joined: 04 Nov 2010

Posts: 525



PostPosted: Tue Dec 15, 2015 10:13 am 
Post subject: Re: Excel Instance Manager

Works with 4.1 SP4.

How can i get ALL recurring schedules and then filter on schedule types (Daily, Monthly) ?
Back to top
aniketp
Forum Addict
Forum Addict



Joined: 05 Oct 2007

Posts: 3633
Location: Manchester


flag
PostPosted: Thu Mar 17, 2016 1:31 am 
Post subject: Re: Excel Instance Manager

It is working fine for me , but failing in one environment where there are many objects.

Can someone please guide me how to get the details only of one particular folder and sub folders placed in it? This will be big achievement for me.... icon_sad.gif

_________________
Regards
Aniket
Back to top
gsbatch1
Forum Member
Forum Member



Joined: 18 Feb 2014

Posts: 10



PostPosted: Tue Aug 23, 2016 1:45 pm 
Post subject: Re: Excel Instance Manager

I downloaded this a few months back and love it, but now my boss wants to be able to track day over day, month over month. The only way I can do this currently is to run this each morning for the previous day and then open MS Access and import the file into a table.
Is there a way to convert this macro into one inside MS Access and insert the results into a preexisting table?

I can then use it to link to Tableau or something else and show a story about our Business Objects.
Back to top
Andreas
Forum Advocate
Forum Advocate



Joined: 20 Jun 2002

medal_silver.gif*2medal_gold.gif
Posts: 17323
Location: *** BEEP ...Dreaming of Africa... leave No message ; ) BEEP ***


flag
PostPosted: Tue Aug 23, 2016 1:54 pm 
Post subject: Re: Excel Instance Manager

gsbatch1 wrote:
..
I can then use it to link to Tableau or something else and show a story about our Business Objects.

icon_eek.gif eek.gif I am going to pretend I did NOT read this.. eek.gif

_________________
Follow me on Twitter
Reading "The Design Of Everyday Things" by Don Norman
Focusing on Data Visualization, Design Thinking, SAP DesignStudio + scripting, SAP BI 4.x platform & architecture, SAP connectivity, Data Modeling, and SAP HANA Certified Associate
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6203
Location: Connecticut, USA


flag
PostPosted: Tue Aug 23, 2016 2:55 pm 
Post subject: Re: Excel Instance Manager

BusinessObjects -> Excel VBA -> MS Access -> Tableau

Why not? lol.gif
Back to top
gsbatch1
Forum Member
Forum Member



Joined: 18 Feb 2014

Posts: 10



PostPosted: Wed Aug 24, 2016 7:19 am 
Post subject: Re: Excel Instance Manager

We have Auditing turned off. We have over 600 publications with those 600 bursting out to the total of 15k emails a day. I know this sounds like a nightmare, and believe me it is. This is what I walked into when I got hired. I need to clean it up, but without auditing turned on, I need to find alternatives. This Excel Macro is great, but I need to be able to see day over day, week over week as I clean things up.
Back to top
gsbatch1
Forum Member
Forum Member



Joined: 18 Feb 2014

Posts: 10



PostPosted: Mon Aug 29, 2016 1:40 pm 
Post subject: Re: Excel Instance Manager

How about if there is a way to get the number of recipients from the publication history? I know it shows on the publication history if you open it, how would I go about getting it on this Excel Macro?
Back to top
adityayottastar
Forum Member
Forum Member



Joined: 06 Apr 2010

Posts: 1



PostPosted: Thu Sep 08, 2016 4:41 pm 
Post subject: Re: Excel Instance Manager

can we do a filter on the folder path in the macro code? I looked at below code & not sure how to do it at specific folder.
Basically I like to restrict the code to look at one specific folder, so I can give this to my business/end users.

Please help!

'build path
sPath = ""
'walk up path until no parent
While oParent.ParentID <> 0
If (oParent.Kind = "Folder" Or oParent.Kind = "FavoritesFolder") Then
sPath = oParent.Title + "\" + sPath
End If
Set oParent = oParent.Parent
Wend
'add last folder to path
If (oParent.ObjectType = 13) Then 'temporary folder
'nothing
ElseIf (oParent.Kind = "Folder" Or oParent.Kind = "FavoritesFolder") Then
sPath = oParent.Title + "\" + sPath
End If
.Cells(1 + i, j + 1).Value = "\" + sPath
j = j + 1

.Cells(1 + i, j + 1).Value = getServerGroupIfAny(serverGroups, oSchedulingInfo)
If oSchedulingInfo.Status <> ceStatusPending And oSchedulingInfo.Status <> ceStatusPaused Then
j = j + 1
.Cells(1 + i, j + 1).Value = oSchedulingInfo.Properties("SI_MACHINE_USED").Value
Else
j = j + 1
End If
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.0194 seconds using 21 queries. (SQL 0.0062 Parse 0.0028 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