[SOLVED] Using WebFOCUS to count files in Windows Folder
I am thinking of using WebFOCUS and ReportCaster to monitor file counts and age of files in one or more Windows folders. We have a document imaging system that pulls documents from folders, and it frequently gets backed up.
I am trying to see if I can build something in WebFOCUS either to alert me that documents in a folder are older than a certain timeframe, or at least give me a file count.
We are also building a batch file and IP Monitor, but I am wondering if WebFOCUS can do it easier.
Thoughts?This message has been edited. Last edited by: Kerry,
WF 7.6.11 Windows Excel, HTML, and PDF.
July 21, 2011, 11:41 AM
Severus.snape
Hi,
If the Windows folders are on the Reporting server machine it will be simple to add the folders to the APP PATH and use the below code
APP QUERY foldername HOLD
TABLE FILE FOCAPPQ
COUNT
*
END
-EXIT
If the folders are on other system ...since WF server is on windows you can easily Map the remote server to the WF server so that you can then add them to the APP PATH and query it... And you can send alerts using Report Caster ofcourse..
thanks Sashanka
WF 7.7.03/Windows/HTML,PDF,EXL POC/local Dev Studio 7.7.03 & 7.6.11
July 21, 2011, 11:43 AM
Francis Mariani
If the folder is accessible by the reporting server, you can achieve this using APP commands:
APP MAP FOLDER1 C:\WINDOWS\CURSORS
APP QUERY FOLDER1 HOLD
TABLE FILE FOCAPPQ
PRINT *
END
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
July 21, 2011, 11:44 AM
Severus.snape
Francis we almost crossed each other in replying... I remember this APP QUERY from one of your older posts....thanks to you..
thanks Sashanka
WF 7.7.03/Windows/HTML,PDF,EXL POC/local Dev Studio 7.7.03 & 7.6.11
July 21, 2011, 12:04 PM
Norb Eckert
Francis,
You are unbelievably organized in that you access WebFOCUS information very rapidly and in great detail. Just out of curiosity, what do you use to store and access all this information?
I browse FocalPoint via Firefox. I installed an extension called ReloadEvery - it reloads the FocalPoint tab every five minutes, allowing me to keep tabs on things!
I use EditPlus as my text editor. I've backed up all the code I've ever worked on for the past nn years and can easily search in multiple app folders.
Since I am a "real" Developer, writing code instead of pointing and clicking and expecting miracles, I'm in touch with the syntax and know my way around a bit. And I read the manuals.
My training began in a proper IT world - I'm comfortable with standards, conventions, reusability... unlike modern report developers, all loosey-goosey, pointy-and-clicky!
Though I find myself out of a job on Tuesday morning!
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
July 21, 2011, 06:09 PM
Waz
quote:
Though I find myself out of a job on Tuesday morning!
Hope you have another one lined up.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
July 22, 2011, 12:57 AM
Ramkumar - Webfous
quote:
quote: Though I find myself out of a job on Tuesday morning!
Hope you have another one lined up.
Yes Francis... So whatz your next assignment? Any plans to move away from WebFOCUS ? ?
Thanks,
Ramkumar. WebFOCUS/Tableau Webfocus 8 / 7.7.02 Unix, Windows HTML/PDF/EXCEL/AHTML/XML/HTML5
July 22, 2011, 08:50 AM
ABT
Great time to jump to IBI! I'd LOVE to have you working on the product from the inside!
Waz: Nothing lined up yet. It was an unexpected contract cancellation. I have some vacation lined up in Aug and Sep so it might be difficult starting something new right now. I'm planing to take some time off.
Ramkumar: "Any plans to move away from WebFOCUS?" - Why would I? Do you want me to?
ABT: "I'd LOVE to have you working on the product from the inside!" - Interesting! Could I do that from my home-base, Toronto?
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
July 22, 2011, 09:49 AM
ABT
quote:
ABT: "I'd LOVE to have you working on the product from the inside!" - Interesting! Could I do that from my home-base, Toronto?