B Inventory

B Inventory

Challenge:

The counting is laborious and slow.Even more there is no time estimate taken for each separate part processing to give a real estimate, So questions like below cannot be answered

• E.g. Time it takes to process a single part through trimming metal phase?.
• In small scale manufacturing industries, There is manual labor involved in parts of production process
• Many times inventory of (individual) processed parts(of product) are taken when phases of manufacturing are completed
• Integration of a Counting solution so as to have no impact on the various processes of manufacturing

Idea/Working:

• An Azure Sphere based IOT solution with a Proximity sensor will act as a counter
• When a person finishes the process on a individual part, The person will wave the part in front of the sensor for a brief moment for it to get recorded
• An Wpf desktop App can then present the Job sheet  in front of the user (displaying time it takes to process each part), with features for exporting data

Parts:

• Avnet Azure Sphere IOT Kit
• Proximity Sensor
• Web Server (PHP installed)
• A Mobile Hotspot connected to Azure Sphere (Small scale industries may not be connected to internet )

Features:

• Viewing of log sheet
• Export of log sheet to excel
• Auto refresh functionality for live view of processing

Solution:

• I used the Azure sphere Multi CURL sample as base starting point
• A Proximity Sensor was connected to GPIO pin 17 for data input
• The Azure Sample was modified to call my API whenever a input was read from the sensor
• The API created an entry on the php database hosted on my website
• A WPF app was created which can interact with the API and get the records in JSON form for displaying to proprietor

Code:

https://github.com/Bhairav-Pardiwala/BInventory

Tech Talk

Special Thanks:

• Mr Praful Pardiwala ( qualial)