Archive for category FileMaker Shipping

Who uses serial scales?

I was recently on a west coast virtual meetup event and there was a discussion about plugins and someone chimed in asking “who uses serial scales?” (or something like that…) With 20+ years of experience working with Claris FileMaker Pro customers in a warehouse, it’s fairly common for us to interface with these devices.

First off, scales used on a shop floor are very industrial and expensive. The Mettler Toledo PS60 looks to be bomb-proof and costs over $500. While current PS60’s have a USB interface, older models rely on the trusty serial protocol. We recently did a shipping integration where a customer had a flashy new dimensionalizer (that cost thousands of dollars) with a serial interface.

Mettler Toledo PS60

Talking to Serial Scales from FileMaker Pro

Interfacing with a serial scale from FileMaker Pro is easiest with a plugin like MBS or Troi Serial. Both work equally well for this use case. In the scripts below we go thru a simple process – we open a serial port, we then send some data to the device (based on device spec, some require a CR/LF or some other characters), then we receive a response back. Some scales return fractional values so we then apply a modifier as needed to get a proper weight in pounds.

Capturing the weight with MBS
Capturing the weight with Troi Serial

Note that on the Mac, you need to have an adapter for a serial scale. The preferred Tripp-Lite/Keyspan USA19-HS adapter requires drivers which will not work with macOS Big Sur. There are some serial to Bluetooth adapters which will provide connectivity for macOS.

The Keyspan USA19-HS Adapter

But what if you don’t like plugins? If you’re in the mood for a science project, you could build a microservice with a Raspberry Pi that communicates with a serial or USB scale, but then exposes it to FileMaker thru CURL. But why waste time when using a plugin is so simple?

If you don’t like science, another alternative is PrintNode, a paid service that installs on your desktop and provides an interface to scales (and printers) thru HTTP requests. PrintNode requires a bit of setup and configuration but is very powerul. One benefit of PrintNode is you can then capture weights using your app with FileMaker Go or FileMaker WebDirect. This opens a whole new world to mobile warehousing.

Alternatives to Serial Scales

Some USB scales are simply serial devices with a USB adapter. When you look at them from the operating system, they require a driver and show as a COM port or some variant. Other USB scales act as HID devices and require special applications to communicate with them using a USB vendor and product ID. We’ve found that dimensionalizers have the ability to communicate over IP using simple HTTP requests.

NRGship solutions for FileMaker have the ability to communicate with scales using serial, HID, PrintNode or IP. NRGship allows you to quickly integrate UPS, FedEx, USPS and LTL validation, rating and shipping into your app.

Please contact our Sales Department for further information if you need help communicating with scales from your own FileMaker Pro app.

No Comments

What’s the best way to ship from FileMaker Pro?

With NRGship and FileMaker Pro you have two options for shipping and choosing between them often depends on what makes sense for your workflow.

Integrated shipping is our preferred method and it allows you to utilize the full capabilites of NRGship across your organization on the desktop or iOS. We often suggest that things start during order entry with address validation. This ensures that the recipient information is correct before the order ever hits your shipping department, and allows you to have a clean address in your backend CRM for future use. From your order, it’s easy to add simple rating functionality based on the content of your order so that you can charge your customer based on the estimate, or provide expedited service options based on a certain delivery date. Once the order has shipped, cost information can be returned back to the order along with the tracking number. The tracking number then provides visibility right on the order without having to check the carrier software or website. With integrated shipping you can seamlessly utilize the power of your shipping carriers without ever leaving your own database.

Overview: Integrated Shipping

Keyed shipping most closely resembles the process you would have using carrier software integrated with FileMaker. You would key in an order number and the data would appear in the shipment. The shipping staff then adds packages, validates the address, runs rates and produces the shipping label. After shipment, the cost information is returned back to your order so that you have visibility across your organization. Since NRGship is built with FileMaker Pro, you can leverage it’s functionality to provide far more complex shipping than you could with the carrier software alone.

Overview: Keyed Shipping

NRGship is a Carrier Certfied provider that powers hundreds of businesses who ship UPS, FedEx and USPS with FileMaker Pro without the need to setup external services or perform complex API coding. Contact our sales staff to setup a time for a demo of NRGship and see how it can improve your entire business.

No Comments

NRGship Pro update adds requested features

The Q1 2021 update of NRGship Pro includes two new features requested by customers. Favorites allow you to save common shipments for repeat shipping which can greatly simplify complex multipackage or international shipments. The continuity camera allows you to use an iOS device to add a photo of your shipment so that you can capture what was placed into a package. Please watch the videos below for a brief overview of these new features.

Overview: Favorites
Overview: Continuity Camera

No Comments

How can I export my UPS Address Book for use in NRGship?

Whether you have been using UPS.com or WorldShip for your shipping needs, you can easily export your address book information for use in NRGship.

UPS.com Address Book

WorldShip Address Book

No Comments

How to process USMCA shipments with NRGship

This article is current as of July 2020. It will be updated as we receive new information from our carrier partners.

 

As of July 1st, 2020, the United States-Mexico-Canada Agreement (USMCA) will replace the North American Free Trade Agreement (NAFTA). Some shipments that cross the borders of these countries may require special import forms.

For USMCA details and forms, go to the U.S. Customs and Border Protection USMCA page. For NAFTA information, go to the U.S. Customs and Border Protection NAFTA page.

UPS

Currently the UPS Developer Kit APIs do not support the new USMCA forms for automated processing.  You will need to produce your own USMCA forms and apply them to the outside of packages. You can find more information on USMCA and a sample form for UPS shipments using this link.

FedEx

Currently the FedEx Shipment APIs do not support the new USMCA forms for automated processing.  You will need to produce your own USMCA forms and apply them to the outside of packages. You can find more information on USMCA and a sample form for FedEx shipments using this link. We are working on an update where you can attach a PDF version of the FedEx form to your shipment.

 

No Comments


%d bloggers like this: