{Spam?} RE: Second request-need to compress / remove empty records from an fPkey file

[Don Coleman]

> -----Original Message-----
> From: Robert Haussmann [mailto:haussma at nextdimension.net]
> Sent: Tuesday, January 09, 2007 11:00 AM
> To: 'Don Coleman'
> Subject: {Spam?} RE: Second request-need to compress / remove empty
> records from an fPkey file
> 
> Don--quick thought off the top of my head.  Do you have access
> to a 5.6 version? (or can you get a demo from fp?)  If so,
> you could write a quick process to read all records from
> the file and create a new file with the same structure without
> the blank records.  You would only lose system maintained fields
> such as @CD.
> 
> Bob Haussmann
> 
> > -----Original Message-----
> > From:
> > filepro-list-bounces+haussma=nextdimension.net at lists.celestial
> > .com
> > [mailto:filepro-list-bounces+haussma=nextdimension.net at lists.c
> > elestial.com] On Behalf Of Don Coleman
> > Sent: Tuesday, January 09, 2007 10:56 AM
> > To: 'filePro Mailing List'
> > Subject: Second request-need to compress / remove empty
> > records from an fPkey file
> >
> > Need to try to do the following today if anyone has any suggestions.
> >
> > Windows native Fp5.0.13, Windows 2000 Advanced Server,
> > WIN2000 & WINXP Pro
> > clients.
> >
> > I have a key file which last night exceeded the 2GB limit and I can no
> > longer access the data.  IUA reports zero records, the fP
> > Directory reports
> > -1736042 records.  I believe approximately 50% of these
> > records are empty
> > and need a way to slightly reduce the size so fP can again
> > access the file.
> > At that point I can archive the used records, delete the
> > unused records and
> > start with a new key file again.
> >
> > Does anyone have a method outside of fP to do this?  I seem
> > to remember Bob
> > Stockler or JPR having an OS utility to "deflate" a file.  Is
> > this a UNIX
> > only solution or is it available for Windows as well?
> >
> > Or is there a way to accomplish this from within fP.  I'm
> > assuming not since
> > presently I cannot access the data.  I'm hoping to not have to remove
> > several records with a hex editor or other such utility because it is
> > important to recover this data and I have not previously had
> > to do this.
> >
> > Don Coleman
> > Donald G. Coleman, Consultant
> > 402 Andrew Circle
> > Indiana, PA 15701
> > dcoleman at dgcreact.com
> > (724) 349-6302
> >
> >
> >
> >
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> 

Bob H., Bob S., Jeff H., Nancy P plus anyone else I am forgetting...
Thank you for the advice on bringing a 2GB+ fP file back from the far side.
It seemed to me that Bob Haussmann's suggestion of using fp5.6 to read the
oversized key and archive what I needed and then delete the remainder to
regain the empty records was simplest fix and worked like a charm.  Plus I
finally had a reason to force me to install 5.6.  Thanks again.

Don Coleman