Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 

 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

fm2word (input)

Rate this function:  

RatingRatingRatingRatingRating
  Average rating: 4.6  (22 votes)
  Discuss this Custom Function

Jens Teich, DJTO
http://jensteich.de

Generates Microsoft Word 2003 XML Documents from FileMaker

Sample Input:
#<p>#Hello World!#</p><p>#
Second Paragraph.#</p><p>#
Third Paragraph!#</p>#
Sample Output:
<?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'><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><w:body><w:p><w:r><w:t>Hello World!</w:t></w:r></w:p><w:p><w:r><w:t>Second Paragraph.</w:t></w:r></w:p><w:p><w:r><w:t>Third Paragraph!</w:t></w:r></w:p></w:body></w:wordDocument>


 Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

Create MS Word Documents (XML 2003) from FileMaker.


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>#

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!'

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

This is my Custom Function and I want to edit it

Discuss:

5 most recent comments | Show all 6 comments

Sorry. Corrected this. Now everything English.

Jens

Jens, Hamburg, Germany
April 17, 2015 10:45pm

Very interested. Please tell me when working with photos, sample input.

thank you.

kobu, tokyo
April 20, 2015 1:40am

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

Regards
Jens

Jens, Hamburg, Germany
June 04, 2015 3:22am

thanks for your kindness.
I noticed your sample today
I will try your sample.

thanks.

kobu, tokyo
June 12, 2015 1:03am

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

Doug Staubach, Denver, Colorado, USA
September 25, 2015 5:00pm

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
City/Location:
Comment:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 1 + 8 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. decFromHex ( hexValue )
  (Mon, Oct 16, 12:34pm)
2. MonthYearList ( startmonth ; startyear ; numbermonth ; short )
  (Mon, Oct 16, 3:38am)
3. ErrorDescription ( errorNumber )
  (Wed, Sep 27, 2:51am)
4. decodeEntities (text)
  (Wed, Sep 27, 1:22am)
5. HexidecimalToNumber ( HexidecimalValue ; counter )
  (Mon, Sep 25, 12:39pm)
6. FixedFieldConverter ( Fieldname ; f1 ; f2 ; f3 ; f4 ; f5 ; f6 ; f7 ; f8 ; f9 ; f10 ; f11 ; f12 ; f13 ; f14 ; f15 ; f16 ; f17 ; f18 ; f1
  (Fri, Sep 15, 12:34pm)
7. ShannonEntropy ( text )
  (Thu, Sep 07, 5:59am)
8. LetterCount ( text ; summary )
  (Thu, Sep 07, 5:53am)

RSS Feed of Custom Functions