Newest functions Upload a function Leave a tip My account

There are 2,522 functions in this library.

fm2word ( input )

Generates Microsoft Word 2003 XML Documents from FileMaker

  Average rating: 4.4 (23 votes) Log in to vote

Jens Teich - Show more from this author DJTO http://jensteich.de

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/* * * Generates Microsoft Word 2003 XML Documents from FileMaker. * * Export result into a textfile with extension '.xml' and it can be opened in MS Word, OpenOffice, Libre Office, ... * * * The expected input is a text with tags: * * #<p># - start paragraph * #</p># - end paragraph * #</p><p># - end + start paragraph * * #<table># - tables * #</table># * #<table-row># * #</table-row># * #<table-cell># * #</table-cell># * * #<section># - section break, continuous no new page * #<section-2-col># - section break starting two column page layout * #<section-3-col># - section break starting three column page layout * * #<b># - bold * #</b># * #<i># - italics * #</i># * * #<pict># * #</pict># * * Author: Jens Teich, http://jensteich.de * */ Let([ styles= "<w:styles>" & "<w:style w:type='paragraph' w:styleId='FileMakersHomebrew'>" & "<w:name w:val='FileMakersHomebrew'/>" & "<w:basedOn w:val='Standard'/>" & "<w:rsid w:val='00AF7A99'/>" & "<w:pPr><w:spacing w:line='360' w:line-rule='auto'/></w:pPr><w:rPr>" & "<w:rFonts w:ascii='Garamond' w:h-ansi='Garamond'/>" & "<wx:font wx:val='Garamond'/>" & "<w:color w:val='7030A0'/>" & "<w:sz w:val='24'/>" & "<w:lang w:val='EN-US'/>" & "</w:rPr>" & "</w:style>" & "</w:styles>" ; include_style_FileMakersHomebrew = ""; header = "<?xml version='1.0' encoding='UTF-8' standalone='yes'?>" & "<?mso-application progid='Word.Document'?>" & "<w:wordDocument xmlns:w='http://schemas.microsoft.com/office/word/2003/wordml' " & "xmlns:wx='http://schemas.microsoft.com/office/word/2003/auxHint' " & "xmlns:v='urn:schemas-microsoft-com:vml' " &" xmlns:o='urn:schemas-microsoft-com:office:office'>" ; // footer = "</w:t></w:r></w:p></w:body></w:wordDocument>" footer = "</w:body></w:wordDocument>" ]; header & styles & "<w:body>" & //<w:p><w:r><w:t>" & Substitute ( input ; ["¶" ; "" ];["'" ; "\"" ]; ["#<p>#";"<w:p><w:r><w:t>"]; ["#</p>#";"</w:t></w:r></w:p>"]; ["#</p><p>#";"</w:t></w:r></w:p><w:p><w:r><w:t>"]; ["#<p-Style-FileMaker-Homebrew>#"; "<w:p><w:pPr><w:pStyle w:val='FileMakersHomebrew'/></w:pPr><w:r><w:t>"]; ["#<table>#";"<w:tbl>"]; ["#</table>#";"</w:tbl>"]; ["#<table-row>#";"<w:tr>"]; ["#</table-row>#";"</w:tr>"]; ["#<table-cell>#";"<w:tc>"]; ["#</table-cell>#";"</w:tc>"]; ["#<section>#";"<w:p><w:pPr><w:sectPr><w:type w:val='continuous'/></w:sectPr></w:pPr></w:p>"]; ["#<section-2-col>#";"<w:p><w:pPr><w:sectPr><w:type w:val='continuous'/><w:cols w:num='2' w:space='708'/></w:sectPr></w:pPr></w:p>"]; ["#<section-3-col>#";"<w:p><w:pPr><w:sectPr><w:type w:val='continuous'/><w:cols w:num='3' w:space='708'/></w:sectPr></w:pPr></w:p>"]; ["#<b>#";"</w:t></w:r><w:r><w:rPr><w:b/></w:rPr><w:t>"]; ["#</b>#";"</w:t></w:r><w:r><w:t>"]; ["#<i>#";"</w:t></w:r><w:r><w:rPr><w:i/></w:rPr><w:t>"]; ["#</i>#";"</w:t></w:r><w:r><w:t>"]; ["#<pict>#";"<w:pict><v:shape><v:imagedata src='"]; ["#</pict>#";"'/></v:shape></w:pict>"]) & footer ) Click to copy

Create MS Word Documents (XML 2003) from FileMaker.


The expected input is a text with tags:

* #

# - start paragraph
* #

# - end paragraph
* #

# - end + start paragraph
*
* #

# - tables
* ##
* ##
* ##
* ##
* ##
*
* #

# - section break, continuous no new page
* ## - section break starting two column page layout
* ## - section break starting three column page layout
*
* ## - bold
* ##
* ## - italics
* ##
*
* ##
* ##

Export result into a textfile with extension '.xml'[*] and it can be opened in MS Word, OpenOffice, Libre Office, ...

On Windows the resulting file shows the MS Word Icon and starts MS Word on double click. On MacOSX the resulting file can be opened with Word (or OpenOffice and friends).

Author: Jens Teich, http://jensteich.de

__
Do not use FileMakers XML export, just use a text format like text-with-tabs and rename the resulting file with extension 'xml!'

 

Comments

		Bruce Robertson Apr 17, 2015
Interesting. Might be nice to have an English language version. Or at least mention that SetzeVar = Let and Austauschen = Substitute

		Jens, Hamburg, Germany Apr 17, 2015
Sorry. Corrected this. Now everything English. Jens

		kobu, tokyo Apr 20, 2015
Very interested. Please tell me when working with photos, sample input. thank you.

		Jens, Hamburg, Germany Jun 4, 2015
Sample file is here http://jensteich.de/wp-content/uploads/2015/04/test-word-transfer.fmp12.zip, showing usage (including image example). Regards Jens

		kobu, tokyo Jun 12, 2015
thanks for your kindness. I noticed your sample today I will try your sample. thanks.

		Doug Staubach Sep 25, 2015
Hi Jens! Nice function and nice demo, thank you! Tip: I noticed that if I change the filename in the demo to end with ".doc" instead of ".xml", the document that gets created will open just fine with MS-Word (Word will recognize that the document was saved in xml format, and will open it in compatibility mode). (I'm interested in trying this technique for Excel documents!) Thanks, Doug

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: