Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Suppress html text conversion on html export?

Featured Replies

When I export a database as an html table, FM converts the html characters like > < " etc to &gt; &lt; &quot; 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?

The > and < are the most important HTML tags smile.gif

"When I export a database as an html table..."

Export to where?

Is this involved with ODBC or IWP?

  • 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 &lt;

> becomes &gt;

" becomes &quot;

(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.

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."

  • 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 &gt;, &lt;, 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

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.

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

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.