从 Lotus Notes 导出数据:C# 互操作、C、Java 还是 LotusScript?
我即将从 Lotus Notes 数据库导出大量数据,我想知道是否有人可以阐明我在这一点上究竟如何前进。
Notes 有一些某种类型的视图(带有自定义模板的列表?) - 这些视图是保存在 Domino 服务器上的 .nsf 文件中,还是仅用于电子邮件的 .nsf 文件?
如果 .nsf 文件实际上是数据库文件,那么用于从中提取数据的最佳语言/开发包是什么?
I'm about to export a lot of data from a Lotus Notes db, and I'm wondering if anyone can shed any light on how exactly I can move forward on this point.
Notes has some views (lists with custom templates?) of some kind - are these saved in .nsf files on the Domino server, or are the .nsf files for email only?
If the .nsf files are actually the database files, what would be the best language / development pack to use to pull data from them?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
发布评论
评论(4)
~没有更多了~
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
如果您需要在现有 Notes 基础架构和 RDBMS 之间进行全时同步,LEI (Lotus Enterprise Integrator) 或像 Notrix 这样的第三方工具将是您最好的选择——就像定义一个作业和一个计划/触发器一样简单运行它。如果您需要偶尔拉取(或推送)数据的子集,那么 NotesSQL 可能是最简单的方法。如果您不害怕学习 NSF(Notes Storage Facility)的结构,那么 LotusScript/COM API 或 Java/CORBA API 将为您提供更细粒度的控制。
如果您真正需要的是一次性转储所有内容,那么将所有数据注释导出到 DXL (Domino XML) 将为您提供将要获得的数据的最完整版本,并且以一种让您能够以其他方式难以实现的方式恢复和转换格式化的 Notes Rich Text、文件附件等。 DXL 很冗长,所以不要说我没有警告你,但它也相当全面。 (NotesDXLExporter 类的 DOmino Designer 帮助条目中有完全正确的示例代码。)
If you need full-time synchronization between an existing Notes infrastructure and a RDBMS, LEI (Lotus Enterprise Integrator) or a third-party tool like Notrix would be your best bet -- it's as simple as defining a job and a schedule/trigger to run it. If you need to occasionally pull (or push) a subset of the data, then NotesSQL is probably the easiest approach. If you're not afraid of learning the structure of the NSF (Notes Storage Facility), then the LotusScript/COM API or the Java/CORBA API would give you finer-grained control.
If what you really need is a one-time dump of everything, then exporting all of the data notes to DXL (Domino XML) would give you the most complete version of the data you're going to get, and in a way that would let you recover and convert formatted Notes Rich Text, file attachments, and so on in a way that would be incredibly difficult to achieve otherwise. DXL is verbose, so don't say I didn't warn you, but it is pretty comprehensive as well. (The DOmino Designer Help entry on the NotesDXLExporter class has example code that is exactly on point.)