{"id":359,"date":"2014-07-10T21:00:38","date_gmt":"2014-07-11T04:00:38","guid":{"rendered":"http:\/\/layneshipley.shipley.website\/?p=359"},"modified":"2014-07-10T21:00:38","modified_gmt":"2014-07-11T04:00:38","slug":"exporting-rtf-text-filemaker-field","status":"publish","type":"post","link":"https:\/\/layne.eqlik.us\/index.php\/archives\/359","title":{"rendered":"Exporting RTF text from a FileMaker field"},"content":{"rendered":"

On one of the projects I was working on, I came across a problem were I had data to export that needed to be exported with the RTF formatting maintained. \u00a0I was trying to create an index with some bolding etc. applied. \u00a0After looking for plugin etc. to do this I came across a simple solution. \u00a0If you’re using FileMaker on a mac you can use applescript to do this. (it may also be possible on Windows – \u00a0I don’t know)<\/p>\n

<\/div>\n
Basically, what I did is create a loop to go through my records. \u00a0Then essentially I copied the contents from the field and pasted them in my application. \u00a0 In this case it was Pages. \u00a0(Note: \u00a0I tried to use inDesign but it doesn’t work with all RTF formatting. \u00a0Plus it crashed \u00a0a bunch as my record got bigger.) \u00a0Pages worked fabulously! \u00a0Over 2500 pages and no problems.<\/div>\n
<\/div>\n
\"Export<\/a><\/div>\n
<\/div>\n
Create a loop.<\/div>\n
Copy (the field you’re store the RTF data in.<\/div>\n
Run the applescript (see below)<\/div>\n
Go to the next record.<\/div>\n
<\/div>\n
\"Export<\/a><\/p>\n
Here is the applescript code I used:<\/div>\n
<\/div>\n
\n
tell application “Pages”<\/span><\/div>\n
\u00a0 \u00a0activate<\/span><\/div>\n
document<\/span><\/div>\n
end tell<\/span><\/div>\n
\u00a0<\/span><\/div>\n
tell application “System Events” to keystroke “v” using command down<\/span><\/div>\n<\/div>\n
<\/div>\n
Worked like a charm! \u00a0Just open up Pages with a blank record and run the FileMaker script.<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

On one of the projects I was working on, I came across a problem were I had data to export that needed to be exported with the RTF formatting maintained. \u00a0I was trying to create an index with some bolding etc. applied. \u00a0After looking for plugin etc. to do this I came across a simple solution. \u00a0If you’re using FileMaker on a mac you can use applescript to do this. (it may also be possible on Windows – \u00a0I don’t know) Basically, what I did is create a loop to go through my records. \u00a0Then essentially I copied the contents from the field and pasted them in my application. \u00a0 In this case it was Pages. \u00a0(Note: \u00a0I tried to use inDesign but it doesn’t work with all RTF formatting. \u00a0Plus it crashed \u00a0a bunch as my record got bigger.) \u00a0Pages worked fabulously! \u00a0Over 2500 pages and no problems. Create a loop. Copy (the field you’re store the RTF data in. Run the applescript (see below) Go to the next record. Here is the applescript code I used: tell application “Pages” \u00a0 \u00a0activate document end tell \u00a0 tell application “System Events” to keystroke “v” using command down Worked like a charm! \u00a0Just open up Pages with a blank record and run the FileMaker script.<\/p>\n","protected":false},"author":1,"featured_media":346,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,6],"tags":[34,35,37,54],"class_list":["post-359","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-computers","category-filemaker","tag-export","tag-field","tag-filemaker-2","tag-rtf"],"acf":[],"_links":{"self":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts\/359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/comments?post=359"}],"version-history":[{"count":0,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts\/359\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/media\/346"}],"wp:attachment":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/media?parent=359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/categories?post=359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/tags?post=359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}