In this article I would like to present you 10 highlights from the MBS FileMaker Plugin innovations of 2022.
One Plugin for FileMaker AND Claris
Recently, the first version of the Claris product line has been released. We are proud to announce that our plugin also work on the new platform and you can use it there as usual.
The best thing is that you can use the same plugin file for FileMaker and the new Claris. This is the first and currently the only plugin worldwide that works on both platforms equally.
MongoDB
The MongoDB section joined the plugin in release 12.3 and has been developed ever since.
You can use FileMaker to access MongoDB databases, read, write and delete data. The special thing about Mongo DB is that it is not a rational database that is limited by relationships and tables, but is based on a JSON-like structure that also allows unusual queries. For example, you can formulate searches to see who has been in your company longer, the carpet in the warehouse or your employee. In rational databases, your carpet wouldn't normally appear in the same table as your employee. So you would have to design a separate table to be able to make this query. In Mongo DB, the records, here called documents, can coexist in the same collection and a simple query can be made.
In Release 12.5, another significant innovation was added for this area. You can execute transactions on MongoDB since then. Normally, every change in the database is immediately applied as soon as it has been made. But this is not always desirable, e.g. when it comes to security relevant things where multiple records have to be changed. If in the meantime the connection breaks we don't know in which state our database is, which records have been changed, which not. For this there are the transactions, with which we can tell the database to make all changes at once or reject all made changes. If you would like to try Mongo DB, please check out our examples.
(more)
In
MBS FileMaker Plugin we have a handy function:
Window.PositionNextDialog function.
You can call this function in a script just before FileMaker shows a dialog. The plugin will watch for new dialogs to show up and the next dialog to come is adjusted. We check if you provided a new X/Y coordinate and if so move the dialog. If you got us a new width and height, we resize the dialog. And if you set the center flag, we finally center the window on screen.
Works fine on MacOS and Windows so far in various FileMaker versions. We hope the function will help people with multiple screens to position the dialogs better.
For next version (currently in 12.6pr4), we improved this to work on Windows for the progress window for Insert From URL script step. So you can show a nice download while you do your synchronisation, uploads and downloads. The plugin can then be used to move those dialogs out of the way. e.g. on Windows move it down on the screen, so it hides behind the task bar.
Please try it! And do not hesitate to contact us in case of questions.
Frohe Weihnachten und ein gutes neues Jahr!
Merry Christmas & Happy New Year
Joyeux Noël et Bonne Année
Buon Natale e Felice Anno Nuovo
Franziska, Sebastian, Michael, Monika & Christian Schmitz
We have some additional script triggers for iOS to use in your FileMaker iOS app:
- Did Become Active
Triggered when the app becomes active.
- Did Enter Background
Triggered when the app enters the background.
- Did Receive Memory Warning
The app receives a warning from the operating system about low memory availability.
- Significant time change
The system posts this notification when, for example, there’s a change to a new day (midnight), a carrier time update, or a change to, or from, daylight savings time. The notification doesn’t contain a user info dictionary.
- Will enter foreground
Triggered shortly before an app leaves the background state on its way to becoming the active app.
- Will resign active
Triggered when the app is no longer active and loses focus.
And since scripts run later, we also provide evaluation of expressions available to run directly. This may include Let() statements for multiple statements together.
(more)
Welcome to the 24th and last door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
Today I will show you how to turn a rectangular image into a round one.
To say it at the beginning. There is no such thing as a round image. The illusion that an image is round is created by the alpha channel. This means that certain areas are transparent.
First, we load the image from the container again and determine the width and height of the image.
Set Variable [ $GM ; Value: MBS("GMImage.NewFromContainer"; GraphicsMagick Advent::Image) ]
Set Variable [ $Width ; Value: MBS( "GMImage.GetWidth"; $GM ) ]
Set Variable [ $Height ; Value: MBS( "GMImage.GetHeight"; $GM ) ]
We first need the image as a square. So we determine the size of the shorter of the two sides. For this, we distinguish our procedure for Landscape and Portrait mode. With the function "GMImage.Crop" we crop the image as we already know it from door 7.
If [ $Width>$Height ]
# Landscape
Set Variable [ $SizeGeometry ; Value: $Height & "x" & $Height ]
Set Variable [ $Size ; Value: $Height ]
Set Variable [ $OffsetX ; Value: ($Width - $Height) / 2 ]
Set Variable [ $OffsetY ; Value: 0 ]
Else
# Portarait
Set Variable [ $SizeGeometry ; Value: $Width & "x" & $Width ]
Set Variable [ $Size ; Value: $Width ]
Set Variable [ $OffsetX ; Value: 0 ]
Set Variable [ $OffsetY ; Value: ($Height - $Width ) / 2 ]
End If
Set Variable [ $Geometry ; Value: $SizeGeometry & "+" &$OffsetX& "+" &$OffsetY ]
Set Variable [ $r ; Value: MBS( "GMImage.Crop"; $GM; $Geometry ) ]
(more)
Welcome to the 23th door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
Today I'm going to show you how to reduce the size of your image files.
If you want to store images in your database, images often consume a lot of space. But sometimes the images don't have to be that huge, because you only want to display them in a container.
On one hand, if available, you can use the function "GMImage.ExifThumbnail" to retrieve the thumbnail and write it to the database instead of the original image. But with many images the thumbnail cannot be retrieved easily and an error occurs or we get back an empty value. So this case we should catch for sure.
...
Set Variable [ $IMG ; Value: MBS( "GMImage.ExifThumbnail"; $GM; "abc.jpg") ]
If [ MBS("IsError") or $IMG="" ]
Show Custom Dialog [ "Error" ; "Thumbnail cannot be retrieved¶" & $IMG ]
Set Variable [ $r ; Value: MBS( "GMImage.ReleaseAll" ) ]
Exit Script [ Text Result: ]
End If
Set Field [ GraphicsMagick Advent::Image ; $IMG ]
...
(more)
Check out the FMTraining.tv website. Richard Carlton and his team do a daily free live stream about FileMaker to watch.
A few days ago Christian Schmitz from Monkeybread Software joined a live episode to talk a bit about the MBS FileMaker Plugin. Watch it on YouTube.
We talk about Microsoft Office 365 Authentication with oAuth 2.0 in FileMaker with the MBS Plug-in.
(more)
Welcome to the 22th door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
Today I show you how you can combine pictures. It's almost Christmas and our monkey is still missing the right costume. This we want to put on him today. The Christmas hat is on a separate PNG image. That means we want to put the image with the Christmas hat on top of the image with our logo. For this we can choose from two functions GMImage.Composite and GMImage.CompositeXY. I would like to introduce the GMImage.Composite function first. First we specify the reference in which we want to have the result in our case this is the reference of the logo. Next is the reference of the image or workspace we want to combine with the image, in our case an image of the cap. The next parameter refers to how the second image is arranged to the first one. Our two images are the same size, so it makes no difference for us the way the two images are positioned in relation to each other, but if the images are different in size, for example the second image is smaller than the first, then it makes a difference whether we align the image to the upper left corner or centered. The following options are available to us:
- ForgetGravity=0
- NorthWestGravity=1
- NorthGravity=2
- NorthEastGravity=3
- WestGravity=4
- CenterGravity=5
- EastGravity=6
- SouthWestGravity=7
- SouthGravity=8
- SouthEastGravity=9
- StaticGravity=10
(more)
For Windows we got a new checkbox in the preferences dialog:
Following the recurring tradition that any enhancement must have a checkbox to turn it off, we got a new checkbox to decide whether you like to have the search box for relationships.
Beside that, the dialog is a convenient way to put in the license key information and press the Register button. The license is then saved to the preferences dialog to make sure the plugin is registered permanently.
New in this prerelease of version 12.6 of the
MBS FileMaker Plugin:
Download at
monkeybreadsoftware.com/filemaker/files/Prerelease/, in
DropBox folder or ask for being added to the DropBox shared folder.
Welcome to the 21st door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
Yesterday we already looked at how we can draw with the basic shapes in GraphicsMagick. Today we would like to draw our own shapes. For this we have some functions in the plugin that we can use. We will draw our own shapes with paths. Let's imagine a pen. We tell this pen where it is and where it goes. Let's draw a triangle together. To do this, we first need to move our pen to the start position. For this we use the function GMImage.AddPathMovetoAbs in the parameters we specify the start coordinates for our point (50/50) in addition to the reference.
Set Variable [ $r ; Value: MBS( "GMImage.AddPathMovetoAbs"; $GM; 50; 50 ) ]
We have now specified an absolute position because we want to start exactly at these coordinates. But if you have a look at the documentation of GraphicsMagick you will notice that there is also a very similar function called GMImage.AddPathMovetoRel. The difference between these two functions is that we specify the absolute coordinates (the exact point where we want to place the pen) or the relative coordinates. The relative coordinates describe where the point is in relation to the old position. This means for example if we have a Relative Coordinate (1/1) we go one unit to the right and one unit down from the point where we are currently located. Most path drawing functions from the MBS FileMaker Plugin occur twice with this difference.
(more)
Check out the FileMaker Magazine website. Matt Petrowsky provides a huge collection of training videos around FileMaker. And recently he started a series of videos about our MBS Plugin:
Watch it on YouTube and subscribe to his channel.
Matt presents a few of our free enhancements for the FileMaker Pro development workspace for macOS.
(more)
Welcome to the 20th door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
Today I want to show you that with GraphicsMagick you can not only edit images, but we can also draw by ourselves. Today I will introduce you to the basic shapes.
To have a working environment on which we can work, we first use the GMImage.New function. This creates a working environment for us. We determine the size and the background color in the parameters. Here we draw a working environment of 500x500 pixels and a white background color.
Set Variable [ $GM ; Value: MBS( "GMImage.New"; "500x500"; "#FFFFFF" ) ]
We have several basic shapes available in the plugin:
- Line
- Circle
- Ellipse
- Rectangle
- Rounded rectangle
- Arc
I will show you these shapes one after the other.
(more)
Did you know, that you can run JavaScript in a WebViewer directly and get back the result right away?
In FileMaker Pro, Claris Pro and your FileMaker iOS SDK based app, you can use WebView functions from MBS FileMaker Plugin. Please take a look at the WebView.Evaluate function:
MBS( "WebView.Evaluate"; WebViewerRef; Expression )
You pass in the reference to the web viewer and whatever JavaScript expression you like to evaluate it. Just like the Evaluate() in FileMaker, but with JavaScript. If you name your WebViewer "web" on the current layout and you have a website loaded ("about:blank" is enough), you can run a calculation like this:
MBS( "WebView.Evaluate"; "web"; "1+2" )
The function returns the result 3 directly and as a number, not text. Use FM.DataType function to check that, if you like. Of course you can also return text or JSON objects. Just send them through JSON.stringify:
MBS("WebView.Evaluate"; "web"; "var obj = { name: \"John\", age: 30, city: \"New York\" };
JSON.stringify(obj);")
(more)
Welcome to the 19th door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
We have already seen in door 2 that we can query some information about an image. If we have photos, but also the metadata created by the device when taking the picture are very interesting. Today I want to show you how you can retrieve some of this information.
We use the functions GMImage.GetAttribute for this purpose. But before we start with this function I would like to introduce you to name related functions. On the one hand we have the GMImage.GetAttributesJSON function. It returns the attributes that have been created before as JSON.
Set Variable [ $JSON ; Value: MBS( "GMImage.GetAttributesJSON"; $GM ) ]
(more)
Welcome to the 18th door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
Do you think that our monkey is a bit pale around the nose? Today we want to change that, because we also have a function that can change the saturation of an image. The GMImage.Modulate function. But not only the saturation can this function influence but also the brightness of the image and the hue. So we can change the HSB values of an image. In the parameters we then specify the corresponding values. If one or more of these three values should not be changed in an image, then we write a 100 in the parameters. The 100 is the neutal value.
Set Variable [ $r ; Value: MBS( "GMImage.Modulate"; $GM; 100; 100; 100) ]
Brightness and saturation are relatively easy to understand if we set the brightness to a value greater than 100 then the image becomes brighter and if the value is less than 100 then it becomes darker. Similarly, if the saturation is greater than 100, the saturation will be higher, and if it is less than 100, the saturation will be lower. We can move within the value range from 0 to 200. With the Hue factor it is not so clear what we are actually doing. Here, too, the values move between 0 and 200. We are familiar from many programs that we can specify colors with the help of the color wheel.
(more)
Welcome to the 17th door of our advent calendar.
In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
Today it will be really colorful, at least today we want to try some backgrounds for our logo. Our original image has a red background.
(more)
Welcome to the 16th door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
Today I'll introduce you to the GMImage.Channel function that allows us to extract individual channels from an image. We have already seen in some effects that we can use individual channels, whether we want to apply blur or if we want to give the image a noise with red pixels. Channels are a great thing. Let's take a closer look at them. In the function GMImage.Channel we first specify the reference in the parameters and then the ChannelType. Each channel type is assigned a number which must be specified in the parameters. Here we see a list of channels that are available to us:
- RedChannel = 1
- CyanChannel = 2
- GreenChannel = 3
- MagentaChannel = 4
- BlueChannel = 5
- YellowChannel = 6
- OpacityChannel = 7
- BlackChannel = 8
- MatteChannel = 9
- AllChannels = 10
- GrayChannel = 11
(more)
Welcome to the 15th door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
Yesterday I introduced you to the Blur effect. Today I will show you the opposite effect: Sharpen. This effect sharpens your image. We use the GMImage.Sharpen function. Again we have the same parameters as with the Blur function. First our reference, then the radius which indicates from which area we use the information for the effect and our sigma which describes the effect in more detail.
Set Variable [ $r ; Value: MBS( "GMImage.Sharpen"; $GM ; 10; 10 ) ]
(more)
Welcome to the 14th door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
The GraphicsMagick functions also provides many effects that we can apply to our images. In the Advent Calendar we would like to introduce a few of these effects. Today I will introduce you to the Blur effect. With this effect you blur the image. You can use the function GMImage.Blur for this purpose. We can pass three different parameters to this function. First of all again our reference, then the Radius of the Gaussian that means we specify the size of the radius from which we get our information for the respective pixel.
We also specify the value Sigma, which is the standard deviation of the Laplacian.
Set Variable [ $r ; Value: MBS("GMImage.Blur"; $GM; 50; 10) ]
The Blur effect is influenced by the combination of the last two parameters, so you can vary these two parameters to your taste.
Here are examples of the variation of values.
(more)
New in this prerelease of version 12.6 of the
MBS FileMaker Plugin:
Download at
monkeybreadsoftware.com/filemaker/files/Prerelease/, in
DropBox folder or ask for being added to the DropBox shared folder.
The year 2022 will end in less than three weeks. Do you need some more licenses?
- You can order licenses for 2023 or later and have invoice, delivery and payment done in 2022.
This way you secure the current pricing and the possibility to keep upgradeability for older licenses. - And of course you can order updates for several years in advance for all your MBS products.
- As all our Xojo and DynaPDF plugin licenses are per developer, you should check if you got a new developer in your team this year and adjust licenses to match team size.
- For MBS FileMaker Plugin please check if you have enough license for the number of seats or servers you have in use.
If you upgrade to unlimited seats or servers, the plugin won't need to check the usage counts.
Especially if you run on a budget and you want to spend some money in the old year, you can buy updates for several years in advance.
If you need help to decide what Xojo, FileMaker or plugin license you need, we may be able to assist you.
Welcome to the 13th door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
The GraphicsMagick also provides many effects that we can apply to our images. In the Advent calendar we would like to introduce a few of these effects. Today I will introduce you to the Swirl effect. With this effect you can turn the center of your image. We use the function GMImage.Swirl for this purpose. In the parameters we can specify the reference and the angle by which the image should be rotated.
Set Variable [ $GM ; Value: MBS("GMImage.NewFromContainer"; GraphicsMagick Advent::Image) ]
Set Variable [ $r ; Value: MBS( "GMImage.Swirl"; $GM; -90 ) ]
Set Field [ GraphicsMagick Advent::Image ; MBS( "GMImage.WriteToContainer"; $GM ; "abc.png" ) ]
Set Variable [ $r ; Value: MBS( "GMImage.ReleaseAll" ) ]
(more)
Recently a client suggested to make a custom function to call CURL functions anywhere with just a function call. But instead of building a convenience function into the plugin, we provide you the recipe on how to make such a custom function, so you can change it.
Our function will do GET and POST with text in and out. That is the most requested case for various REST or SOAP web services. You may also add variations to return result as container to taking a container for upload or a file path as in- or output. So here is our easy script:
CURLExecute(URL, Post Text, HTTP Headers)
Let([
curl = MBS("CURL.New");
// put the URL in for this request
r = MBS("CURL.SetOptionURL"; curl; URL);
// and some headers if needed
r = MBS( "CURL.SetOptionHTTPHeader"; curl; HTTP Headers );
// for POST, we use post text. Keep it empty if you do GET.
r = If( Length(Post Text) = 0; ""; MBS("CURL.SetOptionPostFields"; curl; Post Text));
// run the request
r = MBS("CURL.Perform"; curl);
// we return text as result
result = MBS("CURL.GetResultAsText"; curl; "UTF8");
// and put debug log in global variable
$$debug = MBS("CURL.GetDebugAsText"; curl);
// free the object
r = MBS("CURL.Release"; curl)];
result)
(more)
Welcome to the 12th door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
The GraphicsMagick also provides many effects that we can apply to our images. In the Advent calendar we would like to present a few of these effects. Today I will show you the effect that turns your image into an oil painting. For this we use the function GMImage.OilPaint. Here we have the original image that we want to change.
(more)
Welcome to the 11th door of our advent calendar.
In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December.
Every day I will introduce you to one or more functions from this component.
In this component you will find functions with which you can analyze images,
convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
The GraphicsMagick also provides many effects that we can apply to our images.
In the Advent calendar we would like to introduce a few of these effects.
Today I will show you how to add a noise effect to your image. So we want to bring in a noise effect.
For this we have two functions that we can use. We have the simpler function GMImage.AddNoise which
adds a noise to the image which we can define in the parameters. We have a total of 6 noise types that we can specify.
- UniformNoise = 0
- GaussianNoise = 1
- MultiplicativeGaussianNoise = 2
- ImpulseNoise = 3
- LaplacianNoise = 4
- PoissonNoise = 5
In the parameters we specify the appropriate number. In this script line, for example, the noise type ImpulseNoise was selected.
Set Variable [ $r ; Value: MBS( "GMImage.AddNoise"; $GM; 3) ]
(more)
Welcome to the 10th door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
Today we want to write a text in our image. For this we use the function GMImage.Annotate. As in most functions, we first specify the reference, then the text follows. Optionally we can specify where exactly the text should be, the area we specify in the same way as in door 7 for the image section. First the size in pixels and then the x and y offset ( widthxheight+offsetX+offsetY ). We can also set the text alignment. Last but not least, we can even specify that the text should be rotated by a certain number of degrees. If you want you can set not only the text, but also the font, the color of the text, the font size, the color of the text border and the thickness of the text border. For these individual settings we have one function each. It is best if we look directly at the sample code together.
Set Variable [ $GM ; Value: MBS( "GMImage.NewFromContainer"; GraphicsMagick Advent::Image) ]
Set Variable [ $r ; Value: MBS( "GMImage.SetFont"; $GM; "Georgia" ) ]
Set Variable [ $r ; Value: MBS( "GMImage.SetFillColor";$GM; "#FF0000" ) ]
Set Variable [ $r ; Value: MBS( "GMImage.SetLineWidth"; $GM; 2) ]
Set Variable [ $r ; Value: MBS( "GMImage.SetStrokeColor"; $GM; "#287233") ]
Set Variable [ $r ; Value: MBS( "GMImage.SetFontPointsize"; $GM; 100 ) ]
Set Variable [ $Width ; Value: MBS( "GMImage.GetWidth"; $GM ) ]
Set Variable [ $r ; Value: MBS( "GMImage.Annotate"; $GM; "Merry Christmas"; $Width&"x200+0+20"; "CenterGravity"; -10) ]
Set Field [ GraphicsMagick Advent::Image ; MBS( "GMImage.WriteToContainer"; $GM ; "abc.png" ) ]
Set Variable [ $r ; Value: MBS( "GMImage.ReleaseAll" ) ]
(more)
Welcome to the 9th door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
Today I'm going to tell you a little bit about a function that is quite inconspicuous, but once provided me with great services. I got from a customer at the very beginning of my FileMaker time the order that I should sort out all pages from a scanned PDF file that are empty. I accepted the order and thought, that can't be difficult, there must be a simple function you can use to detect if the page is empty or not. What can I say it wasn't that easy and I was thinking for a long time about how to do it until I found the GMImage.AveragePixelValue function. This function gets the average color value of pixels in an image or a certain area which can be defined with optional parameters in the function.
(more)
Today we like to show you how to use our WebHook functions in MBS FileMaker Plugin to listen for incoming requests and send them from another place within the reachable network. Since a VPN and tunnelling can extend the range, you may even trigger from a FMP in one country to a FMP in another country. You may have various uses of triggering a script within the network.
For example you may have a need to trigger a script on another FileMaker Pro to do something for you. That may be to remotely start a batch process, which takes a while. You may not have our plugin in FileMaker Go, but you can trigger a script on a FileMaker Pro to do something like cropping a picture. Or the FileMaker Go may enter data for an invoice. Then it could send a request to a FileMaker Pro to print that invoice after it is finished.
Let us start with creating a web hook locally in one FileMaker Pro. We request to keep connections open and disable auto answer. Then we bind to a new random port here. We set the script to trigger and finally query the port number we got. Then we write this in a record, so others can read this configuration value to send something. Since the port is random, it changes each time our FileMaker Pro launches. Here is the script:
Set Variable [ $$WebHooks ; Value: MBS("WebHook.Create") ]
# we need to keep connection open
Set Variable [ $r ; Value: MBS("WebHook.SetMode"; $$WebHooks; 1) ]
Set Variable [ $r ; Value: MBS("WebHook.SetAutoAnswer"; $$WebHooks; "") ]
# listen on random port
Set Variable [ $r ; Value: MBS("WebHook.Listen"; $$WebHooks; 0) ]
# set script to run
Set Variable [ $r ; Value: MBS("WebHook.SetScript"; $$WebHooks; Get(FileName); "WebHookReceived") ]
#
# now show IP and Port
Set Field [ Listener::Port ; MBS( "WebHook.GetPort"; $$WebHooks ) ]
Set Field [ Listener::My IP ; Get(SystemIPAddress) ]
Commit Records/Requests [ With dialog: Off ]
(more)
Welcome to the 8th door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
Today I would like to show you how to convert your image into a black and white image or how to display it in grayscale. Let's start with the grayscale. For this we use the function GMImage.SetType. This function sets the repression type of the image. We can specify the following values:
- UndefinedType = 0
- BilevelType = 1
- GrayscaleType = 2
- GrayscaleMatteType = 3
- PaletteType = 4
- PaletteMatteType = 5
- TrueColorType = 6
- TrueColorMatteType = 7
- ColorSeparationType = 8
- ColorSeparationMatteType = 9
- OptimizeType = 10
(more)
New in this prerelease of version 12.6 of the
MBS FileMaker Plugin:
- Added new Get() function names in FileMaker 19.6 for our links in calculations.
- Updated Plugin SDK or FileMaker 19.6.
- Added DynaPDF.CreateICCBasedColorSpace and DynaPDF.CreateICCBasedColorSpaceContainer.
- Fixed a problem with iOS plugins missing the version number.
- Fixed problem with Schedule functions with storing result from evaluate.
- Added WebRequest.GetMode function.
- Changed variable check to disable while scrolling on macOS Ventura with multi line comments in use to avoid layout trouble.
- Changed FM.SQL.Text and FM.SQL.CSV functions to return empty text if there are no rows and no row parameter.
- Changed JSON.SetPathItem to do nothing if value is empty (like v12.4 and before).
- Updated DynaPDF to version 4.0.70.201.
- Changed JSON parser to skip non breaking spaces like regular spaces.
- Fixed a memory leak in LDAP.AddJSON and LDAP.ModifyJSON and added additional checks for the passed in JSON.
Download at
monkeybreadsoftware.com/filemaker/files/Prerelease/, in
DropBox folder or ask for being added to the DropBox shared folder.
Welcome to the 7th door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December.
Every day I will introduce you to one or more functions from this component.
In this component you will find functions with which you can analyze images, convert them,
change them with filters, draw them and much much more.
In the end, you too can take the magic of GraphicsMagick to your images.
I wish you a lot of fun in the process.
Today I want to show you how to crop an image.
For this we use the GMImage.Crop function.
This function returns an image section that you have to define in the parameters before.
As with the other functions, we first specify the reference and then a geometry.
The geometry describes the cut-out from the image.
First we can define how big such a section should be - again in pixels.
First the width and then the height which we separate from each other with an x. But now we don't only
want to define the size of the section, but also the position.
For this reason we have to set the offsets for X and Y in addition to the size information.
The offsets determine the distance from the upper left edge.
If we set a value for X we move away from the side edge, if we set a value for Y we move away from the top border.
These two values can be appended with a plus.
We will make an example now.
We would like to crop the image so that it is square and shows the center of the image.
Here we see the code:
(more)
After the
SMTP with OAuth for Office 365 in FileMaker article we got some feedback from you guys.
Scope
First there is the question about the scope of the token and how to use this for IMAP. So the scope string lists various identifiers separated by a space character and a few of those identifiers are URLs. You can lookup them in the documentation from Microsoft, but we have a few common ones:
Only SMTP:
Set Variable [ $scope ; Value: "https://outlook.office365.com/SMTP.Send"
Only IMAP:
Set Variable [ $scope ; Value: "https://outlook.office365.com/IMAP.AccessAsUser.All"
IMAP and SMTP:
Set Variable [ $scope ; Value: "https://outlook.office365.com/SMTP.Send https://outlook.office365.com/IMAP.AccessAsUser.All"
More with POP3 and profile data and offline access:
Set Variable [ $scope ; Value: "openid profile offline_access https://outlook.office365.com/SMTP.Send https://outlook.office365.com/POP.AccessAsUser.All https://outlook.office365.com/IMAP.AccessAsUser.All"
It may be good to keep this narrow and maybe only ask for SMTP most times so the user is not frightened that for sending emails you also need to read all their existing emails.
(more)
Welcome to the 6th door of our advent calendar.
In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December.
Every day I will introduce you to one or more functions from this component.
In this component you will find functions with which you can analyze images,
convert them, change them with filters, draw them and much much more.
In the end, you too can take the magic of GraphicsMagick to your images.
I wish you a lot of fun in the process.
Today we want to rotate the image and for this we use the function GMImage.Rotate.
In the parameters we first specify the reference and then the number of degrees by which we want to rotate the image.
The image will be rotated clockwise if the degree is positive and counterclockwise if the degree is negative.
In our example file, I have included two buttons that rotate the image clockwise and counterclockwise.
Both buttons call the same script. When pressing the buttons, different script parameters are passed,
so we know which button was pressed.
Clockwise passes the 0 and counterclockwise passes the 1. By how many degrees we want
to rotate the image we specify in the appropriate field. The script looks like this:
Set Variable [ $direction ; Value: Get(ScriptParameter) ]
If [ $direction=1 ]
Set Variable [ $degrees ; Value: Abs ( GraphicsMagick Advent::RotationDegree )*-1 ]
Else
Set Variable [ $degrees ; Value: Abs ( GraphicsMagick Advent::RotationDegree ) ]
End If
Set Variable [ $GM ; Value: MBS("GMImage.NewFromContainer"; GraphicsMagick Advent::Image) ]
Set Variable [ $r ; Value: MBS( "GMImage.Rotate"; $GM; $degrees ) ]
Set Field [ GraphicsMagick Advent::Image ; MBS( "GMImage.WriteToContainer"; $GM ; "abc.png" ) ]
Set Variable [ $r ; Value: MBS( "GMImage.Release"; $GM ) ]
(more)
Welcome to the 5th door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
Today I would like to show you how you can scale an image according to your wishes. For this we use the GMImage.Scale function. In the parameters you have to enter the reference and a geometry. The geometry can look like the geometry we already know (width x height), but we can now also define other things in the geometry and are not limited to a fixed size of the image. So that you can try it yourself we have created a field in the sample file (This will be available on December 24) in which you can enter the geometry to test it. The script looks like this. We always load a fresh image from a file and then scale it with the function. In our container, the image is then scaled, we save the image there as usual and release the reference again.
Set Variable [ $GM ; Value: MBS("GMImage.NewFromFile"; "/Users/sj/Desktop/abc.png") ]
Set Variable [ $r ; Value: MBS( "GMImage.Scale"; $GM; GraphicsMagick Advent::GeometrieScal ) ]
Set Field [ GraphicsMagick Advent::Image ; MBS( "GMImage.WriteToContainer"; $GM ; "abc.png" ) ]
Set Variable [ $r ; Value: MBS( "GMImage.Release"; $GM ) ]
Let's first try the geometry we already know. I have entered 500x100 in the text field. The image is then scaled so that the smaller of the two values is assumed, so the image gets a height of 100 and the width is scaled proportionally. For example, if we were to specify 50 for the width and 100 for the height, then the image would adjust to the 50 and scale the height proportionally.
(more)
Check out the FMTraining.tv website. Richard Carlton and his team do a daily free live stream about FileMaker to watch.
A few days ago Christian Schmitz from Monkeybread Software joined a live episode to talk a bit about the MBS FileMaker Plugin. Watch it on YouTube.
We talk about how to build an iOS SDK App with the FileMaker iOS SDK and add the MBS Plugin later to it.
(more)
Welcome to the fourth door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
Today I will show you how to paint a border around an image. The focus is on the GMImage.Border function. This function again requires our reference.
Set Variable [ $r ; Value: MBS( "GMImage.Border"; $GM) ]
When we use the function like this, a gray fine border is drawn around the image by default. If the image is very large, as you can see here, it is not so noticeable.
(more)
Welcome to the third door of our advent calendar. In this advent calendar I would like to take you on a journey through the GraphicsMagick component in December. Every day I will introduce you to one or more functions from this component. In this component you will find functions with which you can analyze images, convert them, change them with filters, draw them and much much more. In the end, you too can take the magic of GraphicsMagick to your images. I wish you a lot of fun in the process.
So far we have requested information from images, But later in December we would like to change the images and would like to see this change when we put a filter on the image, for example. For this we need to be able to write the edited image which is in our working memory back to a file. How this works I will show you today.
First we think about where we want to have our file. Do we want to write it into a file or into a container, for both we need again different functions.
Let's start with the case that we want to write the image into a file. For this we use the function GMImage.WriteToFile. This function writes a single image to the disk in the parameters we specify the image reference and the path to which the image should be saved. If you want to let the user choose in a dialog where to save the file you can use the functions from the FileDialog component. With these functions you can customize your save dialog by adding a text, a heading and many other settings. After selecting a file we can then get the file path and save the image with the GMImage.WriteToFile function to the specified location. In the script example we have used such a dialog.
(more)
Check out the FMTraining.tv website. Richard Carlton and his team do a daily free live stream about FileMaker to watch.
A few days ago Christian Schmitz from Monkeybread Software joined a live episode to talk a bit about the MBS FileMaker Plugin. Watch it on YouTube.
We talk about what is new in MBS FileMaker Plugin 12.5. see also announcement, what's new and release notes.
(more)
Welcome to the second door of our advent calendar in this advent calendar.
I would like to take you on a journey through the GraphicsMagick component in December.
Every day I will introduce you to one or more functions from this component.
In this component you will find functions with which you can analyze images,
convert them, change them with filters, you can draw them and much much more. In the end,
you can also take the magic of GraphicsMagick to your images. I wish you a lot of fun with it.
Today I want to find out with you some information about the loaded images. We will start with the size of the images.
So we want to find out height and width.
First we load our image into memory as we saw it yesterday.
In our example there is a single image in the container.
Set Variable [ $GM ; Value: MBS("GMImage.NewFromContainer"; GraphicsMagick Advent::Image) ]
Now we can retrieve different information.
The width with the function GMImage.GetWidth and
the height with GMImage.GetHeight function.
The reference is passed to the functions in the parameters and we then get back the desired value.
Set Variable [ $Width ; Value: MBS( "GMImage.GetWidth"; $GM ) ]
Set Variable [ $Height ; Value: MBS( "GMImage.GetHeight"; $GM ) ]
(more)
New in this prerelease of version 12.6 of the
MBS FileMaker Plugin:
Download at
monkeybreadsoftware.com/filemaker/files/Prerelease/, in
DropBox folder or ask for being added to the DropBox shared folder.
Welcome to the first door of our advent calendar.
In this advent calendar I would like to take you on a journey through the GraphicsMagick component.
Every day I will present you one or more functions from this component.
In this component you will find functions with which you can analyze images,
convert them, change them with filters, draw on them and much much more.
In the end, you can also take the magic of GraphicsMagick to your images.
I wish you a lot of fun with it.
Today I will show you how to load an image from a file or container so that you can edit it in the later doors.
When loading an image we have the possibility to load it from a container.
For this we use the GMImage.NewFromContainer function.
We pass the container to this function in the parameters.
With this we load the image into the working memory and get a reference number as return which we can use in the other steps.
Set Variable [ $ref1 ; Value: MBS( "GMImage.NewFromContainer"; GraphicsMagick Advent::Image) ]
If we have an image file with multiple images in a container,
we have the function GMImage.NewImagesFromContainer that
gives us a list of reference numbers. Each image in the container is loaded into memory and has its own reference number.
Set Variable [ $ref2 ; Value: MBS( "GMImage.NewImagesFromContainer"; GraphicsMagick Advent::Image ) ]
The image cannot only be a container value, but also a file on your computer.
You can then load this via the file path.
We use the GMImage.NewFromFile function for this.
We specify the native path in the parameters.
If you have a FileMaker path, the path must first be converted to a native path. Then use the Path.FileMakerPathToNativePath function to do this.
If you want, you can optionally specify a codec here that will take care of decoding the image.
Set Variable [ $ref3 ; Value: MBS( "GMImage.NewFromFile"; "/Users/sj/Desktop/IMG_4420.jpeg"; "JPEG") ]
(more)
