Reading data from a USB or Serial Scale into Scriptcase Application - Any ideas?

Scriptcase 8 Discussion
#1

Im hoping to get some ideas here. I would like to get weight data from a scale into a database so I can use scriptcase to develop an application around that data.
Does anyone have any advice on my options for this?

Since a USB scale would need special software to read its data, Im thinking maybe there could be a USB scale with a program that just reads the scale and writes the value to a table in a database over and over, updating the same value… that I could then read from a scriptcase application when I want to retrieve the weight at that moment.

Anyone have any ideas on this at all?

Thanks!

#2

You do not mention to what the USB scale will be connected. However, I assume that it is not the web server, but rather laptop or desktop. Without knowing more about the purpose and configuration of the whole set up, it is difficult to give advice. Why e.g. only get and store a single measurement value.

For the USB scale it is best to start at the point where it is connected. I would imagine that the USB scale will have an API and/or software that can be used to access the scale to get the weight measurements. So possibly write a C# application for the laptop/desktop that is connected to the USB scale, get the reading with a date/time value. Perhaps include a possibility for specifying a text for each weight measurement in the C# application. The application should regularly connect to your database on the web server via the internet and write the readings to a weight log table with date/time, comment and the weight measurement. Anyone using your SC application via a browser would thus be able to access the weight measurements.

#3

Just a thought… Most applications I have created using something similar was to use this device as a keyboard wedge (like a bar code reader)…if only one field one the form, use that as the initial field…

Need more information to help with a proper solution.

#4

hbmaddog I think the keyboard wedge is the best option. Thanks for the suggestion Orion… but I don’t have the C# skills to pull that off.

Thank you both for your opinions and suggestions.

#5

You can use setfocus in javascript if you use a keyboard wedge. With setfocus you set which input field you use and hence the keyboard input goes there. This should work with a keyboard wedge.

#6

i’m totally in love with your avatar :o