Monkeybread Software - MBS FileMaker Plugin: ZUGFeRD Invoice

Components	All	New	MacOS		Windows		Linux		iOS
Examples	Mac & Win		Server	Client	Guides	Statistic	FMM	Blog	Deprecated	Old

MBS FileMaker Plugin Example Databases

ZUGFeRD Invoice

All examples are included with download of MBS FileMaker Plugin.

ZUGFeRD Invoice.fmp12

Overview
Tables	1
Relationships	0
Layouts	1
Scripts	4
Value Lists	0
Custom Functions	0
Custom Menus	33

File Options
Default custom menu set	[Standard FileMaker Menus]
Default theme	Apex Blue
When opening file
Minimum allowed version	12.0
Login using	Account Name; Account= Admin
Allow user to save password	On
Require iOS passcode	Off
Show Sign-in fields	Off
Switch to layout	Off
Hide all toolbars	Off
Script triggers
OnFirstWindowOpen	Off
OnLastWindowClose	Off
OnWindowOpen	Off
OnWindowClose	Off
OnFileAVPlayerChange	Off
OnWindowTransaction	Off
Thumbnail Settings
Generate Thumbnails	On; Temporary

Tables

Table Name	Statistics	Occurrences in Relationship Graph
ZUGFeRD Invoice	6 fields defined, 1 record	ZUGFeRD Invoice

Fields

Table Name: ZUGFeRD Invoice - 6 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
Invoice Template	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1		ZUGFeRD Invoice		Create PDF with Existing PDF
Output PDF	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1		ZUGFeRD Invoice		Create PDF with Existing PDF Create PDF with New PDF Clear
Invoice XML	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		ZUGFeRD Invoice		Create PDF with Existing PDF Create PDF with New PDF
Gray ICC Profile	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1		ZUGFeRD Invoice		Create PDF with Existing PDF
RGB ICC Profile	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1		ZUGFeRD Invoice		Create PDF with Existing PDF Create PDF with New PDF
CMYK ICC Profile	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1		ZUGFeRD Invoice		Create PDF with Existing PDF Create PDF with New PDF

Layout Objects: ZUGFeRD Invoice

Regular Fields

Field Name: ZUGFeRD Invoice::Invoice Template

Layout Name:

ZUGFeRD Invoice

Top: 162 pt
Left: 138 pt
Bottom: 287 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Field Name: ZUGFeRD Invoice::Output PDF

Layout Name:

ZUGFeRD Invoice

Top: 288 pt
Left: 138 pt
Bottom: 413 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Field Name: ZUGFeRD Invoice::Invoice XML

Layout Name:

ZUGFeRD Invoice

Top: 162 pt
Left: 474 pt
Bottom: 410 pt
Right: 787 pt

Anchoring: Left and Right, Top and Bottom

Field Format:

Edit Box
Include vertical scrollbar

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Disable visual spell-checking
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: ZUGFeRD Invoice::Gray ICC Profile

Layout Name:

ZUGFeRD Invoice

Top: 60 pt
Left: 288 pt
Bottom: 145 pt
Right: 373 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Field Name: ZUGFeRD Invoice::RGB ICC Profile

Layout Name:

ZUGFeRD Invoice

Top: 60 pt
Left: 378 pt
Bottom: 145 pt
Right: 463 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Field Name: ZUGFeRD Invoice::CMYK ICC Profile

Layout Name:

ZUGFeRD Invoice

Top: 60 pt
Left: 468 pt
Bottom: 145 pt
Right: 553 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Type:

Text: Create PDF with existing PDF

Layout Name:

ZUGFeRD Invoice

Top: 428 pt
Left: 22 pt
Bottom: 458 pt
Right: 208 pt

Anchoring: Left, Top

Perform Script [ “Create PDF with Existing PDF” ]

Scripts:

Create PDF with Existing PDF

Button Properties

Coordinates

Script/Script Step

Type:

Text: Create PDF with new PDF

Layout Name:

ZUGFeRD Invoice

Top: 428 pt
Left: 223 pt
Bottom: 458 pt
Right: 391 pt

Anchoring: Left, Top

Perform Script [ “Create PDF with New PDF” ]

Scripts:

Create PDF with New PDF

Script Hierarchy

InitDynaPDF

Create PDF with Existing PDF

Create PDF with New PDF

Clear

Next Script: [Create PDF with Existing PDF]

Script Name	InitDynaPDF
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script	Create PDF with Existing PDF Create PDF with New PDF
Script Definition
Script Steps	#Locate DynaPDF library #you can have libraries in container and export at runtime to folder of your choice. #Or install library somewhere and pass path. #If library is in same folder as plugin, you can only pass only file name. If [ MBS("IsServer") ] #Put the path you use for your server here: If [ Get(SystemPlatform) = -2 ] #Server on Windows Set Variable [ $path; Value:"C:\Programs\FileMaker Server\dynapdf.dll" ] Else If [ MBS("IsLinux") ] #Server on Linux for FileMaker Cloud Set Variable [ $path; Value:"/opt/FileMaker/FileMaker Server/dynapdf.linux.so" ] Else [ ] #Server on Mac Set Variable [ $path; Value: "/Library/FileMaker Server/dynapdf.dylib" ] End If Else [ ] #For desktop and our examples we look in same folder as database: Set Variable [ $databasePath; Value:Get(FilePath) ] Set Variable [ $databasePath; Value:MBS("Path.FilemakerPathToNativePath"; $databasePath) ] Set Variable [ $databasePath; Value:Substitute ( $databasePath ; ".fp7" ; ".fmp12") ] Set Variable [ $databaseName; Value:Get(FileName) & ".fmp12" ] If [ Get(SystemPlatform) = -2 ] Set Variable [ $path; Value:Substitute ( $databasePath ; $databaseName ; "dynapdf.dll" ) ] #plugin will look for dynapdf.dll and if not found also for dynapdf.dll (64-bit) and dynapdf32.dll (32-bit). Else [ ] Set Variable [ $path; Value:Substitute ( $databasePath ; $databaseName ; "dynapdf.dylib" ) ] #Mac dylib is usually 32 and 64 bit together. End If #remove folder name Set Variable [ $path; Value:Substitute ( $path ; "ZUGFeRD and Facture-X/"; "" ) // macOS ] Set Variable [ $path; Value:Substitute ( $path ; "ZUGFeRD and Facture-X\\"; "" ) // Windows ] End If #You can test for free. #If you like to get a dynapdf license, please follow links on our pricing page: #https://www.monkeybreadsoftware.de/filemaker/pricing.shtml Set Variable [ $LicenseKey; Value:"" // put your key here or leave empty for demo. // Use e.g. "Lite", "Pro" or "Starter" to use demo mode for just that mode. ] Set Variable [ $r; Value:MBS( "DynaPDF.Initialize"; $path; $LicenseKey) ] If [ $r ≠ "OK" ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “No”; Button 2: “Cancel”, Commit: “No” ] Halt Script End If
Fields used in this script
Scripts used in this script
Layouts used in this script
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [InitDynaPDF]

Next Script: [Create PDF with New PDF]

Script Name	Create PDF with Existing PDF
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
Layouts that use this script	ZUGFeRD Invoice
Scripts that use this script
Script Definition
Script Steps	#Initialize DynaPDF if needed If [ MBS("DynaPDF.IsInitialized") ≠ 1 ] Perform Script [ “InitDynaPDF” ] End If #Make new PDF environments Set Variable [ $pdf; Value:MBS("DynaPDF.New") ] #Set import flags with Prepare For PDF/A enabled Set Variable [ $r; Value:MBS( "DynaPDF.SetImportFlags"; $pdf; "ImportAll¶ImportAsPage¶PrepareForPDFA" ) ] #Load PDF from container Set Variable [ $r; Value:MBS("DynaPDF.OpenPDFFromContainer"; $pdf; ZUGFeRD Invoice::Invoice Template) ] #Import all pages Set Variable [ $r; Value:MBS("DynaPDF.ImportPDFFile"; $pdf) ] #PDF/A requires a language set Set Variable [ $r; Value:MBS("DynaPDF.SetLanguage"; $pdf; "de-DE") ] #PDF/A requires a structure tree Set Variable [ $r; Value:MBS("DynaPDF.CreateStructureTree"; $pdf) ] # Set replacements for missing ICC profiles Set Variable [ $r; Value:MBS("DynaPDF.SetReplaceICCProfileData"; $pdf; "rgb"; ZUGFeRD Invoice::RGB ICC Profile) ] Set Variable [ $r; Value:MBS("DynaPDF.SetReplaceICCProfileData"; $pdf; "gray"; ZUGFeRD Invoice::Gray ICC Profile) ] Set Variable [ $r; Value:MBS("DynaPDF.SetReplaceICCProfileData"; $pdf; "cmyk"; ZUGFeRD Invoice::CMYK ICC Profile) ] #add xml with invoice data #For ZUGFeRD and Factor-X, please use this file names: ZUGFeRD 1.x: "ZUGFeRD-invoice.xml" ZUGFeRD 2.x: "zugferd-invoice.xml" Factur-X / ZUGFeRD 2.1: "factur-x.xml" XRechnung: "xrechnung.xml" Set Variable [ $XML; Value:ZUGFeRD Invoice::Invoice XML ] Set Variable [ $XML; Value:MBS("Text.ReplaceNewline"; $XML; 2) // LF for line ending ] Set Variable [ $FileHandle; Value:MBS("DynaPDF.AttachFileText"; $pdf; $XML; "UTF-8"; "factur-x.xml"; "Factur-X/ZUGFeRD-Rechnung") ] Set Variable [ $r; Value:MBS("DynaPDF.AssociateEmbFile"; $pdf; "Catalog"; -1; "Alternative"; $FileHandle) ] #Check if this PDF conforms to PDF/A-3b Set Variable [ $c; Value:MBS("DynaPDF.CheckConformance"; $pdf; "FacturX Basic"; "Default") ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Failed to check conformance"; Message: $c; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ] End If If [ $c = 1 ] # A RGB ICC profile must be added to the document Set Variable [ $r; Value:MBS("DynaPDF.AddOutputIntentEx"; $pdf; ZUGFeRD Invoice::RGB ICC Profile) ] Else If [ $c = 2 ] # A CMYK ICC profile must be added to the document Set Variable [ $r; Value:MBS("DynaPDF.AddOutputIntentEx"; $pdf; ZUGFeRD Invoice::CMYK ICC Profile) ] Else If [ $c = 3 ] # A Gray, RGB, or CMYK ICC profile must be added to the document Set Variable [ $r; Value:MBS("DynaPDF.AddOutputIntentEx"; $pdf; ZUGFeRD Invoice::RGB ICC Profile) ] End If #save to container Set Variable [ $PDFData; Value:MBS("DynaPDF.Save"; $pdf; "invoice.pdf") ] Set Field [ ZUGFeRD Invoice::Output PDF; $PDFData ] Commit Records/Requests #cleanup memory Set Variable [ $r; Value:MBS("DynaPDF.Release"; $pdf) ]
Fields used in this script	ZUGFeRD Invoice::Invoice Template ZUGFeRD Invoice::RGB ICC Profile ZUGFeRD Invoice::Gray ICC Profile ZUGFeRD Invoice::CMYK ICC Profile ZUGFeRD Invoice::Invoice XML ZUGFeRD Invoice::Output PDF
Scripts used in this script	InitDynaPDF
Layouts used in this script
Tables used in this script	ZUGFeRD Invoice
Table occurrences used by this script	ZUGFeRD Invoice
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Create PDF with Existing PDF]

Next Script: [Clear]

Script Name	Create PDF with New PDF
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
Layouts that use this script	ZUGFeRD Invoice
Scripts that use this script
Script Definition
Script Steps	#Initialize DynaPDF if needed If [ MBS("DynaPDF.IsInitialized") ≠ 1 ] Perform Script [ “InitDynaPDF” ] End If #Make new PDF environments Set Variable [ $pdf; Value:MBS("DynaPDF.New") ] #set options Set Variable [ $r; Value:MBS("DynaPDF.SetPageCoords"; $pdf; "topdown") ] Set Variable [ $r; Value:MBS("DynaPDF.SetLanguage"; $pdf; "en-US") ] Set Variable [ $r; Value:MBS("DynaPDF.CreateStructureTree"; $pdf) ] #Add page with some text Set Variable [ $r; Value:MBS("DynaPDF.AppendPage"; $pdf) ] Set Variable [ $r; Value:MBS("DynaPDF.SetTextRect"; $pdf; 100; 100; 400; 200) ] Set Variable [ $r; Value:MBS("DynaPDF.SetFont"; $pdf; "Times"; 1; 40; 1; "cp1252") ] Set Variable [ $r; Value:MBS("DynaPDF.WriteFText"; $pdf; "Center"; "Just a test PDF.") ] Set Variable [ $r; Value:MBS("DynaPDF.EndPage"; $pdf) ] #add xml #For ZUGFeRD and Factor-X, please use this file names: ZUGFeRD 1.x: "ZUGFeRD-invoice.xml" ZUGFeRD 2.x: "zugferd-invoice.xml" Factur-X / ZUGFeRD 2.1: "factur-x.xml" XRechnung: "xrechnung.xml" Set Variable [ $FileHandle; Value:MBS("DynaPDF.AttachFileText"; $pdf; ZUGFeRD Invoice::Invoice XML; "UTF-8"; "factur-x.xml"; "Factur-X/ZUGFeRD-Rechnung") ] Set Variable [ $r; Value:MBS("DynaPDF.AssociateEmbFile"; $pdf; "Catalog"; -1; "Alternative"; $FileHandle) ] #Check if this PDF conforms to PDF/A-3b Set Variable [ $c; Value:MBS("DynaPDF.CheckConformance"; $pdf; "FacturX Basic"; "Default") ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Failed to check conformance"; Message: $c; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ] End If If [ $c = 1 ] # A RGB ICC profile must be added to the document Set Variable [ $r; Value:MBS("DynaPDF.AddOutputIntentEx"; $pdf; ZUGFeRD Invoice::RGB ICC Profile) ] Else If [ $c = 2 ] # A CMYK ICC profile must be added to the document Set Variable [ $r; Value:MBS("DynaPDF.AddOutputIntentEx"; $pdf; ZUGFeRD Invoice::CMYK ICC Profile) ] Else If [ $c = 3 ] # A Gray, RGB, or CMYK ICC profile must be added to the document Set Variable [ $r; Value:MBS("DynaPDF.AddOutputIntentEx"; $pdf; ZUGFeRD Invoice::RGB ICC Profile) ] End If #Save to container Set Variable [ $PDFData; Value:MBS("DynaPDF.Save"; $pdf; "invoice.pdf") ] Set Field [ ZUGFeRD Invoice::Output PDF; $PDFData ] Commit Records/Requests #cleanup memory Set Variable [ $r; Value:MBS("DynaPDF.Release"; $pdf) ]
Fields used in this script	ZUGFeRD Invoice::Invoice XML ZUGFeRD Invoice::RGB ICC Profile ZUGFeRD Invoice::CMYK ICC Profile ZUGFeRD Invoice::Output PDF
Scripts used in this script	InitDynaPDF
Layouts used in this script
Tables used in this script	ZUGFeRD Invoice
Table occurrences used by this script	ZUGFeRD Invoice
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Create PDF with New PDF]

Script Name	Clear
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	Set Field [ ZUGFeRD Invoice::Output PDF; "" ]
Fields used in this script	ZUGFeRD Invoice::Output PDF
Scripts used in this script
Layouts used in this script
Tables used in this script	ZUGFeRD Invoice
Table occurrences used by this script	ZUGFeRD Invoice
Custom Functions used by this script
Custom menu set used by this script

Download example: ZUGFeRD Invoice

Used functions: