536
社区成员
发帖
与我相关
我的任务
分享用lei 实现notes与oracle的附件同步）
请教各位高手，我现在用IBM的lei3.1能实现Notes与oracle的数据同步，但是附件（RTF域与Blob中的数据同步）不行，从notes-〉oracle还是oracle-〉notes，倒过去的都是乱码，看了lei3.1帮助，附件的同步只限于notes与notes间，与关系数据库不能实现同步，看了一下lei6.5的帮助在特性概览中的描述：“最大限度地控制Domino选项，例如NotesTM分级文档控制、表单公式计算、自动视图刷新以及附件传输等等。 ”但是 不知lei6.5能否实现附件的同步，各位有没有实现过，难道只能用最笨的方法先将notes中的附件拆离然后写
脚本导入oracle中，notes中的文件附件有10来万个，请各位指点一下，有没有更好的方法，不胜感激！！！
脚本导入oracle中，notes中的文件附件有10来万个，请各位指点一下，有没有更好的方法，不胜感激！！！
...全文
请发表友善的回复…
发表回复
maplescloud 2004-11-26
- 打赏
- 举报
不知道最新的LEI支持不支持对RTF域到BLOB的传输,最好到官网上看看,不过依目前情况来看,实用的还是自己写代码来解决了.
yaorong 2004-11-26
- 打赏
- 举报
Transferring Attachments
Lotus Notes stores attachment data separately from rich text field data. Currently you can only transfer attachments from Notes to Notes; rich text fields with attachments do not store correctly in the target RDBMS such as DB2 and Oracle.
To work around this constraint, you can use the Extract File Attachments option in the Notes Connector to save attachments to files on disk. You can then use LotusScript to read the files, store their contents in LCFields, and save the LCFields to binary fields in a RDBMS. This level of scripting requires LotusScript expertise.
Lotus Notes stores attachment data separately from rich text field data. Currently you can only transfer attachments from Notes to Notes; rich text fields with attachments do not store correctly in the target RDBMS such as DB2 and Oracle.
To work around this constraint, you can use the Extract File Attachments option in the Notes Connector to save attachments to files on disk. You can then use LotusScript to read the files, store their contents in LCFields, and save the LCFields to binary fields in a RDBMS. This level of scripting requires LotusScript expertise.
