RFID card reader/logger on raspberry pi, back end SQL database with Web functions.
€30-250 EUR
완료함
게시됨 거의 7년 전
€30-250 EUR
제출할때 지불됩니다
My goal is to have a RFID card reader which could log card IDs and time stamps, do couple verification steps once card is read, sync data with back end database.
Back-end should have a Web app to review, parse add/edit data, calculate time spent for each card.
----------- Equipment -----------
- Raspberry Pi 3, currently running jessie, if required could be changed to other distro.
- RC522 card reader - [login to view URL] Reader already connected to a raspberry and is able to read the cards - python based script.
- Few LEDs and a buzzer ([login to view URL]), already connected and triggered by python script module.
- Back-end server. I will be able to provide a VM with desired OS to host a database (MySQL, MSSQL or any other desired) and the website.
----------- Programming details-----------
Reader:
Once raspberry boots up it starts a script which waits for cards;
Once card is detected - unique ID is read (uid - etc: [6, 186, 170, 133, 147] ) verification executed.
1.1. if uid is known; Check against ID list which was defined in database earlier;
1.2. check if card was logged before on the same device, assign state value (IN or OUT) opposite to latest entry (Boolean value will work here).
1.3 if above checks success - log stamp - uid, timestamp, state, device name.
Submit logged entries to back-end.
Raspberry should be able to operate with out internet for couple of days and sync data afterwards.
#Comment. I was experimenting with local .txt files for storing known id list, in/out table and log (have coded those parts successfully separately , but i'm not able to perform verification successfully in one script loop pass in python.). Thinking about local MySQL instance on a raspberry to store that data and do another script to sync local MySQL to back end MySQL. Pull known IDlist table and push Log.
Database plan: (can be changed if required)
Back-end database will be running on a VM will have few tables such as:
idlist
uid, cardnumber, card_owner, active;
datalog
uid; date; time; state; device;
Web app requirements:
To a be able to assign values to certain uid, such as card owner name, card number, set card as active, etc.
To pull report for time spent in last 1 day, 7 days, 1 month and so on, query based on specific card or specific device which collected the data or overall.
Edit certain entries in datalog table if required if those does not make sense.
I will be able to provide direct access to the raspberry via ssh with all components connected and to the VM on the same Vlan.
I'm looking for a person who has competence to code all above or in parts.
Part 1. Rasberrypi reader with database
Part 2. Web app.
PM for more details.
Hi there! I would love to help you.
tl; dr of the project is to read the RFID card and store the data.
Then show it nicely in a webserver; right?
I have experience with python/mysql/ and linux it self.
I have few raspberry pi (but not the rfid card reader) so I can help you setting up the system in case something needs to be changed.
Thanks,
Ignacio.-
FREELANCER RECOMMENDED
------------------------------------------------------
Can help... I am an Expert... Lets Start!
Please start a Discussion with me and we can get started from there...
Please check the past projects I have handled and check my reviews for what employers have to say about my work... Can start right now...
Hi,
Can you share more details?
Thanks
David
30+ years C/Unix-HP-UX-Solaris-AIX/Linux programmer, performance
+10 years embedded Linux (openwrt/raspberry/odroid) & Arduino.
Oracle OVM admin
Unix/Linux Kernel support & dev
Python dev.
PHP dev.
Uni* scripting
TCP/IP dev.
mysql/mariadb/sql adm&dev
NFS (admin & rpc programming)
XML
Hello,
Greetings!!!
Hope you are doing great..!!
I have carefully reviewed the requirement. I am very much interested in this project and would like to work with you on your important project.
Kindly share the detailed requirement, so I can work out on that and will give you specific time frame and cost. I have mentioned the estimated cost in a bid which is subject to vary depends on the final scope. I can start working on the project immediately.
I’m glad to answer any question you may have!
Looking for a favorable consideration and let me know to move further!
Many Thanks & Regards,
Rishi A.
Hi Sir,
Nearly ready solution for you
just days ago finished similar project with rpi, MFRC522 and mysql.
We offer our services at very feasible rates. Please discuss with us in details.
We are team of developers and engineers professional in designing electronic circuit solutions, pcb designs, database programming such as MySQL etc, software designs and GUI/UI development, android applications, integrating software and hardware and providing complete solutions.
In this bid, we offer you our solution at very low and affordable rates based on your desired requirements. we normally follow several checks to ensure the quality of service and products.
In this bid prototyping is not included, if at certain point you would like to have prototypes manufactured, we can provide you at minimal cost including courier charges (DHL/FedX etc).
We, very humbly deal with our clients and provide technical support to them during all phases of project execution.
We are very much looking forward to hear from you in coming days.
Cheers,
Ahmad
Lead Technical Engineer
Turktronics Inc.
An Internet of Things Company
i am working as assistant technical manager. I have designed pakistan's 1st RFID debit card system for amusement parks. i have 5 year experience to work with microcontroller, single board computer , PLC , arduino , labview , visual basic , Report writing e.t.c. i can complete your project as you like
I'm a hard worker, self-motivated one with a great desire to pursuit myself and be one of the top in my field and i believe that anyone can be a very successful person in any field by working hard, thinking different and of course believe in his/her strengths and enhancing his/her weaknesses.
And for me now, i'm seeking a challenging position in a reputable firm where I can prove my skills, add new skills to myself and gain new experience. And also helping in firm’s success, accomplishing objectives, effectiveness and efficiency
Having practical experience of development in this area through some starling concepts. May be next one is yours . You may also wish to review my portfolio in order to check my previous work and learn more about my skill.
Thank you