HELP (Richard Kreiss)
Tom Aldridge
toma at aldridgeinc.com
Wed Apr 13 07:17:13 PDT 2011
Perhaps an idea that might be useful to you.
I run nearly all output processes (printed output as well as maintenance
processing) from a filePro file itself.
I call the file 'cron' (I know... a dumb name) but I chose it years ago
because in addition to running a particular output process on demand via
input processing while sitting on a particular record; I have "cron"
[the unix/linux utility)] run the following nightly "/appl/fp/rreport
cron -f cronrun -v cronsel -a -u -ia -bs -bg > /dev/null)"
in order to select records based on fields in 'cron' that duplicate many
of the features of "cron" itself, i.e. every day, day of week, etc. plus
criteria such as run one time and delete it's own record, run every so
many days and increment a set number of days, etc. So when I have a new
output process to run unattended, I don't have to create a new entry in
crontab, I simply add a record to my 'cron' database... and there I tell
it when and how to run.
The 'cron' database contains all sorts of records for running various
printed reports or maintenance processing, i.e, archive/purge/update
records.... on other filePro files.
It has fields like:
8 - a1) fp_command_line . 66. *
9 - a1) fp_command_line . 66. *
10 - a1) fp_command_line . 66. *
that I string together (and run via "system") in input processing to run
on demand, as well as in report processing, see "cronrun" above.
There are other fields that name the report, describe it in detail if
desired; fields that specify printers, email addresses to send results
to, etc.
This being a filePro file itself, one can create as sophisticated a user
interface and search mechanism as desired. No menus to hunt through,
just a filePro file to select records (i.e. reports) from. For various
divisions or departments, you can use qualifiers as well.
I know everyone has their own way to do things. This system works great
for me. Below is part of the map for this 'cron' file.
job_name: 35:allup:
type: 11:allup:
a0)description: 35:*:
a0)description: 35:*:
user_access: 1:yesno:
.:::
run_fp: 1:yesno:
a1) fp_command_line: 66:*:
a1) fp_command_line: 66:*:
a1) fp_command_line: 66:*:
run_shell_command: 1:yesno:
a2) command_line: 66:*:
a2) command_line: 66:*:
a2) command_line: 66:*:
.:::
---individual notification fields---
email_notify: 1:yesno:
email_address: 25:*:
subject: 25:*:
a3) message: 66:*:
a3) message: 66:*:
run_cron: 1:yesno:
dow_numeric: 1:.0:
dow_alpha: 3:allup:
day_of_month: 2:.0:
month_of_year: 2:.0:
run_once: 1:yesno:
run_delete: 1:yesno:
run_mult: 2:.0:
run_on_date: 10:mdyy/:
a3) message: 66:*:
increment_days (to run_on_date): 3:.0:
delete_on_date: 10:mdyy/:
run_days_past_moend: 2:.0:
~
Tom Aldridge
>
> On 4/8/2011 4:37 PM, John Kerr wrote:
>> I am having trouble keeping track of everything having to do with filepro.
>> I am trying to find a solution to organize/manage reports, selections,
>> user menus so we can determine what does what.
>> I have some 300 user menus, some 3000 reports and selections, etc. I am
>> losing control of information for my people. I
>> am sure I can develope something but would rather find someone that has
>> already solved the problem. I can forsee that it would take me a year
>> or more
>> to develope something myself that works. Need some HELP.
>>
>> johnkerr at combotronicsinc.com
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>
More information about the Filepro-list
mailing list