perfectlysoft/perfect-filemaker

A stand-alone Swift wrapper around the FileMaker XML Web publishing interface, enabling access to FileMaker servers.

Perfect - FileMaker Server Connector

This project provides access to FileMaker Server databases using the XML Web publishing interface.

This package builds with Swift Package Manager and is part of the Perfect project. It was written to be stand-alone and so does not need to be run as part of a Perfect server application.

Ensure you have installed and activated the latest Swift 4.1.1 tool chain.

Linux Build Notes

Ensure that you have installed curl and libxml2.

sudo apt-get install libcurl4-openssl-dev libxml2-dev

Building

Add this project as a dependency in your Package.swift file.

.package(url: "https://github.com/PerfectlySoft/Perfect-FileMaker.git", from: "3.0.0")

Examples

To utilize this package, import PerfectFileMaker.

List Available Databases

This snippet connects to the server and has it list all of the hosted databases.

let fms = FileMakerServer(host: testHost, port: testPort, userName: testUserName, password: testPassword)
fms.databaseNames {
	result in
	do {
		// Get the list of names
		let names = try result()
		for name in names {
			print("Got a database name \(name)")
		}
	} catch FMPError.serverError(let code, let msg) {
		print("Got a server error \(code) \(msg)")
	} catch let e {
		print("Got an unexpected error \(e)")
	}
}

List Available Layouts

List all of the layouts in a particular database.

let fms = FileMakerServer(host: testHost, port: testPort, userName: testUserName, password: testPassword)
fms.layoutNames(database: "FMServer_Sample") {
	result in
	guard let names = try? result() else {
		return // got an error
	}
	for name in names {
		print("Got a layout name \(name)")
	}
}

List Field On Layout

List all of the field names on a particular layout.

let fms = FileMakerServer(host: testHost, port: testPort, userName: testUserName, password: testPassword)
fms.layoutInfo(database: "FMServer_Sample", layout: "Task Details") {
	result in
	guard let layoutInfo = try? result() else {
		return // error
	}
	let fieldsByName = layoutInfo.fieldsByName
	for (name, value) in fieldsByName {
		print("Field \(name) = \(value)")
	}
}

Find All Records

Perform a findall and print all field names and values.

let query = FMPQuery(database: "FMServer_Sample", layout: "Task Details", action: .findAll)
let fms = FileMakerServer(host: testHost, port: testPort, userName: testUserName, password: testPassword)
fms.query(query) {
	result in
	guard let resultSet = try? result() else {
		return // error
	}
	let fields = resultSet.layoutInfo.fields
	let records = resultSet.records
	let recordCount = records.count
	for i in 0..<recordCount {
		let rec = records[i]
		for field in fields {
			switch field {
			case .fieldDefinition(let def):
				let fieldName = def.name
				if let fnd = rec.elements[fieldName], case .field(_, let fieldValue) = fnd {
					print("Normal field: \(fieldName) = \(fieldValue)")
				}
			case .relatedSetDefinition(let name, _):
				guard let fnd = rec.elements[name], case .relatedSet(_, let relatedRecs) = fnd else {
					continue
				}
				print("Relation: \(name)")
				for relatedRec in relatedRecs {
					for relatedRow in relatedRec.elements.values {
						if case .field(let fieldName, let fieldValue) = relatedRow {
							print("\tRelated field: \(fieldName) = \(fieldValue)")
						}
					}
				}
			}
		}
	}
}

Find All Records With Skip & Max

To add skip and max, the query above would be amended as follows:

// Skip two records and return a max of two records.
let query = FMPQuery(database: "FMServer_Sample", layout: "Task Details", action: .findAll)
	.skipRecords(2).maxRecords(2)
...

Find Records Where "Status" Is "In Progress"

Find all records where the field "Status" has the value of "In Progress".

let qfields = [FMPQueryFieldGroup(fields: [FMPQueryField(name: "Status", value: "In Progress")])]
let query = FMPQuery(database: "FMServer_Sample", layout: "Task Details", action: .find)
	.queryFields(qfields)
let fms = FileMakerServer(host: testHost, port: testPort, userName: testUserName, password: testPassword)
fms.query(query) {
	result in
	guard let resultSet = try? result() else {
		return // error
	}
	let fields = resultSet.layoutInfo.fields
	let records = resultSet.records
	let recordCount = records.count
	for i in 0..<recordCount {
		let rec = records[i]
		for field in fields {
			switch field {
			case .fieldDefinition(let def):
				let fieldName = def.name
				if let fnd = rec.elements[fieldName], case .field(_, let fieldValue) = fnd {
					print("Normal field: \(fieldName) = \(fieldValue)")
					if name == "Status", case .text(let tstStr) = fieldValue {
						print("Status == \(tstStr)")
					}
				}
			case .relatedSetDefinition(let name, _):
				guard let fnd = rec.elements[name], case .relatedSet(_, let relatedRecs) = fnd else {
					continue
				}
				print("Relation: \(name)")
				for relatedRec in relatedRecs {
					for relatedRow in relatedRec.elements.values {
						if case .field(let fieldName, let fieldValue) = relatedRow {
							print("\tRelated field: \(fieldName) = \(fieldValue)")
						}
					}
				}
			}
		}
	}
}

perfect-filemaker's Issues

The code compiles using the examples using spm and MacOS X

swift build && ./.build/x86_64-apple-macosx10.10/debug/PerfectTemplate

I have tried just about all the examples on the page, however all of them behave exactly the same as typing: echo -n and hitting enter in the terminal. I know FileMaker is set up correctly as I can use both curl and FX.php against the FileMaker server.

$ cat Sources/PerfectTemplate/main.swift
import PerfectHTTP
import PerfectHTTPServer
import PerfectSMTP
import PerfectFileMaker

let fms = FileMakerServer( host: "127.0.0.1", port: 8180, userName: "username", password: "password" )

print( fms )

fms.layoutInfo( database: "db", layout: "layout {
	result in
	guard let layoutInfo = try? result() else {
                print( "No result" )
		return // error
	}
	let fieldsByName = layoutInfo.fieldsByName
	for ( name, value ) in fieldsByName {
		print( "Field \( name ) = \( value )" )
	}
}

Building and running the code:

$ swift build && ./.build/x86_64-apple-macosx10.10/debug/PerfectTemplate
warning: PackageDescription API v3 is deprecated and will be removed in the future; used by package(s): libxml2
Compile Swift Module 'PerfectTemplate' (1 sources)
Linking ./.build/x86_64-apple-macosx10.10/debug/PerfectTemplate
FileMakerServer(host: "filemaker.lan.domain.tld", port: 80, userName: "username", password: "password" )
devMB15R:PerfectTemplate user$

$ cat Package.swift
// swift-tools-version:4.0

import PackageDescription
let projectName = "PerfectTemplate"
let package    = Package(
	name: projectName,
	products: [
		.executable(name: "PerfectTemplate", targets: ["PerfectTemplate"])
	],
	dependencies: [
		.package(url: "https://github.com/PerfectlySoft/Perfect-HTTPServer.git", from: "3.0.0" ),
		.package(url: "https://github.com/PerfectlySoft/Perfect-FileMaker.git", from: "3.0.0" ),
		.package(url: "https://github.com/PerfectlySoft/Perfect-SMTP.git", from: "3.0.0" ),
	],
	targets: [
		.target( name: projectName,
     dependencies: [
       "PerfectHTTPServer",
       "PerfectSMTP",
       "PerfectFileMaker",
     ]
   )
	]
)

also tried to set up netcat to no avail

let fms = FileMakerServer( host: "127.0.0.1", port: 8180, userName: "username", password: "password" )

And listening as below:

nc -l -p 8180

No output.

If there was errors I could correct myself, when there is apathy I'm having a hard time.