具有平面文件数据存储(ISAM 文件)的旧版 dos 系统
我有一个旧系统,以前在 dos 上运行。它是零售店(时尚)的 ERP 系统。它认为它将数据存储在平面文件中。
我有以 *.KEY 结尾的文件和以 *.D00 结尾的其他文件(向上计数)。 我认为关键文件保存关键信息,D 文件保存一些数据...有很多 D77 文件...
据我的调查,这不是 dfb 或 Foxpro,它可能是专有的...
编写的公司当然,它已经停业了,所以没有机会获得支持或任何提示。 当我在 vim 或其他编辑器中打开这些文件时,我得到一些二进制符号和一些文本...我在十六进制模式下尝试过,但仍然没有任何用处... 我是否有机会以 csv、ascii、xml 格式转储数据?
我很确定这不是标准格式。有人能告诉我这些数据过去是如何存储的吗?我怎样才能使它们可读……
有什么工具、提示或技巧吗?
// 编辑
一段时间后,我取得了一些进展,现在可以发布一些我当时没有的细节,并且使得一个好的答案变得不可能。
我假设 dos 系统是用 Visual cobol 编写的,并且文件可能是以 ISAM 格式存储的 b 树文件。我认为我可以提供的最秘密的东西是,格式有可能是 C-ISAM。
我如何访问/查看或修改这些文件...C#、JAVA、Ruby...一切新时代语言都会很酷...我不确定我是否可以处理 cobol...如果有的话那就太好了转换器或查看器工具最好是开源的...
希望这能澄清更多我的问题=)
I have a legacy system which used to run on dos. It is an ERP system for retail stores (fashion). It think it stores it's data in flat files.
I have files ending with *.KEY and other files ending with *.D00 (counting up).
I think the key files hold the key informationen and the D-Files hold some data ... there are alot D77 files...
As far as my investigation concerns this is not dfb or foxpro it could proprietary...
The company who wrote it is out of business of course so no chance for support or any hints.
When I open these files in vim or other editors I get some binary signs and some text... I tryed it in hex mode but still nothing to use...
Is there any chance I can dump out the data... in csv, ascii, xml?
I am pretty sure that this is not a standard format. Can someone point me in a direction how those data were stored back in the days and how could I make them read-able...
Any tools, tips or tricks?
// EDIT
After some time I made some progress and can now post some details which I did not now of back then and made a good answer impossible.
I asume that the dos system was written in visual cobol and that the files could be b-tree files stored in ISAM format. I assume the closet thing I could provide is, that there is a possibility that the format is C-ISAM.
How can I access / view or modify these files... C#, JAVA, ruby.... everything new age language would be cool... I am not sure if I can handle cobol... It would be great to have a converter or a viewer tool preferable opensource...
Hope this clearifies more my question =)
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
OpenCOBOL 拥有非常活跃的用户组。该语言本身是免费的,可以在 Linux 和 Windows 甚至 MacOSX 上运行。与那里的用户组聊天;他们也许能提供帮助。
OpenCOBOL has a very active user group. The language itself is free and runs on Linux and Windows and perhaps MacOSX. Have a chat to the user group there; they may be able to help.
C-ISAM 是肯定的。用于 COBOL 和其他一些语言(主要在 DOS 中)。
它已经不再开发了,可能是由于当今更流行的其他开发数据库(Mysql 等)的入侵。
https://sourceforge.net/projects/vbisam/< 有一个开源(不再开发) /a> 提供一些反向兼容性。
如果您可以访问 ISAM 4.0 (DOS) 中的文件,您可能会获取数据并将其导出为另一种格式(我认为是 CSV)
C-ISAM is for sure. Used in both COBOL and some other language's mainly in DOS.
It's already not developed anymore, probably due to the incursion of other developed database (Mysql and alike) that are more prevalent these days.
There is an open-source (not developed anymore) in https://sourceforge.net/projects/vbisam/ that provides some reverse compatibility.
If you could get access to the files in ISAM 4.0 (DOS), probably you would get the data and export it into another format (CSV i presume)
Peachtree 会计软件早在 1992 年就使用了这些文件扩展名。
Peachtree Accounting Software used those file extensions back in 1992.