June 20, 200223 yr When I export a database as an html table, FM converts the html characters like > < " etc to > < " etc. Is there a way to suppress this conversion? Preferably by field, but if not, globally. Or does anyone know a way to keep html within fields as working html through a html export?
June 21, 200223 yr "When I export a database as an html table..." Export to where? Is this involved with ODBC or IWP?
June 21, 200223 yr Author No, it's not directly to do with IWP or ODBC. If you have a database open in front of you and go to FILE>EXPORT RECORDS, one of the format options is EXPORT AS HTML TABLE. FM, with this, exports all found records as rows with each field as a cell of an html table. Unfortunately for me, it converts text within fields so that it displays the same in a browser. Conversions like: < becomes < > becomes > " becomes " (This forum makes exactly the same kind of conversion on your post when you post.) This is bad for me because what I have in the field is html. In the field I might have <img src="mypicture.jpg"> but instead of displaying the picture, the table just displays <img src="mypicture.jpg"> when viewed in a browser. So I want to suppress that conversion.
June 21, 200223 yr This from FileMaker Pro 4 Companion, by Maria Langer. "Specifying a File Name, Location, and Type "...enter a name for the HTML table. Do not include spaces in the file name, but do include the appropriate file name extension: .html or .htm." and "If you want to view or edit the HTML that FileMaker Pro composed for you, you can open the exported file with a text editor or word processor."
June 21, 200223 yr Author "...enter a name for the HTML table. Do not include spaces in the file name, but do include the appropriate file name extension: .html or .htm." Yes, I am doing that. I don't have a problem with the exported file's name, but with the text that appears in the exported file. "If you want to view or edit the HTML that FileMaker Pro composed for you, you can open the exported file with a text editor or word processor." With BBEdit I could convert >, <, etc. back, but that is a step that I am hoping I don't have to take, since the purpose of using a database to make html is that I won't have to post process the FM output to use the html. Thanks
June 21, 200223 yr The whole exercise is still mystery to me. If FM is exporting all data to tables, no HTML element can be present -- as I wrote before.
June 22, 200223 yr Here's one option: Define a calculation field (unstored, text): Export_HTML = Case(Status(CurrentRecordNumber) = 1, "<HTML>
Create an account or sign in to comment