SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Addict
    Join Date
    Mar 2005
    Posts
    231
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Converting Legacy Binary Data

    We have a potential project where the client used an old dos binary database. We have no idea how to extract the data as the creator has passed on. We do know that the data is stored in binary flat files.

    Unfortunatley when I view them in notepad, I cannot read them. How might we be able to extract the data?

  2. #2
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    "binary" just means "not plain text"... if you have no idea how the raw bits translate to usable data, you can't get it out

  3. #3
    SitePoint Addict
    Join Date
    Mar 2005
    Posts
    231
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    BTW, i have traid a dbase viewer to know avail. How might the data be read?

  4. #4
    SitePoint Addict
    Join Date
    Mar 2005
    Posts
    231
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Dan Grossman View Post
    "binary" just means "not plain text"... if you have no idea how the raw bits translate to usable data, you can't get it out
    Gotcha. I was hoping to get the data exported into readable tables at least. How might you find out how the raw bits translate to usable data?

    Are there tools for this process?

  5. #5
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    The linux strings utility will try searching through the file for any offsets where reading the data gives it ascii text. You can start there. The best bet is to figure out what program the file was used with, then finding something to open or convert it should be much easier.

  6. #6
    SitePoint Addict
    Join Date
    Mar 2005
    Posts
    231
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for your input, Dan.

    The file was used in two legacy apps written in C and Visual basic. We have no access to the source code. I can make sense of SOME OF the lines but most are interspersed with weird characters.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •