Hi

fm11Adv Mac 10.6.4 XHTML 1.1

I have a single calc field that creates code for a static html page

export field contents creates the pages, but apprantly due to FM export
character encoding, the output has invisible text that screws the xhtml
1.1 document validation; I know whats going on, what I need is a simple
way t produce a single page; xml/xlst stylesheet export is unfathomable.

Copy and paste works just fine, but too repetitious for the project

I have tried a command line approach
touch ~/desktop/qq.txt
open ~/desktop/qq.txt

and pbpaste > ~/desktop/qq.txt

but the FM copy does not transfer through th clipbaoard(s)

any suggestions?

"105" <cortical (AT) internode (DOT) on.net> wrote

As far as I'm aware, FileMaker changes only three things with a Field's data
when exporting:
- replace carriage returns with vertical tabs,
- replace tabs with something,
- separate Repeating Field values with something

I can't remeber what those last two replacements are though.

You should be fine as long as your XHTML Field does not contain any of those
(which normal HTML doesn't recognise anyway, but I don't know enough about
XHTML).

If you XHTML Field has to retain such characters, then you could re-replace
tham after exporting from FileMaker using any good word / text processor or
one of the command line text manipulators.

If you're exporting more than one Field, then FileMaker will insert a tab /
comma as the separator. If you're exporting more than one Record, FileMaker
will insert a carriage return separator. Both of these could, but shouldn't,
cause minor problems with HTML.


You could try Automator / AppleScript.


Helpfull Harry )

&lt;/html&gt;</DATA></COL></ROW></RESULTSET></FMPXMLRESULT>
<<
I have a single calc field that creates code for a static html page

export field contents creates the pages, but apparantly due to FM export
character encoding, the output has invisible text that screws the xhtml
1.1 document validation; I know whats going on, what I need is a simple
way to produce a single page; xml/xlst stylesheet export is unfathomable.
Exporting as text, embeds invisible and unrequired code, that screws the
valiadation. The export as xml is just a way of illustrating the sort of
code that is added even when exporting field contents as text (which is
the starting point and desired method)


an FM text field with a single line e.g.
<

In article <4c5b7922$0$11098$c3e8da3 (AT) news (DOT) astraweb.com>, 105
<cortical (AT) internode (DOT) on.net> wrote:
Exporting as plain text format should not add any extra characters /
information, other than the previously mentioned replacements. A tab
separated export file is probably best, since comma / CSV and Merge export
file formats will also add extra quote marks around field content and
Field names. ?|

Helpfull Harry )

Execute a calculated AppleScript with this argument:

"do shell script \"echo \\\""&
Substitute( table::field;"¶";Char(10))&
"\\\" > /Users/<your username>/Desktop/out.txt\""

Jens

On 7/08/10 12:48 AM, Jens Teich wrote:


"do shell script \"echo \\\""&
Substitute( fUser::g_text;"¶";Char(10))&
"\\\" > /Volumes/Data/cortical/Desktop/out.txt\""

A real number can’t go after this “"”.

Unknown error -2740



changing to:
/Volumes/data/cortical/Desktop/out.txt
>> same error

105 <cortical (AT) internode (DOT) on.net> writes:

Your path /Volumes/... looks invalid. Open Terminal.app

cd Desktop
pwd

and take result as path.

Jens

On 7/08/10 3:52 PM, Jens Teich wrote:

user(s) are on a separate partition 'data'


imac27:desktop cortical$ pwd
/Volumes/data/cortical/desktop
imac27:desktop cortical$



Chris

105 <cortical (AT) internode (DOT) on.net> writes:


Data -> data
Desktop -> desktop

Jens

On 9/08/10 12:51 AM, Jens Teich wrote:



1. file dragged onto shell
/Volumes/data/cortical/Desktop/aa.html

2. cd desktop
pwd
/Volumes/data/cortical/desktop

(I'll have to remember there are case issues;
file dragged into shell = upper
pwd - lower
but cd accepts lower; imac27:~ cortical$ cd desktop
imac27:desktop)



SCRIPT STEP:
"do shell script \"echo \\\""&
Substitute( fUser::g_text;"¶";Char(10))&
"\\\" > /Volumes/data/cortical/desktop/out.txt\""

Unknown Error: -2740.


Chris