Help with DAT file repair.

[Bill Rollins]

All,
Additional Note: All i'm trying to do, is to extract the data to any
format that i can then import
back into a clean file.

Thanks

Bill Rollins

[Bob Campbell]

Bill,

I tried to view the file using the database browser in C5. It thought the
driver was Btrieve.

Could you send the file layout definition?

P.S. The file looks it good shape using a hex editor.

Bob.

Bill Rollins <brol...@tcsoft.com> wrote in message
news:37eb...@news.x-gen.com...
> All,
> The attached file was damaged. It cannot be opened in CSCN (unable to
> scan file) it appears
> to still contain all of the data. Does anyone know how I can get at it?
> Attached is the file zipped.
> The customer just changed locations and had not done a backup for
about
> 3 weeks.
>
> Bill Rollins
>
>
>
>

[Bill Rollins]

Bob,
Thanks for looking. this is the file layout.

Thanks for any help

Bill Rollins

LABOR FILE,DRIVER('Clarion'),RECLAIM,OEM,PRE(LAB),CREATE,THREAD
CODE_KEY KEY(LAB:CODE),DUP,NOCASE,OPT !Job/Service Code
TECH_KEY KEY(LAB:TECH),DUP,NOCASE,OPT !By Tech
WO_KEY KEY(LAB:WO_NO),DUP,NOCASE,OPT !Work Order Number
DATE_KEY KEY(LAB:DATE),DUP,NOCASE,OPT !Date
LineNo_Key KEY(LAB:WO_NO,LAB:LineNo),DUP,NOCASE,OPT !Work Order and Line
Number
Record RECORD
CODE STRING(10)
TECH STRING(10)
DESC STRING(25)
QTY DECIMAL(5,2)
RATE DECIMAL(7,2)
TOTAL DECIMAL(9,2)
WO_NO LONG
DATE LONG
CUST_NO STRING(10)
Cost DECIMAL(7,2)
TotalCost DECIMAL(9,2)
LineNo LONG
Type STRING(10)
PriceOverRide BYTE
SubRefNo STRING(10)
END
END

[Mike McLoughlin]

Bill,

It might just be the header record that's corrupted - DAT files that are not
encrypted are quite easy to recover. Download the Clarion DAT file utility
READHDR.ZIP form the software library section of my website. It will give
you all the info you need.

regards,

Mike
--
*** Clarion Developers Photo Gallery - are you in it?
*** BackFlash *** CopyFlash *** IMPEX data exchange templates ***
*** LogFlash activity logging templates *** SearchFlash
For more information on these visit http://www.sterlingdata.com

[Bill Rollins]

Mike,
Thanks. That gives alot of information. How should I go about repairing
the header? I do have
a copy of the same file from another store.

Bill Rollins

[Mike McLoughlin]

Bill,

>>How should I go about repairing
the header? I do have
a copy of the same file from another store.

Make a note of the length of the header. Then use the DOS file driver with a
record set to the length of the record (as shown by READHDR.EXE) to read in
the records and write them out to a new DAT file. You could use a process
for this.

[Bill Rollins]

Mike,
Thanks. That Worked. File Recovered <VBG>.

Bill