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: No events within the next 45 days.

WID Scanner
8 members found this topic helpful
Goto page 1, 2, 3, 4, 5, 6, 7, 8, 9, 10  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
jbo
Principal Member
Principal Member



Joined: 31 Jul 2005

Posts: 110


flag
PostPosted: Tue Mar 13, 2007 2:44 pm 
Post subject: WID Scanner

Quote:
Purpose:

For each WID-file in the CMS the following information is retrieved and written in a MDB and/or Flatfile:

Author
Filename
Path
Description
Keywords
Folder
Foldertype
Instance Yes/No
Universes used
Objects and Predefined Conditions used**

** Since this information is gathered by using a grep command on the physical WID-file, the relationship between the universes and objects is not retrieved. Also the class an object belongs to is not retrieved.


version: BOXI rls2
platform: MS Windows

JBO
jbo_911@hotmail.com

download grep @ http://sourceforge.net/project/showfiles.php?group_id=23617


Updated 8/14/2007 -- Version 1.1:

-fix export path, spaces were not allowed
-added FullClient documents to documentlist (no object scan is done, other tools available)
-added filesize in KB of the documents
-Instances are (if wanted) excluded in a proper way



WIDScanner_1_2.zip
 Description:
Updated to 1.2

Download
 Filename:  WIDScanner_1_2.zip
 Filesize:  42.78 KB
 Downloaded:  12362 Time(s)

Back to top
MichaelWelter
Forum Advocate
Forum Advocate



Joined: 08 Aug 2002
ASUG Icon
speaker.gif*6medal_bronze.gif
Posts: 15015
Location: Rancho Cucamonga, CA, USA, Earth, Milky Way


flag
PostPosted: Tue Mar 20, 2007 12:18 am 
Post subject: Re: WID Scanner

Approved, and moved to BOB's Downloads.
_________________
Michael Welter, BOCP-BOE, Webi Image link
Independent BI Consultant
(909)899-3002

______________________
Follow me on Twitter

Latest Blog Posts
• 2019-02-22 Tableau Security Made Easy
• 2018-09-20 Hello, Tableau
• 2018-08-16 New Beginnings
Back to top
Bobarella
Site Administrator
Site Administrator



Joined: 11 Feb 2004

Posts: 1079
Location: BOBville



PostPosted: Tue Aug 14, 2007 2:26 pm 
Post subject: Re: WID Scanner

Revised with updated attachment -- 8/14/2007
_________________
Search is Your Friendô
Back to top
kevish
Forum Member
Forum Member



Joined: 01 Jun 2005

Posts: 29
Location: New Orleans, LA


flag
PostPosted: Mon May 05, 2008 6:19 pm 
Post subject: Re: WID Scanner

All I keep getting is "File not found", every time I tell it to retrieve. Strangely, it does seem to find the files in the repo (saying 0/410) in the lower-right.

Can anyone help out with this?

XI R2 SP2, .Net InfoView only.

Thanks,
Kevin.

_________________
Acceptance of what has happened is the first step to overcoming the consequences of any misfortune.
-- William James
Back to top
crystal01
Principal Member
Principal Member



Joined: 30 Aug 2006
ASUG Icon
Posts: 437
Location: Chicago, IL


flag
PostPosted: Tue May 13, 2008 2:43 pm 
Post subject: Re: WID Scanner

It sounds like your BOE environment has references to report objects in the CMS database, but the actual report objects no longer reside on the FRS. I had the same issue as you when using this tool - you'll want to modify the code to check for existence of the file before the filesize is checked, and before the file is grepped for objects used.

A good first step might be to take a look at the records that were generated to the flat file / access DB and see if you can identify which report is causing your issue.
Back to top
DonS
Senior Member
Senior Member



Joined: 26 Jun 2006

Posts: 51
Location: Kansas City, Mo.


flag
PostPosted: Tue May 13, 2008 3:29 pm 
Post subject: Re: WID Scanner

Has anyone tried to use the SECWINDOWSAD auth to access the information needed. I have tried it and it says I need the plugin but I don't understand because we have AD setup in BOE.

Also, I am correct if you don't have authority to the filestore path it will not access the information.

_________________
Donald Strickland
Back to top
jbo
Principal Member
Principal Member



Joined: 31 Jul 2005

Posts: 110


flag
PostPosted: Wed May 14, 2008 12:18 pm 
Post subject: Re: WID Scanner

@kevish: I updated the program some time ago and it checks for missing files now. If it still doesn't work for you it probably has to do with not having access rights to the filestore.

cannot get it uploaded to bob so you will have to download here:
http://rapidshare.com/files/115347212/WIDScanner_1_2.zip.html

Quote:

V1.2
added variable batch processing to avoid stressing CMS (batchsize is size of resultset of query against CMS database)
added check for physical file existance (sometimes CMS contains files that physically don't exist anymore)


Last edited by jbo on Fri May 16, 2008 10:54 am, edited 1 time in total
Back to top
kevish
Forum Member
Forum Member



Joined: 01 Jun 2005

Posts: 29
Location: New Orleans, LA


flag
PostPosted: Wed May 14, 2008 3:03 pm 
Post subject: Re: WID Scanner

This tool is AMAZING -- incredible. icon_mrgreen.gif

The only thing I find is that, when I refresh to an MDB file (the only way to get the objects used, which is what we're really looking for here), the MDB table wid_document_objects is empty. The Universes table is populated at looks great at first blush, just the objects table is empty.

You all have been so awesome on this with the input, so any additional help to get us the last couple steps would be very appreciated.

Thanks again,
Kevin. seeya.gif

_________________
Acceptance of what has happened is the first step to overcoming the consequences of any misfortune.
-- William James
Back to top
crystal01
Principal Member
Principal Member



Joined: 30 Aug 2006
ASUG Icon
Posts: 437
Location: Chicago, IL


flag
PostPosted: Wed May 14, 2008 3:07 pm 
Post subject: Re: WID Scanner

Do you have Grep installed and your classpath configured correctly? I experienced the same thing (everything worked fine but blank wid_document_objects table) when I didn't yet have Grep configured correctly...

You should see a command line window "flicker" as it repeatedly executes the .wid file greps while the program is running - is this happening?
Back to top
kevish
Forum Member
Forum Member



Joined: 01 Jun 2005

Posts: 29
Location: New Orleans, LA


flag
PostPosted: Wed May 14, 2008 4:19 pm 
Post subject: Re: WID Scanner

I do have grep installed (2.5.1a-2) from SourceForge. The bin directory of grep is added to the path environment variable, and I have verified that typing an unqualified "grep" at a command prompt results in the command asking for options:

Code:
C:\>grep
Usage: grep [OPTION]... PATTERN [FILE]...
Try `grep --help' for more information.


I do not observe the "flickering" that you mentioned.

You mentioned the classpath variable. Do I need to configure classpath also? I didn't notice any .class files in the GnuWin32 directory.

Thanks again & Keep the input coming! icon_biggrin.gif

Kevin.

_________________
Acceptance of what has happened is the first step to overcoming the consequences of any misfortune.
-- William James
Back to top
anair_bo
Principal Member
Principal Member



Joined: 05 Dec 2006

Posts: 255
Location: Philly, PA


flag
PostPosted: Thu May 15, 2008 8:50 am 
Post subject: Re: WID Scanner

jbo,
Will this work in Java env?
We are on BO XI R2 SP3 (Solaris) mounted on weblogic(Solaris) .
Back to top
jbo
Principal Member
Principal Member



Joined: 31 Jul 2005

Posts: 110


flag
PostPosted: Thu May 15, 2008 11:20 am 
Post subject: Re: WID Scanner

it's a vba macro so it will only work in a windows environment, if your server resides on a java env it doens't matter as long you have access to deski...

Last edited by jbo on Tue Jun 03, 2008 7:43 am, edited 1 time in total
Back to top
kevish
Forum Member
Forum Member



Joined: 01 Jun 2005

Posts: 29
Location: New Orleans, LA


flag
PostPosted: Fri May 16, 2008 10:07 am 
Post subject: Re: WID Scanner

Got it! I added this line at 311, after noticing that the If bFileExists loop was short-circuiting. I'm not sure if I just got a bad download, since this code is definitely necessary, given the logic structure. The line I added is the third in this excerpt:

Code:
sFileName = CStr(IS_property.properties("si_files").properties("SI_FILE" & iCnt))
sFilePath = Replace(Replace(CStr(IS_property.properties("si_files").properties("si_path")), "frs://", ""), "/", "\")
bFileExists = oFso.FileExists(cFileStorePath + "\\" + sFilePath + sFileName)

If bFileExists Then


So, previous to my edit, the code was calculating an update to the file name and path, but was not reupping the bFileExists to reflect this change.

Hope this helps someone out there! I always like to post my resolutions and keep this board kickin' butt! yesnod.gif

Kevin.

_________________
Acceptance of what has happened is the first step to overcoming the consequences of any misfortune.
-- William James
Back to top
jbo
Principal Member
Principal Member



Joined: 31 Jul 2005

Posts: 110


flag
PostPosted: Fri May 16, 2008 10:55 am 
Post subject: Re: WID Scanner

Oops icon_eek.gif , updated the link above.
Back to top
Snabbles
Forum Member
Forum Member



Joined: 07 Jul 2006

Posts: 15



PostPosted: Mon May 19, 2008 1:50 pm 
Post subject: Re: WID Scanner

Great tool! Very useful. However I did find one bug (using the new version). The flat file extract breaks if a report has a carriage return in the comment section; it creates more than one row for that report.

Again, Thanks for a great tool! icon_surprised.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 10 All times are GMT - 5 Hours
Goto page 1, 2, 3, 4, 5, 6, 7, 8, 9, 10  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.1104 seconds using 20 queries. (SQL 0.0160 Parse 0.0665 Other 0.0279)
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