Jump to content

RFID Hardware and Software integration with Filemaker


dickiechung
 Share

This topic is 2227 days old. Please don't post here. Open a new topic instead.

Recommended Posts

We are using Filemaker Pro 14 to develop a Staff Management and Control Access System. Each employee will be issued a RFID card as identity card.  We need to integrate RFID encoder and RFID reader with our Filemaker database. May anyone point me to the right direction how this can be done? Are there proven RFID hardware and software that will work with Filemaker Pro from encoding/writing to decoding/reading? 

 
Edited by Lee Smith
Removed bold formatting.
Link to comment
Share on other sites

  • 1 month later...

Don't know if this is still relevant, but if you only need the UID of an rfid card than buy an HID RFID Reader on eBay ($20-$30). The unique 10 digit ID on each tag will be your reference in the DB. Make sure the scanner is HID so it works just like a keyboard (plug in and scan, id will display in Notepad). You then make a script which is triggered by the 'ENTER' of the reader (the rfid reader works just like a barcode scanner and adds an 'ENTER' after each scan). You don't have so safe anything on the rfid card it self, all is done in filemaker.

I tried too many times to write back to the card but it is too complicated.

Link to comment
Share on other sites

  • 5 weeks later...

Thank you very much for your inputs.  We have successfully build an Access Control System with the following features:

  1. Access control hardware are installed in different locations for different departments.
  2. Access control hardware are updated regularly the official working hours and access rights of each employee.
  3. Filemaker can access and control the hardware over our internal network.

Our solution:

  1. We bought a 2 in 1 (finger print recognition and smart card reading) Access Control Hardware from www.jd.com, a Chinese online retailer at around US$100. (ZKT U100)
  2. The hardware came with a management software to work with the hardware. We asked the supplier to give us a .DLL file (not came with the hardware).
  3. We use PowerBuilder to create a .exe file to execute the functions of a .DLL file that works with the hardware.
  4. To update the records of the hardware, we use Filemaker to create a .txt file (containing info of employee names, IDs, working hours etc.) in a temporary directory and immediately call the .exe file (using Send Event) to execute the .DLL functions to update the hardware.
  5. To download attendance data from the hardware, we use Filemaker to call the .exe to import data directly into Filemaker. (The .exe is created by PowerBuilder and Filemaker acts as an ODBC database of PowerBuilder when data is downloaded from hardware.)
  6. The smart cards we buy have unique serial number pre-encoded so that we avoid the need of encoding smart cards.
Edited by Lee Smith
Made font readable.
Link to comment
Share on other sites

This topic is 2227 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.