FREECHN.EXE script

[Don Coleman]

Mark, John, Bill, Mike, & Chris:

This has become somewhat of an expected procedure several times per week, if
not daily.  

My application runs an ascii file import process every 10 minutes importing
data from one alien application.  My app. also has a socket interface
connected to a second alien application importing data from that
application.  This client is in the process of transitioning from one
clinical prescription system to another, hence the two systems with two
different methods of bringing data into my fP app.  This transition has been
underway for 11 months and will take another 6-12 months to complete (I'm
told).

Approximately 40,000 records are brought into my fP application (a workflow
application which tracks each Rx from the time into the building until it
leaves the building) from the two interfaces combined.  Each completely
processed and shipped Rx is then archived to a mirror file each night
beginning at 12:15AM.  This occurs after the network share (drive) is
disabled and all users are off the system.  In my archive script I rebuild
the freechain in my main Rx file before the archive procedure starts and
again as the last step before the script exits.  Problems occur (freechain
errors either during the archive process itself or shortly thereafter when
they begin processing prescriptions again) if I don't do this both at both
the beginning and end of the script.  During the day with 40-60 users on the
system certain Rx's will be "voided" which copies the Rx record to the
mirror file and deletes it out of the active Rx file.  Depending on the day
this may be enough to cause a freechain rebuild by itself.  The customer
also periodically needs to print multiple delivery sheets (packing slips)
and manually archive those orders after printing them during the day.  If
they don't disable both interfaces, archiving those records will surely
cause a freechain rebuild.  I always assumed it was because I had two
interfaces assigning data to free records in the file (which were most
likely "used" records the previous day but have been archived and are now
free records) and at the same time was archiving data which was creating
"new" free records.

Anyone who can provide some guidance on this would be appreciated by bth
myself and the client.  Before this installation I had probably not needed
to run freechain on a system 5 times in my life.  At this site it may well
happen 5 times in a week.  

Don Coleman
Donald G. Coleman, Consultant
402 Andrew Circle
Indiana, PA 15701
dcoleman at dgcreact.com
(724) 349-6302

> -----Original Message-----
> From: filepro-list-bounces+dcoleman=dgcreact.com at lists.celestial.com
> [mailto:filepro-list-bounces+dcoleman=dgcreact.com at lists.celestial.com] On
> Behalf Of Fairlight
> Sent: Wednesday, June 27, 2007 9:43 AM
> To: filepro-list at lists.celestial.com
> Subject: {Spam?} Re: FREECHN.EXE script
> 
> On Wed, Jun 27, 2007 at 09:13:55AM -0400, Don Coleman, the prominent
> pundit,
> witicized:
> > List:
> >
> > fP5.0.13, Windows 2000 Advanced Server, Windows 2000 & XP Prof. clients.
> >
> > Is there a way I can invoke the FREECHN.EXE command without directly
> > specifying the filename to have the freechain rebuilt but have fP
> display
> > the filePro files and allow the user to select the desired one?  I could
> use
> > this in either a fP menu script or .bat script.
> 
> I'd be less concerned with being able to do it than with whatever is
> causing you to -have- to do it?  Isn't the freechain supposed to be
> self-maintaining barring errors?
> 
> mark->
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list