Hi guys, I’m developing a background agent to export some documents from notes to a mySQL table: in notes documents there are one or more Rich text fields that contains text, images or attachments, and I’ld be able to see these contents in a PHP web page that refers to a mysql table… I’m thinking to use blob fields, but… there is a LS function for converting RTF to blob? Or from RTF to HTML for storing to blob fields?
Thanks!!
Subject: re: rich text <> mysql blob
There is no built-in function to turn rich text into the formats you mention. Note that HTML is not nearly powerful enough to represent the information you have in the rich text – in HTML for instance, an image or file attachment is stored in a separate file and referenced by the HTML. Where would this information be stored for URL reference?
You could export the rich text to an XML representation using the NotesDXLExporter, then use XSLT to transform it into what you need. As far as I know, nobody has already done this work for you, but perhaps someone else will know of a tool for this.
Subject: Thanks
Thank you Andre for your response. I have found also this interesting article:
http://pd4ml.com/i/Dev_Spellman_Leverage%20DXL.pdf
Fabio
Subject: DECS
have a chat with your admin, he may be able to help you using either DECS or LEI, i think it is…