Current Version: v01.01.00
The Fairlight fpgsr utility is a global search-
No more pain! This utility will do a global search and replace on the original string, replacing it with the substitution string. What’s more, it will make backups of every table it alters, log every change it makes to a single logfile, skip altering binary (encoded/encrypted) processing tables on its own, and make sure the file ownerships are preserved.
PLEASE NOTE: If your processing tables are not saved with ABE=ASCII in your environment (read: if your processing tables are saved in the encrypted format), this program will not work for you. It is impossible to decrypt the table format externally from outside filePro. This utility skips tables which are saved in binary, and reports which tables were skipped for that reason. It will only perform substitutions on tables which are saved in ASCII format.
Fairlight fpgsr requires Perl 5.6 or higher be installed on your system for *nix
variants. For Windows, the program is a self-
Currently supported platforms are:
Unix/Linux: Unpack the compressed tar archive into any directory you choose. A program named fpgsr will be created. Copy uniclient to somewhere sensible in your path, if you did not extract it to the desired location. You may need to alter the first line of the program to reflect the location of your perl binary. Make sure the program is set to mode 0755.
Windows: Use the installer executable.
After invoking the program, you will see output that denotes what progress is being
made, unless you use the -
Behind the scenes, as each processing table is handled, a backup copy is made within
a directory heirarchy in a backup directory within the working directory. The default
directory is /appl/fpgsr_backups, but if /appl does not exist you will need to use
The program makes no assumption about the directory to process. Rather than rely
on environment variables (which might be set incorrectly, or which may be set to
something you’ve forgotten about) and risk mistaken operations, you need to specify
a base directory for your filePro processing tables, using the -
You may instruct the program to exclude specific filePro files (directories). See
the documentation for the -
By default, patterns fed to -
When the program has finished, you will find a file named LOGFILE.txt within the backup directory for that particular run of the program. This file notes the patterns provided, every change that was made to every table, which tables were skipped because they were binary encoded, and a concise list of modified tables, as well as some other miscellaneous useful summary information.
NOTE: While the utility does make its own backup files for processing tables it modifies, you may feel more comfortable making an extra backup of your entire filePro database directory before using the program. This is technically not necessary, but it is a prudent course of action before running something that may change hundreds of files. Fairlight Consulting will not be liable for loss of data, or undesirable results. You assume full responsibility for ensuring you have adequate backups of your files.
This option dictates what directory will be used to store the backup directories containing original processing tables within a replica of the directory heirarchy. The default is /appl/fpgsr_backups.
This option dictates the pattern to search for and replace.
This option dictates the pattern to substitute in place of the original pattern.
This option dictates which directory contains the filePro file directories ($FPDIR equivalent). This path must end in “/filepro”.
This option denotes a directory name to skip during processing. No processing tables within a directory of this name will be modified. You may specify more than one exclusion by repeating the option/argument pair, changing the argument for each iteration on the command line.
This option enables the use of Perl Compatible Regular Expressions (PCREs) for pattern
matching. Note that only the pattern segment is specified with the -
This option tells the program to skip the pattern check and confirmation phase when
This option specifies that the program should analyse all files and log what would happen when run normally, but that it should not perform any directory or file modifications. Only the backup directory and logfile are created when this option is in use.
This option specifies quiet mode. If just -
This option designates which user to check against to see if chown operations should be performed. The user filepro is assumed. This option is only meant to be use in a test/development environment, as the program is intended to be run either as filepro or root.
This option returns the program version information.
This option returns the program changelog information.
This option returns the program help (a briefer summary of the options) in a self-
Copyright, License, Warranty, and Payment
This software remains the property of Fairlight Consulting, and license to use the program is sold to users. Fairlight fpgsr is licensed at a cost of $99.00 USD per server on which it is installed. Each license fee entitles you to use Fairlight fpgsr on one server, in any role you require.
Upon receipt of payment for a license, program will be delivered to the licensee via email at the email address associated with the PayPal payment.
Upgrades for the product are currently free when moving to new minor and major versions. Fairlight Consulting reserves the right to change this policy in the future, with no prior warning.
There is no warranty for this software. This software is offered "AS-
Good computing practice dictates that any program should be thoroughly tested with