FileMaker Conferences

Thursday 29 May 2014 at 9:34 pm
Currently I know those six conferences: Do you know more this year?

MBS Filemaker Plugin, version 4.2pr8

Tuesday 27 May 2014 at 11:09 pm
New in this prerelease of the 4.2 plugins:
  • Added Files.DeleteFolder function.
  • Updated DynaPDF library to version 3.0.33.92.
  • Added more DynaPDF functions.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Xojo/FileMaker Meetings in Vienna, Austria

Friday 23 May 2014 at 7:38 pm
The voting is done and we have final results:

Wednesday, 11th June, Xojo Developer Meeting
Thursday, 12th June, FileMaker Developer Meeting

Please save the date and we'll look for a room.
If you are interested in joining, please email me, so we know how many seats we need.
Meeting will be probably in a beer garden or restaurant somewhere near Vienna.

"Early Bird" Discount Ends June 3 for 2014 FileMaker Developer Conference

Wednesday 21 May 2014 at 09:53 am
If you plan to go, please use the early bird pricing to save $300.

MBS will be at the conference with a booth as well as 1000+ attendees.

MBS Filemaker Plugin, version 4.2pr7

Monday 19 May 2014 at 10:12 pm
New in this prerelease of the 4.2 plugins:
  • Added Background parameter for PDFKit.Watermark function.
  • Fixed PDFKit.Watermark function to use correct page size.
  • Added more DynaPDF functions.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Using Tiny URL web service

Saturday 17 May 2014 at 11:25 am
Today a FileMaker developer asked if we can use the tiny URL web service functions to create short URLs from FileMaker.
The answer is yes, we can. Here a sneak peak on the script. The example database will be included with next plugins:

The API is explained here and you can sign up for a developer key here.

The script itself is not that difficult. First we start a new CURL transfer and set a lot of options. This includes setting up a form with the various parameters for the service. Than we perform transfer and show debug and result texts in some fields for debugging. Once we closed transfer, we can parse the result json and get the state and the url. If state is not okay, we show dialog with error, else we got our short URL.

PS: This would work similar from Xojo, too.

Going to Vienna in Austria

Thursday 15 May 2014 at 12:23 pm
In June, I travel to vienna and I think this is great opportunity to have some parties.
So I plan to organize a FileMaker and a Xojo developer meeting.
I started two surveys to find the best days in the week:

Xojo Developer Meeting   FileMaker Developer Meeting

If you like, please vote for a day if you like to come.

MBS Filemaker Plugin, version 4.2pr6

Wednesday 14 May 2014 at 11:06 am
New in this prerelease of the 4.2 plugins:
  • Added Twain.IsInitialized, OCR.IsInitialized, DynaPDF.IsInitialized and XL.IsInitialized.
  • Fixed DynaPDF.RenderPage to pass right file name with image.
  • Added more checks to avoid the plugin to return too big data in container.
  • Added DynaPDF.GetCharacterSpacing and DynaPDF.SetCharacterSpacing.
  • Updated DynaPDF library to version 3.0.33.91.
  • Added field Platform for Audit, so you can record where log was written.
  • For missing variables, we now explicit show message after line with text like this: $r not found!
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Audit with MBS Plugin and FileMaker Server, works with FileMaker go!

Tuesday 13 May 2014 at 3:10 pm
Recently in our FileMaker training day there was an interesting question. If we trigger the plugin function through a script on a server, would that perform the Audit calculations on server? Running it on server would avoid a lot of remote SQL queries and be much better for performance.

So if you like to host database on server and have Audit log being updated from all devices, you can do this steps:

First you create the AuditLog table like usually. You add text fields for FieldName, FieldHash, RecordID, TableName and FieldValue. If you like add more like HostName, FieldOfdValue, Platform, UserName, LayoutName or something from the list in documentation. This table must be in same database.

Next you create two scripts per table to watch. First script calls second script with "Perform Script on Server" script step. This script does not need to wait for the other script to finish.

The second script performs the actual Audit call. For this you only need a script step "Set Variable" with the audit calculation: MBS( "Audit.Changed"; Get(CurrentHostTimestamp); "Projects"). Projects is here the name of the table. You can of course include or exclude fields like normal audit handling. If you like, you can pass some extra details using script parameter and use them in this script to log extra information. For that you can for example pass an extra parameter with "Info|" & Get ( ScriptParameter ) to fill the parameter's value into a field named Info.

To actually get something running, you now define for each layout a trigger which calls the first script. So for the trigger OnRecordCommit you choose the script and FileMaker calls the script. The script than performs the other script on server which does the Audit operation. Performance is great here, even from iPad with FileMaker Go 13. If you like you can also have the script perform when user moves to layout or leaves layout.

Please try it. If it works for you, you should see new audit logs being written from FileMaker Pro, Filemaker Go and WebDirect. In the sample project we log in Info field the answer from Get(SystemPlatform), so we record 4 for web direct, 3 for FileMaker Go and 1 for FileMaker Pro on Mac.

There are differences when doing audit on server. Platform on the server is always ServerScripting. The hostname is of course the name of the server. The user name contains the name of script, the login name and and ID. The host IP and time stamps are of course those from the server, not the client.

A new example project and newer plugin is available tomorrow with the next prerelease.

New Text for unknown variables in scripts

Monday 12 May 2014 at 09:50 am
For next FileMaker plugin we now added a little text to the script when we detect an unknown variable:



Without plugin, it just looks like this:



To activate the variable name checks for scripts, you need to first have a Mac, second install the plugin and third execute MBS( "SyntaxColoring.CheckVariableDeclaration.Enable" ) once.

We hope it helps debugging scripts if you see that you have typos in variable names for local variables.

MBS Filemaker Plugin, version 4.2pr5

Saturday 10 May 2014 at 09:55 am
New in this prerelease of the 4.2 plugins:
  • Updated DynaPDF library to version 3.0.33.90.
  • Changed FM.ExecuteSQLOnIdle to set FM.ExecuteSQL.LastError to -1 until the SQL was performed.
  • Updated default rule set for syntax coloring. Now includes french. Use SyntaxColoring.FactoryDefaults function if you like to reset.
  • Added Midi functions.
  • Fixed a problem with TWAIN plugin crashing on HP scanner (especially with a Deskjet 2540 where it now works).
  • Added Window.GetTopMost and Window.SetTopMost.
  • Added wrap parameter to String.ReplaceNewline function.
  • Added DynaPDF.AddValToChoiceField, DynaPDF.CreateGroupField, DynaPDF.GetBorderStyle, DynaPDF.SetBorderStyle, DynaPDF.CreateComboBox, DynaPDF.CreateCreateListBox, DynaPDF.CreateSigField, DynaPDF.CreateSigFieldAP and DynaPDF.CreateRadioButton.
  • Added Process.FrontProcessBundleID function.
  • Changed how function return numbers. Integers are returned as 32bit signed integer if fit, else as double.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

FileMaker's native MD5 function

Tuesday 06 May 2014 at 3:34 pm
Recently Todd Geist reported on his blog that FileMaker has a native MD5 calculation function using:

GetContainerAttribute( "FileMaker 13" ; "MD5" )

Text encoding used seems to be UTF-8, but I don't think FMI specifies that.
If you need more hash functions or options, you can of course check our plugin hash functions.

Dash/Zeal help browsers

Monday 05 May 2014 at 11:37 pm
We have for some time now support for the Dash application as a help browser.

And there is also available for Windows and Linux here: Zeal

So here you can click to launch Dash or Zeal and install our plugin help:
MBS Xojo Plugin and MBS FileMaker Plugin

Our next FileMaker events

Monday 05 May 2014 at 1:46 pm
You like to talk directly with us about MBS Plugins?
On the following events you can learn more about our plugins:

Archives

Feb 2017
Jan 2017
Dec 2016
Nov 2016
Oct 2016
Sep 2016
Aug 2016
Jul 2016
Jun 2016
May 2016
Apr 2016
Mar 2016
Feb 2016
Jan 2016
Dec 2015
Nov 2015
Oct 2015
Sep 2015
Aug 2015
Jul 2015
Jun 2015
May 2015
Apr 2015
Mar 2015
Feb 2015
Jan 2015
Dec 2014
Nov 2014
Oct 2014
Sep 2014
Aug 2014
Jul 2014
Jun 2014
May 2014
Apr 2014
Mar 2014
Feb 2014
Jan 2014
Dec 2013
Nov 2013
Oct 2013
Sep 2013
Aug 2013
Jul 2013
Jun 2013
May 2013
Apr 2013
Mar 2013
Feb 2013
Jan 2013
Dec 2012
Nov 2012
Oct 2012
Sep 2012
Aug 2012
Jul 2012
Jun 2012
May 2012
Apr 2012
Mar 2012
Feb 2012
Jan 2012
Dec 2011
Nov 2011
Oct 2011
Sep 2011
Aug 2011
Jul 2011
Jun 2011
May 2011
Apr 2011
Mar 2011
Feb 2011
Jan 2011
Dec 2010
Nov 2010
Oct 2010
Sep 2010
Aug 2010
Jul 2010
Jun 2010
May 2010
Apr 2010
Mar 2010
Feb 2010
Jan 2010
Dec 2009
Nov 2009
Oct 2009
Sep 2009
Aug 2009
Jul 2009
Apr 2009
Mar 2009
Feb 2009
Dec 2008
Nov 2008
Oct 2008
Aug 2008
May 2008
Apr 2008
Mar 2008
Feb 2008