This is only my second 'large' Arduino project and firstly I don't expect to do it all my self, so will be hiring people for the two key areas that are beyond my ability
(at least at this stage), the bar code database and the opencv work.
But for starters let me briefly explain the project...
This is a production line/ pick and place project, with many 'stations' each doing individual tasks.
I have already completed the hardware for almost all of the stations (over 1000hrs of 3D printing later...) and have a widish variety of suitable electronic components to use, although for my areas of concern I'm happy to purchase whats required.
I'm confident with basic Arduino coding, wiring, etc. and the initialization/homing procedures I have already finished successfully myself so will not require any wiring/schematic help, etc.
The two parts I need to outsource again are the bar code database and opencv code. But before i do this I'd love to get a better understanding of how to do this and whats required.
Firstly, the opencv part i'm fairly confident I should be able to integrate with few major difficulties. It's only used at one 'station' and would do a similar (albeit more complicated/specific in terms of vision identification) job to this:
Pick and place Robot using image processing OpenCV - YouTube (not mine)
There would be Arduino processes running before and after the opencv part which would act to effectively interrupt the Arduino processes by sending it 3 sets of information, X&Y coordinates (to control stepper motors) and an angle (to control a servo) when id identification criteria are met. I think this can be done but I'd love to know any potential issues or problems i might encounter when hiring/coding for this.
The bar code database part however has me stumped. I've googled this for months while continuing work on the other parts, trying to find a solution but haven't come across one yet.
Each station requires this. Ultimately this is what needs to be accomplished:
As the product passes by each station it's bar code is scanned I've got this module for starters: https://www.aliexpress.com/item/1005001458273140.html?spm=a2g0s.90423188.8.131.52424c4dbUfGFz)
I then need it to use that bar code number, lets say '123456' to recall information from a table, relevant to that station. For example, the simplest station merely sprays the product as it goes by, I have a relay that activated the pump that can be turned on and off.
So the arduino would read the bar code then go to the 'spray station' column (Y) for that barcode number (X) and read a value, lets say '20000.' If 20000ms has expired since the previous 'spray' then the product passes without further interaction. If the time elapsed is greater than 20000ms then the relay is switched on briefly to spray the product as it passes.
Another station might be the blowing station, similarly simple, a relay turns a fan on and off as it passes. Again, the arduino would read the bar code then go to the 'blower' column (Y) for that barcode number (X) and read a value, lets say '10000.' If 10000ms has expired since the previous 'blow' then the product passes without further interaction. If the time elapsed is greater than 10000ms then the relay is switched on briefly to blow air at the product as it passes.
So, many bar codes and may different columns for various stations, each doing unique processes to the product as it passes.
Ideally i would like to be able to add and edit table entries online while never having to turn off/update the various stations. But if that's not possible, the nearest possible solution would suffice.
Also, data logging to an online platform is required, ie. logging the times/dates of each action that is successfully completed as well as a few sensor input values.
I hope that's clear enough for a start, I'll post a couple of photos of one particular station (the one that requires the computer vision (for which I currently have a jevois to hopefully give you a better idea of the project)