Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Matching file name to report name

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Matching file name to report name
 Login/Join
 
Member
posted
We recently had a request to do searches against all .fex files to locate one or more strings.
Ex Show me all reports that have the string "- SET" in them.

We have a good tool to crawl the files, but it can only list the file names (xzy.fex).

Does anyone have a good solution for matching the file names back up to the "report" name?
EX xzy.fex = "Accounting Quarter End Report 1"

Any other recommended ways to fulfill that type of request?

Jason Vipond

This message has been edited. Last edited by: Jaywill,


WF 8.0.08 ... Windows Server 2008
 
Posts: 21 | Registered: January 27, 2006Report This Post
Virtuoso
posted Hide Post
That information is somewhere hidden in the html files.
We have created an application that lists all the fexes, creation date, changedate, internal name and location and the display names.
You could combine this with your search.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Platinum Member
posted Hide Post
This information is in your domain html file on the server. Assuming a fairly plain install, this would be located in: x:\ibi\WebFOCUS76\basedir\domain\domain.htm.

The domain file names can be found by right clicking your domain folder in Dev Studio and viewing the properties.

As Frank mentioned, there have been posts on this forum that provide methods for treating that file like a source for a report and thus you can write reports against it. Take a look at that file in a text editor and it should make some sense.

Try this: http://forums.informationbuilders.com/eve/forums/a/tpc/...1057331/m/3411070661

And it was based off of an idea from Francis but I can't find that thread at the moment (maybe he'll chime in).



Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF
 
Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005Report This Post
Expert
posted Hide Post
jaywill
use TEXTPAD, its a text editor from , as luck would have it, www.textpad.com
its got a kicking 'search in files' feature
which searches whatever directories you spec, for whatever character string you spec, and gives you a list of every file name and presents the full line of text in tha file containing your desired string.
Nice, concise list output.
its very cheap.
Free for x days. The free version won't search but 50 files at a time as i recall, at least that's the way it used to be.


wait, i misread your question. you've already got that...
yes you want to read the domainname.htm file in the domain directory, which Frank and Trav have already said.
meaning, if your domain is named mydomain then there exists a file
basedir/mydomain/mydomain.htm
That file will have the true file name and the display name (what you see in the Properties box)..i assume that's what you mean by 'Report name';
You can write a master for this , as a text file; and just do some -READ's

This message has been edited. Last edited by: susannah,




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Guru
posted Hide Post
try Agent Ransack

its a very good searching tool, you can specify RegEx or search within files, and it will also give you a preview panel to show you line of code that matches your query...

and it's free....


Developer Studio 7.64
Win XP
Output: mostly HTML, also Excel and PDF

"Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor
 
Posts: 285 | Location: UK | Registered: October 26, 2007Report This Post
Platinum Member
posted Hide Post
I like Notepad++ :-)

Searches in files, regex supported, free, support syntax highlighting for TONS of languages (even WF), and you can use it was a WF dev tool.

Check out the features at:
http://notepad-plus.sourceforge.net/uk/site.htm



Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF
 
Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005Report This Post
Member
posted Hide Post
Has anyone already built a master for this that they wouldn't mind sharing??

Thanks for all the suggestions!

Regards,
Jason


WF 8.0.08 ... Windows Server 2008
 
Posts: 21 | Registered: January 27, 2006Report This Post
Platinum Member
posted Hide Post
Francis did, but I had trouble finding that post... You might search and see if you can find it (I honestly didn't look too long).

Otherwise you might bug Francis.



Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF
 
Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005Report This Post
Expert
posted Hide Post
The master is just one long record, make it A200
Its the parsing of each record in the read fex that is the wizardry...




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Expert
posted Hide Post
[CLOSED] how to list reports in a dashboard block provides a Master for basedir.htm and Report against user.htm? provides a master for user.htm. Both are handy for reporting on MRE data.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Member
posted Hide Post
Indeed, you are the raddest of the rad!

Thanks again,
Jason


WF 8.0.08 ... Windows Server 2008
 
Posts: 21 | Registered: January 27, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Matching file name to report name

Copyright © 1996-2020 Information Builders