Hey guys
I’ve got this idea to improve the workflow in my current role
In my work we get bulk amount of these medical devices to service/perform maintenance on
The only way we can look up the details on this device is by using SQL/access database which is a lot of walking and time wasting
So basically I want to have a way of scanning the device and being able to pull up he status of the device
For example parts required, date quote was sent, Out Source Repair and have that in a handheld display so it’s easier to visually see what it needs without having to look through the database. These devices do have a serial number on them so which is 4 letters hyphen four numbers if that helps
Have basic knowledge/experience with Arduino looking to also incorporate Raspberry Pi if necessary
Any suggestions on how to go about this??
And what machine-readable identifiers do these unnamed devices carry?
They carry a serial number they do have a job number but not on the device that’s online on our desktop. I was thinking is it possible to generate barcode or QR code or RFID chip that could store this info for the device but not sure as to how to implement
sboldie:
They carry a serial number they do have a job number but not on the device that’s online on our desktop. I was thinking is it possible to generate barcode or QR code or RFID chip that could store this info for the device but not sure as to how to implement
Remember the heat and chemical baths the medical instruments must endure. I don't think any method of adding something to them will stand the stress.
Paul
As AWOL mentions... there needs to be a UNIQUE identifier on the machine itself so you can even BEGIN your data adventure.
Before more questions... can you elaborate on this?
"The only way we can look up the details on this device is by using SQL/access database which is a lot of walking and time wasting"
So you 'walk' to some office/work station......... and......? Do what exactly?
Can you access this 'machine' via intranet?
Perhaps using an ESP module to connect to the 'app' (query) and send the ID might be an avenue to look into?
Like what happens atm we have approx 30 of these devices on a trolley the only way of knowing quick and easy what it needs is by putting a sticker on it blue is for needs approval for repair yellow waiting parts orange out source repair and we write on a sticky notes what parts it needs but as people know stickers lose their adhesive and can get lost and I was just thinking of a way that we could scan the device SN (AAAA-1111) for instance and be able to pull info from the database quick and easy
Can’t you get a scanner interfaced to your existing database , plus a terminal a bit nearer to you . This is more likely to be the best solution .
thats exactly what I was saying...
WAY easier.... intranet/wifi.. whatever....
a phone even...