Record the weight from a scale or balance to a file – Simple Data Logger software

Connecting your scale to a PC and recording the weight should not be a difficult task. However, data logging software available from scale manufacturers or third parties is often expensive, difficult to use or frustratingly unreliable. We developed Simple Data Logger (SDL) to address these issues.

SDL writes the weight received from a scale or balance to a file, optionally adding the date and time. The CSV files generated by SDL can easily be opened in Excel and other spreadsheet applications for further processing and visualization.

Recording the weight from a precision balance using Simple Data Logger

SDL currently supports the following connections:

  • COM port: RS-232, USB virtual COM port, Bluetooth SPP, etc.
  • TCP/IP: Ethernet, WLAN (raw TCP format only).

Note: Your scale has to send data in ASCII format.

Get started recording weight values with Simple Data Logger

Connect your scale to your computer, download and install SDL, then follow these steps to configure the software (updated on December 7, 2019 – please refer to the documentation on the SDL website for the latest instructions):

  1. Input tab:
    Input tab: A&D scales and balancesIf your scale or balance is listed in SDL, simply select it and press the set default parameters for device button. Otherwise, select “generic measuring instrument” and enter the interface parameters manually. Set the radio button to match your connection: COM port (RS232, USB VCP, Bluetooth SPP) or TCP/IP.Make sure that you’ve specified a terminator (a.k.a. delimiter, the last character your scale sends in each line of data) or a timeout (e.g. 100ms, SDL will process received data if no additional data is received during this time).
  2. Output tab:
    Output tab (English US)Choose a file for the recorded data. SDL will create if for you if it does not exist (otherwise, data will be appended). Choose (or enter) a date and time format or select “None” from the list if you do not want SDL to add the date or time. Pick a decimal separator (for numeric values) and value separator (used to separate values from each other). The correct settings for your locale can be made automatically by clicking on the set values button.
  3. Start tab:
    Start tab: A&D FX-300i balancePress the start button to start recording data. Press the “PRINT” button on your scale or balance to send the weight to SDL. Depending on you scale, this button might have a different name (e.g. “DATA”). Some scales like the A&D FX-300i used in this example also have to ability to automatically transfer each (stable) weight. Data received will be shown in the event log (with the captured weight value shown in blue) and the weight will be written to the chosen file. Press stop to stop data logging and to close the file.

    Note: SDL can also handle continuous streams of weight data if this is what your application calls for (we’ve tested it with a scale which sends 100 values per second). The total number of recorded values is only limited by your disk space (but please keep in mind that Excel cannot open files containing more than 1,048,576 rows).

Process the weight values in Excel (or other spreadsheet applications)

Provided that you’ve made the right format settings in the output tab, you can easily open the CSV file in Excel (or other spreadsheet applications like Google Docs, OpenOffice/LibreOffice Calc). The weight will be recognized as a number, allowing you to make further calculations (i.e. calculating the total weight as shown below):
Everything shown here can be done with the “Basic” version of SDL (which is free for personal, non-commercial use). The “Plus” version has additional features including a timer to request the weight from the scale in user-defined intervals.

Very affordable licences can be purchased from our partner FastSpring (immediate license delivery).

 

Links and further information

Using your smartphone as a scale?

So far, apps which claim to transform a smartphone into a weighing scale generally fall into one of two categories:

  • Simulators: They pretend to be a scale, but simply show a previously entered weight. Might be good for dealers wanting to rip off gullible customers, but certainly not much else.
  • Creative sensor use: Some apps try to make use of existing sensors in order to calculate the weight of an object. This could mean balancing your phone on a bag filled with air and placing an object on it while the app measures the inclination. Another app requires putting your smartphone on top of the object you want to weigh and then dropping both on a cushion. Of course, you’d also have to repeat the procedure with reference weight. Obviously, this is not exactly user friendly. While I haven’t tried any of the apps myself, they mostly received one star reviews. Unlike the simulators, which at least do what they pretend to be doing, it doesn’t look like these apps work well enough to be even remotely useful.

Therefore, I was surprised when I saw the following video featuring Peach-O-Meter, an application which compares the weight of two peaches:

Weighing Plums on an iPhone

It’s easy to use and seem to be working better than anything available so far. This became possible thanks to 3D Touch, a feature on the new iPhone 6s. A new layer of capacitative sensors registers how hard you press on the pliable glass:

Pressing down onto the glass bends the glass very slightly at the point of contact, shortening the distance between your finger and the corresponding capacitor plate in the array beneath the display.

Putting peaches on your screen is probably not what Apple had in mind when they introduced 3D Touch as “a new way of interacting”. Originally, the program author had planned to use grapes, but discovered that the iPhone ignored them. He’s announced that he’s purchased calibrations weights and is planning to run further tests. There’s also at least one company which is trying to develop a professional app (with “calibration cubes”).

I’m looking forward to seeing where this leads, thought I’m skeptical concerning the usefulness of such an app. Want to weigh lightweight “objects” while you’re on the move? I’m sure you’d get much better results from an inexpensive pocket scale. Using your top-of-the line device in the kitchen has its own perils and reminds me of this sketch from a German comedy show:

iPad Chopping Board (English Subtitles)

Free software for scales and balances with RS-232 and USB interface

Are you still manually entering weight readings from your scale or balance on your PC? Is your scale equipped with an RS-232 or USB (virtual COM port) interface? If yes, you can probably eliminate manual data entry by connecting your scale to your computer and using our free 232key software.

232key automatically types the weight into any application

Our software runs in the background, listens to the COM port (serial port) your scale is connected to and waits for measurement values sent by the scale. Those values are then parsed, formatted and typed into the application running in the foreground at the current cursor position as simulated keystrokes. This means that 232key can be used to transfer the weight (or other measurement values) into any application that accepts keyboard inputs, e.g. Microsoft Excel, OpenOffice / LibreOffice Calc, Google Docs, a form on a website, etc.

In the following example, I used A&D’s FG-60KBM scale with an optional RS-232 interface (FG-OP-23). I connected it to my laptop with A&D’s serial cable (AX-PC09-SCA) and an inexpensive converter to USB (as my laptop doesn’t have a serial port). Upon pressing the “PRINT” key on the scale, the weight was typed directly into an input field on a website:
Transferring the weight from a scale to a website

Compatibility with scales and balances

To use 232key, you’ll need a scale with a RS-232 interface (aka. serial port, COM port, EIA-232) or an interface which appears as a (virtual) COM port when the scale is connected to your PC. This is the case for many (but not all) scales with a USB interface and for scales which support the Bluetooth Serial Port Profile.

Your scale or balance also has to send the weight in ASCII format. Ideally, the weight should be the first numeric value sent and it should only be sent once (after you’ve pressed a key on the scale or on stability), not continuously.

The vast majority of scales and balances available on the market today fulfill these requirements. To give you a few examples, you should be able to use 232key with most or all scales and balances made by A&D, Mettler-Toledo, Ohaus, Sartorius and other well-known brands. New device profiles are constantly added!

Finally, an easy way to transfer data from your scale to your PC

We designed 232key to make your life easier. No complicated configuration is required. If your scale manufacturer or model is included in the list of predefined devices, you don’t even have to manually enter the interface parameters: Simply select your scale and click on Set defaults to load the settings.
interface settings for weighing scales and other instruments

Not sure which COM port your scale is connected to? Press the “Auto” button and 232key will try to detect the port automatically (works with devices which have some sort of hardware handshaking functionality, e.g. scales and balances made by A&D or Sartorius).

Do you know which decimal separator (point or comma) your scale is using? Why should you! 232key understands both input formats and lets you choose which output format you want.
output weight with dot or comma

Would you like 232key to press an additional key after typing the weight, e.g. the “Enter” key to jump to the next row in a spreadsheet? No problem, simply specify the desired key in the Output tab.
Press Enter after weight

All of these useful and user-friendly features are available for free! Additional functionality is available in the paid “Plus” version of 232key.

Download and documentation

Please visit our product website 232key for further information and to download our free software. There you’ll also find the documentation, an extensive troubleshooting guide and FAQ. Should you still have questions or feature suggestions, please post them in our support forum or as a comment below.


Do you prefer to write the weight to a file instead?

232key is a great solution for sending the weight from your scale to an application running on your PC (as simulated keystrokes). In some cases, however, it makes more sense to record the weight to a file which is opened later (e.g. in Excel).

This is particularly true for unattended data logging applications running over long periods of time. Another example are applications with high data rates (several weight values per second) which would overwhelm your PC when sent as keyboard inputs.

For these use cases, we’ve created Simple Data Logger, an easy to use solution for recording the weight sent from your scale to a CSV file. You can read more about it on this blog or on www.smartlux.com/sdl.


Article last changed on November 19, 2020: Screenshots and some links updated.