OCR for Real Studio and Filemaker

Today we added OCR functions for our Filemaker plugin. The example looks like this:

We use tesseract3 as engine and provide the plugin functionality for both Real Studio and Filemaker with our latest plugins. Basically you simply give it an image and ask for the text. For better results you should check the options like defining the page segmentation mode or an rectangle of interest.
The results in first tests of some users are less than optimal. Mostly because they use the wrong options. Like for a business card, the default page segmentation mode is wrong. Single Block mode does not work well with multi column texts or mixed texts like in a business card. Better use Auto mode here.
Next you need to make sure you have the best image. We recommend at least 150 dpi, better 300 dpi. And if you have RGB or Grayscale. B/W is often not so good. Internally tesseract applies some filters and converts itself to black and white later. But the result with RGB or grayscale is normally better if you let tesseract convert the colors. Using an image with poor resolution can cause tesseract to not recognize anything at all.
Finally you have to choose a language. The reason is that the engine has been trained with demo text from a given language. You can of course create your own file here. If you don't know the language you can simply try with all packs you want to support and pick the result with best confidence.

You find documentation here for Filemaker and here for Real Studio.
We hope you have fun adding OCR functionality to Real Studio and Filemaker solutions. If you have questions, please do not hesitate to contact us.

MBS Filemaker Plugin, version 2.9pr4

New in this prerelease of the 2.9 plugins:
  • Added new OCR functions.
  • Fixed a bug with GraphicsMagick functions error handling for loading an image.
  • Performance improvements for Audit function. Some values like UserName are only queried once per record instead of per field.
  • Fixed Window.Resizable for Filemaker 12.
  • Improved Audit functions to make them a little bit faster.
Download later today at monkeybreadsoftware.de/filemaker/files/Prerelease/.

Audit Tip for Importing

Have you checked our Audit functions? (see Documentation and introduction tutorial)

If you import a lot of records in a database, the Audit function can slow down the import process a lot. Because for each field, Filemaker triggers the plugin and we record all the changes while importing. This is not necessary. So when import and you see this dialog, please make sure the checkbox is not marked:

Now you import and the plugin does not record changes while importing, so it's very fast.
To inform the plugin about your changes and to log them, you now loop over the imported records and call the Audit.Changed function for each record. You can easily find the imported records by checking the AuditState field as it has no value. Use a Set Field script step to set the AuditState field with the result to calling Audit.Changed with the same parameters as in your table definition.
Now the plugin has all entries logged, so it can keep history and you have old values on changes for a later undo/restore operation.

Licenses per developer

Do you work alone or do you have several developers working with Real Studio or Filemaker?
Well, not sure if you know, but the license from Real Software is given per developer. So if you have three people working with Real Studio, you also need three licenses.
The rules are similar for Filemaker products, but you often have volume licenses for using Filemaker in bigger companies.

For our plugins, we also sell licenses per developer. We do not count which platform you use or if you have several desktop and/or laptop computers.

Also you should know that for businesses the Mac App Store sells software per user. So a company needs to have several licenses of Mac OS X 10.8, one for each user. But for the Mac Developer Programm members, the Mac OS X licenses are included as far as I see and covered for all Macs you use for development/testing. A private consumer only needs one license for all of his computers.

Licensing is not always easy and if you have questions or we can assist you, please contact us.

Accept file drops in Filemaker with MBS Plugin

This tutorial is about accepting file drops on a Filemaker window with MBS Filemaker Plugin and performing a script. We create a little database with fields FileName and FileSize. The setup looks like this in Filemaker 12:
(more)

MBS Filemaker Plugin, version 2.9pr3

New in this prerelease of the 2.9 plugins:
  • Added Files.AccessDate, Files.CreationDate, Files.FileDisplayName, Files.FileKind, Files.FileName, Files.FileUTITypes and Files.ModificationDate.
  • Changed Files.FileSize to give on Mac also data- or resourcefork size and either logical or physical size.
Download later today at monkeybreadsoftware.de/filemaker/files/Prerelease/.

MBS Filemaker Plugin, version 2.9pr2

New in this prerelease of the 2.9 plugins:
  • Fixed bug in internal text encoding conversion. Affected several functions like the XL functions and on Windows the File Dialogs, File functions, Preferences and fonts.
Download later today at monkeybreadsoftware.de/filemaker/files/Prerelease/.

Introducing Filemaker Runtime Shrinker

With our 2.9pr1 plugin we included the Filemaker Runtime Shrinker for Mac OS X. Download it on our prerelease plugin download page. This is a little tool which can shrink your Filemaker runtimes significantly.
The main window looks like this:

Left Filemaker 11, right Filemaker 12.

As you see we have 4 options:
  • First you can remove PPC code. As Filemaker does not even run on PowerPC based Macs, you can safely remove the old PPC code. It's not needed and we are not sure why Filemaker actually does include it in the first place.
  • Second, we remove duplicate libraries. Yes, the runtime contains a few shared libraries several times and it works fine if you remove the duplicates.
  • Third, there are some icon files in the runtime which are not assigned to file types, so the operation system will never use them. You can remove them easily with this option.
  • Finally you can reduce the number of languages you support.
When we click the shrink button with all options and leaving only one language, we get the runtime smaller and the result dialog:


As you see we save 95 MB (64%) for a Filemaker 11 runtime here and 85 MB (55%) for a Filemaker 12 runtime.

We already had questions for a Windows version. Filemaker runtimes on Windows include a lot of DLLs and all are required as far as we see. You still can yourself delete some localization files if you like. Also you don't need to include the Microsoft Runtime folders on Windows 7 as far as we see. Those libraries do ship with Windows 7, but please test that yourself.

Please give it a try and if you have questions, please do not hesitate to ask us.
if you want to share this news with friends, please point them to our website/blog so they can download the latest version. This app will probably need updates regularly for newer versions of Filemaker. And I hope Filemaker Inc is not upset with us providing this tool.

1000 tweets!

If you follow us on twitter, you may have seen it: We now have a tweeted a 1000 times.

To keep in touch with updates and news, you can follow us on twitter, watch our page on Facebook, subscribe the RSS feed or look on our blog regularly.

MBS Filemaker Plugin, version 2.9pr1

New in this prerelease of the 2.9 plugins:
  • Added Runtime Shrinker application.
  • Added Math.NumberToText and Math.TextToNumber.
  • Fixed debug output from Trace so it works on Mountain Lion.
  • Added new XL methods for using libxl to read text from Microsoft Excel files.
  • Added new PDFKit methods.
Download later today at monkeybreadsoftware.de/filemaker/files/Prerelease/.

Filemaker Magazine Article with MBS Plugin

With the last Filemaker Magazine they included an article from me about how to use file dialog functions from MBS plugin.

With a little image database, we import images and batch export them later. With the plugin you can define initial folder or customize the dialog with different captions or titles. Also you can ask the user for file, folder or even both.

The article is in german and currently we have no translation to english.

Download PDF: fmm_201203_30-31.pdf

ChartDirector everywhere

You probably know that we have a Real Studio plugin with ChartDirector. Now if you look into Filemaker, you'd notice that charts there are made using ChartDirector, too.
Amazing, isn't it?

in two months: Filemaker Conference 2012 in Salzburg

Just two months left until the great conference takes off!

Your chance to meet over 100 filemaker developers from Europe. Also you can meet people from Filemaker, Inc and of course you can talk to me and learn about our plugin.

For more details, please check the filemaker-konferenz.de website.

With the coupon code "mbsplugin", you get a 10 Euro discount on the conference ticket.

MBS FileMaker Plugin 2.8 for OS X/Windows - More than 1100 Functions In One Plugin

Nickenich, Germany - MonkeyBread Software today is pleased to announce MBS FileMaker Plugin 2.8 for Mac OS X or Windows, the latest update to their product that is easily the most powerful plugin currently available for FileMaker Pro. As the leading database management solution for Windows, Mac, and the web, the FileMaker Pro Integrated Development Environment supports a plugin architecture that can easily extend the feature set of the application. MBS FileMaker Plugin 2.8 has been updated for Filemaker 12 and now includes 1100 different functions, and the versatile plugin has gained more than 100 new features:

With our new Audit functions you can log all changes on a database in a log table. This way you always know who edited what value in what table. And you can restore the old state if needed. On normal workflow the performance cost is not noticeable.

For Mac OS X 10.8 you can now send notifications to the new notification center. For example for reminders or to report status for background activity. With a runtime you can have your runtime launched when the notification was clicked. And if your solution is running, you can receive a script call when the notification was shown to your user.

New RemoteControl functions allow you to move the mouse programmatically and press the mouse buttons. Also you can press keys and on Windows enumerate all windows on the system. This functions can help you scripting other applications.

New file functions allow you to copy, move and rename files and folders. Of course you can also move files/folders to the trash. And using Files.List function you learn what files and folders exist in a given folder.

Read about all changes in detail in the release notes on our website. Please also take time to check our more than 100 example databases showing you the functionality of our plugin.

Filemaker Magazine

The Filemaker Magazine (in German) published a new issue today and it features an article from me about our MBS Filemaker plugin.

Included is an article from us about using our MBS Plugin to show file dialogs. First we show you how to select a file using the plugin and importing it. Than we show you how to select a folder for export and export all images in a table into the folder.
If you have questions, please do not hesitate to ask us.

Also if you have time to come to Austria in October, don't miss the Filemaker conference in Salzburg. 11th to 13th October 2012.

MBS Filemaker Plugin, version 2.8fc

New in this prerelease of the 2.8 plugins:
  • Added String.AppendTextFile function.
Download later today at monkeybreadsoftware.de/filemaker/files/.

MBS Filemaker Plugin, version 2.8pr10

New in this prerelease of the 2.8 plugins:
  • Added CURL.GetInputAsText function. (For Email with Attachments example)
  • Ported project to Xcode 4.4 on Mac OS X 10.8. We only had to update screen functions.
  • Changed Audit functions to take name of fields to ignore directly.
Download later today at monkeybreadsoftware.de/filemaker/files/.

Introducing Audit Plugin Functions for Filemaker

Sometimes people want to know who edited which record when and what values changed. All this questions can be solved with an audit log and our plugins. The idea is simple: Whenever someone changes something, we write a records for those changes to the AuditLog. Later you can check the log or have a script restore the changes.

The MBS Filemaker Plugin 2.8 introduces a few new Audit functions.

To show you how it works, we add Audit Logging to one of the starter solutions, the Event Management database. First we go and create a new table named AuditLog. This table can be in a different database file if needed as long as the plugin can find a table with that name. But in all cases, we need you to have a layout for the AuditLog table. It's not required to be user visible, but the plugin needs to find it.


Next we create a couple of fields. Required for the plugin are FieldName, FieldHash, TableName, RecordID. So we can store which table and which field changed. RecordID is the unique ID of the record and FieldHash stores a hash value for the content of the field. Optionally you can add more fields: FieldValue, FieldOldValue, FieldType, UserName, IP, CurrentTimestamp, TimeStamp, CurrentTime, CurrentDate, Action, CurrentHostTimeStamp, PrivilegeSetName, AccountName, LayoutNumber, ApplicationVersion, FileName, HostApplicationVersion, HostName, HostIPAddress, LayoutName, PageNumber, LayoutTableName, TableID, FieldID and WindowName. In this example we added FieldValue and FieldOldValue, so we know the new and old values for the change. The action field stores what happened and FieldType can tell us what data type we have for the value.
You can later add more fields if you like. The plugin dynamically detects them and fills them with values. Like if you need to know the IP of the user, simply add a new IP field and all new log entries record the IP addresses.


Now we can check all the tables in the database. For each we create two fields. First AuditTimeStamp with the timestamp when record was last modified. And second the AuditState calculated field which calls our plugin. The fields do not need to have exact this names. But if you don't use the default names, you have to change them everywhere and inform the plugin.


Here you see the definition for the time stamp field. We check the checkbox to store here the record modification timestamp. Filemaker will update this field automatically every time the record changes.
We typically do not allow the user to edit the Audit fields.


We define the AuditState field. Simply a text field which is calculated. Also make sure the checkbox "Do not replace existing value of field (if any)" is unchecked.
Here we also declare that user should not edit the field.


In the calculation for the AuditState field, we call the plugin: MBS( "Audit.Changed"; AuditTimeStamp; "Contacts" ). As you see we call the Audit.Changed function and pass the time stamp field from above. Third parameter is the name of the table. Filemaker simply does not tell the plugin what name the current table has, so we need to pass it here. If the table contains fields which you don't want to be logged or you have given AuditState/AuditTimeStamp fields a different name, you should pass them here as additional parameters. So for example you can call MBS( "Audit.Changed"; AuditTimeStamp; "Contacts"; "myAuditState"; "myTimeStamp"; "internalField" ). This way the plugin will not log those three fields. Unstored calculations and global fields are never logged. With the function Audit.SetIgnoredFieldNames you can globally define which fields you want to ignore always.


When all tables have been prepared, you can use the database. As you see, the first time the plugin sees a record, it writes log entries with "Create" as action. Next time you touch the record, you see "Change" entries for all the changes you made.
You can later add more fields to be logged like UserName or WindowName.

With Audit.Delete function you can also log deletion of records. But that is a topic for another blog entry.

If you have questions, please do not hesitate to contact us.

Archives

Mar 2024
Feb 2024
Jan 2024
Dec 2023
Nov 2023
Oct 2023
Sep 2023
Aug 2023
Jul 2023
Jun 2023
May 2023
Apr 2023
Mar 2023
Feb 2023
Jan 2023
Dec 2022
Nov 2022
Oct 2022
Sep 2022
Aug 2022
Jul 2022
Jun 2022
May 2022
Apr 2022
Mar 2022
Feb 2022
Jan 2022
Dec 2021
Nov 2021
Oct 2021
Sep 2021
Aug 2021
Jul 2021
Jun 2021
May 2021
Apr 2021
Mar 2021
Feb 2021
Jan 2021
Dec 2020
Nov 2020
Oct 2020
Sep 2020
Aug 2020
Jul 2020
Jun 2020
May 2020
Apr 2020
Mar 2020
Feb 2020
Jan 2020
Dec 2019
Nov 2019
Oct 2019
Sep 2019
Aug 2019
Jul 2019
Jun 2019
May 2019
Apr 2019
Mar 2019
Feb 2019
Jan 2019
Dec 2018
Nov 2018
Oct 2018
Sep 2018
Aug 2018
Jul 2018
Jun 2018
May 2018
Apr 2018
Mar 2018
Feb 2018
Jan 2018
Dec 2017
Nov 2017
Oct 2017
Sep 2017
Aug 2017
Jul 2017
Jun 2017
May 2017
Apr 2017
Mar 2017
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