Using Grid-In-Hand™ Mobile Grid to take Inventory on Android

Submitted by admin on Wed, 08/14/2013 - 08:29
Best Android Attendance Taking     Also works on iOS iPad, iPhone, iPod Touch

 

This document outlines how Grid-In-Hand™ Mobile Grid is used for taking inventory.
This page requires the user to have an Cloud-In-Hand.com account with lookup, or description, privileges.

 

In this example we paired a Samsung Galaxy Nexus with a Scanfob® Wireless Scanner,
however any barcode scanner that's compatible with the Scanfob® scanner format can be used.

Setting up the inventory database

Create your database using an Excel sheet that has the desired columns for your requirements.

RFID-NFC Android mobile inventory count excel

Login to the Cloud-In-Hand.com account with inventory privileges and click on the "item" option.

Next to Upload CSV or XLS file, choose Browse to pick the databse file you created to load to the Cloud-in-Hand server. 
Click Upload. The mapping view will appear so your file headers can be associated with their item function.
Drag each label to the correct box and click Submit.


Note: Mapping keys with asterisks (*) are optional.

After Upload and mapping, the associated mobile device(s) can download the database for use.

Taking inventory 

On the Android, go to the Grid-In-Hand™ Mobile Grid application. Tap Menu > Options > Cloud Account. 
Enter in the login info for the Cloud-In-Hand.com account and tap OK.

Tap Descriptions and tap Update Description Data to check for new databases.
Select the desired database under Item database and check the Enable Descriptions box.
Return to the Options page and turn Descriptions on.

best value Andoid Barcode NFC RFID Excel spreadsheet inventoryBarcode NFC RFID Andoid Excel spreadsheet inventorybest value Andoid Excel Open Office scan barcode/NFC get description

Note: Mobile Grid may notify you that the grid columns will be updated to match the mapping you did earlier (above-middle).

Return to the Mobile Grid home screen and tap Upload if asked to upload the current grid data.

Now insure the Scanfob® Wireless Scanner is connected.
Take inventory by scanning the barcodes associated with the items in the database.
Once a barcode is scanned, a popup will appear asking for the quantity of the item.
When the same barcode is scanned after it has been posted to the grid, each new scan and quantity will post to a new row (below-right).

Android tablet phone inventory counting Barcode RFIDAndroid inventory counting Barcode RFID

Note: The Android camera scanner can also be used to take inventory.
Tap Menu > Camera Scan to scan barcodes and take inventory.

Once all desired barcodes have been scanned and quantified, tap Menu > Upload Grid.
The grid will be sent to the Cloud-In-Hand account setup on the Android device per the account settings via XLS, CSV, PDF, TXT, HTML using email, FTP, SQL, XML-RPC.