<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Nick Lightbody on Medium]]></title>
        <description><![CDATA[Stories by Nick Lightbody on Medium]]></description>
        <link>https://medium.com/@nicklightbody?source=rss-d23e5498aacd------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*4EWgCQOLI72pFBgEUvK1mA@2x.jpeg</url>
            <title>Stories by Nick Lightbody on Medium</title>
            <link>https://medium.com/@nicklightbody?source=rss-d23e5498aacd------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 03:24:32 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@nicklightbody/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Adventures with an old wooden racing dinghy Part 2: going to the races]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://nicklightbody.medium.com/adventures-with-an-old-wooden-racing-dinghy-part-2-going-to-the-races-c7f3997edc5d?source=rss-d23e5498aacd------2"><img src="https://cdn-images-1.medium.com/max/1548/1*sF91yzNmAaxFxsaag171-Q@2x.jpeg" width="1548"></a></p><p class="medium-feed-snippet">We prepare for and enter our first race meeting, observe how good the National Champions are and recognise the need to work on our fitness.</p><p class="medium-feed-link"><a href="https://nicklightbody.medium.com/adventures-with-an-old-wooden-racing-dinghy-part-2-going-to-the-races-c7f3997edc5d?source=rss-d23e5498aacd------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://nicklightbody.medium.com/adventures-with-an-old-wooden-racing-dinghy-part-2-going-to-the-races-c7f3997edc5d?source=rss-d23e5498aacd------2</link>
            <guid isPermaLink="false">https://medium.com/p/c7f3997edc5d</guid>
            <category><![CDATA[yacht-racing]]></category>
            <category><![CDATA[yachting]]></category>
            <category><![CDATA[boat-repair]]></category>
            <category><![CDATA[wooden-boats]]></category>
            <category><![CDATA[dinghy]]></category>
            <dc:creator><![CDATA[Nick Lightbody]]></dc:creator>
            <pubDate>Thu, 27 May 2021 19:31:49 GMT</pubDate>
            <atom:updated>2021-05-27T19:31:49.916Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Adventures getting a old wooden racing dinghy into competitive condition (edition 2)]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://nicklightbody.medium.com/adventures-getting-a-old-wooden-racing-dinghy-into-competitive-condition-b239600362e7?source=rss-d23e5498aacd------2"><img src="https://cdn-images-1.medium.com/max/1200/1*XxguVEPgN5tU9Ldk8RsvWw@2x.jpeg" width="1200"></a></p><p class="medium-feed-snippet">A brand new wooden Scorpion &#x2116;2048 Liquid Spirit built by Duffin/Paintcraft.</p><p class="medium-feed-link"><a href="https://nicklightbody.medium.com/adventures-getting-a-old-wooden-racing-dinghy-into-competitive-condition-b239600362e7?source=rss-d23e5498aacd------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://nicklightbody.medium.com/adventures-getting-a-old-wooden-racing-dinghy-into-competitive-condition-b239600362e7?source=rss-d23e5498aacd------2</link>
            <guid isPermaLink="false">https://medium.com/p/b239600362e7</guid>
            <category><![CDATA[yachting]]></category>
            <category><![CDATA[dinghy]]></category>
            <category><![CDATA[yacht-racing]]></category>
            <category><![CDATA[wooden-boats]]></category>
            <category><![CDATA[boat-repair]]></category>
            <dc:creator><![CDATA[Nick Lightbody]]></dc:creator>
            <pubDate>Fri, 14 May 2021 14:52:27 GMT</pubDate>
            <atom:updated>2021-05-15T00:00:38.009Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Adventures getting a old wooden racing dinghy into competitive condition (edition 1)]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://nicklightbody.medium.com/adventures-getting-a-old-wooden-racing-dinghy-into-competitive-condition-751ca01404d?source=rss-d23e5498aacd------2"><img src="https://cdn-images-1.medium.com/max/1200/1*XxguVEPgN5tU9Ldk8RsvWw@2x.jpeg" width="1200"></a></p><p class="medium-feed-snippet">A brand new wooden Scorpion No. 2048 Liquid Spirit built by Duffin/Paintcraft.</p><p class="medium-feed-link"><a href="https://nicklightbody.medium.com/adventures-getting-a-old-wooden-racing-dinghy-into-competitive-condition-751ca01404d?source=rss-d23e5498aacd------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://nicklightbody.medium.com/adventures-getting-a-old-wooden-racing-dinghy-into-competitive-condition-751ca01404d?source=rss-d23e5498aacd------2</link>
            <guid isPermaLink="false">https://medium.com/p/751ca01404d</guid>
            <dc:creator><![CDATA[Nick Lightbody]]></dc:creator>
            <pubDate>Fri, 14 May 2021 02:24:02 GMT</pubDate>
            <atom:updated>2021-05-14T14:53:41.594Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Building a high-performance image library with Claris FileMaker.]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://nicklightbody.medium.com/building-a-high-performance-image-library-with-claris-filemaker-c8df614bb45b?source=rss-d23e5498aacd------2"><img src="https://cdn-images-1.medium.com/max/600/1*cAFcvFhLtoQ9lVLYVSOcPg.png" width="600"></a></p><p class="medium-feed-snippet">I have many images scattered over many devices, storage systems and photo handling Apps. I also get pretty fed up when the one I relied&#x2026;</p><p class="medium-feed-link"><a href="https://nicklightbody.medium.com/building-a-high-performance-image-library-with-claris-filemaker-c8df614bb45b?source=rss-d23e5498aacd------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://nicklightbody.medium.com/building-a-high-performance-image-library-with-claris-filemaker-c8df614bb45b?source=rss-d23e5498aacd------2</link>
            <guid isPermaLink="false">https://medium.com/p/c8df614bb45b</guid>
            <dc:creator><![CDATA[Nick Lightbody]]></dc:creator>
            <pubDate>Sat, 08 May 2021 12:52:42 GMT</pubDate>
            <atom:updated>2021-05-08T13:26:23.977Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[VIGOR Document Certification enables health status to be shared — but only when you wish to do so.]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://nicklightbody.medium.com/vigor-document-certification-enables-health-status-to-be-shared-but-only-when-you-wish-to-do-so-a637ec16aca9?source=rss-d23e5498aacd------2"><img src="https://cdn-images-1.medium.com/max/1280/1*xxxfgviHFkhiDOHZeX6ypw.jpeg" width="1280"></a></p><p class="medium-feed-snippet">This Cambridge startup&#x2019;s privacy based solution enables people to easily, quickly and securely demonstrate their health status.</p><p class="medium-feed-link"><a href="https://nicklightbody.medium.com/vigor-document-certification-enables-health-status-to-be-shared-but-only-when-you-wish-to-do-so-a637ec16aca9?source=rss-d23e5498aacd------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://nicklightbody.medium.com/vigor-document-certification-enables-health-status-to-be-shared-but-only-when-you-wish-to-do-so-a637ec16aca9?source=rss-d23e5498aacd------2</link>
            <guid isPermaLink="false">https://medium.com/p/a637ec16aca9</guid>
            <category><![CDATA[personal-privacy]]></category>
            <category><![CDATA[health-certifications]]></category>
            <category><![CDATA[privacy-protection]]></category>
            <category><![CDATA[health-passport]]></category>
            <category><![CDATA[covid19]]></category>
            <dc:creator><![CDATA[Nick Lightbody]]></dc:creator>
            <pubDate>Mon, 29 Mar 2021 20:41:58 GMT</pubDate>
            <atom:updated>2021-03-30T21:43:06.959Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[What is No-Code or Lo-Code and why should I care?]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://nicklightbody.medium.com/what-is-no-code-or-lo-code-and-why-should-i-care-368c7392a362?source=rss-d23e5498aacd------2"><img src="https://cdn-images-1.medium.com/max/1792/1*jRAtGCFhz7fgQhtn24yAxA@2x.jpeg" width="1792"></a></p><p class="medium-feed-snippet">Easy start No Code &amp; Lo Code Data Apps can be dangerous because they hit a wall not so far down the road&#x200A;&#x2014;&#x200A;where FileMaker Pro just goes&#x2026;</p><p class="medium-feed-link"><a href="https://nicklightbody.medium.com/what-is-no-code-or-lo-code-and-why-should-i-care-368c7392a362?source=rss-d23e5498aacd------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://nicklightbody.medium.com/what-is-no-code-or-lo-code-and-why-should-i-care-368c7392a362?source=rss-d23e5498aacd------2</link>
            <guid isPermaLink="false">https://medium.com/p/368c7392a362</guid>
            <category><![CDATA[spreadsheets]]></category>
            <category><![CDATA[pro-code]]></category>
            <category><![CDATA[no-code]]></category>
            <category><![CDATA[filemaker]]></category>
            <category><![CDATA[lo-code]]></category>
            <dc:creator><![CDATA[Nick Lightbody]]></dc:creator>
            <pubDate>Wed, 10 Mar 2021 02:29:09 GMT</pubDate>
            <atom:updated>2021-03-10T02:29:09.175Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Claris FileMaker Server 19: a performance test of Linux .v. Windows]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://nicklightbody.medium.com/claris-filemaker-server-19-a-performance-test-of-linux-v-windows-4bb007b5e2d7?source=rss-d23e5498aacd------2"><img src="https://cdn-images-1.medium.com/max/1081/1*qpMYClmI0pvKjKg7PTjC_w.png" width="1081"></a></p><p class="medium-feed-snippet">Why Linux deployment could change everything</p><p class="medium-feed-link"><a href="https://nicklightbody.medium.com/claris-filemaker-server-19-a-performance-test-of-linux-v-windows-4bb007b5e2d7?source=rss-d23e5498aacd------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://nicklightbody.medium.com/claris-filemaker-server-19-a-performance-test-of-linux-v-windows-4bb007b5e2d7?source=rss-d23e5498aacd------2</link>
            <guid isPermaLink="false">https://medium.com/p/4bb007b5e2d7</guid>
            <category><![CDATA[server-performance]]></category>
            <category><![CDATA[linux]]></category>
            <category><![CDATA[docker]]></category>
            <category><![CDATA[windows-server]]></category>
            <category><![CDATA[filemaker]]></category>
            <dc:creator><![CDATA[Nick Lightbody]]></dc:creator>
            <pubDate>Thu, 21 Jan 2021 23:48:16 GMT</pubDate>
            <atom:updated>2021-01-21T23:48:16.027Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[So, why do people use FileMaker?]]></title>
            <link>https://medium.com/filemaker/so-why-do-people-use-filemaker-43e1035074c0?source=rss-d23e5498aacd------2</link>
            <guid isPermaLink="false">https://medium.com/p/43e1035074c0</guid>
            <category><![CDATA[mobile-app-development]]></category>
            <category><![CDATA[business]]></category>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[rapid-prototyping]]></category>
            <category><![CDATA[responsive-design]]></category>
            <dc:creator><![CDATA[Nick Lightbody]]></dc:creator>
            <pubDate>Thu, 08 Dec 2016 22:21:32 GMT</pubDate>
            <atom:updated>2016-12-12T22:54:47.441Z</atom:updated>
            <content:encoded><![CDATA[<h4>In their own words — here is why some really smart folk have continued to develop in FileMaker for up to 31 years.</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/887/1*pKFgu95zs7Q4X8i_NtrUfQ.jpeg" /><figcaption>A super-fast responsive photoblog web page created with <a href="http://deskspace.com/photo_blogging_with_deskspace_cms.html">Deskspace CMS</a> — a new App built with FileMaker.</figcaption></figure><p>The FileMaker developer community includes many folk who have been developing solutions to business problems in FileMaker for up to 31 years — evidence of a very strong platform loyalty, unusual in a rapidly evolving software development environment.</p><blockquote><strong>So it is interesting to consider why that is? What is it about the FileMaker Platform that keeps developers coming back when there are so many newer products around that may claim to offer a similar range of features, or better?</strong></blockquote><p>I surveyed a group of 27 expert FileMaker Developers who had a total of 536 years experience of the platform between them (that’s an average of just under 20 years each) and asked them why they continued to use FileMaker:</p><blockquote>30% said because it was a powerful method of developing solutions</blockquote><blockquote>22% said it was a quick method of developing solutions</blockquote><blockquote>22% said it was flexible and/or a range of several reasons</blockquote><h3>Vox pop</h3><p>I have quoted some of their insightful comments at the end of this piece.</p><h3>Citizen developers</h3><p>Most people first use Filemaker as a normal person, wanting to solve a business problem, and that simple first use remains easy because FileMaker has stayed true to its roots in maintaining true ease of use.</p><h3>A real Community</h3><p>However, it is necessary to learn a little more in order to create an efficient and scaleable system that will run effectively over a Wide Area Network and there are many providers of courses, training and publications and experienced developers happy to work with their clients. The FileMaker developer community is very supportive and well formed questions will generally receive very helpful responses and solutions. See for example:</p><ul><li><a href="https://community.filemaker.com/welcome">Welcome |FileMaker Community</a></li><li><a href="http://fmforums.com/">FMForums.com</a></li></ul><h3>But first, what exactly is FileMaker?</h3><p>It is a rapid development software platform comprising FileMaker Server, FileMaker Advanced and FileMaker Pro, with versions of each which run on either OS X or Windows and the newly announced FileMaker Cloud service available through Amazon Web Services. It also includes FileMaker Go, free from the Apple App Store which has much of the user functionality of FileMaker Pro but without the ability to create or edit a solution file.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DPimTxfxoFffJkO63n2Wxg.jpeg" /><figcaption>The FileMaker Platform</figcaption></figure><p>FileMaker’s range of functionality is extremely wide but at its heart, in its DNA, it is a database, the Draco Engine, a means of handling records.</p><p>FileMaker Server includes a web service called FileMaker WebDirect which simulates much of the user functionality of FileMaker Pro, but delivered to modern browsers. Hence users of platforms other than OS X, iOS and Windows can access FileMaker solutions through their browser with WebDirect.</p><p>FileMaker Developers can automatically create an iOS App from a FileMaker Solution file using the FileMaker Software Development Kit (SDK).</p><h3>What is a FileMaker Solution or App?</h3><p>These are different names for the same thing because exactly the same software file(s) can be used on a normal computer, a mobile device or indeed shared across multiple devices over a local or Wide Area Network.</p><blockquote>Precisely the same file runs natively on OS X, iOS and Windows, amazing but true.</blockquote><p>Solutions comprise one or more files, each file containing:</p><blockquote>Database tables of records</blockquote><blockquote>Layouts to display data</blockquote><blockquote>Scripts to automate processes</blockquote><blockquote>Value lists to display options</blockquote><blockquote>A security system</blockquote><blockquote>Custom functions — developer defined expressions</blockquote><blockquote>Custom menus — developer added menus</blockquote><blockquote>Themes that control appearence</blockquote><blockquote>Third Party Plugins can be used to add features</blockquote><h3>An Apple Subsidiary</h3><p>FileMaker Inc., headquartered in Santa Clara in California, was carved out of Claris, the company that Apple used to develop software for Macs in the 1980/90s and it remains a subsidiary of Apple.</p><h3>Group wisdom</h3><p>Here is what some of our group of 27 developers said in reply to my question asking why they continued to use Filemaker. Remember they are all professional software developers who could choose to work in <strong>any</strong> software environment — but who choose to work in FileMaker:</p><h4>Seven developers with over 20 years experience each:</h4><p><em>“These products work. They allow me to create markets for services I can provide.”</em> (31 years)</p><p><em>“There is no other tool like it. In terms of the all-encompassing capabilities of it, and that continues to expand. There are many exciting things on the horizon and that has me really excited about what we’ll be able to deliver to our customers in the future. So to me it’s the flexibility and the breadth of the platform.”</em> (30 years)</p><p><em>“Always learning something new with the product which allows me to help my clients more.”</em> (27 years)</p><p><em>“The reason I keep sticking with the FileMaker platform is that (for me at least) it frequently hits the sweet spot of capability &amp; design, along with speed of development &amp; deployment.”</em> (27 years)</p><p><em>“The main reason that I use FileMaker is that I can prototype quickly and get a fully functional 3 dimensional model up and running fairly quickly. And since I learn best by doing, this helps me deliver quality solutions to my clients. For me it’s really about adding value to the client.”</em> (25 years)</p><p><em>“You shouldn’t underestimate the importance of cross-platform. And the fact that it is equally satisfying to both sides of my brain, all inside the one piece of software.”</em> (23 years)</p><p><em>“The reason why I like FileMaker above all is it’s flexibility. If after some years, a customer changes completely the way he works, his processes… it’s usually incredibly quick to adapt the software. This is something that keeps impressing me.”</em> (23 years)</p><h4>Five developers with less than 20 years experience each:</h4><p><em>“I think that FileMaker has 3 primary advantages: 1. Rapid Application development; 2. Plays nice with others, AKA integration possibilities; 3. Deploy to multiple platforms from a single development environment.</em> (20 years)</p><p><em>“I develop in FileMaker because it makes sense; it adds more value than it costs for the problem at hand. (it = the total cost, licensing + development + deployment + support).”</em> (19 years)</p><p><em>“FileMaker has grown into an amazing platform with incredible flexibility, limited by our own imagination and creativity. Incredibly impressed with the direction things are heading.”</em> (19 years)</p><p><em>“FileMaker is a tool that is so powerful that I create things that other development platforms could not do in time, price and without having to learn many different programming languages.”</em> (17 years)</p><p><em>“FileMaker offers a unique mix of cross-platfom, cross-environment development that is fast, relatively inexpensive and very adaptable.”</em> (14 years)</p><p>Finally, I have used FileMaker for 18 years because I really enjoy using it every day, it has changed my life.</p><p>Cheers, Nick Lightbody</p><p>Sussex, UK December 8th, 2016</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=43e1035074c0" width="1" height="1" alt=""><hr><p><a href="https://medium.com/filemaker/so-why-do-people-use-filemaker-43e1035074c0">So, why do people use FileMaker?</a> was originally published in <a href="https://medium.com/filemaker">FileMaker</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[In praise of curl]]></title>
            <link>https://medium.com/filemaker/in-praise-of-curl-a127155eb803?source=rss-d23e5498aacd------2</link>
            <guid isPermaLink="false">https://medium.com/p/a127155eb803</guid>
            <category><![CDATA[curl]]></category>
            <category><![CDATA[security]]></category>
            <category><![CDATA[deskspacecms]]></category>
            <category><![CDATA[ftp]]></category>
            <category><![CDATA[mobile-app-development]]></category>
            <dc:creator><![CDATA[Nick Lightbody]]></dc:creator>
            <pubDate>Sat, 24 Sep 2016 01:07:51 GMT</pubDate>
            <atom:updated>2016-10-05T00:11:04.182Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*tzulVgUkZoo2suPRhyt74Q.jpeg" /></figure><h4>An essential element in the user experience of the new FileMaker App <a href="http://deskspace.com/">deskspaceCMS</a> is the use of curl to automate the upload of web pages and other resources to your web server. Nick Lightbody explains exactly how curl can be called from a FileMaker script under both OS X and Windows to achieve this.</h4><blockquote>“curl is used in command lines or scripts to transfer data. It is also used in cars, television sets, routers, printers, audio equipment, mobile phones, tablets, settop boxes, media players and is the internet transfer backbone for thousands of software applications affecting billions of humans daily.” <a href="https://curl.haxx.se/">The curl official site</a></blockquote><p>curl — which originally meant “see url” — is a powerful, flexible and highly useful command line tool which enables your FileMaker App to interact with an other computer in order to transfer data.</p><blockquote>curl is a brilliant method of enabling your FileMaker App, on OS X and Windows, to interact with other Apps and services by way of file transfer. It is powerful and of industrial quality, so once you figure out how to use it — it just works.</blockquote><h4>The problem</h4><p>In our case the problem we had to solve, in order to make large numbers of deskspaceCMS deployments scaleable with a very simple user experience, was how to:</p><ol><li>upload new or revised web pages to the web server as part of a scripted process;</li><li>upload images and other resources to the web server as part of a scripted process and how to</li><li>automatically create unique new directories/folders on the web server to enable each deskspaceCMS user to have their own web site in their own directory without any manual intervention.</li></ol><p>The obvious route into making a curl call was through Applescript on OS X and using a Windows Event on Windows OS.</p><p>curl can run many different protocols, I have only used the ftp (file transfer) protocol.</p><p>See the curl manual <a href="https://curl.haxx.se/docs/manpage.html">here</a>.</p><h4>The solution</h4><p>The steps to success where as follows:</p><ol><li>Syntax: the correct syntax is not complex but contatenating the correct string from Filemaker can be a little tricky.</li><li>Encoding the URL: unless you encode the url into HTTP compliant characters your call will fail whenever you use any characters outside the HTTP permitted character set.</li><li>Debugging: providing the user with a preformed command line to use in debugging their connection was highly desirable since the OS X Terminal App or the Windows OS equivalent then take that command line copied and pasted by the user and automatically create a report showing where the call to curl failed.</li></ol><h4>OS X: to call curl with Perform Applescript []</h4><h4>PART 1: THE FIRST CALL to CURL</h4><p>We need to use an expression to assemble the correct string for the call to curl, in this case we are setting a variable $curl which is what we then pass as a parameter to Applescript, hence the syntax has to suit Applescript, as well as curl.</p><p>NB: It is essential to only use plain single and double quotes, avoid curly quotes, they will stop your ftp call to curl running correctly.</p><pre>LINE 1: Set variable [ $curl;</pre><pre>//FUNCTIONS TO TRANSFER FILE</pre><pre>Let([</pre><pre>// define our variables<br> ftpserver = &lt;ftp server name or IP Address&gt;;<br> destfolder = &lt;the target folder below the ftp root folder if any&gt;;<br> u = GetAsURLEncoded(&lt;ftp username&gt;);<br> pw = GetAsURLEncoded(&lt;ftp password&gt;);<br> file1 = $filename1; // local name<br> file2 = $filename2; // name on ftp server<br> tp = Get(TemporaryPath);</pre><pre>// concatenate the Applescript string — the curl flags go straight after the initial “curl” declaration<br>// curl flags can be short or long<br>// -T or — upload-file | to Transfer a file<br>// --ftp-create-dirs   | When an FTP or SFTP URL/operation uses a path that doesn&#39;t currently exist on the server, the standard behavior of curl is to fail.<br>//                       Using this option, curl will instead attempt to create missing directories.</pre><pre>x = &quot;do shell script \&quot;curl -T &#39;&quot; &amp;<br>Case( not IsEmpty( tp )<br>    ;<br>     tp ) &amp; file1 &amp; &quot;&#39; ftp://&quot; &amp; u &amp; &quot;:&quot; &amp; pw &amp; &quot;@&quot; &amp; ftpserver &amp; &quot;/&quot; &amp; Case( not IsEmpty(destfolder)<br>    ;<br>     destfolder &amp; &quot;/&quot;<br>    ) &amp;<br>file2 &amp; &quot;\&quot;&quot; ;</pre><pre>// Finally any required syntactic corrections to the string — here we needed to add “private” to the string</pre><pre>p1=Position(x;&quot;/&quot;;1;1);<br>p2=Position(x;&quot;/&quot;;1;2);<br>y=Middle(x;p1+1;p2-p1-1);  <br>z=Substitute(x;y;&quot;private&quot;)<br>];z)] </pre><pre>// end of Set Variable [$curl]</pre><pre>LINE 2: Perform Applescript [ $curl ]</pre><pre>LINE 3: Set Variable [ $error; Get(LastError)]</pre><h4>PART 2: THE SECOND CALL TO CURL</h4><p>If the first call fails, because the required folder does not exist then you can make a second very similar call — just using a different switch after “curl” which will try to create the directory structure that is missing.</p><pre>&quot;do shell script \&quot;curl --ftp-create-dirs</pre><p>In my experience this always works and it is a very wonderful thing.</p><h4>PART 3: THE THIRD CALL TO CURL</h4><p>Your third call just repeats the first call, which should now work as the directories it is expecting now exist.</p><h4>PART 4: ERROR HANDLING</h4><p>Assuming you have used an <strong>if[$error&lt;&gt;0]</strong> to call the error handling — we now need to create the debug string required under OS X in Terminal to tell the user why their call to curl failed.</p><pre>LINE 1: Set field [ Field 1</pre><pre>;</pre><pre>Let([x=$curl;</pre><pre>y=Substitute(x;”\””;”|”);</pre><pre>r=”curl — trace -n -v -ssl -l “ &amp; xExtractBetweenDelimiters ( y ; “|” )];r)</pre><pre>] // end of Set Field</pre><pre>LINE 2: Show Custom Dialogue [</pre><pre>//Title</pre><pre>“A problem has occurred with FM Error: “ &amp; $error</pre><pre>;</pre><pre>// Content</pre><pre>“Sorry, but your upload to your web server was unsuccessful.¶¶</pre><pre>You should check your Settings¶¶</pre><pre>The Apple scripted Curl command used was:¶¶</pre><pre>“ &amp; $applescript &amp; “and you can use the string copied into the field below, in OS X Terminal to debug your Web Server settings.¶¶</pre><pre>The current page has been exported to your local folder specified in settings or if none then to your desktop.¶¶</pre><pre>This process will now halt.”</pre><pre>;</pre><pre>// Input field in dialogue shows Field 1 with label</pre><pre>“On OS X — copy this string into Terminal to debug the Curl Command.”</pre><pre>] // end of Show Custom Dialogue</pre><pre>Note: We used this custom function to extract part of the $curl string:</pre><pre>xExtractBetweenDelimiters (text; delimiters)</pre><pre>Let([s=Substitute(text;”\””;”\\” &amp; “\””);</pre><pre>x=Evaluate(Quote( s ));</pre><pre>p1=Position(x;delimiter;1;1)+1;</pre><pre>p2=Position(x;delimiter;1;2);</pre><pre>L=p2-p1;</pre><pre>y=Middle(x;p1;L);</pre><pre>z=Substitute(y;”\\”;””)];z)</pre><h4>WINDOWS OS: to call curl with a Windows Send Event []</h4><p>This is very similar to the Applescript version but with some small differences in syntax.</p><h4>PART 1: THE CALL to curl</h4><pre>LINE 1: Set variable [ $curl;</pre><pre>//FUNCTIONS TO TRANSFER FILE (WINDOWS)</pre><pre>Let([</pre><pre>[as previously]</pre><pre>x = &quot;curl -T &#39;&quot; &amp;<br>Case( not IsEmpty( tp )<br>    ;<br>     tp ) &amp; file1 &amp; &quot;&#39; ftp://&quot; &amp; u &amp; &quot;:&quot; &amp; pw &amp; &quot;@&quot; &amp; ftpserver &amp; &quot;/&quot; &amp; Case( not IsEmpty(destfolder)<br>    ;<br>     destfolder &amp; &quot;/&quot;<br>    ) &amp;<br>file2;</pre><pre>// Finally any required syntactic corrections to the string — here we needed to remove single quotes</pre><pre>y=Substitute(x;&quot;&#39;&quot;;&quot;&quot;)</pre><pre>];y)</pre><pre>// end of Set Variable [$curl]</pre><pre>LINE 2: Send Event [ “aevt” ; “odoc” ; “cmd /c “ &amp; Quote($curl)]</pre><p>Interestingly, the calls to curl from FileMaker appear to run much faster on Windows OS than they do on OS X.</p><p>Cheers, Nick</p><p>Sussex, UK</p><p>September 24th, 2016</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a127155eb803" width="1" height="1" alt=""><hr><p><a href="https://medium.com/filemaker/in-praise-of-curl-a127155eb803">In praise of curl</a> was originally published in <a href="https://medium.com/filemaker">FileMaker</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Micro-Responsive Web Design]]></title>
            <link>https://medium.com/filemaker/micro-responsive-web-design-8c3fd130cf9b?source=rss-d23e5498aacd------2</link>
            <guid isPermaLink="false">https://medium.com/p/8c3fd130cf9b</guid>
            <category><![CDATA[mobile-app-development]]></category>
            <category><![CDATA[filemaker]]></category>
            <category><![CDATA[web-performance]]></category>
            <category><![CDATA[responsive-design]]></category>
            <dc:creator><![CDATA[Nick Lightbody]]></dc:creator>
            <pubDate>Mon, 19 Sep 2016 01:47:08 GMT</pubDate>
            <atom:updated>2016-09-20T20:48:47.504Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*dDAthzTfD_zaRXBsdHFqDw.jpeg" /></figure><p><em>A FileMaker App is leading the way in creating the world’s fastest web sites using Micro-Responsive Web Design, and, it is doing this much faster than other methods. Nick Lightbody explains how and why.</em></p><p>FileMaker, the flexible suite of Apps and deployment options including FileMaker Server, FileMaker Pro &amp; Advanced, FileMaker Go and FileMaker WebDirect, is a popular means of creating data driven solutions to challenges in business, the public sector, education and not for profit.</p><blockquote>Flexibility and speed of development are the most often quoted reasons for using FileMaker.</blockquote><p>A less frequent quoted reason is its speed, but my development work over the past year provides a great example of a use where a FileMaker App beats all comers for pure speed. Surprising, but true.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*J_pq-1bJLUUTxIAN3mC_mw.png" /></figure><p>DeskspaceCMS (dCMS) is a “Content Management System” (if you are a web designer, otherwise you would call it a “Web Builder”) which creates responsive web sites. It has been developed over about 12 months using FileMaker 14/15 and the new version <strong>dCMS v3</strong> will soon be available for download from <a href="http://deskspace.com/downloads.html">deskspace.com</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Fxv9mDgkpkDueBojBA3m0g.png" /><figcaption>dCMS provides different user interface levels for less and more experienced user.</figcaption></figure><p>As you know, creating sites which work perfectly and look great on any device nowadays is the key priority because the majority of folk use mobile devices, often with quite small screens. A responsive site is one that works perfectly on any device using the same HTML page code but leveraging CSS media queries to vary the appearance of the page depending on what size screen it is viewed on.</p><blockquote>Fast and responsive sites now rank very well on search engines hence this is not just a crowd pleaser.</blockquote><p>With a need to create responsive sites I experimented with the approach the <a href="http://www.the-haystack.com/">Stephen Hay</a> describes in <a href="http://www.peachpit.com/store/responsive-design-workflow-9780321887863">“Responsive Design Workflow”</a>. So I used <a href="http://www.barebones.com/products/bbedit/">BBEdit</a>, <a href="http://pandoc.org/index.html">Pandocs</a> and <a href="http://www.dexy.it/">Dexy</a> as a method of first drafting content, in John Guber’s <a href="https://daringfireball.net/projects/markdown/">Markdown</a> language, and then creating the HTML pages. I had looked hard at Stephen’s work because I heard he had been used by the world’s leading digital agency, <a href="https://www.rga.com/">R/GA</a>, to teach them how to build fast responsive web sites. I loved his approach, pure simplicity, and have built my own approach to responsive page design firmly on Stephen’s suggestions. However, I was unimpressed by the actual speed in practical use of the command line Apps, Pandocs &amp; Dexy.</p><blockquote>The obvious thought was “Why not do this in FileMaker?”.</blockquote><p>After an intensive night’s work, I had created the first version of the new App. The core idea was to use FileMaker’s Substitute() function on an industrial scale to set CSS values set by the user into an html page template, hence to automatically rebuild and preview the page everytime the user made a change, and it worked.</p><p>It worked because although a FileMaker App is technically an interpreted App, not a compiled App, and hence should not in theory be as fast as a compiled App, its Substitute() function is a very wonderful thing, which works very fast, as the statistics above show.</p><p>On every page, dCMS is assessing about 250 conditional styling values and then substituting those values into the in-line CSS within the style section of the page. It is also assembling formatted paragraphs, image tags, hypertext links, YouTube videos players, mailto tags, Google Map viewers, Form fields and PayPal buttons and the site navigation system before minifying the page and automatically uploading it to the web server. All done with vanilla FileMaker, without plugins. It really is just text manipulation on a fairly large scale.</p><blockquote>You get this performance by playing to FileMaker’s strengths and simplifying everything that creates a performance load.</blockquote><p>Accordingly, this App differs from most other FileMaker Apps in that it uses a very simple relationship model and a limited number of fields, which are two big performance boosters, whilst using large numbers of repeats in a small number of repeating fields and many scripts, both of which create a very low performance load.</p><p>Here, for example, is the relationship graph, which you can see is extremely simple…</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/821/1*Uq3xOKr7PcfZAYLv0XDe4w.jpeg" /><figcaption>The deskspaceCMS relationship graph is very simple — aiding high performance.</figcaption></figure><p>Thinking back to Sir Tim Berners-Lee’s invention of Hyper Text Markup Language (HTML), the foundation of the World Wide Web, he focused on enabling people to work faster, in order to make their lives easier.</p><p>That is what the Responsive Web is all about. Ensuring that web sites work fast and are simple to use. Yet, the majority of sites are quite the opposite, often unresponsive on mobile devices and more often slow over a cellular network. Slow and unresponsive sites make peoples’ lives harder, not easier.</p><p>The first and biggest step towards working out how to get great responsive performance is to look at the entire code used by the device’s browser in order to display the page to the user, and to assess its function. In practice, many sites use over a 100k characters of code merely to display a few score characters of readable content.</p><blockquote>Why? Because they use one or more complex, long, feature rich CSS Librarys to control their page appearance.</blockquote><p>In every case, much of this code is redundant, unused by the page in question. In fact completely unnecessary. Yet, despite using only a small number of features from each library on a particular page, nonetheless, the user’s low powered mobile device is still required to download every CSS library to which the page refers, in its entirety.</p><blockquote>Then it has to interpret several librarys’ competing instructions in order to work out how to display perhaps only a few lines of text and a few of images.</blockquote><p>This is incredibly inefficient!</p><p>It is inevitably slow.</p><blockquote>Surely there must be a better way you are thinking?</blockquote><p>Indeed there is.</p><p>When we write software Apps we are building amazing machines with a zero cost of reproduction, a miracle of technology. Such a machine can be designed to write the html and CSS required to construct a web page. deskspaceCMS is such a machine.</p><p>When you write web pages with a machine, you have no need for external CSS style libraries, because you can dynamically write in-line CCS code to control each page as <strong>part of the page in question</strong> whenever the page is amended. This enables the App to avoid using and including any CSS code which is not required on a page by page basis.</p><blockquote>You cannot do this with an external library.</blockquote><p>The result is that the user’s device has much less code to interpret for each page and hence the pages render very much faster then they would with external CSS Libraries.</p><blockquote>We have christened this approach Micro-Responsive Web Design.</blockquote><p>To experience this for yourself just download the demo version of dCMSv3 from <a href="http://deskspace.com/downloads.html">deskspace.com</a>. If it isn’t yet available <a href="http://nick.lightbody@deskspace.com/">drop me a line</a> and we will send you a copy on release. Then use dCMS to reproduce a page from your existing site. Measure the original and new pages with <a href="https://developers.google.com/speed/pagespeed/insights/">Google’s Page Speed Insight</a> tool. You will find that the new page is much faster then the original. Compare the code for both pages, including all external resources referred to. The new code is much shorter.</p><blockquote>This is not rocket science, merely simple logic. The starting point for speed is to reduce what you ask the device to deal with.</blockquote><p>We have yet to find any responsive sites anywhere on the web which are faster than equivalent sites created with dCMS, measuring with Google Page Speed Insight, and hence we are proud to be able to say…</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/764/1*IorNjr4pF3fgBOuRMEv2Bw.jpeg" /></figure><p>Cheers, Nick</p><p>September 14th, 2016</p><p>Sussex, UK</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8c3fd130cf9b" width="1" height="1" alt=""><hr><p><a href="https://medium.com/filemaker/micro-responsive-web-design-8c3fd130cf9b">Micro-Responsive Web Design</a> was originally published in <a href="https://medium.com/filemaker">FileMaker</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>