Hi All,I ve a richtext field that contains photo of people. How can I export these fields to SQL ???
Subject: Export Richtext Field content to SQL
We use LEI for this, it is a separate product but I think you can download it with a free trial period which might cover you if its just a one off export.
Subject: RE: Export Richtext Field content to SQL
If the photos are file attachments, I have an article coming out shortly in developerWorks that explains how to program this.
If the photos are imported or pasted images, however, this is a lot harder. While you can export the data to a relational database, it’s in Notes rich text format, which isn’t useful to any programs other than Notes. You would have to process the rich text using the Notes C API if you wanted to extract the images – or export to DXL and then scan the result for pictures which you would then have to convert back into binary.
www.geniisoft.com might have something for you.
Subject: RE: Export Richtext Field content to SQL
FYI: In reference to Andre’s last comment, he is referring to our Midas Rich Text LSX, and specifically the ExportGraphic method (see this post for example). Just to be clear, it is a commercial product.