SerialMagic How To: Low cost mobile inventory counting solution for BlackBerry with a spreadsheet

SerialMagic facilitates a mobile inventory counting and data collection solution using a Bluetooth barcode scanner, and a BlackBerry with Grid-In-Hand(tm) Mobile Grid

More ways to use SerialMagic

This document outlines how a Scanfob 2002 Bluetooth barcode scanner, SerialMagic Professional Power Upgrade software, are used to create a mobile inventory solution on a Bluetooth enabled BlackBerry. This also works with other Bluetooth scanners supported by SerialMagic Professional such as Socket, Intermec, Honeywell and others.

The bundle to implement this solution can be purchased here.

Once SerialMagic Professional Power Upgrade software is installed on the BlackBerry device, and the scanner has been paired with the BlackBerry (see SerialMagic documentation or SerialMagic support page), the first step is to select the proper Action Profile in SerialMagic. Action Profiles can be used to perform keystrokes, commands, and other functions before and after entering scanned data, and even based on content of scanned data.

SerialMagic includes a default SerialMagic Action Profile (SMAP) designed to work perform inventory counting. Launch SerialMagic and highlight the Action Options section. If the setting is Less expand it to More by pressing the SPACE bar on the BlackBerry keypad. Then use the trackball to highlight the Profile option. Click the trackball and select the GIH_INVEN_CNT_01 Profile. Set "Number of columns" in the "Scanner Data Options:" section to 2. Then name the columns as desired.

Blackberry mobile inventoryBlackberry mobile inventory Spreadsheet columns 2Blackberry mobile inventory Spreadsheet labels

Activate Scanfob Bluetooth scanner radion and start SerialMagic, SerialMagic should connect with the scanner and display the Grid-In-Hand(tm) Mobile Grid view.

Launch GridMagic and create a New spreadsheet.  As Item UPC’s (or other barcodes) are scanned with the Scanfob Bluetooth wireless barcode scanner, SerialMagic enter the scan in the Item column, and will prompt for item quanity, then enter the value in the Qty column.

Blackberry mobile inventory PromptBlackBerry Inventory Item QtyBlackBerry Inventory Item Qty ready to upload

When user is ready to upload the grid simply use the upload option, and the data is delivered per the account settings on iScanList.com. Data can be sent in CSV or XLS format via email, posted to FTP server, and even posted directly to MySQL database.

BlackBerry Inventory Spreadsheet uploadBlackBerry Inventory Spreadsheet sendingBlackBerry Inventory Spreadsheet upload done

Yes, it really is that simple.