testing for corruption

Jeff Harrison jeffaharrison at yahoo.com
Mon Feb 4 17:27:01 PST 2008


--- Fairlight <fairlite at fairlite.com> wrote:

> Only Bob Stockler would say something like:
> > Jeff Harrison wrote (on Mon, Feb 04, 2008 at
> 11:01:16AM -0800):
> > [snip]
> > 
> > | I wonder if there would be any demand for a
> filepro
> > | corruption detector (written in filepro of
> course). 
[snip]

> Define "corruption" in this context.
> 
> Record 20-byte header at wrong/unexpected offset? 
> Possibly detectable,
> since they'd be outside the printable character
> range.
>
Good point.  I had defined corruption (for myself) as
any non-ascii characters that are stored in real
fields as specified in the map - that is the
corruption that I really care about.  Also, if data
exists in deleted records - I would call that
corruption.

Also good point - I see no reason that this could not
be extended to check and make sure that the system
maintained fields are valid (ascii/valid dates/or
blak) as well - as an option.  I suppose we could also
extend it to optionally let you know if it passes the
field edits. 

This is all most people care about isn't it?  I would
want to keep this very simple at its basic level, then
people could then use flags for options to do the more
detailed validity checking.
 

> Further...when you find such a misalignment, what is
> the procedure for
> continuing reporting?  Reset the record start offset
> to where you -think-
> the record actually starts?  Continue onwards as if
> nothing happened,
> assuming the other offsets should be correct? 

Yes.  Continue on.  Lets not make this too complex
-yet.  There would need to be another utility to
actually fix the problem(s) - or you just need to fix
it the old fashoned way - then run this utility again
to see if you are clean.
[snip]

> And technically speaking, both those scenarios are
> actually the least
> likely form of corruption unless you're physically
> losing a drive's
> integrity.

[snip]

I don't care what the cause the of corruption is - I
keep seeing people ask this list how they can check
for invalid data in fields - this would fit the bill
for that, I think.

[snip] 

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHImport and JHExport. The fastest and
easiest ways to import and export with filepro. 


      ____________________________________________________________________________________
Looking for last minute shopping deals?  
Find them fast with Yahoo! Search.  http://tools.search.yahoo.com/newsearch/category.php?category=shopping


More information about the Filepro-list mailing list