Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Suppress html text conversion on html export?

droosan

By droosan
in Custom Web Publishing

 Share

This topic is 8182 days old. Please don't post here. Open a new topic instead.

Recommended Posts

droosan Enthusiast

droosan

Posted
Posted

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?

droosan Enthusiast

droosan

Posted
  • Author
Posted

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.

Keith M. Davie Mentor

Keith M. Davie

Posted
Posted

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

droosan Enthusiast

droosan

Posted
  • Author
Posted

"...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 Bridge Rising Star

The Bridge

Posted
Posted

Here's one option:

Define a calculation field (unstored, text):

Export_HTML =

Case(Status(CurrentRecordNumber) = 1,

"<HTML>

This topic is 8182 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...

Important Information

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

  I accept