fPlib call-table routine & database that displays user menus easily from processing tables. "Easily" = 1 line of filepro code per menu request, plus one declare statement per processing table. Menu creation & maintenance is easy via an intuitive Menu-Editor.
Written with filePro 4.08.09 for SCO Unix, running on SCO Open Server 5.0.5, and Linux version <kernel-of-the-week>.
Does not require a PLUS or FULL Development System to develope apps. Does not require any Development System to use the run-times. Does not require any Development System to create/modify/delete menus. So it can be used to write apps that will be distrubuted in purely tokenized form.

fpl_menu.tar.gz - fPlib_MENU filePro file (updated: 06/29/00)
fpl_menu_help.txt - Install & Usage (updated: 06/29/00)
screen shot - Menu-Editor main screen
screen shot - Menu-Editor notes popup
screen shot - Menu-Editor line-item detail pop-up
screen shot - Example Menu
screen shot - Example Menu Help

syntax hilighting
Syntax files for colorized syntax hilighting in external text editors.
Install these config files into the indicated editor, and see filePro prc tables in pretty syntax-hilighted color.
vim/gvim - "Vi Improved" - for dos/win/unix/linux
cooledit/mcedit - CoolEdit and the Midnight-Commander built-in editor, mcedit - for unix/linux

Converts all processing tables to unencrypted ascii.
Written with filePro 4.08.09 for SCO Unix, running on SCO Open Server 5.0.5, using the stock SCO /bin/sh. Should work with earlier versions of filePro but untested. Linux version should work too, but is also untested.
prc2ascii - for SCO Unix
prc2ascii-L - for Linux

Leftify is very powerful, but very dangerous mojo. :)
Lets you change the format of data that is already being referenced by many records and files, by updating ALL occurances of the data throught the system. Essentially this means you can change your mind about decisions that were made years ago when you started generating and accumulating data.
It's the first incarnation of a tool or possibly a set of tools tentatively known as "sweep" and currently only performs one type of manipulation. Left-Justify.
I think the sample log files from actual runs describe the action of leftify best. As you can see by the last test-run log below, It's already useful as a reporting tool to find discrepencies in your file layout, to help you clean up things like those e-mail feilds...different field lengths, different edits, all in the same application, not to mention a LOWUP edit on an e-mail field? tsk tsk tsk...

Written with filePro 4.08.09 for SCO Unix, running on SCO Open Server 5.0.5, using the stock SCO /bin/sh. Should work with earlier versions of filePro but untested.

leftify - shell script for SCO Unix
leftify.txt - Description of leftify and sweep
sweep_Feb19-1313 - Log of a real run
sweep_Feb19-1537 - Log of a real run
sweep_Feb19-1316 - Log shows finding an ascoc. field
sweep_Feb20-0611 - Log shows how to deal with assoc. fields.
sweeptest-1 - screen shot of a test-run
sweep_Feb19-1704 - Log of a test-run

Extracts files from multi-volume tars created by the SCO line of operating systems such as Xenix and Open Server, onto Linux or other systems using Bash-2.x (or now, ksh) and GNU tar. (Yes, *finally* someone addressed this aggrevation!)
You can use this to install SCO Unix filePro from floppies on Linux.

scotar.txt - install & usage readme
scotar-1.0 - shell scipt (bash-2.x)
scotar-1.6 - shell scipt (ksh)

Work-Around for fpcopy on SCO Unix, for filepro version 4.8.*, allows you to fpcopy a filepro file, including any prc, tok, screen, out, sel, and brw formats that have filenames longer than 14 bytes which fpcopy incorrectly ignores. This script temporarily renames any objects that would get ignored, runs fpcopy, then renames the altered objects back to their original names in both the source and target filepro files.

Should work as-is on at least SCO Open Server and Linux, but it's written and only tested on SCO. I did test echo and ps for similar functionality in ksh on Linux, other commands should be fine but the acid test has not been performed.
Note: I do not know if the Linux native version of fpcopy even has the problem that the SCO Unix version has.
Run with "-d" for extra debugging messages.
    Run this from a user menu, or see to it that PFDIR is set before running.
    I need to run this as root, you might not, but be advised.

fpcopyall - ksh script

lookups is a small ksh script that scans through all prc tables in all filePro files and prints a listing of all lookups to a given file, with line numbers.

If you specify a valid filePro file name on the command line the list will run non-interactively, otherwise it asks you for a name. In interactive mode there is a busy-indicator so you know if it is "hung" or working while it searches. In non-interactive mode the spinner is supressed so that the output may be parsed by other utilities.

Should run out-of-the-box on at least SCO and Linux, but if you don't have ksh installed on Linux, you can change the top line from ksh to bash and it will work. May need to be user filepro or root to use. (You may need to "chmod +x lookups" after downloading, and you may need to edit the filepro path near the top of the script.)

lookups - ksh script
lookups.txt - session log of using lookups

These are some nice icons I drew up for Windows and X. The Windows .ico has all four images in the one file. The 16x16 images are actually transparent, I just used a white backgraound in the gif for the sake of visibility here (in Windows this size is always on a white or grey background since it just shows up in directory listings and the taskbar/quick-launch bar/etc...) . The other images are grey button/tiles like you see here (not transparent). Right click on an image and select "save link as" or "save target as" to download the .xpm or the .ico . Right-click on an image and select "save image as" to download the .gif . (The 16x16 xpm is really slick in ICEWM / FVWM / KDE menus)

filePro 16x16x16 gif/xpm filePro 32x32x16 gif/xpm fP 48x48x32 gif/xpm filePro 48x48x32 gif/xpm fP 16x16x16 giffP 32x32x16 giffP 48x48x16 giffP 48x48x256 gif fPman 16x16x16 giffPman 32x32x16 gif
X .xpm
X .xpm
X .xpm
X .xpm
16x16x16, 32x32x16, 48x48x16, 48x48x256
Windows .ico
16x16x16, 32x32x16
Windows .ico

unpcl is a sed script that strips HP PCL / HP PGL (aka: LaserJet) escape codes from a file or stdin. Copy this into /usr/local/bin and "chmod 755 /usr/local/bin/unpcl"
Run it by giving a file name on the command line or by piping data to it on stdin, output will go to stdout. (in other words, use it like "cat")

unpcl - sed script

ibm2ascii is a sed script that converts ibm (cp437) line drawing characters to plain ascii equivalents. Copy this into /usr/local/bin and "chmod 755 /usr/local/bin/ibm2ascii"
Run it by giving a file name on the command line or by piping data in via stdin, output will go to stdout. (IE: use it like "cat")

ibm2ascii - sed script

cpqual is a ksh script that will create a new qualifier by copying all instances of an existing qualifier in all files in a given filepro directory.
It can also make a qualified copy of the entire unqualified filepro directory, but often this is not desireable since existing programming may be relying on the filePro's behaviour of automatically using the unqualified version of a file if the current PFQUAL doesn't exist in some file. Actions taken are:
* the qualify file is edited
* key & data are copied (optionally, new key & data are zeroed-out)
* indexes are copied and rebuilt

Assumes dxmaint is in the PATH.
Does basic safety checking to protect against accidentally overwriting or erasing a file that already exists.
See the comments at the top of the script itself for more details and a few examples.

cpqual.ksh - ksh script

Shell script that displays or kills headless/orphaned filePro processes.
For the purpose fo this script, "headless" is defined as any filepro process whose parent process id is 1.
This happens a few different ways, but no normal filePro process, including cron and/or cgi jobs, ever has a parent id of 1 except when it's real parent has disappeared.
Copy it into your path and run "headless -h" for help.
Works on Linux, SCO OpenServer, and FreeBSD.

headless - v 1.6 20111113

Reptmail is a ksh script that takes text files generated by any legacy application that can print to file (which means any application that can print at all, thanks to printer interface scripts), and sends the file as email.

Printed output is often formatted into tables and columns and often contains lines and boxes drawn in ibm line-drawing characters or with plain ascii characters. This formatting relies on the fact that printers print with fixed-width fonts for the lines and columns to line up.

However, if you take a simple text file from printing a report to file, and just pipe it into the "mail" command to send the file as email, usually the recipient does not see the report the way it looks on paper.

This is because almost no one has their email client configured to display email using a fixed-width font.

Reptmail handles this by wrapping the text data in just enough html to use the <pre> tag. This has the effect of making the report display properly in most current graphical email clients without abusing the email system or requiring the user to open an attachment. (both faults of the increasingly common practice of sending reports in the form of pdf attachments)

It also uses "unpcl" and "ibm2ascii" (see above) so that most epson/ibmpro/hplaser print data can be used as-is without having to change the application.

Copy this into /usr/local/bin and "chmod 755 /usr/local/bin/reptmail"
Run it without any options to see a help message that explains it's various options.
Runs on (at least) SCO Open Server, Linux and FreeBSD. The observant may note the use of sendmail, and that on Open Server the default MTA is mmdf rather than sendmail. Not to worry, it works on Open Server with at least, sendmail, mmdf, and smail, by virtue of a dummy sendmail that both mmdf and smail provide. My guess is that almost any other mail server (qmail, etc...) probably has such a compatibility mechanism also.

reptmail - ksh script - Updated: 05/30/2003
reptmail1.eml - sample output from reptmail
reptmail2.eml - sample output from reptmail
reptmail3.eml - sample output from reptmail
reptmail4.eml - sample output from reptmail
reptmail5.eml - sample output from reptmail
head.html - example "head.html" for use with reptmail
head_2.html - example "head.html" for use with reptmail
head_3.html - example "head.html" for use with reptmail
tail.html - example "tail.html" for use with reptmail

Magic file for some filePro file formats. Usage:
file -m magic_fp.txt /u/appl/filepro/cust/index.A

magic_fp.txt - "magic" file

url-encode / url-decode text purely in processing.
Unpack the fp_urlenc tar file and copy the filepro/lib directory into your filepro directory and run setperms.
To test:
    dclerk lib -surlenc -xa
Enter data into either box and it will be translated to the other box when leaving field.

prc.input - Input prc table
prc.urlenc - URL-Encode prc call table
prc.urldec - URL-Decode prc call table
fp_urlenc.tar.bz2 - filepro file "lib" with screen and process tables.
See Also: C source & man pages for for stand alone urlenc & urldec system commands.

SCO OSR5 binary to print the PPID (Parent Process ID) as fast & light as possible.
Use to get your own current pid from inside a runnig filepro process table via the USER command.
Unpack and put myppid in your path. Usage example in the .c file comments.
(Thanks to Fairlite Consulting for the c code)
myppid.tar.bz2 - tar.bz2 with the source .c file and compiled OSR5 binary

This site is part of the fileProWebRing:

[ Previous 5 Sites | Previous | Next | Next 5 Sites | Random Site | List Sites ]

Linux SCO filePro Home

filePro is cool !