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,

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

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

Output:

 DATE        TIME      GMTTIME     SIZE          FILENAME                                                                APPNAME
 ----        ----      -------     ----          --------                                                                -------
 04/08/2004  08.00.00  1091620800  766           3dgarro.cur                                                             folder1
 04/08/2004  08.00.00  1091620800  766           3dgmove.cur                                                             folder1
 04/08/2004  08.00.00  1091620800  766           3dgnesw.cur                                                             folder1
 04/08/2004  08.00.00  1091620800  766           3dgno.cur                                                               folder1
 04/08/2004  08.00.00  1091620800  766           3dgns.cur                                                               folder1
 04/08/2004  08.00.00  1091620800  766           3dgnwse.cur                                                             folder1
 04/08/2004  08.00.00  1091620800  766           3dgwe.cur                                                               folder1
 04/08/2004  08.00.00  1091620800  766           3dsmove.cur                                                             folder1

Documentation: Developing Reporting Applications > Creating and Working With Applications > Reports and Help

Francis we almost crossed each other in replying...
I remember this APP QUERY from one of your older posts....thanks to you..

thanks
Sashanka

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?

Thanks,

Norb

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!

quote:

Though I find myself out of a job on Tuesday morning!

Hope you have another one lined up.

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 ? ?

Great time to jump to IBI! I'd LOVE to have you working on the product from the inside!

-ABT

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?

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?

How about it, David Glick or Brian Suter? :-)

- ABT

Thanks for the responses. I think I have enough code to work with to get this going.

Francis, enjoy your time off.

Francis,

Enjoy the break, rechard the batteries, and hope to see you on the forum soon.

Perhaps the next place won't have the diffucult set up you have there.

quote:

Ramkumar: "Any plans to move away from WebFOCUS?" - Why would I? Do you want me to?

Defenitely a BIG NO. Just asked. Your contributions are much needed in the webFOCUS world.

All the best for all your future endeavours. Let your future foucs on WebFOCUS.