Merge Data/Key Files

[Jeff Harrison]

--- Clay Brown <clay at andycomputer.com> wrote:

> What I have is when troubleshooting the report
> printing problem I copied the 
> entire FILEPRO directory to the local machine and
> set the batch to read data 
> from the local machine. ie
> set pfdata=c:
> set pfprog=c:
> set pfdsk=c:
> after the problem was corrected I forgot to change
> the pfprog and pfdsk and 
> pfdata back to the network share (F:\).
> data was entered from network clients and from the
> local client but the 
> local client was not writing its data to the
> DATA/KEY files on the server. 
> Now that I have uncovered my mistake I need to merge
> the data that has been 
> edited on the loacl machine in with the file on the
> server. They are 
> parctally the same file except for the data input
> over 2-3 weeks. This is 
> Software for Case Management. There are several Menu
> Options. Worthless 
> Checks; Witness Files; Jury menu; Etc.   Each of
> them have diffrent tables 
> and data. There was only one option or Data/Key set
> that was edited by this 
> user so I just need to merge the
> c:\filepro\dajuror\DATA with the 
> f:\filepro\dajuror\DATA and the
> c:\filepro\dajuror\KEY with the 
> f:\filepro\dajuror\KEY
> Does this make any more since of the problem?
> 
> Thanks for your time
> Clay
> 
> 

Yes, this helps - somewhat.  So are you saying that
the user at the problem local workstation potentially
edited existing records as well as added new ones?

If that is the case what do you want to do about the
pre-existing records (if any) that were edited both on
the main server and the local workstation?  Do you
want to just keep the one with the later date of last
update?

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The fastest and
easiest ways to generate filepro exports and imports.
 


       
____________________________________________________________________________________
Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.
http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow