I'm doing a project for a college assignment, the idea is that it is going to be based in an engineering environment where I will use this project to book measuring equipment in and out of Inspection. I wish to do this by flashing the card over the reader to book the equipment out and then flash again to book it in.
Note: Each card I use, is going to represent a different piece of measuring equipment.
I have managed to hook up my RFID starter kit and have started using the Arduino software combined with Excel Data Streamer. Data is present on the "Data In" tab when I hover my RFID card over the reader, however I have run into a few problems.
I would like the reader to recognise the card I am scanning and display a customised serial number which I want to assign to each card to represent a different piece of measuring equipment that I am going to book out of inspection.
How would I go about doing this? Is this something I must do on the Arduino software or on Excel itself?
The other problem I will later face is that, I would like the software to recognise that with each scan I am changing the status of the measuring equipment from "Booked In" to "Booked Out".
How would I achieve this and how would I be able to display this on the Excel table.
Any resources, ideas or suggestions would be greatly appreciated,
If I got it right... You're "walking around" and scanning equipment...
The decision is "Booked In” or “Booked Out."
I my opinion the scanning device should register "Booked" in order to be free from knowing the past. Microcontrollers are not fit for keeping data bases in their memory. Let the Excel judge if a "Booking" is "Booking in" or "Booking out".
For Your portable device there's no problem showing the identity of the scanned equipment.
If you are referring to me walking around with the device, the device is going to stay within an enclosed unit and will stay by my computer for me to book measuring equipment in and out.
So I am correct in saying I do not need to change anything regarding the Arduino software? All I need to do is make changes within Excel?
I would also like to add that the device is registering each card differently as it should with one being "'6800901C9A7E" and the other being "'6800866866E0". If I want this to register as a serial number of my choice, I must change this on Excel. Correct?
Okey. No difference. You bring the equipment to Your reader and wants to register data.
If all the needed data are sent to Excell, do the work in Excel.
Regarding the "Booking" I'm not sure if I understand the details. You figure out if Excell can make the conclusions from the data transferred.
When I am mentioning equipment being "Booked Out" I mean that it is being logged as going out of the room to the shop floor where it is going to be used. Once the engineer is done with the equipment they will bring it back into inspection for me to log it as being back in the room where it belongs, when not in use (Booked In).
As for the Excel making conclusions, I will see what I can find elsewhere. This post was to simply find out if I needed to make any changes or adjustments at an Arduino level.
Okey, a book keeping system to know where equipment is,
I didn't understand Your question this way.
To the end, design the system, who will know what and where will decisions be made.
I don't feel clear about what knowledge the Arduino is keeping so You need to be more precise.