Hi,

Our company uses SQL-Server to store product related data.

For creating offline-versions of the product-database we want to

use FileMaker, so we have to export the data from SQL-Server

onto our FM6-Server, where some further data editing is done

by the team.

FileMaker imports via ODBC or XML both work well, but now my problem:

The original texts are formatted in HTML, and I want to keep the formatting

when it is imported into FM. (Only reduced HTML-Set like bold, italic,

subscript, superscript, underlined).

After importing into FM6 I have plain text with HTML-Tags between...

I tried to import the data into FM7, then run there scripts for

replacing HTML-Tags and formatting the included text, it works quite well.

As result my FM Content is formatted fine, like edited by the users

in an WYSIWYG-Webinterface...

But how to get the data from FM7 into FM6, where it has to be stored, because

the company uses FM-Server 6 and won't update to FM7 the next time...?

Any ideas?

Thank you very much,

Peter Bue

I wrote a longer post earlier. But in the process of attempting to use Safari to process the html text from FileMaker I inadvertantly wiped out my not-yet-sent post; don't ya hate it when that happens -/

Basically what I found was that FileMaker 7 only supports formatted text internally. You can't even copy/paste it to 6 (or any other app) as styled text. So there's a price we paid for cross-platform styled text in the calculation engine in 7. So be it; maybe it will be expanded.

So, FileMaker 7's CSS support seems to be no help (that I can see) to get this into 6. It is possible to do this with AppleScript and a text editor that supports styled text, such as Tex-Edit Plus. It comes with an HTML->Mac conversion AppleScript. That script doesn't have the Subscript, but there's another AppleScript in there that does.

Perhaps someone has a more powerful method (I was trying Safari, but you saw what happened there :-[

It's tricky to deal with styled text (unless you're an AppleScript expert, which I'm not really). Example:

tell application "FileMaker Pro"