SerialMagic How To: Use "Send Command" to get Scale Readings into Excel spreadsheet on Windows Mobile

Using SerialMagic Professional, and a BlueSnap RS232 adapter, you can capture readings from any RS232 directly to Excel, via Bluetooth.

More ways to use SerialMagic

This document outlines how to use SerialMagic Professional software, along with a BlueSnap RS232 Adapter, to capture readings from an RS232 scale directly to an Excel spreadsheet on Windows Mobile 5. This is just one example of the power of SerialMagic; there is a multitude of applications possible.

Here are the main components of this setup:
1) A Scale measuring weight, using an RS232 output for the data.
2) BlueSnap RS232 adapter to take the RS232 data and transmit it is as a Bluetooth signal.
3) A Dell Axim X51v device, with Bluetooth, running SerialMagic Professional software.
4) SerialMagic "Send Command" feature, which is configured to send the "Read" command to the scale by the push of a button!
5) The Excel spreadsheet which is open on the Dell Axim X51v, to capture the incoming data.

First, you will need to configure the BlueSnap RS232 Adapter to have the same Baud settings of your RS232 scale.
The easiest way to configure the BlueSnap is remotely, via Bluetooth, using SerialMagic's Remote BlueSnap Config.

Next, determine what key command is necessary to get a reading from the scale.
For example, when you send the "W" <ENTER> key, the scale replies with the weight "04.810" etc.

Now, launch SerialMagic Professional on your PDA/Phone (In this example we are using a Dell Axim X51v).
Go to Setup > Other Settings > Send. If SerialMagic is not yet connected to the BlueSnap, you will be notified.

Now, define the command to send to the scale. In this example, when we send the scale "W" <CR> it replies with the weight.
Enter "Get Weight" for the command Name, and enter "W" for the Data. Also check "CR" to send the <CR> at the end of the data (this is common).
Now that the command has been defined, all we have to do is "Assign" that command to a button on the Axim X51v.
Click on "Assign" to open the button assignment screen. Click "New" to add a new assignment.
Next, select the "get weight" command from the list, and hit the button on the Axim X51v that you wish to assign the command to.

Once the command has been assigned to a button, tap OK, then Done.

Now test the new Command/Assignment. Tap "Start" to start SerialMagic and connect to the BlueSnap.
Once Connected, hit the assigned button. You should see the weight reading returned in the text box below.
Place another item on the scale and hit the assigned button again, to receive the next reading, etc...

Now that you have verified that SerialMagic is properly configured to get readings from the scale, click the OK button.
Launch Excel (Start > Excel Mobile). Open a new spreadsheet, place your cursor where you want the scale data to go, and hit the assigned button!
The weight reading goes directly into Excel! Now place another item on the scale...

This is just one example of using SerialMagic Professional's "Send Command" feature.

You can apply this feature to a number of different devices, capturing data to virtually any application!