Færdiggjort

RFID card reader/logger on raspberry pi, back end SQL database with Web functions.

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 - [url removed, login to view] Reader already connected to a raspberry and is able to read the cards - python based script.

- Few LEDs and a buzzer ([url removed, login to view]), 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.

Evner: HMLT5, Linux, MySQL, Python, Software Arkitektur

Se mere: where do i get python programming application for raspberry pi, raspberry pi c programming websites, raspberry pi c programming, php, mysql, python, programming with raspberry pi, programming the raspberry pi, programming raspberry pi, programming on raspberry pi, programming c for find the memory of my raspberry pi, raspberry pi python web development freelance, raspberry pi python, hire a python programmer raspberry pi, access database sql web application, python rfid programming, python mysql rfid data, php database sql web template, rfid reader python programming, programming python raspberry

Om arbejdsgiveren:
( 0 bedømmelser ) Vilnius, Lithuania

Projekt ID: #13838394

Tildelt til:

ignaciorodrguez

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 Flere

€250 EUR in 3 dage
(30 bedømmelser)
4.6

15 freelancere byder i gennemsnit €210 på dette job

ranganathp

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 p Flere

€155 EUR in 3 dage
(43 bedømmelser)
6.3
€250 EUR in 5 dage
(75 bedømmelser)
6.2
dfrmex

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 Ke Flere

€244 EUR in 5 dage
(19 bedømmelser)
5.7
dannyflorida

I can help you with that. I have done a similar project before. I can help you with that. I have done a similar project before.

€277 EUR in 3 dage
(10 bedømmelser)
4.8
ahmad5857

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 deve Flere

€200 EUR in 5 dage
(14 bedømmelser)
4.5
€155 EUR in 3 dage
(5 bedømmelser)
3.1
dimaseko

Hi, The project is quite interesting. I have done that before, integrating raspberry pi 3, MFRC522, weighing scale, IP based LED, traffic lamp, buzzer, and backend server. And i have compiled the python functio Flere

€222 EUR in 5 dage
(3 bedømmelser)
3.0
rishiajmera

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 d Flere

€177 EUR in 20 dage
(4 bedømmelser)
2.4
ahsandilawarr11

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 , lab Flere

€200 EUR in 3 dage
(4 bedømmelser)
2.4
livedigix39

Give us a chance to prove that your decision was best. We are providing the services by which customers are satisfied.

€155 EUR in 3 dage
(0 bedømmelser)
0.0
kameshwarthakur

I have working experience on linux and raspi project along with php development which makes me fit for this job. RASPI projects i've worked upon:- RFID attendance system Smart Mirror Home AUtomation DashCam Secur Flere

€155 EUR in 4 dage
(0 bedømmelser)
0.0
esmairi

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 a Flere

€155 EUR in 3 dage
(0 bedømmelser)
0.0
vw7888219vw

Krishantha (Software Engineer) Windows or web base software develop using C#, vb .net MS SQL Crystal report. I have more than 5 year experience as software engineer. Graduated in university of Moratuwa, Sri lanka- Bac Flere

€155 EUR in 3 dage
(0 bedømmelser)
0.0
baap7

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 sk Flere

€400 EUR in 7 dage
(10 bedømmelser)
0.0