Trying to setup a development copy of the filePro databases

[Mike Schwartz - PC Support & Services]

     One of my customers asked me to setup a development copy of their
filePro databases, including a development copy of their menus.  

 


      Their Linux system is:  2.6.32-573.18.1.el6.x86_64 #1 SMP Wed Jan 6
11:20:49 EST 2016 x86_64 x86_64 x86_64 GNU/Linux

 

     Their original filePro databases are in /u/appl/filepro, with /appl
linked to /u/appl.  This has worked just fine for years.  

     

     So I created a /u/appl2/filepro subdir and copied their existing
databases into /appl2

 

[devgroup at filepro /]$ ls -l | more

total 179

lrwxrwxrwx.   1 root root     7 Nov 11  2016 appl -> /u/appl

lrwxrwxrwx.   1 root root     8 Apr 27 19:20 appl2 -> /u/appl2

 

     Then I wrote a script that -should- allow a user named "devmaster" to
select either the live filePro menus and databases -or- the
development/testing menus and databases:

 

[devgroup at filepro ~]$ more .bash_profile

 

# .bash_profile

 

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

        . ~/.bashrc

fi

 

# User specific environment and startup programs

 

PATH=$PATH:$HOME/bin

 

export PATH

 

clear

clear

echo "Select Desired Profile."

echo

echo "1) filePro 2023 ."

echo "2) filePro Apr 2026 ."

echo "3) EXIT ."

echo

echo

read answer

case $answer in

      1)

         #mjs."

         PFPROG=/appl

         #  PFDATA=/

         PFDIR=/appl

         TERM=scoansi

         #  TERM=xterm

         PFMENU=/appl/fp/menus

         PFTMP=/appl/tmp; LOGFILE=/tmp/fm; PFLOGAPPEND=ON

         export PFPROG PFDATA PFDIR PFMENU PFTMP LOGFILE PFLOGAPPEND TERM

         p

         #mjs."

         ###======================================

         ;;

      2)

         #PPM"

         PFCHECKLOCKLOG=/u/tmp/pfchecklock2.log

         PFPROG=/appl

         #  PFDATA=/

         PFDIR=/appl2

         TERM=scoansi

         PFMENU=/appl/fp/menus2

         PFTMP=/appl/tmp; LOGFILE=/tmp/fm; PFLOGAPPEND=ON

         export PFPROG PFDATA PFDIR PFMENU PFTMP LOGFILE PFLOGAPPEND TERM
PFCHECKLOCKLOG

         #p MENU1

         p

         #PPM"

         ###======================================

         ;;

      3)

         #Logging out"

         EXIT

         ##Logging Out."

         ;;

      *)

         #Logging out"

         echo "Sorry, you must enter 1 2 or 3.  Press ENTER to exit..."

         read akey

         EXIT

         ##Logging Out."

         ;;

esac

 

      (Thanks to "Old Tony" for the sample script he provided to the filePro
list a few years ago.)

 

      The problem is that whenever I select either option #1 or option #2,
then try to go into "inquire, update, add" on one of the databases, like our
"CustList" database, I get this error message:

 

*** A filepro Error Has Occurred

 

on File: /appl/filepro/ListCustomer/data

File Also On /u Drive

Duplicate files found while scanning drives.

***

Press    H -Hardcopy    Enter -Continue

 

     I presume this error has something to do with the linked /appl and
/u/appl subdirs and/or with the linked /appl2 or /u/appl2 subdirectories,
but I haven't been able to figure out what the problem is.  

 

     Both instances of databases do share the same set of executables, which
are in /appl/fp, except that there is a /appl/fp/menus 2 folder which holds
the development/testing menus.

 

     Any ideas?

 

Thanks!

 

Mike Schwartz 

  

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20260429/e5539fe8/attachment.html>