Our Blog, Filemaker only, Xojo only, Archive (older), Follow us on Twitter, Xing, LinkedIn or Facebook.


FileMaker DevCon 2017 with MBS booth

Sunday 26 February 2017 at 12:46 pm


See you in Phoenix Arizona for the FileMaker Developer Conference, 24th to 27th July 2017.
MBS will be present with a booth in the vendor area. If you like to join the conference, be sure to buy your ticket till 28th February for the best price.

A Calendar running in WebViewer in FileMaker

Friday 24 February 2017 at 3:27 pm
On a recent trip to Switzerland I had a training day and spontaneously we created an example project using a JavaScript based calendar in a WebViewer.
We use a lot of MBS Plugin functions to initialize this and run the JavaScript.

Calendar in FileMaker with MBS Plugin

While we will include it with next plugins in examples, this is only half done. So take the chance to learn and see how you can call JavaScript and catch events.

Next trainings:

MBS FileMaker Plugin, version 7.1pr3

Wednesday 22 February 2017 at 3:23 pm
New in this prerelease of the 7.1 MBS FileMaker Plugin: Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder. PS: Due to an oversight, this pr3 plugin has 2 as version number.

Create PDF with Embedded Links in FileMaker using MBS Plugin

Wednesday 22 February 2017 at 10:00 am
One of our plugin users, Kevin Frank, wrote a nice article on his filemakerhacks blog about using embedded links in a PDF document.

With FileMaker you can create PDFs from your records. Using DynaPDF functions in MBS Plugin you can merge several PDFs, but how to do a table of contents page?
Kevin explains how he uses our plugin to add the clickable links on the first page with the list of topics, so each click jumps to the right page.

Read yourself here: filemakerhacks.com/2017/02/21/pdf-with-embedded-links/

Thanks for sharing and for asking for more functions. You need plugin version 7.0 or later for the example.

Using Apple's Global Service Exchange web service in FileMaker

Tuesday 21 February 2017 at 3:42 pm
Quite a few Apple shops use FileMaker and/or Xojo for their development of in-house tools. A common request is to use Apple's webservices to query warranty status. So today I want to show some scripts on how to do this. First of course you have to ask Apple for a GSX login which may require some paperwork. Next you need to white list your static IP for their webservice and get the credentials.
 
You request a certificate from Apple, so you generate a private key. The tricky key is to copy the private key with the certificate into one pem file. This pem file is than used wiht our script. Also please download a standard cacert.pem file with root certificates.
The first script logs into the webservice from Apple. We pass the user id and service account id in the login request. 
 
#Parameters

Set Variable [$path; Value:"/path to files/"]

Set Variable [$userid; Value:"xxx"]

Set Variable [$serviceAccountNo; Value:"yyy"]

Set Variable [$PrivateKeyPassword; Value:"secret password"]

#Build the XML

Set Variable [$xml; Value:GSX::Login XML Template]

Set Variable [$xml; Value:Substitute($xml; "$userId$"; MBS("Text.EncodeToXML"; $userid))]

Set Variable [$xml; Value:Substitute($xml; "$serviceAccountNo$"; MBS("Text.EncodeToXML"; $serviceAccountNo))]

#Start curl session

Set Variable [$curl; Value:MBS("CURL.New")]

Set Variable [$r; Value:MBS("CURL.SetOptionURL";$curl; "https://gsxapi.apple.com:443/gsx-ws/services/emea/asp")]

#We use a PEM file with private key and our certificate

Set Variable [$r; Value:MBS("CURL.SetOptionSSLCertType"; $curl; "PEM")]

Set Variable [$r; Value:MBS("CURL.SetOptionKeyPassword"; $curl; $PrivateKeyPassword)]

Set Variable [$r; Value:MBS("CURL.SetOptionSSLCert"; $curl; $path & "your.pem")]

#and the usual root certificates

Set Variable [$r; Value:MBS("CURL.SetOptionCAINFO"; $curl; $path & "cacert.pem")]

#Use TLS v.1.2

Set Variable [$r; Value:MBS("CURL.SetOptionSSLVersion"; $curl; 6) // TLS v1.2]

#Wait for 10 seconds

Set Variable [$r; Value:MBS("CURL.SetOptionTimeOut"; $curl; 10)]

#Specify content type and SOAP Action for webservice

Set Variable [$r; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml; charset=UTF-8"; "SOAPAction: \"urn:authenticate\"")]

#Pass XML to CURL

Set Variable [$r; Value:MBS("CURL.SetOptionPostFields"; $curl; $xml)]

#Run the request

Set Variable [$r; Value:MBS("CURL.Perform"; $curl)]

#Check result by storing result, debug log and output data in fields

Set Variable [$httpResponse; Value:MBS( "CURL.GetResponseCode"; $curl )]

Set Field [GSX::CURL Result; $r]

Set Field [GSX::CURL Input; $xml]

Set Field [GSX::CURL Debug; MBS("CURL.GetDebugAsText"; $curl; "UTF8")]

Set Field [GSX::CURL Output; MBS("CURL.GetResultAsText"; $curl; "UTF8")]

If [$r = "OK" and $httpResponse = 200]

#on success, get our session id

Set Field [GSX::SessionID; MBS("Text.FindBetween"; GSX::CURL Output; "<userSessionId>"; "</userSessionId>")]

End If

#always clean up

Set Variable [$r; Value:MBS("CURL.Cleanup")]


(more)

Workshop zum MBS FileMaker Plugin @ Denkform

Monday 20 February 2017 at 6:47 pm
For our German speaking clients we have a workshop day: In Zusammenarbeit mit der DenkForm GmbH bieten wir eine Schulung zum MBS Plugin an. Am 2. März 2017 (und 7. Dezember 2017) können Sie in Hofheim am Taunus an einer eintägigen Schulung teilnehmen. Lernen Sie die über 4400 Funktionen einmal näher kennen und wie Sie sie effektiv einsetzen. Sammeln Sie Ideen und verbessern Sie ihre FileMaker Lösungen durch den Einsatz unseres Plugins. Das Monkeybread Software Plugin für FileMaker stellt eine vielseitige Erweiterung der eigenen Datenbank dar. Der Kurs bietet nicht nur einen tiefgreifenden Überblick in die Benutzung und Entwicklung, sondern bietet auch die Chance das Plugin günstiger zu erstehen.
  • Einführung in das MBS Plugin
  • Überblick über die Funktionsbereiche
  • Neues im MBS Plugin dieses Jahr
  • Rundgang durch ausgewählte Beispiele
  • Gemeinsames Implementieren von Plugin Funktionen in eine Datenbank:
  • Upload/Download mit CURL auf einen HTTP/FTP Server
  • Ausfüllen eines Formulares auf einer Webseite
  • Bilder bearbeiten
  • PDF Verarbeitung
  • Druckerfunktionen
  • Adressbuch und Kontakte abfragen bei Mac OS X.
  • Fragen und Antworten
Die Teilnahme kostet 99 Euro inkl. MWSt. und Verpflegung. Details und Anmeldung bei der Denkform. Im Anschluss geht es noch zur Pizzeria zum FileMaker Stammtisch Rhein-Main. An jedem ersten Donnerstag im Monat findet ab 19 Uhr der "FileMaker Stammtisch Rhein-Main" statt, zu dem jeder herzlichst eingeladen ist. PS: Die Schulung findet statt.

Dash help archives for Xojo and FileMaker

Monday 20 February 2017 at 09:15 am
For browsing help files, the Dash application is very useful on Mac and iOS.

Here you can click to launch Dash and install our plugin help:
MBS Xojo Plugin and MBS FileMaker Plugin

You can download the archives manually on our website:
FileMaker and Xojo (Real Studio).

You can also add Xojo documentation itself to your dash set, see download in preferences dialog.
For FileMaker you find the docsets for v15 here: FileMaker Dash Docsets

Feedback is welcome.

Worldwide first curl conference in Germany, March 2017

Wednesday 15 February 2017 at 10:41 am
On the weekend of March 18-19, 2017, the first ever curl conference is taking place is Nuremberg, Germany.

Users, developers, binding authors, application authors, curl maintainers, libcurl hackers and other people with a curl interest are welcome!

I will be there and finally meet the curl people. I've been using curl for various projects including Xojo and FileMaker plugins for over 10 years.
Do you also come?

Dialogs with more buttons in FileMaker

Tuesday 14 February 2017 at 7:19 pm
Today I presented my MBS Plugin and showed with a lot of other things my Dialog functions. Someone asked how many buttons we can have and they had the wish to show more than three:

So for next plugin version, we can have up to 10 buttons.
Mac and Windows. Want to try? Just email me.

MBS FileMaker Plugin, version 7.1pr2

Friday 10 February 2017 at 1:24 pm
New in this prerelease of the 7.1 MBS FileMaker Plugin:
  • Updated DynaPDF to version 4.0.8.21.
  • Added DPI support to various functions returning images.
  • Updated SQLite to 3.17.0 prerelease version.
  • Fixed a problem in Audit which caused a crash if no FieldID was found.
  • Changed Printer.Print to make printer name optional.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

FileMaker Custom function to query a value from other table or file

Friday 10 February 2017 at 09:03 am
Today I have a custom function for FileMaker for you. It allows you to query any value in your databases by referring to the record by a field and it's value.
This can avoid complex relations if you just run a little query:

// Custom Function QueryValue

//

// Parameter:

// theFileName: the file name of the database. Empty for current.

// theFieldToQuery: the field name we want to query

// theFieldToMatch: The field to look for (primary field). Can be RowID for record ID.

// theValueToMatch: The value of the match field. Must match in data type

// 

 

Let ( [

// put quotes around field names unless it is RowID

theFieldToMatch = If(theFieldToMatch = "RowID"; theFieldToMatch; "\"" & theFieldToMatch & "\"");

theFieldToQuery = If(theFieldToQuery = "RowID"; theFieldToQuery; "\"" & theFieldToQuery & "\"");

 

// put quotes around the table name

theTable =  "\"" & theTable & "\"";

 

// Now run query

SQLRef = MBS( "FM.SQL.Execute"; theFilename; "SELECT " & theFieldToQuery & " FROM " & theTable & " WHERE " & theFieldToMatch & " = ?"; theValueToSearch);

 

// if no error, get first value

result = If(MBS("IsError"); SQLRef; MBS( "FM.SQL.Field"; SQLRef; 0; 0 ));

 

// if no error, release the recordset from memory

r = If(MBS("IsError"); ""; MBS( "FM.SQL.Release"; SQLRef ))

 

// return result

] ; result )

By using FM.SQL.Field, we get the field in it's original data type. So a container stays a container and a number stays a number. Converting to text would destroy them and cause problems. For example you can use this query to show a picture (container field) of a user if you know the user's login name for the query:

Set Field [Test::Picture; QueryValue(Get(FileName); "Picture"; "PersonID"; $PersonID) ] 

The advantage is that you don't need a relation and you can query it at any time anywhere.  

A special field name is RowID which allows you to query with using record ID. This is internal FileMaker number for a record which you query by Get(RecordID).

Works with current MBS Plugin and FileMaker with FileMaker 11 and newer.


Tip of the day: Connect to MySQL and run a query

Tuesday 07 February 2017 at 09:22 am
With MBS Plugins you can connect to various databases from Xojo and FileMaker.
As you may know we support Centura SQLBase, DB2, Firebird, Informix, InterBase, MariaDB, Microsoft Access, Microsoft SQL Server, MySQL, ODBC, Oracle Database Server, PostgreSQL, SQL Anywhere, SQLite, SQLCipher and Sybase. 
 
Here an example script for FileMaker using MySQL: 
 

#Start a new connection

Set Variable [$Connection; Value:MBS("SQL.NewConnection")]

#Tell plugin where MySQL library is (put it where you like)

Set Variable [$result; Value:MBS("SQL.SetConnectionOption"; $Connection; "MYSQL.LIBS"; "/Users/cs/Desktop/libmysqlclient.dylib")]

#Connect to a mysql database:

Set Variable [$result; Value:MBS("SQL.Connect"; $Connection; "192.168.11.51@Server_Config"; "user"; "password"; "MySQL")]

If [$result  ≠  "OK"]

#Connection failed

Show Custom Dialog ["Error: " & $result]

Set Variable [$result; Value:MBS("SQL.FreeConnection"; $Connection)]

Halt Script

Else

#Create a query:

Set Variable [$Command; Value:MBS("SQL.NewCommand"; $Connection; "SELECT * FROM Server_Config where ServerName=:Name")]

#If you use parameters, you can fill them here

Set Variable [$r; Value:MBS("SQL.SetParamAsText"; $Command; "Name"; "MacMini")]

#Execute it

Set Variable [$result; Value:MBS("SQL.Execute"; $Command)]

If [$result  ≠ "OK"]

Set Field [MySQL Query::Result; $result]

Show Custom Dialog ["Error: " & $result]

Else

Set Variable [$lines; Value:""]

Set Variable [$fieldcount; Value:MBS("SQL.FieldCount"; $command)]

Loop

#call FetchNext to get the next record

Set Variable [$result; Value:MBS("SQL.FetchNext"; $Command)]

Exit Loop If [$result  ≠ 1]

Set Variable [$line; Value:""]

Set Variable [$i; Value:1]

Loop

#We query field names and values to show them later

Set Variable [$v; Value:MBS("SQL.GetFieldAsText"; $command; $i)]

Set Variable [$n; Value:MBS("SQL.GetFieldName"; $command; $i)]

Set Variable [$line; Value:$line &  $n & ": " & $v & ¶]

Set Variable [$i; Value:$i+1]

Exit Loop If [$i > $fieldCount]

End Loop

Set Variable [$lines; Value:$lines & ($line & ¶)]

End Loop

Set Variable [$lines; Value:$lines & ¶]

Show Custom Dialog ["Result from Query:"; $lines]

End If

#Cleanup

Set Variable [$result2; Value:MBS("SQL.FreeCommand"; $Command)]

End If

Set Variable [$result2; Value:MBS("SQL.FreeConnection"; $Connection)]

 
As you notice some database types like MySQL, PostgreSQL, DB2, Oracle, Firebird and others need a client library. We point the plugin to load the client library which must match the bit number from FileMaker or Xojo. Once we are connected, we can run several queries over the connnection and usually keep it open while the application does its work.

English MBS Plugin training in Netherlands

Monday 06 February 2017 at 09:44 am
The people from FileMaker Developers Nederland organize regularly FileMaker meetings in Netherlands. They asked me to offer some insight into the MBS Plugin, so we invite to an MBS Event for Saturday 11th March 2017 to de Schakel, Utrecht:

Wat zou FileMaker zijn zonder de plugin van Monkeybread Software? Deze plugin biedt FileMaker ongekende uitbreidingsmogelijkheden voor een aanvaardbare prijs.

De dag wordt ingeleid en begeleid door Christian Schmitz, de maker van de plugin. Zijn nieuwe versie 7 omvat Inmiddels ruim 4400 functies verdeeld over 169 groepen. De functies zijn grotendeels Windows, Mac en FM Server compatible.

Tijdens de dag gaan we aan de slag met CURL (o.a. email, ftp), file-manipulaties, Restful API, SQL en functies die grappig en handig zijn.

Daarnaast zal Christian de verbeelding stimuleren door een vooruitblik te geven op nieuwe functies. Uiteraard is er gelegenheid voor vragen.

Voor een lunch wordt gezorgd, daarna is een borrel op eigen kosten.

Het evenement vindt plaats in Vleuten nabij Utrecht en is goed bereikbaar met auto (gratis parkeren) en openbaar vervoer. Om de onkosten te dekken vragen we voor deze Meetup €50,= excl BTW.

Deelnemers moeten eigen laptop meenemen en zelf zorgen voor installatie van de laatste versie van de MBS Plugin.

in English:

Where would FileMaker be without the plugin from MonkeyBread Software? This plugin offers an unprecedented array of functions for a very reasonable price.
Our MeetUp event will start with an introduction by Christian Schmitz, who created the plugin. The new version 7 offers an impressive 4400 functions, in 169 groups. Many of them are cross-platform and even support FileMaker Server.

During the day, we will get our hands on CURL (including e-mail communication, FTP), file and folder manipulation, use of the plugin for RESTful programming and SQL, among other things.
Christian will be around to answer questions and we hope he will also gives us a glimpse of future developments as well.

The Event will be held in Vleuten near Utrecht. The location is easily accessible by car and public transport. To cover the expenses, we charge a fee of €50,- pp. excl. VAT, which includes the lunch.
Participants are invited to bring their won laptop and take care of the installation of latest version of the plugin themselves.

This is an English speaking event and I hope to see a lot of people from Netherlands or areas around. Sign up on Meetup or contact the organizer Hans Erik Hazelhorst.

MBS FileMaker Plugin, version 7.1pr1

Saturday 04 February 2017 at 1:52 pm
New in this prerelease of the 7.1 MBS FileMaker Plugin: Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Interactive FileMaker Containers are Webviewers

Tuesday 31 January 2017 at 2:20 pm
Did you notice that the interactive Containers in FileMaker are really Webviewers?

Even a simple picture is shown using a Webviewer with an IMG tag:
<html style="height: 100%;">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
        <style>
            body {background-color:rgba(100%,100%,100%,1);}
        </style>
    </head>
    <body style="border:0; margin:0; padding:0; overflow: hidden; height: 100%; ">
        <img src="file:////Volumes/Mac/Users/cs/Library/Caches/FileMaker/ContainerCache/Interactive_Container_Webviews/5B5E9D4AA552A54E72180807B75548D6/LocalThumbs/45/7D/15B8790A/D6942AC2/400D5012/8E5DW/968x645.jpg" width="484" height="323" style="position:absolute; top:53px; left:0px;">
    </body>
</html>
We get the html text using the WebView.GetHTMLText. Please define a name for the container control, so you can reference it later in the Webviewer calls. (more)

Meine Bundestagspetitionen

Thursday 26 January 2017 at 8:13 pm
Da ich für meine Firma viel Papierkram machen muss, hab ich letztes Jahr zwei Petitionen beim Bundestag eingereicht um die Arbeit etwas einfacher zu machen:


Petition 68061: Umsatzsteuer - Erhöhung der Grenze für Kleinstrechnungen in der UStDV

Petition 68062: Einkommensteuer - Grenzen für geringwertige Wirtschaftsgüter anpassen

Die erste zielt auf die Anforderungen an die Rechnungen. Ist schon oft passiert, dass wir Quittungen hatten über 150 Euro. Wenn man die Vorsteuer ziehen will, dann braucht man eine Rechnung mit der Anschrift vom Leistungsempfänger. Allerdings fehlt der oft und dann ist die Rennerei lästig. Wäre schön, wenn die Grenzen mal angepasst werden, so dass wir weniger oft bei Firmen nach einer ordentlichen Rechnung fragen müssen.

Beim zweiten geht es um die Abschreibungen. Die GWG Grenze liegt seit 60 Jahren bei 800 Mark, heute 400 Euro. Ich würde es begrüßen, wenn die Grenze mal angehoben wird um man direkt Sachen bis 800 oder 1000 Euro abschreiben kann ohne lange sich um die Abschreibung zu kümmern. Es gibt zwar die Möglichkeit GWGs als Paket über Jahre abzuschreiben, aber das ist ja auch Aufwand für die Buchhaltung.

Vielleicht habt ihr 5 Minuten um das mit zu zeichnen?
Gibt auch noch andere gute Petitionen auf epetitionen.bundestag.de.

Query geolocation in FileMaker via MBS Plugin and Google Maps API

Wednesday 25 January 2017 at 2:18 pm
You may know that we have CLGeocoder functions in our plugins to query geo coordinates for addresses on Mac. But some users need it cross platform and I recently implemented a sample script for an user.
 
So first get a Google Account. It's always good to separate this, so best may be to make a new account for a project where you need maps. Best on the client, so Google knows where to complain about abuse.
 
Than go to the developer page for the google maps api. There you can request a new API key. Please copy the API key into the field of my example database. Or just hard code it in the script. Although for client projects, it's always good to have a preferences layout where you can set global settings like this and you don't need to check all scripts whether they use the key.
 
The script starts a CURL session, encodes the address to query into the URL and runs the query. The JSON is put in a field and the interesting values are extracted: Latitude, longitude and formatted address. Please check the script:

#Start new session

Set Variable [$curl; Value:MBS("CURL.New")]

#Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.)

Set Variable [$result; Value:MBS("CURL.SetOptionURL"; $curl; "https://maps.googleapis.com/maps/api/geocode/json?address=" & MBS("Text.EncodeToURL"; Substitute(Google Maps API::Address to query; ¶; ", "); "utf8") & "&key=" & Google Maps API::API Key)]

#RUN now

Set Field [Google Maps API::Result; MBS("CURL.Perform"; $curl)]

#Check result

Set Field [Google Maps API::JSON; MBS("CURL.GetResultAsText"; $curl; "UTF8")]

Set Field [Google Maps API::Debug Messages; MBS("CURL.GetDebugAsText"; $curl)]

Set Variable [$httpResult; Value:MBS("CURL.GetResponseCode"; $curl)]

Set Variable [$status; Value:MBS( "JSON.GetPathItem"; Google Maps API::JSON; "status"; 1 )]

If [$status = "OK"]

Set Field [Google Maps API::Latitude; MBS( "JSON.GetPathItem"; Google Maps API::JSON; "results¶0¶geometry¶location¶lat"; 1 )]

Set Field [Google Maps API::Longitude; MBS( "JSON.GetPathItem"; Google Maps API::JSON; "results¶0¶geometry¶location¶lng"; 1 )]

Set Field [Google Maps API::Found; MBS( "JSON.GetPathItem"; Google Maps API::JSON; "results¶0¶formatted_address"; 1 )]

Else

Set Field [Google Maps API::Latitude; ""]

Set Field [Google Maps API::Longitude; ""]

Set Field [Google Maps API::Found; ""]

End If

#Cleanup

Set Variable [$result; Value:MBS("CURL.Cleanup"; $curl)]


I hope this helps you. The example database will be in the next plugin release. Or email me if you need a copy today.
 
 
 
 

Neujahrsempfang im K&K Verlag

Wednesday 25 January 2017 at 11:40 am
Für alle FileMaker Anwender im Raum Hamburg:

Neujahrsempfang mit Sekt & Fingerfood

am 28. Januar 2017, 11.00 Uhr

Liebe Freunde des FileMaker Magazins,

jeder Jahreswechsel bringt neuen Schwung mit sich und der Blick richtet sich wieder erwartungsvoll nach vorn. Wir freuen uns auf das neue Jahr in der FileMaker Welt – am liebsten mit Ihnen zusammen!

Deshalb laden wir Sie herzlich zu einem kleinen Sektempfang in unsere Verlagsräume in Hamburg-Ottensen ein.

Bitte lassen Sie uns vorher wissen, ob wir uns auf Ihre Teilnahme freuen dürfen.

Auf ein schwungvolles, erfolgreiches und positives neues Jahr!

Klemens Kegebein
und das Team des K&K Verlags


Dieses Jahr komme ich auch nach Hamburg und zum Empfang. Man sieht sich!

MBS FileMaker Plugin 7.0 - More than 4400 Functions In One Plugin

Monday 23 January 2017 at 11:20 am
Nickenich, Germany - (January 23rd, 2017) -- MonkeyBread Software today is pleased to announce MBS FileMaker Plugin 7.0 for Mac OS X, Linux and 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 7.0 has been updated and now includes over 4400 different functions, and the versatile plugin has gained more new functions:

New functions help you read details from X509 certificate files. You can read PKCS12 files and extract public and private keys as well as additional certificates. You can than write keys or certificates as PEM files and use them with our CURL functions.

Our new XML functions help you find nodes and attributes in XML text. You can extract text and subtrees. To process XML efficiently you can let the plugin read XML and put values in local variables in your script.

For CURL we added new functions to batch download files via FTP. Of course you can still query yourself the list of files via plugin in a directory and than download several files one after each other. But now we have options to do this all in one transfer and with the use of wildcards to specify which files to fetch.

Using the new function FM.AllowFileDragDrop you can allow users to drag and drop container with files from FileMaker to other applications, e.g. the Finder. And if needed you can switch this on/off on layout changes.

For DynaPDF we added new functions to query or set raw content of a page. You can rotate page templates and add page links or watermark annotations to your PDF pages.

As FileMaker on Mac is now 64-bit in most cases, we include an Apple Script to create 32 or 64-bit only plugin. The MBS Plugin in our plugin download is for both and you can split it to get a smaller plugin file if needed.

The functions to work on Word files have been improved. They should now be able to replace tags with multi line texts. And if you have a table in your template, we can now remove rows there, too.

When you run SQL queries in FileMaker using our FM.SQL.Execute functions, you can later query result as text. Or we provide the results properly encoded for CSV export.

We improved PrintDialog, PortMidi, LDAP, Audit, ImageCapture, SerialPort line reading, SmartCard, SQL functions and more. DynaPDF is updated to 4.0.8.19, LibXL to version 3.7.2 and SQLite to 3.16.2.

See release notes for a complete list of changes.

MBS FileMaker Plugin 7.0 - 4400 Funktionen in einem Plugin

Monday 23 January 2017 at 10:52 am
23. Januar 2017 - Monkeybread Software veröffentlicht heute das MBS Plugin für FileMaker in Version 7.0, mit inzwischen über 4400 Funktionen eines der größten FileMaker Plugins überhaupt. Hier einige der Neuerungen:

Mit neuen Funktionen können Sie jetzt Details aus X509 Zertifikate lesen. Sie können PKCS12 Dateien öffnen und die privaten und öffentlichen Schlüssel auslesen oder weitere enthaltene Zertifikate. Sie können dann die Schlüssel in PEM Dateien schreiben und Sie mit den CURL Funktionen benutzen.

Unsere neuen XML Funktionen helfen Ihnen XML Knoten und Attribute im XML Text zu finden. Sie können dann Texte und Teilbäume extrahieren. Um XML effizient zu verarbeiten können sie das XML einlesen lassen um automatisch Variablen für ihr Skript zu definieren.

Für CURL haben wir neue Funktionen für automatisierte Downloads von mehreren Dateien via FTP. Natürlich können Sie weiterhin selber per Plugin die Liste der Dateien abfragen und eine Datei nach der anderen runter laden. Aber jetzt haben wir Optionen um das automatisch in einem Transfer zu machen. Sie können ein Suchmuster angeben um nur bestimmte Dateien zu laden, zum Beispiel alle mit einer bestimmten Dateinamenerweiterung.

Über die neue Funktion FM.AllowFileDragDrop können Sie Drag & Drop erlauben für Container mit Dateien. So ziehen Sie Dateien aus FileMaker direkt auf den Schreibtisch oder in andere Programme. Natürlich kann man das pro Layout an/abschalten.

Für DynaPDF haben wir neue Funktionen um die Rohdaten von einer PDF Seite abzufragen oder zu setzen. Vorlagen für PDF Seiten können Sie jetzt drehen und Seitenverweise oder Wasserzeichen zu PDF Seiten hinzufügen.

Da FileMaker für Mac jetzt meistens in 64-bit läuft, liegen dem Plugin AppleSkripte bei mit denen Sie Plugins für 32-bit oder 64-bit erstellen können. Das MBS Plugin im Download enthält 32-bit und 64-bit Unterstützung und beim Aufteilen bekommen Sie eine kleinere Plugindatei.

Die Funktionen für Word Dateien wurden verbessert und Sie können jetzt mehrzeiligen Text ersetzen. Wenn Sie in der Vorlage eine Tabelle haben, können Sie jetzt extra Zeilen löschen.

Wenn Sie SQL Abfragen über die FM.SQL.Execute Funktion laufen lassen, können Sie jetzt auch das Ergebnis einfach als Text bekommen. Oder für einen CSV Export kann das Plugin die Texte passend kodieren.

Verbessert wurde außerdem die Funktionen zum PrintDialog, PortMidi, LDAP, Audit, ImageCapture, SerialPort mit lesen in Zeilen, SmartCard, SQL Funktionen und mehr. DynaPDF kommt jetzt in Version 4.0.8.19, LibXL in Version 3.7.2 und SQLite in Version 3.16.2.

Alle Änderungen in den Release Notes.

Older blog entries:

2017-01-22 Dash help archives updated
2017-01-20 MBS FileMaker Plugin Schulung auf Deutsch bei der FMK 2017
2017-01-19 MBS FileMaker Plugin, version 7.0pr4
2017-01-19 FileMaker DevCon 2017
2017-01-19 Field Colors in FileMaker via other field and Xojo app
2017-01-18 FileMaker Pro 15.0.3 Update
2017-01-17 curl meeting in Germany, March 2017
2017-01-13 MBS FileMaker Plugin, version 7.0pr3
2017-01-10 Batch sending Emails in FileMaker via MBS Plugin
2017-01-09 Xojo job offer in southern France
2017-01-09 Allow file drag and drop from FileMaker container field to Finder
2017-01-09 MBS FileMaker Plugin, version 7.0pr2
2017-01-07 FileMaker Conference .fmp[x]Berlin 2017
2017-01-07 FileMaker Stammtisch SaarLorLux
2017-01-07 Audit with MBS FileMaker Plugin
2017-01-04 MarkDown via HTMLViewer for Xojo and FileMaker
2017-01-04 SQLite Release 3.16.1
2017-01-02 FileMaker Magazin - MBS Artikel
2017-01-02 MBS FileMaker Plugin, version 7.0pr1
2016-12-27 New XML Functions in MBS FileMaker Plugin

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
XML: RSS Feed XML: Atom Feed