Windows on ARM in 64-bit


With Visual Studio 15.9, Microsoft now supports ARM64 processor architecture as target for Windows software. So Windows now runs currently on 4 architectures: x86 for Intel 32-bit, x64 for Intel 64-bit, ARM in 32-bit and 64-bit. In history Windows NT also run on IA-64, MIPS, Alpha, PowerPC, PC-98 before, so they keep it quite cross platform viable.

Now the big question is whether Xojo Inc. and/or FileMaker Inc. will support the new architecture anytime soon. But if they would, we would of course try to build the plugins for the new platform.

See blog entry from Microsoft.

MBS Xojo Training


Looking back this year we had two group trainings this year for Xojo and seven individual trainings. Alone this November I visited two companies to train them on Xojo. At the MBS Xojo Conference in Munich, Ulrich Bogun did the beginner training, so I could concentrate on the advanced training. If you are looking for training here in Germany, you could ask Ulrich or me for help. Others developers may be available if you ask on the Xojo forum.

Looking on topics, there may be different cases:
  • Getting started in Xojo, starting with a walk though the IDE and building an example application live in front of audience.
  • Kickstart a project by building a prototype together with me. We setup the basics, do a little part so your developer learns how to do it and than adds more similar pages or windows.
  • We debug your application to try to fix a list of bugs.
  • Reviewing your project for possible problems and security holes and make sure you have less problems in future.
  • Learn from the experts advanced features like declares, delegates or interfaces.
  • Learn what we have available in the plugin toolbox to help your applications.
  • Kick start your project by implementing a new feature based on a plugin where you like to have help from the guy who wrote the plugin.
  • Connect a new device (e.g. USB) to your application by creating the interface via plugin.
  • We may even work on a plugin of your company or in a project add a new function to MBS plugins to help you.
  • Assist a new employee and help them developing in Xojo.
To give a few samples, a company flew me in to review the project for two years to fix possible issues before it went public. Another company invited me and we spoke a whole day about what our plugins can do and they took a lot of notes. Second day we implemented a few of the most wanted features directly into their solution. A few clients came to our office and we started a new web app together and put a first version on the server the very same day. Some projects turned out into bigger consulting projects as I wrote the app for them instead of just training. Other clients turned into regularly booking training and providing a todo list of each meeting, so I come for a visit every few months and we work on a todo list of problems they couldn't solve themselves.

Training is available as one to one or group training. It can be organized in your company, in our office or in some hotel. While I may work via phone & screen sharing for some things, I may often need to connect to a database or physical device, so physical presence is sometimes easier than getting a hole in the firewall.

If you are interested in any of this, please get in touch.

FMnext Experience II in Meilen, Schweiz und MBS Plugin Schulung


Am kommenden Dienstag, den 20. November 2018 veranstaltet die Medio-Ingeno AG einen FileMaker Event in Meilen am Zürichsee:

FMnext Experience II

Zahlreiche FileMaker Vorträge am Abend, Empfang und einem unterhaltsames Special am Ende.
Bitte bald anmelden, denn der Platz is begrenzt. Das Programm startet gegen 17:30 Uhr und der Eintritt kostet 50 CHF.

MBS Plugin Schulung

Wir bieten eine MBS Plugin Schulung für den gleichen Tag um ca. 9 Uhr im gleichen Hotel an. Für unsere Kunden haben wir ein Programm zusammengestellt speziell für die Anforderungen in der Schweiz:
  • MBS Plugin Überblick für 2018.
  • QRCodes für Schweizer Einzahlungsscheine nach ISO 20022.
  • FileMaker Migration Tool
  • MBS Shell Funktionen um das Tool zu automatisieren
  • SmartCards auslesen am Beispiel der Schweizer Krankenversichertenkarte
  • Audit Funktionen
  • Word-Serienbriefe aus FileMaker
  • Fragen & Antworten
Weitere Themenwünsche bitte baldmöglichst an mich schicken.
Kostenbeitrag: 150 CHF inkl. Mittagessen.

Anmeldung FMnext Experience II und Anmeldung für MBS Schulung

Noch wenige Restplätze vorhanden, also bitte schnell noch anmelden, falls es terminlich passt.

SetApp for Xojo Apps


In the last week we made a new Xojo plugin for a client. The plugin allows the integration with the SetApp service. As you may know SetApp allows you to subscribe for $9.99 to a pool of various Mac apps. The money is split each month to the developers based on what percentage of users have the app installed and in use.

When you offer a Mac application though SetApp, you receive your own custom library to link into your app (or a plugin). The library offers functions to report usage, ask user for email and present login or release notes. As the library is different for each vendor, we just build a new plugin for each of them.

If you like to try SetApp as Xojo developer, please visit their developer website.

FileMaker Roadmap for 2019


Did you see the webinars for the roadmap and the updated website?
You can check it here: FileMaker Roadmap and the Video

To give a few comments for the questions I got immediately from a few FileMaker developers:

FileMaker Next

MBS Plugin 9.x will be available at launch next year when the next FileMaker version ships. We will use the new plugin SDK and make a few changes to get the plugin working well in the new version. To ensure the plugin works well, we'll test the beta version of FileMaker. If you see an issue, please report it soon to us.

As FileMaker will probably ship again in mid May, we may have our March release ready for the new version and fix any outstanding problems with our May release a week after FileMaker's release.

Code Signing

MBS Plugin is code signed for a few years now for MacOS and Windows. Occasionally there may have been a beta version without signature, but the release versions should all be signed.

File functions

The new data file functions are certainly welcome in the community, especially as you will be able to use them in FileMaker Go. Still the plugin provides an alternative for reading and writing files with more options and outside a script as the plugin can be used in all calculations.

JavaScript in Webviewer

As you know we have a function WebView.RunJavaScript function in our plugin. We are curious to learn what FileMaker plans for future versions to do similar things in FileMaker directly. This is certainly welcome for Web Direct, where our plugin can't provide that feature. For FileMaker Pro desktop on Windows we wonder if they switch away from Internet Explorer as engine (Webbrowser ActiveX control) and use something like embedded Chromium instead. Another curious thing is how FileMaker Inc. will provide an unified interface for both JavaScript to FileMaker and FileMaker to JavaScript. What we have, can be read in this blog article: FileMaker and WebViewer communication

FileMaker Cloud 2

The new version 2 of FileMaker Cloud may ship with or without plugin support. Not sure if a new plugin SDK will be ready for the release or whether existing plugins can be used there. Once we get a newer SDK, we'll look into how to make plugins there and see what will be possible.

While vs. FM.Loop function

It looks like the product idea for a loop function was welcome both to FMI and to us. We implemented in March 2018 our FM.Loop function. It allows you to have a loop in a calculation counting a variable up or down. The FileMaker version can do a bit more as you can include several commands directly in the function call with square brackets like in a Let function. The plugin interface doesn't allow us to do the same. But we do have a second expression to evaluate which lets you define an exit conditions independent of the counting up or down the variable. While MBS Plugin function returns a list of all the results from the various expression, in FileMaker you collect the values yourself and return them in the result expression. If needed

FileMaker Marketplace

We look forward to add our plugin to the marketplace and encourage our users to add solutions there, which use our plugin. Some clients have integrations ready using MBS Plugin, e.g. for receiving emails in FileMaker and showing them like a mail application.

Thanks FileMaker Inc. for their ongoing investments into FileMaker and the impressive features coming to the platform. Having modules as XML files ready to integrate in solutions with a market place to get them, will bring the platform to a new level. Imaging a world, where a consultant can build a solution for a client by combining several modules from Marketplace and have something ready to use within minutes.

Machine ID


As you may know we offer MachineID function in our SystemInformationMBS module. That ID is a MD5 of some values of the computer like the Mac serial number, Mac model, CPU Brand string and hard disk serial. But that is not very stable as some people may have seen values change. Especially hard disk serial may sometimes be available and other times not.

So we got a better way as a Xojo project. Our new Machine ID example project uses a SQLite database for preferences and to keep a list of configurations. We use the following 10 values for a configuration: MACAddress, MacModel, HardDiscSerial, MacUUID, WinProductKey, ComputerName, CPUBrandString, Platform, PhysicalRAM and ProcessorCount.

The CheckMachineID method checks if the current values for all of them matches an existing configuration. If yes, we have a perfect match. Otherwise if 9 of 10 values match, we add the new configuration to the database. This way we learn all the configuration and user can change RAM or swap hard disk without breaking the licensing. Only if 2 or more values changed, we would ask for license key or activation via web and than store the new configuration.

Download: MachineID.zip
The example will be included in next plugin prerelease. You may want to fine tune this to your needs.

Please provide back feedback and we can update our example.

MBS Xojo Plugins, version 18.5pr7


New in this prerelease of the 18.4 plugins:
  • Added IEClearBrowserSessionMBS global method.
  • Changed how timeout is passed to LDAPMBS.Search function.
  • Updated SQLAPI library to version 4.2.4 beta 1.
  • Changed CDDataSetMBS.setDataSymbol, CDThreeDScatterGroupMBS.setDataSymbol and CDPolarLayerMBS.setDataSymbol to retain the CDDrawAreaMBS object to keep it alive.
  • Changed DecompressZLibMBS to auto detect the size of output data.
  • Bugfixes in ChartDirector 6.3:
    • In contour and surface charts, the color axis is not drawn correctly if smooth coloring is and the number of ticks on the color axis are significantly less than the number color stops. For example, there are only 2 ticks, the color axis will draw itself by using a smooth gradient to vary colors between the two ticks, ignoring the other color stops in between.
    • In contour and surface charts, if the color axis is of logarithmic scale, and smooth coloring is used, the colors are still interpolated using linear scale. As a result, the coloring may look good.
    • For the color axis, if auto-scaling is used, the setColorScale always results in linear scale, even if setLogScale has already been called for the color axis.
    • Vector layer crashes if setArrowHead(0) is called.
    • In a vector layer, the setLineWidth has no effect if setArrowStem is used.
    • In a vector layer, the stem is visible even if the line width is 0.
    • In a vector chart, the legend icon disappear if the head size is 0 (that is, the vector chart shows stems).
    • In a vector chart, the image map is not natural if the stem width is thicker than the arrow head.
    • FinanceChart can produce too many x-axis labels in some cases.
    • ChartDirector can crash if the SurfaceChart has no data
    • DrawArea.setOutputOptions has no effect for SVG.
    • ArrowShape does not work in CDML <*IMG*>.
Download: monkeybreadsoftware.com/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

MBS FileMaker Plugin, version 8.5pr7


New in this prerelease of version 8.5 of the MBS FileMaker Plugin: Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Version number reported it 8.5.04, sorry.

Xojo Script Warning Enumeration


One of our apps uses XojoScript to compile and run scripts on the fly. We log warnings and errors. There is a list of all warnings in Xojo documentation. Today I had to figure out which warning is a specific number, so I started building a table. Here it is:
XojoScript EnumerationDescriptionValue
ConversionPrecisionConverting from %OriginalType to %NewType causes a possible loss of precision, which can lead to unexpected results.5
ConversionSignConverting from %OriginalType to %NewType causes the sign information to be lost, which can lead to unexpected results.6
CustomA custom warning displayed with Pragma Warning.8
Deprecated%Name is deprecated.1
DeprecatedWithReplacement%Name is deprecated.  You should use %Replacement instead.2
FloatingPointComparisonPerforming a %Operator comparison on floating-point values can yield unexpected results due to their inexact binary representation.7
NameLookupChangeBefore 2014r3, this would have referred to the %OldPath but now it refers to the %NewPath.14
OldStyleConstructorOld-style constructor methods are no longer supported.  You should use "Constructor" instead.3
ShadowedConstantThis constant shadows one already defined by %Superclass.13
ShadowedPropertyThis property shadows one already defined by %Superclass.12
UnknownPragmaWarningUnknown pragma name.4
UnusedEventParameter%Name is an unused event parameter.11
UnusedLocal%Name is an unused local variable.9
UnusedMethodParameter%Name is an unused method parameter.10

Welcome Stefanie


Monkeybread Software proudly presents our new junior software developer Stefanie Juchmes. Last month Stefanie finished here Bachelor of Science in Informatics. And she accepted our employment contract, so 1st January she will start at Monkeybread Software.

We are looking forward to a lot of new content from here including tutorials, examples, videos and presentations related to our plugins. And as she knows some C++, we may even involve here in some plugin programming. But first, I've given her my library of books about FileMaker and Xojo to read.

You may have seen Stefanie at a few conferences this year and we may bring here to a few more conferences in 2019 so she can meet our clients.

Bugs fixed in ChartDirector 6.3


With MBS Xojo Plugins 18.5 we include the new ChartDirector 6.3 version for all platforms. The main new feature are embedded resources:

ChartDirector can use images for the chart background, pattern colors, scatter symbols, CDML icons, … In previous versions of ChartDirector, these images have to be provided using file system paths. ChartDirector 6.3 allows these images to be embedded in executables as resources, and uses "resource paths" to access them. This eliminates the need to redistribute image files with the executable. Apart from images, font files can also be embedded as resources.

Beside the new resources functions, it also includes the following bug fixes:
  • In contour and surface charts, the color axis is not drawn correctly if smooth coloring is and the number of ticks on the color axis are significantly less than the number color stops. For example, there are only 2 ticks, the color axis will draw itself by using a smooth gradient to vary colors between the two ticks, ignoring the other color stops in between.
  • In contour and surface charts, if the color axis is of logarithmic scale, and smooth coloring is used, the colors are still interpolated using linear scale. As a result, the coloring may look good.
  • For the color axis, if auto-scaling is used, the setColorScale always results in linear scale, even if setLogScale has already been called for the color axis.
  • Vector layer crashes if setArrowHead(0) is called.
  • In a vector layer, the setLineWidth has no effect if setArrowStem is used.
  • In a vector layer, the stem is visible even if the line width is 0.
  • In a vector chart, the legend icon disappear if the head size is 0 (that is, the vector chart shows stems).
  • In a vector chart, the image map is not natural if the stem width is thicker than the arrow head.
  • FinanceChart can produce too many x-axis labels in some cases.
  • ChartDirector can crash if the SurfaceChart has no data
  • DrawArea.setOutputOptions has no effect for SVG.
  • ArrowShape does not work in CDML <*IMG*>.
The new version can be tested now with 18.5pr6 or newer.

MBS Plugin @ FileMaker Conference in UK


ThumbnailWe got a new video for you:

MBS Plugin @ FileMaker Conference 2018
Presentation from FileMaker DevCon UK.

An overview of what changed in our MBS FileMaker Plugin since the last conferences. Optionally watch the DevCon 2018 video first.

File dialogs with sheets for FileMaker


A client asked for using file dialogs as sheets, a Mac feature to show a dialog attached to a parent window. Once the user made a choice, we trigger a script of your choice and allow you to check the list of files selected.



Before showing the sheet, please call FileDialog.SetSheetScriptTrigger to set script trigger and use FileDialog.SetUseSheet function to enable sheets. Be aware that the script must be different. The first script shows the sheet and exits. Later another script runs and processes results as the process is asynchronously.

New plugin with updated example database is comming soon.

Correct Image Orientation in FileMaker


Sometimes you may see pictures in FileMaker with wrong orientation. But in your image editing application, the orienation is correct. So you may wonder what is going on?
 
Image files like JPEG, PNG and TIFF have all metadata which describes the orienation of the image in 8 different ways. So the pixels in the picture come in the orientation they are read from the sensor chip. But you may hold your camera rotated, so the pixels flow into the file and the camera marks the image to be taken rotated and writes that in metadata. 

Sadly not all applications handle this and show the image in the right orienation. For all 8 ways, we change the orientation to always be in mode 1 and save the image with the new orientation, so all applications will show the image correctly: 
 

# load image

Set Variable [ $Image ; Value: MBS( "GMImage.NewFromContainer"; Correct Image Orientation::Input ) ] 

If [ MBS("IsError") = 0 ] 

Set Variable [ $orientation ; Value: MBS( "GMImage.GetOrientation"; $Image ) ] 

If [ $orientation > 0 ] 

If [ $orientation = 1 ] 

# TopLeftOrientation = 1, (Line direction: Left to right, Frame Direction: Top to bottom) 

# nothing to do

Else If [ $orientation = 2 ] 

# TopRightOrientation = 2, (Line direction: Right to left, Frame Direction: Top to bottom) 

# Flip horizontally

Set Variable [ $r ; Value: MBS( "GMImage.Flop"; $Image ) ] 

Else If [ $orientation = 3 ] 

# BottomRightOrientation = 3, (Line direction: Right to left, Frame Direction: Bottom to top) 

# Rotate 180°

Set Variable [ $r ; Value: MBS( "GMImage.Rotate"; $Image; 180 ) ] 

Else If [ $orientation = 4 ] 

# BottomLeftOrientation = 4, (Line direction: Left to right, Frame Direction: Bottom to top) 

# Flip vertically

Set Variable [ $r ; Value: MBS( "GMImage.Flip"; $Image ) ] 

Else If [ $orientation = 5 ] 

# LeftTopOrientation = 5, (Line direction: Top to bottom, Frame Direction: Left to right) 

# Rotate 90° and flip horizontally

Set Variable [ $r ; Value: MBS( "GMImage.Rotate"; $Image; 90 ) ] 

Set Variable [ $r ; Value: MBS( "GMImage.Flop"; $Image ) ] 

Else If [ $orientation = 6 ] 

# RightTopOrientation = 6, (Line direction: Top to bottom, Frame Direction: Right to left) 

# Rotate 90° 

Set Variable [ $r ; Value: MBS( "GMImage.Rotate"; $Image; 90 ) ] 

Else If [ $orientation = 7 ] 

# RightBottomOrientation = 7, (Line direction: Bottom to top, Frame Direction: Right to left) 

# Rotate -90° and flip horizontally

Set Variable [ $r ; Value: MBS( "GMImage.Rotate"; $Image; -90 ) ] 

Set Variable [ $r ; Value: MBS( "GMImage.Flop"; $Image ) ] 

Else If [ $orientation = 8 ] 

# LeftBottomOrientation = 8 (Line direction: Bottom to top, Frame Direction: Left to right) 

# Rotate -90° 

Set Variable [ $r ; Value: MBS( "GMImage.Rotate"; $Image; -90 ) ] 

End If

Set Variable [ $r ; Value: MBS( "GMImage.SetOrientation"; $Image; 1 ) ] 

Set Variable [ $r ; Value: MBS( "GMImage.SetEXIFOrientation"; $Image; 1 ) ] 

End If

#  Write back to new field

Set Field [ Correct Image Orientation::Output ; MBS( "GMImage.WriteToJPEGContainer"; $Image; GetAsText(Correct Image Orientation::Input)) ] 

# free memory

Set Variable [ $r ; Value: MBS( "GMImage.Destroy"; $Image) ] 

End If

 
The example database will be included in future plugin releases.

MBS FileMaker Plugin, version 8.5pr6


New in this prerelease of version 8.5 of the MBS FileMaker Plugin:
  • Fixed edge case for filename in CURL.GetResultAsContainer function.
  • Improve DynaPDF.Initialize to better reject invalid license keys.
  • Updated to Xcode 10.1.
  • Added a lot of GameKit functions to work with Game Center on Mac and iOS.
  • Changed SendMail functions to no longer turn TO to CC if you have several TOs.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Version number reported it 8.5.04, sorry.

MBS Xojo Plugins, version 18.5pr6


New in this prerelease of the 18.4 plugins: Download: monkeybreadsoftware.com/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

Fix for missing accessibilityIsAttributeSettable function


For one of our Xojo app, we got crash reports for missing accessibilityIsAttributeSettable function in various classes:

-[NSMenuItem accessibilityIsAttributeSettable:]: unrecognized selector sent to instance 0x600001ffea00
Please report to the application developer.

0 CoreFoundation 0x00007fff3cc54fa5 __exceptionPreprocess + 256
1 libobjc.A.dylib 0x00007fff68d4befb objc_exception_throw + 48
2 CoreFoundation 0x00007fff3ccd2c8d -[NSObject(NSObject) __retain_OA] + 0
3 CoreFoundation 0x00007fff3cbf65de ___forwarding___ + 1468
4 CoreFoundation 0x00007fff3cbf5f98 _CF_forwarding_prep_0 + 120
5 AppKit 0x00007fff3a7aea33 NSAccessibilityPerformEntryPointBOOL.llvm.11937614488442194757 + 16
6 AppKit 0x00007fff3a545d63 NSAccessibilityEntryPointIsAttributeSettable + 86
7 AppKit 0x00007fff3a61a460 -[NSCarbonMenuImpl _carbonIsAccessibleAttributeSettableEvent:handlerCallRef:axElement:] + 185
8 AppKit 0x00007fff3a409778 NSSLMMenuEventHandler + 1009
9 HIToolbox 0x00007fff3be26b79 _ZL23DispatchEventToHandlersP14EventTargetRecP14OpaqueEventRefP14HandlerCallRec + 1502

The name of the class and functions related in the stack trace changes, but the problem is always the same. Same function in Apples framework wants to call deprecated accessibilityIsAttributeSettable function, but that one is no longer implemented in Apple's own classes. It's a code path which doesn't happen for all users, so only a few get the crash and maybe this is related to some accessibility setting.

Anyway, via a new InstallNSAccessibilityPatchMBS function in our plugin, we'll patch it and install a accessibilityIsAttributeSettable function to just return false every time. If the class has such a method, the class method is preferred, but we install a fallback to avoid the crash.

So when you see such a crash, you can soon try our MBS Xojo Plugins in version 18.5 and call InstallNSAccessibilityPatchMBS method on start of the application.

Write formatted text with DynaPDF


As you may know you can use MBS Plugins with Xojo and FileMaker to write PDFs with DynaPDF functions. The WriteFText functions accept formatting commands in the text, so you can create various formats. We got a few examples in the following Xojo source code:
  • Change text rise and size to get footnote references
  • Change font to get e.g. a bold font
  • Change color
  • Create lists with hierarchies, numbered entries or multiline entries.
Check the sample code here:

// set font call pdf.SetFont "Helvetica", 0, 12.0, true, pdf.kcpUnicode dim y as Double = 50 // change font size and raise for foot note references text = "\FS[12]Hello World\FS[6]\TR[6]123\TR[0]\FS[12] Just a test." call pdf.WriteFTextEx(50, y, 200, -1, pdf.ktaLeft, text) y = y + 20 // change font to get bold text = "\FT[Helvetica]Hello \FT[Helvetica-Bold]World \FT[Helvetica]everyone." call pdf.WriteFTextEx(50, y, 200, -1, pdf.ktaLeft, text) y = y + 20 // change color in the text text = _   "\FC[" + str(DynaPDFMBS.RGB(255, 0, 0)) + "]Red "+_   "\FC[" + str(DynaPDFMBS.RGB(0, 255, 0)) + "]Green "+_   "\FC[" + str(DynaPDFMBS.RGB(0, 0, 255)) + "]Blue "+_   "\FC[" + str(DynaPDFMBS.RGB(0, 0, 0)) + "]Black " call pdf.WriteFTextEx(50, y, 200, -1, pdf.ktaLeft, text) y = y + 20 // make list text = _   "\LI[0]First"+EndOfLine+"with two lines\EL#"+_   "\LI[0]Second\EL# "+_   "\LI[0]Third\EL#" call pdf.WriteFTextEx(50, y, 200, -1, pdf.ktaLeft, text)
The same formatting texts can be used in FileMaker, Xojo and any other development tool supported by DynaPDF like C++, VB, PHP and Delphi.

Use root certificates included with FileMaker


If you like to have SSL with security, you need to verify the certificate. FileMaker comes with a root certificate file, so we can refer CURL to that file and enjoy the checks against the given list of root certificates:

 

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

If [ MBS("IsIOS") ] 

# look for path to certificate file

Set Variable [ $path ; Value: Substitute(MBS("Folders.UserDocuments"); "/Documents"; "/Library/Application Support/FileMaker/iOS/1.0/root.pem") ] 

If [ MBS("Files.FileExists"; $path) ] 

# use in CURL

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

Else

Show Custom Dialog [ "File not found." ; $path ] 

End If

Else If [ MBS("IsMacOSX") ] 

# look for path to certificate file

Set Variable [ $path ; Value: Substitute(MBS("Folders.UserDocuments"); "/Documents"; "/Library/Application Support/FileMaker/Shared/17.0/root.pem") ] 

If [ MBS("Files.FileExists"; $path) ] 

# use in CURL

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

Else

Show Custom Dialog [ "File not found." ; $path ] 

End If

Else If [ MBS("IsWindows") ] 

# look for path to certificate file

Set Variable [ $path ; Value: Substitute(MBS("Folders.UserDocuments"); "\Documents"; "\AppData\Local\FileMaker\FileMaker Pro Advanced\17.0\root.pem") ] 

If [ MBS("Files.FileExists"; $path) ] 

# use in CURL

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

Else

Show Custom Dialog [ "File not found." ; $path ] 

End If

Else If [ MBS("IsLinux") ] 

# look for path to certificate file

Set Variable [ $path ; Value: "/FileMakerData/Extensions/OpenSSL/root.pem" ] 

# use in CURL

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

End If

# Start new session

Set Variable [ $URL ; Value: "https://www.filemaker.com" ] 

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

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

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

# Do transfer now:

Set Field [ PlaceHolder::result ; MBS("CURL.Perform"; $curl) ] 

# Check result

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

Set Field [ PlaceHolder::result ; MBS("CURL.GetDebugAsText"; $curl) ] 

// Set Field [ PlaceHolder::result ; MBS("CURL.GetCertinfo"; $curl; "UTF8") ] 

# Cleanup

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

This script works fine with MacOS, Windows, Linux and iOS. If needed you can request certificate information via CURL.SetOptionCertInfo and see all the details from certificates in the text given by CURL.GetCertinfo function.


ChartDirector 6.3 Released


We got the announcement of an update to ChartDirector:

Advanced Software Engineering is pleased to announce the immediate availability of ChartDirector 6.3.

ChartDirector 6.3 adds support for embedded resources in executables. As embedded resources are mostly used in desktop GUI applications (as opposed to web or command line scripts), so ChartDirector 6.3 is only released for C++ and .NET (C#, VB).

ChartDirector can use images for the chart background, pattern colors, scatter symbols, CDML icons, … In previous versions of ChartDirector, these images have to be provided using file system paths. ChartDirector 6.3 allows these images to be embedded in executables as resources, and uses "resource paths" to access them. This eliminates the need to redistribute image files with the executable.

Apart from images, font files can also be embedded as resources.

More details can be found in the ChartDirector 6.3 Release Notes.

We'll update our MBS Xojo ChartDirector Plugin soon, when we get the libraries and header files.

Root certificates coming with FileMaker Go


We got a list of the root certificates coming with FileMaker Go:
  • AddTrust External CA Root
  • COMODO Certification Authority
  • COMODO RSA Certification Authority
  • Entrust Root Certification Authority
  • Entrust Root Certification Authority - EC1
  • Entrust Root Certification Authority - G2
  • Entrust Root Certification Authority - G3
  • Entrust.net Certification Authority (2048)
  • FileMaker Root Authority
  • GeoTrust Global CA
  • GeoTrust Global CA 2
  • GeoTrust Primary Certification Authority
  • GeoTrust Primary Certification Authority - G2
  • GeoTrust Primary Certification Authority - G3
  • GeoTrust Primary Certification Authority - G4
  • GeoTrust Universal CA
  • GeoTrust Universal CA 2
  • Go Daddy Root Certificate Authority - G2
  • Go Daddy Root Certificate Authority - G3
  • Go Daddy Root Certificate Authority - G4
  • Symantec Class 1 Public Primary Certification Authority - G6
  • Symantec Class 2 Public Primary Certification Authority - G6
  • Symantec Class 3 Public Primary Certification Authority - G7
  • thawte Primary Root CA
  • thawte Primary Root CA - G2
  • thawte Primary Root CA - G3
  • thawte Primary Root CA - G4
  • Thawte Timestamping CA
  • The Go Daddy Group, Inc.
  • VeriSign Class 1 Public Primary Certification Authority - G3
  • VeriSign Class 2 Public Primary Certification Authority - G3
  • VeriSign Class 3 Public Primary Certification Authority - G3
  • VeriSign Class 3 Public Primary Certification Authority - G4
  • VeriSign Class 3 Public Primary Certification Authority - G5
  • VeriSign Class 4 Public Primary Certification Authority - G3
  • VeriSign Universal Root Certification Authority
  • VeriSign, Inc.
As far as we know you can only connect to servers which use a certificate based on one those root certificates. Depending on the version of FileMaker Go/Pro, the list for you may be different.

IconFamilyMBS class deprecated


In our Xojo plugins we have the IconMBS and IconFamilyMBS classes. They use Apples frameworks with icon functions, but those are not well maintained the last few MacOS releases and we see more and more issues. Probably as a lot of functions are based on the deprecated QuickDraw framework. So we deprecate IconFamilyMBS class for the next prerelease plugin.

So please change code and move to newer functions. For example instead of IconFamilyMBS class to get an icon in various sizes, you can use NSWorkSpaceMBS class methods. IconForFile functions returns the icon for a file and than you can use NSImageMBS class to scale down. With the following code you can quite easily get a 2x picture for a FolderItem:

const SizeWanted = 256
dim file as FolderItem = SpecialFolder.Desktop.Child("test.rtf")

dim n as NSImageMBS = NSWorkspaceMBS.iconForFile(file)
// set size we want
n.setSize SizeWanted*2, SizeWanted*2

// make picture
dim p as Picture = n.CopyPictureWithMask

// make 2x picture here:
dim q as new Picture(SizeWanted, SizeWanted, array(p))

If you need an icon for a file type, you can use the IconForFileType function. If you need to add an icon to a file, please use SetIcon method in NSWorkSpaceMBS class.

The folderItem.IconMBS function is still working well and was upgraded in MBS Xojo Plugins in version 14.2 to use NSWorkspace methods to get the icon.

By the way, NSWorkspace's icon functions internally use the same functions as our IconMBS class, which is not deprecated!

Xojo Stammtisch in Zürich, Schweiz


On my next visit to Zurich, I'd love to make another Xojo developer meeting:

Wer hat Interesse an einem Xojo Entwicklertreffen am 21. November in Zürich?



Einfach gemütlich zusammen sitzen und über Xojo schnacken.
Gerne zeige ich auch neue Pluginfunktionen oder helfe bei Problemen mit Xojo Projekten. Einfach Computer mitbringen und was zeigen.

Bei Interesse bitte anmelden: Anmeldung

Wer Interesse hat an einem Termin mit mir für Softwareentwicklung, Schulungen, Entwicklungshilfe, Plugin Empfehlungen, assistierte Fehlersuche, Code-Review und IT-Beratung, der darf sich gerne melden für eine baldige Terminfindung.

MBS FileMaker Plugin, version 8.5pr5


New in this prerelease of version 8.5 of the MBS FileMaker Plugin: Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Version number reported it 8.5.04, sorry.

MBS Xojo Plugins, version 18.5pr5


New in this prerelease of the 18.4 plugins: Download: monkeybreadsoftware.com/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

Notarize apps for MacOS


While FileMaker runtimes are deprecated, they are still a great tool to give away a test copy of your fabulous solution. Apple now recommends you to notarize your app. This is a step further than normal code signing as the app is actually uploaded to a test system which scans it for malware. Looks like for next year this may be required for apps to launch without a warning dialog.

The following steps work for us with the test.app on Desktop. File paths, names, bundle and Apple IDs will be different for you:
  1. Install Xcode and run it once to get the command line tools installed.
  2. Build a runtime app in FileMaker Pro Advanced.
  3. Adapt our SignScript FM 17 (included with MBS Plugin download).
    Please change name of certificate, the path and the name of the app. For codesign lines, please add --options runtime as command line parameters after the -f command line parameter. Run the script and watch for the last lines saying accepted and Developer ID.
  4. Next build an disk image. With a GUI app or simply via terminal with right path:
    /usr/bin/hdiutil create -imagekey zlib-level=9 -srcfolder /Users/cs/Desktop/Test -fs HFS+ -volname Test /Users/cs/Desktop/Test.dmg
  5. Sign the disk image. e.g. via Terminal:
    codesign -f -vvvv -s "Developer ID Application: Christian Schmitz Software GmbH" /Users/cs/Desktop/Test.dmg
  6. Notarize the app. Run xcrun in terminal. The bundle ID is found in the info.plist file of the runtime app inside the bundle. Please pass your own Apple ID here for your Apple developer account:
    xcrun altool --notarize-app -f /Users/cs/Desktop/Test.dmg --primary-bundle-id com.filemaker.client.runtime12.test -u Developer@monkeybreadsoftware.de -p @keychain:"Application Loader: Developer@monkeybreadsoftware.de"
    This may take a while and return a RequestUUID.
  7. Wait for an email from Apple or periodically check the status of the notarization until it has completed. Please put in again your Apple ID and the request UUID from above.
    xcrun altool --notarization-info 193b7ad2-36e1-45d5-880c-c297250f77b2 -u Developer@monkeybreadsoftware.de -p @keychain:"Application Loader: Developer@monkeybreadsoftware.de"
    This may take a while till this tool returns success and you can run it several times. Otherwise you get an email when the app is done. Once done you get Package Approved in the call above.
  8. Add the staple ticket to the dmg:
    xcrun stapler staple -v /Users/cs/Desktop/Test.dmg
    This will add the notarization to the disk image.
  9. Now you can test the final app in the disk image:
    spctl -a -v /Applications/test.app
    This shows on 10.13.6 only "source=Developer ID", but on 10.14 shows "source=Notarized Developer ID", so it worked!
If you followed all steps, got the paths right and the Apple ID, bundle ID and file names, your app should show the notarized state and run without a warning dialog on MacOS 10.14 Mojave.

MBS is available for paid support to help you getting your app notarized if needed.

xDev 16.6 Issue


The November/December (16.6) issue of xDev Magazine is now available. Here's a quick preview of what's inside:

Munich 2018 by Marc Zeedar
The MBS Xojo Conference in Germany gets bigger every year. This fall it was held in Munich and Marc went so you could stay home and read all about it.

Upgrading Xojo by Jim Meyer
No doubt you have a few older Xojo projects you haven't upgraded to the current version. How much trouble will it be to get them working in the latest IDE? Will it be worth it? Jim shares his experience.

Road Work by Marc Zeedar
These days, programmers can work almost anywhere there's Internet. Marc spent a few weeks in France testing the theory and has tips for working on the road.

Building a Controller by JC Cruz
Jose shows how to build a data-entry controller.

PLUS: Clipboards, database rules, database transactions, Xojo 2018r3, and more!

Archives

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