Merge Data/Key Files (Clay Brown)

Clay Brown clay at andycomputer.com
Fri Jul 6 13:21:22 PDT 2007


After talking to the client yesterday there is a papertrail of the changes 
that were made to the server data and it could be easily reinput to the 
server. The local client data was not so easy. So I made a backup of the 
servers f:\filepro\dajuror directory and copyed the local copy to the 
server. So all the important data was now on the server and the client 
decided that they could live with retyping a few lines of data or 10-20 
people. So all turned out well and Major headache was Adverted.

Thanks For all the advice.

Clay

----- Original Message ----- 
From: Pete Murray
To: filepro-list-request at lists.celestial.com
Cc: clay at andycomputer.com
Sent: Friday, July 06, 2007 3:55 PM
Subject: Re: Merge Data/Key Files (Clay Brown)


Suggestion:

Do a search on the server dajuror file usind @cd and @ud to see how many 
records were created or updated.  If small, you could manually update the 
local file then copy it.

Also, you may want to copy the local file to a new file like tmpjuror using 
fpcopy, copy it over to the server so you can work with it (also make a copy 
of the server file using fpcopy).  Then, using a lookup between the two 
files in a sort/select processing table, you can identify records that are 
in one but not in the other.  Also, using @ud you could identify records 
that were updated in one but not updated in the other and records that were 
updated in both.  Depending on the results, you could use the lookup and the 
copy command to create or update the necessary records.  I would use fpcopy 
generously to have multiple copies of the files at different stages of 
change.  good luck. 



More information about the Filepro-list mailing list