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:
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.
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.
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.
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.
I am still having problems capturing the weights. no communication between my balance an the PC. What could be the problem. Is there any proprietary equipment required. that is Specific cable?
Please take a look at our extensive troubleshooting guide.
Using the wrong cable is a very common issue. What kind of balance are you using? The pinout can vary between different models and manufacturers, so even if you can physically connect a cable, it doesn’t necessarily mean that the electrical connection has been correctly established.
I required Weight balance 2-3 kg
Lab using and product details print
Hello,
what is in your opinion our best setup?
we want to scan the unique numbers on our products and link weight on them in excell.
The outcome should look something like this
Weight Unique number
0.25 1234
0.3 0012
0.125 4345
1.050 1235
We have ‘Dibal G series’ scales with RS232 ports but I can’t get them to send to excell.
Thanks for sharing your knowledge
Wout
Hi,
232key is very suitable for this application: set it to transmit a TAB after the weight and configure the barcode scanner to end the line with Enter (any modern barcode scanner should supports direct input as a keyboard, so 232key is only needed for the scale).
As for your Dibal G series scale, I have no experience with this model, but it seems to support a very large number of protocols. Please make sure to configure the scale so that it sends the weight in ASCII format when you press a button. The following article with information on how to test communication might be helpful: Can your scale or balance be used with our free software 232key?
I also offer paid integration support through Fiverr (please select at least the “standard” package).
any info were i can buy a low cost solution ,, need a scale and to monitor it
It’s a great source of knowledge; I think it will be helpful for the free software scales balance. Thank you very much for sharing this article, this is really helpful for me, thanks again and looking for more in future!
Wanted to know if instead of PC/Laptop, android tablet can be used.
Subsequently, can the data from tablet be evtransferred to PC or Laptop?
If so, what’s the method?
232key currently runs on Windows only. We may have an solution for Android and iOS near the end of the year, please check the software section on our website for news.
I have designed a manual bottle filling machine that uses gravity flow from a large overhead storage tank to fill 1 gallon bottles. The liquid is water based and very foamy due to the detergent in the mix. As a result, pumping the liquid is not an option. We use a very long tube to discharge the liquid at the bottom of the container and the container lowers itself on a spring as the weight increases so the end of the fill tube is just barely under the surface of the liquid while filling. In order to control the length of time the liquid is allowed to flow to get the desired fill volume, we have a valve at the end of the filling tube and control this valve with an adjustable digital timer. However, as the liquid level in the overhead storage tank decreases, the liquid pressure gradually decreases and the time to fill must be gradually increased accordingly. We have found that every 4-5 gallons, we increase the time by 1/10th of a second, which gives excellent results.
My scale has the RS232 UART signal. I would like to use the output signal to increase a laptop timer when the output falls down to my desired minimum weight. Do you think your 232key would work in this application?
I do not recommend using 232key in industrial automation. There are delays which are introduced by the sending the weight to the keyboard buffer and there’s always the risk that another application might “steal” the focus from the target application, preventing 232key from entering the weight. Please consider using a custom application which communicates directly with your scale or a PLC.
In our weighing scale there is no option to connect rs232 connector then, how to connect with my pc to weight scale, how it will be do
232key can only be used with scales which have an RS-232 interface or any other type of interface which appears as a virtual COM port in the Windows Device Manager (Bluetooth SPP, USB CDC, Ethernet with COM port driver, etc.).
Hi Stephan,
Just wanted to confirm if we can use the Software for the below weigh scale? https://www.datalogic.com/eng/retail/fixed-retail-scanners/magellan-9800i-pd-600.html
Our Requirement is we need to read the weight from the scale to the Magento PWA POS.
Is it possible?
Hi Kumar, these kind of POS balances/scanners generally use bi-directional protocols which are not supported by 232key.
Hi Stephen
Are you able to have a Zoom meeting to set up my scale RS232/laptop installation (I down loaded the software but need a bit of assistance
I’m sorry, but we can’t offer this kind of service for free. Please read our documentation, FAQ and troubleshooting page. Should you have any specific questions, please post them in our support forum.
Hello Stephan,
I am working on a project where the people in the market weigh the goods and enter it manually, I am trying to automate it through a SaaS via a web browser. There are presently Essae Weighing Sale which is Bluetooth 3.0 compatible and optional RS-232. Can you guide me about various possibilities on who to automate this without manually entering the weights into the browser using Bluetooth/wifi technology (master-browser, slave-weighing machine).
If the scales support the Bluetooth serial port protocol (SPP) and send the weight in ASCII format when a “print” key is pressed, it should be possible to use them with our software. You would need one PC per scale running the web browser and 232key.
Alternatively, you might want to look at retail scales based on a PC platform.
I have an SDS – IN520 reader that I want connected to my Zebra GK420d label printer. They are linked with an Rs-232 cable. Can your software provide the needed connection to print labels with the weight on it ?
Our software 232key has no printing function, its sole purpose is to type the weight into other applications as simulated keystrokes. So unfortunately it won’t do what you need unless you have a label printing software which allows you to input the weight from the keyboard.
Any suggestions for software that allows a weight range for dosing of fine powder
Unfortunately I don’t know any such software. A project like this is on our to-do list, a first version is expected to be released in the first quarter of 2019. To be notified, you can subscribe to our newsletter: https://www.smartlux.com/newsletter/
Hi,
Our lab has virtual bar code generators set up to interface with the scales so we could scan a virtual bar code to capture the mass into our database. We have been forced to replace a balance but we can’t get the virtual barcode scanner to read from the new balance. The virtual barcode scanners are no longer supported and we can’t find a replacement a yet. The new balance has an Ohaus indicator (model T31XW). We could use 232Key, although a bar code scanner is preferred to pressing a key on the indicator to capture the mass. Do you know if a virtual bar code scanner is available and adaptable to our scales indicator?
Hi, I’m not familiar with virtual barcode scanners, but if pressing a key combination (on the PC) to capture the mass is something that would work for you, you could use software like TWedge or Kern Balance Connection. The next major version of 232key will also support this hotkey functionality.
Sir
i have a dacell indicator dn 10 w.
i want connect this balance with pc but i dont know about this plz tell me about connectind with pc
Please see: Can your scale or balance be used with our free software 232key?
We have a weight indicator attached to the scale. Weight indicator is Rice Lake IQ Plus 310A. How do we get the weight from the indicator to an input field in our web application.
Please see this article for further information: Can I use my scale or balance with 232key?
I’ve downloaded from both the main site and alternate site. I’ve re-downloaded. I’ve downloaded with different browsers and on different machines.
On a Windows 7 machines I’m getting the error: “The installation package is corrupted, 615”
It will not install.
Sorry for the late reply. This issue is usually caused by interference from overzealous anti-virus or anti-malware software, please try disabling it during the installation.
Hello Stephan,
Kudos to your work.
I want to make my digital Tanita Innerscan Scale transmit data to my phone via bluetooth or wifi. I really just dont know where to start. I can give you pictures of what’s inside the weight scale. I can buy a module – whichever you suggest. BUT, i really dont know where to connect the wires to. I also cant seem to find a schematic diagram for this scale.
Can you help me out buddy?
Please tell me, how should i tackle this.
Thank you.
Do you mean this bathroom scale: http://amzn.to/2AQ0tg2 ?
It doesn’t look like it has an interface. Unfortunately, communicating with this type of scale is outside my area of expertise. I’d either try to tap into the signal going to the LCD to get a weight reading or connect directly to the load cells like described here (basically building a new scale and foregoing the existing functionality): https://learn.sparkfun.com/tutorials/getting-started-with-load-cells
The one i have is model BC-541. But yes, that in your amazon link is of the same type.
I’ll check on the wires going the LCD. As per your suggestion, I may find my answer there. And I’ll check on that link about load cells too.
Thanks a lot for the reply.
Hello!
Is there a way to get 232key to work on a tablet? I’d like to connect a tablet to the scale and read the weights.
Thank you!
Amol
If you’re running Android or Windows on your tablet, you can use a wired adapter:
http://www.ftdichip.com/Products/Cables/USBRS232.htm
Your Android device must support USB on-the-go (OTG) aka USB host mode. You’d also need an app which supports the adapter you’re using (you can find some by searching the play store for “FTDI”). On Windows, you’d need a software which can connect to a COM port (like 232key).
You could also use a RS-232 to Bluetooth adapter (serial port profile) for a wireless connection (or a WiFi serial device server).
Hello!
I’m looking for weigh scale traceability software. Our use case is essentially, generating a simple record for each item weighed. The record would include a unique user ID, user name, weight, time stamp and the user ID of the collections agent who authorized the collection and certifies the record. We already have a roster with 40 user IDs matched with 40 user names along with 4 collections agent IDs.
Every time a product is weighed, the user would be prompted to enter their 6 digit ID, if the PIN matches a farmer, the record will be displayed for the collections agent to accept. If they accept, then they are prompted to enter their PIN. if the PIN is correct the record is stored and even printed.
We now have records which allow us to trace back the weight collected from each of the User IDs and the PIN of the collections agent who authorized it.
Any suggestions?
I am looking for an inexpensive system(software and any necessary hardware) that is easily handled to input apw from a database into my counting scales to eliminate the need for sample lots or hand counting.
This is an interesting question (though not directly related to our software). You’d need either
or
I recommend contacting a scale dealer or systems integrator in your area.
I wanted to log weight data continuously in every 30s. In my experiment, there is continuous flow of solution 100-400 mg/30s. I tried with MTbut it logged once the display stable for ~2s. So, it didn’t work for me. Any solution Please
I’m not familiar with MT balances, but it seems that you balance is set to send the weight automatically once it is stable (often called “auto-print” mode). Consult the manual to see if this mode can be changed to interval mode. There might also be a setting to send only stable weights (you’ll want this to be off). Alternatively, use a data logging software which requests the weight from the scale every 30s.
If this doesn’t work, you’ll find that many scales made by A&D and Ohaus support sending the weight every 30s.
Hi,
I am looking for a balance which will transfer the data to the pc and which I can manipulate using visual basic. That means that every time I print the weight of one of my manufacturing parts the weight and other important data would appear in a spreadsheet that I can manipulate.
Regards,
Cesar
If you’re using your own Visual Basic program, you can communicate directly with the balance over the serial interface (RS-232 or USB virtual COM port) and do not need a software like 232key. The balance doesn’t care which programming language you use, so I recommend looking for the capacity, accuracy and size that you need for your application while making sure that the balance has a well-documented RS-232 or USB (virtual COM port) interface.
I can generally recommend balances made by A&D and Ohaus (these two manufacturers also offer free data acquisition software), but there are certainly many other excellent balances on the market.
We have a Precia Molen scale. I want to connect the indicator with a pc that’s why i install a USB to RS-232 converter. But it is not be installed properly. Do you provide me any solution for install the converter properly. The converter is manufactured by FTDI corporation.
You could try installing the driver directly from FTDI’s website: http://www.ftdichip.com/Drivers/VCP.htm
Please also have a look at the extensive troubleshooting section on our 232key website: https://www.232key.com/troubleshooting/index.html
Thanks for the information. I’m looking for a simple solution. I have a scale that is USB and my computer only has USB ports. I simply need to put a package on the scale, have my UI read that weight from the scale and transfer that data to my UI. I might have the wrong that scale and all I’m finding as a solution is Download Stamps or Endicia software but they are wanting me to sign up.
I wouldn’t think this would be a difficult problem to solve but I’m learning there’s not a plug and play solution out there. I plug in our bar code scanners, and it’s reads it and transmits it with ease. Do you have any suggestions?
Hello, thanks for the article. I need to scan ISBNS barcodes from books and weight them too, then input the data on our inventory panel on a pc with windows 10.
do you have a solution for this? and which USB/BLUETOOTH/232 scale do you recommend in my case? can you mention one of each connection type?
thank you.
I would get an USB barcode scanner, connect it directly to the PC and set it up so that it adds a tab after entering the ISBN. Then, get a scale which works with 232key* and configure 232key to send an enter key after the weight.
With this configuration, you can create a spreadsheet, scan the ISBN and then weigh the book. The ISBN and weight will show up in the same row.
*A list of supported devices can be found here: https://www.232key.com/documentation/index.html#device
I particularly like the Ohaus Navigator series which can be equipped with an USB interface and supports automatic printing (so you wouldn’t have to press the print key on the scale).
what if my scale don’t have a print bottom
If your scale doesn’t have a print button, consult the manual to see if it supports automatic printing (on stability). Otherwise, you can unfortunately not use it with 232key at this time.
I tried installing it but it says no rs232 comm port found on your system and then it exits. I do have usb port will that not work?
If your PC doesn’t have a RS232 port you can use a converter to USB (or a scale with a built-in converter): https://www.232key.com/faq/index.html#no-rs232
Please also make sure you’re using a recent version of 232key, it shouldn’t exit when no COM port is found:
https://www.232key.com/software/232key-setup.exe
Will your software record the increase of weight on the scales as a function of time? I am looking to measure how fast a medium drains.
232key is not meant to be a data recording (data logging) software, it just transfers the measurement values from a scale into whatever application currently has focus (cursor position). That said, if your scale has an interval mode to send the weight every x seconds, you might still be able to use it together with 232key for your application.
We’re currently working on a dedicated data logging application, you can sign up to our newsletter to be informed of its release: http://www.simpledatalogger.com/
We slice smoked brisket, weigh it, and then pack it in a vacuum sealed bag. We need a way to export the weight of each pack and include it in a label that we print out
Will your software do this with a suitable st of scales, a PC, and a printer?
232key is a virtual keyboard wedge software designed to automate applications where the weight is currently being read from the scale by a user and then typed into an application running on a PC. This means that if you generate labels by manually entering the weight, you can use 232key to simplify this process. However, if you’re starting from scratch it might be better to either find a scale with an integrated label printer or a label printing application which can directly communicate with a connected scale (without the need for a virtual keyboard wedge).
I am looking for a low-cost scale with serial output (USB or RS232) with which I can continuously log weight; for example, capture weight on the scale once a minute. The output of the scale can be monitored using a connected pc, perhaps using your software.
The low cost scale should have a range of 0-25kg or 0-50kg, with a precision of at 1 g or better and accuracy of +/- 2% or better.
We will be using the scale to monitor the rate of conversion of dry ice to gaseous CO2, in a protocol for measuring building ventilation rates.
This is for educational use at a college in India, where funds are scarce.
An recommendations?
232key is not really intended to be a data logging software, it would be better to use an application which directly writes the weight to a file. The software should also have a timer function to periodically trigger the scale to send the weight. We’re currently working on a new software called Simple Data Logger which is going to be available in a few months. Alternatively, you could use A&D’s free WinCT software, perhaps with the brand new SA-30K scale. I recommend contacting A&D India for further information.
How can i get you product regarding weight machine along with a software.
I’m sorry, I don’t understand your question. Could you please rephrase it?