Software Kern BalanceConnection: what’s new in 2019

Two versions of Kern’s BalanceConnection software are now available: the standard version (SCD-4.0) and the Pro version (SCD-4.0-PRO).

The following table shows the features of the standard version on the left and the additional features of the Pro version on the right (according to Kern’s 2019 catalog):

BalanceConnection SCD-4.0 BalanceConnection SCD-4.0-PRO
· For operating systems Windows XP, Vista, 7,
8, 8.1, 10
· Supports balances measuring devices with
RS 232, RS 485, Bluetooth, LAN or WLAN
network (TCP/UDP/IP)
· Highly flexible formatting of the output (any
order, formatting and rounding), particularly
recording of date and time for every value
transferred, if required
· Any number of devices/interfaces can be
connected, as well as simultaneous and
synchronised recording of several balances
· Key-activated or time-controlled interro-
gation of measurements or trigger of device
functions, also for continuous recording
· The interface protocols for KERN balances are
already predefined (standard configuration)
· Compatible interface cable included when
you order a KERN balance at the same time
· Many different transfer and recording
options:
– Microsoft ® Excel/Access/Word in the
fore ground or background
– Other Windows applications (through key
simulation), e.g. shipping software or ERP
system (SAP, Sage, etc.)
– File recording (e.g. as text or CSV file)
– Print out on text or label printer
– Screen output such as large display, line
chart (drying curve for moisture analyzer),
histogram, etc.
· ODBC/SQL databases such as SQL Server
or MySQL
· Transfer to HTTP Webservices/Web forms
· Histogram
· Enables the connection of medical balances
to practice EDP systems using the device
data transfer protocol (GDT) and also the
HL7 protocol
· Implementation of programs/scrips using
freely-definable command lines
· Command sequences
· Defining the conditions for specific events
and the reaction to these events
· Filter for stability recognition (configurable
value storage)
· Central configuration repository, e.g. on the
network
· On-screen displays with configurable user
interface for flexible balance operation

If you do not need the features listed on the right, the standard version is the right choice. However, this version has also become a bit more expensive compared to the single version available so far.

Inexpensive alternatives

If you don’t need the extensive functionality of BalanceConnection and only want to connect a single scale to your PC, we offer two very inexpensive alternatives. Each of these programs has a single purpose and is therefore easy to set up and use:

  • 232key: Transfers the weight to any application (e.g. Excel, shipping software, etc.) using a key simulation (virtual keyboard wedge).
  • Simple Data Logger: Stores the weight in a CSV file (if desired with date and time), the weight can also be retrieved from the scale using a timer (Plus version only).

Further information

Raspberry Pi: Connecting a scale can be very easy…

…as long as you choose the right scale! The photo below shows an A&D EK-2000i compact balance connected to a Raspberry Pi 3 Model B using a compatible serial cable and an FTDI RS-232 to USB converter:
Scale connected to Raspberry Pi

Python and pySerial make it easy to read weight data from a scale

On the Pi, I used Python with pySerial to read the weight from the scale. The script I put together is trivially simple. You can download it here or just type it on the Pi:
Script to read weight sent from A&D scale

By pressing the PRINT-Button on the scale, I then sent a few weight values to the Pi and the script wrote them to the terminal (b’ is added by Python):
Weight printed to terminal

In a more useful application, you would want to parse the data sent from the scale to get the weight as a number and then do something with it (maybe write it to a database). You could also do interesting things with the GPIO on the Pi like sounding an alarm when a certain weight is exceeded (though a microcontroller might be better suited for this).

I then switched the scale to “stream mode” (continuous transmission) where it sent 10 values per second (stable or not). The output you see below is the result of placing a single object on the scale and waiting for it to stabilize:
Weight data in continuous mode

I hope this example shows that it can be really easy to transfer the weight from a scale to a Raspberry Pi.

Notes on scales and the Raspberry Pi

One advantage of A&D scales is that (almost) all of them use the same data format and interface parameters and that you’ll find a good description in the manual:
A&D EK-i balance data format

However, you could use also use scales made by other manufacturers as long as they come with an RS-232 interface and the ability to send the weight in ASCII format. Available data output modes vary, so please read the product description carefully before buying.

A converter like the one I used is already built into some scales, which means that you can directly connect them to the Raspberry Pi via USB (you won’t need a serial cable). You’ll find many Ohaus scales with this interface option and the ones I’ve tested worked fine. However, cheaper scales with a USB interface can often not be used with pySerial as they do not emulate a serial port. They can also present other challenges (e.g. data that is not transmitted in human-readable ASCII format).

You do of course not have to use Python, just make sure that your preferred programming language can communicate over a serial port on the Pi. The book Raspberry Pi with Java: Programming the Internet of Things (IoT) contains projects using Ohaus scales and, well, Java.

Finally, please don’t try to use the serial interface already provided by the Pi on the GPIO pins without a logic level converter (RS-232 voltage could reach up to 15V). Excellent further information on serial ports on the Raspberry Pi can be found here.

Hydraulic Press Channel uses compression load cell for crush resistance measurement

For most videos featuring weighing instruments, a few thousand views would be considered a success. The Hydraulic Press Channel regularly achieves millions of views and included a compression load cell with an indicator in one of the latest videos:

How Much Weight Can a Soda Can Hold? Hydraulic Press Test

If you’re wondering why these types of videos are so popular on YouTube, this article might offer some insights. As far as the measuring instrument is concerned, it appears to consist of an AnyLoad 266AH-5t load cell connected to a Rinstrum R320 indicator (with peak hold function).