Rebuild Indexes

[Richard Kreiss]

You can rebuild all of the automatic indexes using the following command

\fp\dxmaint !! -e -ra placed on a menu command line.

The 2 !! insure that the option presents the options in the filePro folder(directory). -ra tells dxmaint to rebuild all of the auto indexes and the -e returns dxmaint to the menu when finished.

You can also use this in a batch file with the proper environmental variables set.

If you want to rebuild demand indexes, this, at present, is done one at a time,

Keep in mind that indexes ca be rebuilt using their parameters from a batch file.  This is one way to insure that you have the correct parameters for rebuilding an index.

Also look for 2 supplied files fpidx and fpidxdat.  These two programs will create a batch file with all of the proper commands for building(rebuilding) indexes.  This file is a handy thing to have and you should run this program (fpidx).  Note the name and location  of the file being created.


Richard Kreiss
GCC Consulting





-----Original Message-----
From: Filepro-list <filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com> On Behalf Of Ross Salas via Filepro-list
Sent: Tuesday, January 7, 2020 5:31 PM
To: filepro <Filepro-list at lists.celestial.com>
Subject: Rebuild Indexes

 Hi!  What is an easy way to rebuild all indexes?  (running this from a menu is okay for now)

We are running filePro 5.8 on Linux (CentOS 6.10).

Eventually, I would like to automate this process from the command line if possible.

Thanks,
Ross

I found the following:
http://mailman.celestial.com/pipermail/filepro-list/2016-January/032416.html

echo "Started `date`" >/home/mjs/retime
cd /u/appl/filepro
for file in *
     do echo $file
        if [[ -d $file ]]; then
                echo "Starting Freechain:" $file `date` >>/home/mjs/retime
                /u/appl/fp/lib/freechain $file
                echo $file `date` >>/home/mjs/retime
                /u/appl/fp/dxmaint $file -ra -e
        fi
done
echo "Ended `date`" >>/home/mjs/retime
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20200107/2c5e4462/attachment.html>
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 11268 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20200107/49059d99/attachment.bin>