fmAccounting Link (MYOB AccountRight Edition) Now Supports Jobs

/0 Comments/in , , , , /by

We’ve just finished an update to fmAccounting Link (MYOB AccountRight Edition) which now includes examples for working with Jobs, one of the most requested features from our customers. fmAccounting Link shows you how you can use FileMaker to:

  • download Jobs from MYOB to FileMaker (all Jobs or filtered by Start Date)
  • create Jobs in FileMaker and upload them to MYOB
  • update a single Job from MYOB
  • enter a Job against an Invoice Line Item or a General Journal Item
  • download a Job Budget from MYOB to FileMaker and send an updated version back to MYOB

This is a free update for all existing customers. You can view the full release notes on our version history page. If there are other features you would like to see in the core fmAccounting Link (MYOB AccountRight Edition) file please get in touch and let us know.

New fmAccounting Link (Xero Edition) Videos

/0 Comments/in , , , , /by

We’ve just uploaded a couple of new videos demonstrating how you can work with Prepayments and Overpayments using fmAccounting Link (Xero Edition). In each video we cover:

  • creating a new Prepayment and Overpayment from a Customer
  • allocating the Prepayment/Overpayment to an Invoice
  • refunding the balance of the Prepayment/Overpayment

You can watch these videos on the Videos page or here are the direct links:

Prepayments in fmAccounting Link

Overpayments in fmAccounting Link

fmEcommerce Link (WooCommerce Edition) Update

/0 Comments/in , , , , , /by

We’ve just released our first update to fmEcommerce Link (WooCommerce Edition) for 2017 – this release provides an alternative method for handling authentication for some servers that may not parse the Authorization header correctly, as well as making the process of working with Product Variations much easier.

The WooCommerce REST API docs mention that some servers may not parse the Authorization header correctly – we’ve never encountered this during the testing and development of fmEcommerce Link but recently a customer contacted us after having trouble getting started with fmEcommerce Link (WooCommerce Edition). Upon further investigation we noticed that were receiving the same error each time they attempted to download data from WooCommerce:

{
 "code": "woocommerce_rest_cannot_view", 
 "data": {
 "status": 401
 }, 
 "message": "Sorry, you cannot list resources."
}

After many hours of frustration we stumbled across the suggestion to switch from using HTTP Basic Auth and implemented a change to test this and had immediate success. We’ve decided to add a toggle that users can switch on/off in case anyone else in the future encounters this issue:

We’ve also made it easier to download, update, create and view Product Variations in the fmEcommerce Link (WooCommerce Edition) file:

and also show which variations were selected when viewing an Order:

This is a free update to all our existing customers – we have a number of items on the list to add, including Refunds (create a Refund in FileMaker and upload to WooCommerce) and download Reviews. If there’s any examples that we don’t currently have that you would like to see please get in touch and let us know.

fmAccounting Link (Xero Edition) – Prepayments Update

/0 Comments/in , , , /by

Our first update to fmAccounting Link (Xero Edition) for 2017 is now out the door – this release includes a number of minor enhancements as well as a new endpoint example: Prepayments. We’ve had a number of requests for Prepayments so we’re happy to release this free update to all our existing customers.

The fmAccounting Link (Xero Edition) file has examples for:

  • downloading Prepayments from Xero (all Prepayments or between 2 dates)
  • creating a Prepayment in FileMaker and pushing to Xero
  • allocating Invoices to a Prepayment in FileMaker and pushing to Xero
  • creating a Refund for a Prepayment in FileMaker and pushing to Xero

Further details on fmAccounting Link (Xero Edition) including the full list of examples are available on the fmAccounting Link (Xero Edition) product page. If there’s any examples that we don’t currently have that you would like to see please get in touch and let us know – we’re already working on the next round of enhancements and examples based on customer feedback.

North West Sydney FileMaker Developer Meetup Dates for 2017

/0 Comments/in , , /by

The dates for the 2017 North West Sydney FileMaker Developer Meetups have been finalised so you can lock these into your diary now:

February 24th (Pennant Hills Bowling Club 12:30pm)

May 26th (Pennant Hills Bowling Club 12:30pm)

August 25th (Pennant Hills Bowling Club 12:30pm)

December 6th Xmas Meetup (Sydney CBD 7pm – location TBD – suggestions welcome)

If you would like to join the mailing list just visit the signup page at:

http://databuzz.us12.list-manage.com/subscribe?u=366d1a87399a120a9d438cb56&id=8bb1fea366

We’ll send our reminders before each meeting – anyone is welcome to attend and no RSVP is required

fmAccounting Link (MYOB AccountRight Edition) Updates – my.MYOB Login and General Journals

/0 Comments/in , , , , , /by

We’ve been busy working on some updates to fmAccounting Link (MYOB AccountRight Edition) over the past few weeks. fmAccounting Link (MYOB AccountRight Edition) was a popular item during our recent End Of Year sale and we’ve had some great feedback from customers about features they would like to see in future releases.

We’ve just released an updated version of fmAccounting Link  – v1.0.8. As well as the usual bug fixes we’ve added examples for working with the General Journals API endpoint – you can now download, create and update General Journals from FileMaker using fmAccounting Link. We’ve also added support for users that have linked their MYOB Company File User ID to their my.MYOB login – typically this is set using either of the following dialogs in AccountRight:

We couldn’t find anything about working with linked my.MYOB logins in the API documentation and after raising a ticket with MYOB developer support we were informed about the changes you need to make when working with linked my.MYOB accounts. We’ve added a new checkbox to the MYOB Company screen that allows you to flag that you’ll be using a linked my.MYOB login:

which handles the required changes automatically. For existing customers using older versions of fmAccounting Link you can simply disable a single script step to handle working with linked my.MYOB logins – see our FAQ page for details.

We’ve started working on adding examples for working with the JOBS API endpoint and hope to have this completed in the next few weeks. If there are features you would like to se in the core fmAccounting Link (MYOB AccountRight Edition) file please get in touch and let us know. You can view the full release notes on our version history page.

fmEcommerce Link (WooCommerce Edition) and Webhooks

/1 Comment/in , , , , /by

When we released fmEcommerce Link (WooCommerce Edition) last week there was one feature that we wanted to include that wasn’t quite ready: Order Webhooks. The initial release of fmEcommerce Link lets you download orders from WooCommerce, either all at once or within a specified date range. For many users that will be sufficient as they might only need to download all orders from the previous day.

Some customers would prefer to be notified immediately the order was placed and have it automatically download into FileMaker – you could setup a server side schedule that ran every x minutes that checked for new orders since a specified timestamp, but it’s much more efficient to leverage Webhooks if they are available. A Webhook is simply a way of having WooCommerce send a notification to another service at a nominated URL when a particular event is triggered.

Webhooks were introduced in WooCommerce 2.2 and can trigger events each time you add, edit or delete orders, products, coupons or customers. New orders seemed the logical place to start – wouldn’t it be great if upon receiving a new order in WooCommerce it could be pushed to the fmAccounting Link FileMaker file automatically without you having to do anything?

We’ll be releasing a free update to fmEcommerce Link (WooCommerce Edition) in the next couple of days which will include support for Webhooks when a new Order is created. You will need to setup a Webhook and install the supplied PHP file on your FileMaker Server (you will need to enable Custom Web Publishing/PHP in your FileMaker Server Admin Console), and once this in place anytime a new Order is received in WooCommerce it will automatically be pushed to the fmEcommerce Link file, typically within a few seconds.

This was a feature that we wanted for ourselves to completely streamline the order entry process for our business – there’s nothing better than waking up in the morning and seeing new overnight orders already in the fmEcommerce Link file. Here’s a short video demonstrating this in action (you can also watch this on YouTube here):

 

 

Databuzz releases fmEcommerce Link (WooCommerce Edition) – Integrate FileMaker Pro and WooCommerce

/0 Comments/in , , , , /by

Sydney, Australia – December 14, 2016 – Databuzz today announced fmEcommerce Link (WooCommerce Edition), a FileMaker solution that integrates with the WooCommerce eCommerce platform.

fmEcommerce Link (WooCommerce Edition) allows you to upload and download data between your FileMaker solution and WooCommerce, the popular plugin for WordPress that powers over 39% of all online stores. fmEcommerce Link (WooCommerce Edition) removes double data entry and human errors saving your company significant time, money and hassle by automating the exchange of data between FileMaker and WooCommerce.

fmEcommerce Link (WooCommerce Edition) is completely unlocked allowing you to integrate it into your FileMaker solution. You can copy and paste examples showing you how to authenticate with the WooCommerce API and download Customers, Orders, Products, Coupons and more at the click of a button.

fmEcommerce Link (WooCommerce Edition) features include:

  • works with FileMaker Pro v12, v13, v14 and v15
  • works with Macintosh and Windows
  • completely unlocked
  • can be hosted by FileMaker Pro or FileMaker Server
  • works with WooCommerce v2.6 or later (HTTPS required)

“Like many of our customers we use FileMaker Pro to run our business and WooCommerce for our eCommerce platform,” said Andrew Duncan, CEO of Databuzz. “We didn’t want to have to manually re-enter Customers and Orders in FileMaker, so we built fmEcommerce Link (WooCommerce Edition) to streamline our business and now we’re making it available for everyone. With fmEcommerce Link (WooCommerce Edition) you can push and pull data between FileMaker and WooCommerce at the click of a button.”

fmEcommerce Link (WooCommerce Edition) includes examples for the following WooCommerce API endpoints:

  • Customers: download and upload Customers
  • Products: download and upload Products
  • Orders: download Orders from WooCommerce (including Order line items)
  • Coupons: download and upload Coupons
  • Tax Rates: download Tax Rates from WooCommerce
  • Tax Classes: download Tax Classes from WooCommerce
  • Categories: download Categories from WooCommerce
  • Attributes: download Product Attributes from WooCommerce
  • Shipping Classes: download Product Shipping Classes from WooCommerce
  • Tags: download Product Tags from WooCommerce

 Availability, Pricing, and Compatibility

fmEcommerce Link (WooCommerce Edition) is available in a number of licenses: Company, Vertical Solution and Developer. It is available now from the Databuzz website at http://www.databuzz.com.au/fmecommerce-link-woocommerce-edition/. As part of the Databuzz End of Year Xmas Sale all Licenses are 20% until December 31, 2016. Company Licenses start at AUD $495.00. fmEcommerce Link (WooCommerce Edition) requires FileMaker Pro v12, v13, v14 or v15 and WooCommerce v2.6 or later using HTTPS.

Media/Customer Contact:

Andrew Duncan

Phone: +61 418 468 103

sales@databuzz.com.au

http://www.databuzz.com.au

About Databuzz: Databuzz is a long standing member of the FileMaker Business Alliance. We have been developing and deploying FileMaker solutions for clients in Australia and internationally since 1999. Our clients are individuals, small-medium businesses, government agencies and multi-national corporations. Databuzz was founded by Andrew Duncan, a Certified FileMaker 15 Developer. For more information please visit our website at http://www.databuzz.com.au.

###

FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries. All other trademarks are the property of their respective owners.

Databuzz 2016 End of Year Xmas Sale – 20% Off All Licenses

/0 Comments/in , , , , , , , /by

databuzz-xmas-sale-2016

It’s time for the Databuzz End of Year Xmas Sale – All Product Licenses are now 20% Off, including:

The sale runs until the end of the day on the 31st December, 2016 (Australian Eastern Daylight Time).

All our prices are in Australian dollars – if you’re purchasing from outside of Australia you’ll also get to take advantage of the low Australia dollar (1 Australian Dollar equals approximately 0.74 US Dollars).

Discounts are applied automatically – no coupons required! Click here to start shopping.

We also have a similar sale on fmSMS Licenses (20% off) – click here to visit the fmSMS website for further details.

fmEcommerce Link (WooCommerce Edition) Preview Video

/2 Comments/in , , , , /by

Last week we announced the upcoming release of our latest FileMaker integration solution – fmEcommerce Link (WooCommerce Edition) – and included some screenshots. We’re in the final stages of testing and working on the website product pages etc but I can confirm that v1.0 will have the following features:

  • download Customers, Products, Orders, Tax Rates, Tax Classes, Categories, Attributes, Shipping Classes and Tags from WooCommerce
  • download all Product Details, including Images
  • update existing Customer, Product and Order records from WooCommerce to FileMaker
  • download Orders between 2 dates
  • create/update a Customer record from FileMaker to WooCommerce

Like our other products it will also have these features:

  • will work with FileMaker Pro v12, 13, 14 and 15
  • can be hosted by FileMaker Pro or FileMaker Server
  • works with Macintosh and Windows
  • 100% unlocked for you to integrate into your own FileMaker solution

I’ve put together a short preview video showing fmEcommerce Link (WooCommerce Edition) in action downloading Products, Orders and Customer data from WooCommerce to FileMaker. You can watch this below or via this link on YouTube: