Lotus 123 database
The file format is actually quite similar to the Excel file format so you may be able to get some ideas from Spreadsheet::ParseExcel. Other functions that you might find useful in this task are pack, seek, tell and binmode. Since the binary records have defined lengths it should be easy to iterate through the file record by record looking for salient information. You can extract and convert the binary information that you need using unpack. You will find Lotus documentation on the 123 file format here Length, but that have clearly defined boundries.
#LOTUS 123 DATABASE HOW TO#
How to read a binary file and extract arbitrary strings of somewhat arbitrary I am trying to reverse engineer their formatting I am needing some pointers on how to seek through a file, find that
#LOTUS 123 DATABASE CODE#
Invariably, the binary data is preceded by the code 0x00 0x25 0x00, Represent the data addressing and formatting.
The first 12 bytes are the same as for text in that they But, the following sequence which represents The problem is that I can not read the data entered in binary format. I can pretty easily determine the values for text data in that format. The data seems to fall under the general file format of:įormat line_num 0x00 label_num cell_num value end_marker The nextįield after the string shown is the number of the label followed by Not sure what the 4 bytes in the middle there represent. The sheet label definitions are fairly easy to pick out. I am looking at the file format in a binary editor and see that To maintain the parsing info and they quite often modify the number It works, but unfortunately it is difficult I had a script that parses the csv formatted output and throw To run a script in each sheet and export the format in csv format. The thing is, it is an extremely hairy process. They won't move their data over to a searchableĭatabase, so we have tried several ways of pulling the data ourselves. Our list of server names, ip addresses, and other data for our I have a project where I need to yank out a ton of data fromĪbout 100 Lotus 123 docs and then throw them into a MySQL database.īut, this is not a one time deal.
I am a complete novice at parsing formatted binaries.