Merge Data/Key Files
Clay Brown
clay at andycomputer.com
Tue Jul 3 13:01:40 PDT 2007
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
----- Original Message -----
From: "Jeff Harrison" <jeffaharrison at yahoo.com>
To: <clay at andycomputer.com>; <filepro-list at lists.celestial.com>
Sent: Tuesday, July 03, 2007 11:27 AM
Subject: Re:
>
> --- clay at andycomputer.com wrote:
>
>> I'm using a Web Email Client so I hope this comes
>> out as plain text.
>> Think I have those settings Correct.
>> Back a few months ago I was having a problem with a
>> windows printer and
>> after getting that problem solved
>> I had a problem getting 1 certian report to print.
>> Found the problem
>> with that; the compiled report was corrupt and I had
>> to recompile.
>> During this time one workstation's batch file got
>> changed like this
>>
>> set pfdata=f:
>> set pfprog=c:
>> set pfdsk=c:
>>
>> and should have been
>>
>> set pfdata=f:
>> set pfprog=f:
>> set pfdsk=f:
>>
>> so I now from that point have 2 sets of data. there
>> is only one database
>> that I am concerned with merging from the
>> workstation into the server.
>> So not everyting has to be merged 4 or 5 databases
>> are in the program.
>> is there any painless way of doing this?
>>
>> Thanks
>>
>> Clay
>>
>
> Hi Clay. I received this as plain text FYI.
>
> Yes, this shouldn't be too difficult. However, you'll
> need to give a little more information so that we can
> work out the details. I assume from your description
> that when you say "database" that you mean a "filepro
> file". Basically, what I believe that you need to do
> is take the local one, and copy it with fpcopy. Then
> write an archive process from that file to the
> original file.
>
> The processing will look something like this:
>
> Then: Lookup tmp = origfile r=free -e
> Then: copy tmp
>
> Once you set up the output format and this associated
> processing, then you can copy this new filepro file to
> the server and run this process on just the records
> that you want to copy over.
>
> This assumes that you just need certain records, and
> that you have a reasonable way of identifying which
> ones are the ones that you need. Also, it assumes
> that you don't need to worry about duplication - Hence
> my point about needing some clarification.
>
> Good Luck
>
> Jeff Harrison
> jeffaharrison at yahoo.com
>
> Author of JHExport and JHImport. The fastest and
> easiest ways to generate filepro exports and imports.
>
>
>
>
> ____________________________________________________________________________________
> Food fight? Enjoy some healthy debate
> in the Yahoo! Answers Food & Drink Q&A.
> http://answers.yahoo.com/dir/?link=list&sid=396545367
>
More information about the Filepro-list
mailing list