Figuring out an old "dos style" database table

MarrowZero

Member
Licensed User
agraham said:
It's unlikely to be anything to do with Delphi - DOS era would be Borland Pascal, Assembler, QuickBasic etc. Delphi is Windows era. I guess your ID program has made a bad guess.
Click to expand...
Arh, maybe its my mistake to title this as "and old dos style" as I was thinking more about the data files than the application. You can see from the screenshots the app is Windows based, so sorry if I was misleading in this regard. This is all a bit before my time, hence the call for help

I have taken the orignal appication and run it throuogh (https://github.com/crypto2011/IDR) and it does seem to recongise it as 'Delphi 5'



 

Daestrum

Expert
Licensed User
Longtime User
This might help you get started decoding it
B4X: 
Sub Process_Globals
    Dim r As RandomAccessFile
    Dim buff(1024) As Byte
End Sub

Sub AppStart (Args() As String)
    r.Initialize2("d:/olddbfiles","S_RESO.dat",True,True) ' Values are little endian
    r.ReadBytes(buff,0,1000,0)
    Dim recLen As Int = r.ReadShort(0xc)
    Log("Record length = " & recLen & " bytes")
    For pos = 1 To 20 ' first 20 records
    r.ReadBytes(buff,0,recLen,4+(recLen*pos))
        Dim descLen As Byte = buff(30) ' length of description
        Log(BytesToString(buff,0x1f,descLen,"US-ASCII"))
    Next
    r.Close
End Sub
 

rabbitBUSH

Well-Known Member
Licensed User
Longtime User
BrainLoss said:
certainly puts my thoughts in a new direction, thankyou so much.
Click to expand...
I just seen this thread now. A friend [ Still] Uses Delphi 5 a lot, he says:


Says he has a reader script to convert if you're still interested - and assuming your files are as github says - Delphi5.
 

MarrowZero

Member
Licensed User
rabbitBUSH said:
Says he has a reader script to convert if you're still interested - and assuming your files are as github says - Delphi5.
Click to expand...

In post#1 I uploaded some sample files - I wonder if your friend would be interested to download these and see if they can indeed be read?

Thanks for taking an interest in this thread.
 

rabbitBUSH

Well-Known Member
Licensed User
Longtime User
BrainLoss said:
In post#1 I uploaded some sample files - I wonder if your friend would be interested to download these and see if they can indeed be read?

Thanks for taking an interest in this thread.
Click to expand...
I have the script and the source URL. I will check later on and let you know through PM.

You can find Delphi 7 on the net and download as well - which resolves some D5 issues - if you need it.
 

pliroforikos

Active Member
Licensed User
Before 26 years i was working for a company where they were writting code to cobol. My responsibility was to transfer some of those programs to MSAccess 2.0 . Many files like them was in the program directories.
Dat: data files
Ndx: index files

2. there was an other database named paradox from corel or borland but i dont remember much about it.
3. Clipper had files like them, and dbf files too.
 

Magma

Expert
Licensed User
Longtime User
..COBOL, qbasic, basic, gwbasic, pascal...

the file record will be a Type (mixed with strings, integer, double, currency, long, char)... specifi fields... with specific length per record... idx just used for faster search... so need personal work to achieve extract the fields/records... and ofcourse the "person" will do the job must know the result of a record... and better at least 2-3 records at rows..
 

MrKim

Well-Known Member
Licensed User
Longtime User
MarrowZero said:
Indeed I have looked for export functions, sadly there is nothing useful. Even printing and OCR might not be good as those printed reports are for the summary of infomation, not the table data.
Click to expand...
If you have MS Access available I would try using their import functions - you might even want to go with an old version if you can get it. Access is pretty damn good at sorting out various file types. Although I don't have as much experience with it Excel is good at it as well. If you can get the data into an access table or excel spreadsheet then you can export it in a manageable form.
 
A

Alex_197

Well-Known Member
Licensed User
Longtime User
If I not late to the party I'd like to add my 2 cents - try MS Visual Foxpro
 

tchart

Well-Known Member
Licensed User
Longtime User
Not sure if you read this thread;

[RESOLVED] How to Read DAT Files-VBForums

Hi Guys, We are in the process of upgrading a clients software. I'm not sure what database their existing app uses but in the db folder there are DAT and IDX files. I need to find a way of reading those files so I can import the data across to the new database. Can someone please advise me...
www.vbforums.com

They ended up using an app called DBISAM

Might be worth spending €20 to see if it works.
 
You must log in or register to reply here.
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…