Trying to setup a development copy of the filePro databases

[Mike Schwartz]

     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/6d1212ee/attachment.html>