We'll have a meeting in Dallas (Texas) for Monday, 27th April 2015 with local FileMaker developers.
If you are using FileMaker and you are in the area, maybe you want to join us?
We'll chat about what's new in the FileMaker world, upcoming developer conference and of course our MBS Plugin.
The meeting will take place in a local restaurant, probably somewhere between Dallas and Fort Worth.
Participation is free, except the cost of your own food and beverage.
If you like to join, please email me, so we can reserve the right number of seats.
Our SQLite Extension gives you over 50 new functions for SQLite:
Additional mathematical functions like Round or Pow.
Functions to save blob values in files outside the database.
Functions to calculate checksums on blob values on the server.
String functions like SoundEx or accents removing for your text searches.
Regular Expressions in queries.
Our SQLite Extension supports Mac OS X, Windows and Linux.
Example projects for Xojo and Real Studio are included for SQLiteDatabase, REALSQLDatabase, REALSQLServerDatabase and CubeSQLDatabase classes.
You can test the extension for free up to 10 minutes per launch in a demo mode. Licenses are available for 99 Euro per developer with one year of free updates. If you have feature requests for additional functions, please send us an email.
If your application produces PDF via DynaPDFs, you can include print settings for the PDF Viewer application. For existing PDFs you can import them in DynaPDF and write a new PDF including your print settings.
Print settings can include details like duplex mode with possible settings for default, short edge, long edge or simplex printing. You can ask the PDF Viewer to pick the tray from a laser printer based on the PDF Paper size. You can specify number of copies in range 1 to 5 and ask for no scaling or app default scaling. Finally you can even suggest print ranges to only print some pages.
For Xojo the DynaPDFMBS class has methods including SetPrintSettings, GetPrintSettings and GetInPrintSettings. Related constants like kdpmFlipLongEdge, kdpmFlipShortEdge, kdpmNone and kdpmSimplex help to define values like duplex mode.
Especially the possibility to post process existing PDFs should help. For saving records as PDF from FileMaker provides a PDF which you can customize using our plugin.
In recent plugin version we got new dictionary functions. Those can be used to quickly lookup some value for a key value. As the plugin preserves the original data type (e.g. containers), you can really use it to store anything very well. For example if you reference in your app some ID with a name, you can load all those values in a dictionary. New functions in version 5.1 will allow to fill it with SQL command easily.
For now we want to show you how to use it for parameter passing to scripts. FileMaker allows you to pass one script parameter and our idea is to pass the dictionary reference number as parameter instead of values. So in calling script we call Dictionary.Create to create a new dictionary. Than we fill in a few parameters with the Dictionary.SetValueForKey function. Finally we can pass our variable to the target script with the reference number.
For the called script we have code like below. We first query the script parameter into local variable. Than we query all the values and put them in variables in the new script. Finally we have to free the dictionary.
#get dictionary reference number
Set Variable [$param; Value: Get(ScriptParameter) ]
As you see this needs some more work in the scripts. But we can make it easier. The calling script can use the function Dictionary.SetVariables (new in 5.1). This function uses the keys and values in dictionary for the variables. So if there is a key named "Company", we create a variable called $Company and fill the value. So you automatically get the variable names. Also the Dictionary.Create function now takes key/value pairs, to easily fill a dictionary in a script. See the following script:
Set Variable [ $param; Value: MBS( "Dictionary.Create"; "text"; Test Table::TextField; "number"; Test Table::NumberField) ]
Added inline option for SendMail.AddAttachmentFile and SendMail.AddAttachmentContainer.
Added DynaPDF.SetPrinterSettings, DynaPDF.GetPrinterSettings and DynaPDF.GetInPrinterSettings functions.
Added RichText.WritePDF and RichText.GeneratePDF functions.
Added parameter to Math.TextToNumber to detect dot or comma for decimal separator.
Added Dictionary.SetVariables function.
Added Dictionary.Values, Dictionary.AddSQL, Dictionary.ValueTypeForKey and QuickList.AddSQL.
Added GMImage.NewImagesFromContainer and GMImage.NewImagesFromFile to split tiff.
Added XL.CopyContent function to copy content from one XL document to other, useful for converting between XLS and XLSX formats.
Added Text.CapitalCase, Text.LowerCase and Text.Uppercase with full unicode support.
Added Plugin.SetPreviewSize function to control preview sizes.
Changed PDF preview rendering to make smaller previews in faster speed.
Added parameter for various functions returning PDF containers to disable rendering of JPEG preview: SQL.GetFieldAsPDF, SQL.GetParamAsPDF, WebView.RenderPDF, CURL.GetResultAsPDF, PDFKit.GetPDFPageValue, Files.ReadPDF, Window.AsPDF, Container.DecodeFromBase64, ServiceProvider.Value, CGPSConverter.Convert, PDFKit.GetPDFPagePDF and PDFKit.GetPDFPagesPDF.
Fixed bug in GMImage.WriteImages function. Now working again.
Changed FM.ExecuteSQL to return error messages in clear text on error. You can use IsError function to know if it was an error.
Updated DynaPDF to version 188.8.131.52.
Added FM.ArgumentCount and FM.Argument functions.
Fixed GMImage.GetPixelColor to return correct error message if coordinate is out of bounds.
Fixed bug in JSON.GetObjectName. Reports now an error if index is out of bounds instead of crashing.
Changed ZipFile.WriteContainer to accept writing empty file.
Added UnZipFile.UsePassword and ZipFile.UsePassword to encrypt Zip archives.
Fixed bug in Text.DecodeFromXML and Text.DecodeFromHTML about html entities not being decoded correctly.
As you may know we come to Texas for the Xojo conference in Austin. While we are there, we thought it may be nice to meet some FileMaker developers there. So if you like, we can organize meetings. Simply reserve a table in a restaurant, meet and have dinner together while chatting about FileMaker and plugins.
We simply offer 3 meetings and see if people are interested. Surveys will be open and once we have a few people for an event, we can decide on the exact date.
On same day, we could of course arrange training or consulting meetings with you in your office to discuss your FileMaker plugin questions.
Location: To be defined. Suggestions welcome.
Cost: Your own meals and drinks.