Archive for category Case Studies

Let us help you harness the power of APIs with Claris FileMaker Pro

While our primary development efforts at NRG revolve around shipping and carrier APIs, we often assist other Claris developers with projects related to other APIs. With our knowledge of XML and JSON creation and parsing, we can often provide assistance to jumpstart integrations and save considerable time and effort. Contact our sales department for more information on our development services.

ShipStation APIs

We recently did a projet where a customer was implementing NRGship for Endicial Label Server to replace label generation thru ShipStation. The customer wanted to maintain their existing multi-channel order downloads in ShipStation for the time being, but wanted more finite control over label generation from FileMaker. Their workflow consisted of downloading orders (TXT) from ShipStation and importing into their FileMaker ERP. While we were able to quickly add the label generation functionality to their solution, the ShipStation order download only provided limited data. In order to update track info in ShipStation, we needed the order’s internal ID which was not provided in the download. By implementing ShipStation APIs to search for orders, we were able to get the internal ID, and afterwards utilize that ID to update the order and add the appropriate tracking information.

Acuity Scheduling

We responded to a post on FaceBook where a member of the FileMaker community was looking to access their appointment data from the web based Accuity Scheduling system from their FileMaker database. We created a simple database using Insert from URL that would query appointment data and then add or update records in the FileMaker table based on the query result. In addition, another function was created to download client data from Accuity so that it could be used as a Source of Truth for customer information.

Veryfi Invoice Data

We helped another developer who was looking to utlilize the Veryfi API to extract data from PDF invoices. We built scripts which would encode and upload a PDF document from a container field, and then parse out the invoice and line item data from the JSON into FileMaker records.

No Comments

How easy is it to integrate my database with NRGship?

This is a common question we get from other FileMaker developers. Recently we were contacted by a customer who wanted help integrating their mailing database with NRGship FedEx for FileMaker. This customer had a fairly simple use case – on a weekly or monthly basis they are sending out printed materials to one of a few hundred locations. Each shipment could be one or more boxes of a varied weight via FedEx Ground. They’d also like to see shipment history and tracking for previous shipments. In under two hours we were able to modify their database so they could perform the following functions:

  • Add a shipment with one or more more packages to a CRM record
  • Capture weight off a USB-connected scale
  • Select pre-defined box sizes or enter dimensions manually
  • Print shipping labels to a networked Zebra printer
  • Allow users with certain permisions to void or delete shipments
  • Show a history of shipments with links to track at FedEx.com
  • Produce FedEx Ground End Of Day reports
  • Validate delivery addresses on data entry screens (and batch validate existing addresses)

All of this development was done using standard FileMaker scripting with no need to understand XML, JSON, Web Services or CURL. NRG solutions are available for all current versions of FileMaker Pro and can be used on the desktop, thru FileMaker Go or with Web Direct.

NRGship FedEx for FileMaker is a Certified FedEx Compatible solution.

CRM Shipping

 

FedEx Address Validation at Time of Entry

 

No Comments

Customer #1

During the holiday shipping season we often hear from NRGship customers who are being featured on television or on lists for must-have products. So I started to think about a blog posting listing our rock-star customers and their products but decided to highlight our first customer, Cliff Stoll from Acme Klein Bottles. Cliff is a TED-talker and may be best known as the guy who brought down a KGB hacker in the 80’s. He’s been shipping Klein Bottles with NRGship since 2004 and still uses one of the first versions:

The UPS shipper just keeps right on workin’ … nary a hiccup.  Solid software that has worked everyday since 2004.  Across Filemaker upgrades, through UPS revisions, across operating system changes.  WELL DONE!

 During the holidays, I may ship 30 to 50 packages in a day.  NRGSoft lets me do this through a simple Filemaker interface … transparently printing out a UPS shipping label from my customer’s name & address. Reliable, invisible, problem free.  This is the way software should behave!

For seven plus years, your software has allowed me to keep a lean, customized back-office database, a system that has made thousands of happy mathematicians.

While we wish all of our customers could be featured in the media during the holidays, they are all rock-stars in their own way.

No Comments

Customer Spotlight – AOV, Inc.

aov_bubble1

We just wanted to share this email we received from AOV, Inc. – a Boulder, CO based company who provides high quality screen printing, embroidery, and promotional products.aov_emailheader1

Andy:

We just shipped 24 boxes in one transaction (UPS normally limits this to 20 boxes when you do it online).

Outside of the annoying 10 seconds it took to spool the labels, hit our Purchasing table, link the purchase to the inventory record and the job and capture the tracking number… it worked flawlessly. I was comforted by the fact that this would have probably taken 15 minutes if I had done it the “old fashioned” way.

🙂

Marc

No Comments

NRG Assists in Painless Fulfillment…

FileMaker Pro developer Ken d’Orionzio from Paradise Partners was recently featured alongside NRGShip customer The Fest on the FileMaker, Inc. website for their use of NRGShip UPS in creating a seamless order processing workflow. Ken also goes into more detail on the integration on his blog – check it out!

No Comments


%d bloggers like this: