Informatik Dienstleistungen, Unternehmens-Beratung und Schulung
Entwicklung, Hosting und Vertrieb von Informatikprodukten

Swiss Payment Filemaker PlugIn

This PlugIn for Filemaker 19 provides functions to generate a Swiss-QR Code for embedding into printing layouts. The PlugIn can produce it in EPS, SVG and PNG Format. For best printing quality use the EPS Version but the Windows Version of Filemaker can't display or use EPS in layouts, even if you try to generate a PDF.

The following function will be added by using this PlugIn with Filemaker:

Modulo10( numeric )
QRCode( format; alphanumeric {; dotsize} )
SwissQR(
        format; 
        CdtrInf.IBAN; 
        CdtrInf.Cdtr.AdrTp; 
        CdtrInf.Cdtr.Name; 
        CdtrInf.Cdtr.StrtNmOrAdrLine1; 
        CdtrInf.Cdtr.BldgNbOrAdrLine2; 
        CdtrInf.Cdtr.PstCd; 
        CdtrInf.Cdtr.TwnNm; 
        CdtrInf.Cdtr.Ctry; 
        UltmtCdtr.AdrTp; 
        UltmtCdtr.Name; 
        UltmtCdtr.StrtNmOrAdrLine1; 
        UltmtCdtr.BldgNbOrAdrLine2; 
        UltmtCdtr.PstCd; 
        UltmtCdtr.TwnNm; 
        UltmtCdtr.Ctry; 
        CcyAmt.Amt; 
        CcyAmt.Ccy; 
        UltmtDbtr.AdrTp; 
        UltmtDbtr.Name; 
        UltmtDbtr.StrtNmOrAdrLine1; 
        UltmtDbtr.BldgNbOrAdrLine2; 
        UltmtDbtr.PstCd; 
        UltmtDbtr.TwnNm; 
        UltmtDbtr.Ctry; 
        RmtInf.Tp; 
        RmtInf.Ref; 
        RmtInf.AddInf.Ustrd; 
        RmtInf.AddInf.StrdBkgInf; 
        AltPmtInf.AltPmt; 
        AltPmtInf.AltPmt
)

All fields of the SwissQR function except the "format" field, which can only be "SVG", "EPS" or "PNG", are named like in the official reference "Schweizer Implementation Guidelines QR-Rechnung" starting at Page 27. The naming convention follows object oriented style. Inside the documentation they use +, ++ and +++ for the levels inside the data structure.

The header fields Header.QRType, Header.Version and Header.Coding are not available because there are automaticly set by the function.

The Swiss-QR function checks important fields for plausibility. For example, the QR-IBAN is checked for correct formatting. The function returns an empty result if there is incorrect data given otherwise a Graphic in the specified format.

Find more information and instructions about layout conventions of a correct Swiss-QR Bill on this Homepage.

Installation

Download the PlugIn, inflate it and move it to Filemakers PlugIn location. You'll find that location by starting Filemaker and open the PlugIn section of the Preferences. There is a button to open that directory.

After restarting Filemaker open the PlugIn section of the Preferences again and select the SwissPayment PlugIn in the list. Then click on "Configure" to purchase the needed license.

Pricing & License

The license follows the workplace model. One license per workplace. A license costs 50.- SFr.