Wilfile Medical

Wil File Medical is an open source medical record keeping system that works with Microsoft Internet Information Servers (IIS) and MySQL Server capable of managing:

Prescription documentation

Personal medical records from visits

Receipts for reimbursement

Transactions for health care reimbursement accounts

Vaccination documentation

MySQL is a popular database system that is used by NASA, The US Census Bureau, Wal-Mart, and most social media platforms capable of handling large scale database tables and information quickly and securely (MySQL is used by WilFile for tracking website traffic).

This application will work with mobile devices giving you the option to store documentation to the transaction such as receipts, test results, prescriptions, immunization records, and other medical information securely without the need to hang onto the actual paperwork.

If you are looking for a solution to keep track of medical transactions for tax and record keeping purposes, this is a perfect solution.

 

Currently, Wilfile Medical is working to take care or HRA (Healthcare Reimbursement Account) and FSA (Flexible Spending Account) managment including resetting these balances properly at the end of the year.

The system is also being updated to provide payment options for Care Credit, and Access One, to submit transactions to those payemnt services as well as providing account balance information, payment processing, and interest payment adjustments.

These enhancements are pushing the completion date of the application into early 2023.

Available soon on Git-Hub

The application release is pending the completion of the app to build the database structure and procedures for MySQL Server.

System Requirements:

Windows 10 Professional, Windows Server 2016 or 2019 (Internet Information Services must be enabled).

MySQL Server 8.0 (64-Bit)

Linux, Mac, or Windows 10 computer or Server (64-bit) to install MySQL Server 8.0 on a separate machine (optional if you want to separate the web server from the SQL server).

8 GB of RAM

1 gb ethernet connections (more than ethernet port per server is recommended for SQL management purposes).  Wi Fi connections are not recommended for security reasons as well a bandwidth concerns when uploading documents to the database server.

Solid state hard drives are not recommended for MySQL Server (per Oracle). A magnetic based hard drive should be used to store database information including transactions and paperwork (1TB is recommended).

SSH is recommended to install to manage MySQL Server as needed.