Group Actions
Engagement
  • Author Author: bhairavpardiwala
  • Date Created: Date Created
  • Views 458 views
  • Likes 6 likes
  • Comments 0 comments
Related
Recommended

B Inventory

bhairavpardiwala

B Inventory

 

Note to Contest judges:-Please check out my second entry B Mimic (An innovative retail 3D solution)  listed i have logged my entries into both qualial and bhairavpardiwala accounts as i taken device under account qualial and posted here initially .However i came to know that i should have used the qualial account for posting hence i have posted my second entry there in order to not be missed out ,thanks

 

Challenge:

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

 

Idea/Working:

  1. An Azure Sphere based IOT solution with a Proximity sensor will act as a counter
  2. 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
  3. 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:

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

 

Features:

  1. Viewing of log sheet
  2. Export of log sheet to excel 
  3. Auto refresh functionality for live view of processing

 

Solution:

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

 

Code Azure Sphere:

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

 

Code Inventory Viewer Windows App:

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

 

PHP Api:

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

 

 

FlowChart:

image

 

 

Special Thanks:

  1. Mr Praful Pardiwala ( qualial)

 

Tech Talk

 

 

 

 

image

image

image