F2X Pro – FAQs

How long does the demo last?
You may test out the plug-in free of cost for 30 days.

Can I use my license on multiple computers?
Each license subscription is valid for a single computer.

The plugin worked with FileMaker Pro 13 or earlier but it stopped working on FileMaker Pro 14?
F2X Pro 1.0 is only available for 32 bit architecture. You need to insure that FileMaker Pro is installed as a 32 bit application.
F2X Pro 2.0 is available as 32 bit and 64 bit. Ensure you have matched the plugin to the installation.

I’ve followed the F2X Pro 2.0 wizard and I keep getting an error message
“…Consumer%20Key%20Was%20Not%20Recognised”

  • Ensure that only one FileMaker file that references the plugin is open at time you call the plugin (close the other file).
  • Ensure that your Xero Application is set for a Private Key, not a Public Key. If you have chosen a Public Key, you will need to start from scratch;
    • Delete the account in the Plugin Preferences panel
    • Clear the relevant fields in the Sample File preferences: Consumer Key, Private Key, PublicKey, Unique ID
    • Delete the Xero Application and create a new one with a different name (important!)
    • Run the Wizard again.

I’ve followed the F2X Pro 2.0 wizard and I keep getting this error message instead
“…The%20nonce%20value….has%20already%20been%20used”

You need to start from scratch;
  • Delete the account in the Plugin Preferences panel
  • Clear the relevant fields in the Sample File preferences: Consumer Key, Private Key, PublicKey, Unique ID
  • Delete the Xero Application and create a new one with a different name (important!)
  • Run the Wizard again.

What format do dates need to be?
All dates need to be in the YYYY-MM-DD format. For example:

CF2X_AddOptionalField ( "Date" ; "31/01/2014" ) // This will fail
CF2X_AddOptionalField ( "Date" ; "31-01-2014" ) // This will also fail
CF2X_AddOptionalField ( "Date" ; "2014-01-31" ) // This will succeed


Are the function parameters case-sensitive?
End points and field names are case-sensitive. For example:

CF2X_GetFieldByID ( "contacts" ) // This will fail
CF2X_GetFieldByID ( "CONTACTS" ) // This will also fail
CF2X_GetFieldByID ( "Contacts" ) // This will succeed


What is the ClearData function and when do I need to use it?
The ClearData function is used to clear all and any data stored in the plug-in which has been downloaded from Xero or uploaded to Xero. It is best practice to call this method after you have finished working with an end point, whether it be uploading or downloading. For example:

CF2X_GetFieldByID ( "Contacts" ) // Download Contacts from Xero
CF2X_ClearData ( 1 ) // Clear Contacts data from the plug-in
CF2X_GetFieldByID ( "Invoices" ) // Download Invoices from Xero


What are the “set header” functions and how do I use them?
There are four functions which can be used to manipulate the headers when downloading from Xero, to help get more precise data. The functions need to be called prior to a download. Once these headers have been set, they remain set until the ClearData function is called. For example:

// Get Contacts modified after January 1st, 2014
CF2X_SetModifiedAfterHeader ( "2014-01-01T00:00:00" )

// Order the results by their email alphabetically
CF2X_SetOrderByHeader ( "EmailAddress" )

CF2X_GetFieldByID ( "Contacts" ) // Download Contacts from Xero
CF2X_ClearData ( 1 ) // Clear Contacts data and header info from the plug-in


How can I double check my data before uploading it to Xero?
Using the GetXML function, you are able to preview a XML representation of the data you have stored in the plug-in. For example:

CF2X_AddContact ( "Foundation Data Ltd" ) // Create a Contact

// Set the email for the Contact
CF2X_AddOptionalField ( "EmailAddress" ; "contact@foundationdata.co.nz" )

// Set the website for the Contact
CF2X_AddOptionalField ( "Website" ; "www.foundationdata.co.nz" )

CF2X_GetXML ( 1 ) // Preview the XML data

Will return:

<Contacts><Contact><Name>Foundation Data Ltd</Name><EmailAddress>contact@foundationdata.co.nz</EmailAddress><Website>www.foundationdata.co.nz</Website></Contact></Contacts>

How can I obtain the Xero Identifiers for Invoices I just uploaded?
Using the GetLastUploadIDs function, you are able to retrieve a list of the Xero Identifiers for the most recently uploaded objects. Note, this will only get the IDs for objects uploaded in the last upload, not all uploads. For example:

// Create a Contact to upload to Xero

CF2X_AddContact ( "John Key" )

CF2X_UploadToXero ( 1 ) // Upload the data to Xero

// Create some more Contacts to upload to Xero

CF2X_AddContact ( "Tom Cruise" )

CF2X_AddContact ( "Meryl Streep" )

CF2X_AddContact ( "Brad Pitt" )

CF2X_UploadToXero ( 1 ) // Upload the data to Xero

CF2X_GetLastUploadIDs ( 1 ) // Get the IDs for the uploaded Contacts

Will return (note only 3 IDs):

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx