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