Repost: Modifications to Mysql/php medical database

Budget N/A
Bids 24
Average Bid $678

Note: Repost to previous provider drop-out x 3

Please do not bid if:

1) You are going to have a family problem 1 hr before the project deadline and suddenly decide you can't go ahead (two weeks into the project)
2) You are going to insist on using email only (and only when you feel like it). I like and value communication with my freelancers and that means that you must be able to use instant chat as a minimum.
3) You are simply going to stop answering emails.

Also: Total cost to develop original system (which is much more complex than modifications outlined below) was only $1100. I accept that your cost structure mean you might want to charge more than this - but please use this as a guide to what we are going to think is a realistic price.

We have an existing mysql/php medical database that runs on localhost in 5 separate offices and need the following changes made:

1) There is an export and import data mode that is currently working (in that data exports and imports) but there is no way of checking that data is not overwritten. We need the addition of a last updated tag to records - and need the import to check the last updated tag before over-writing i.e. if we import data between sub-offices we always want to make sure we are left with the most up to date record.

2) We have an existing data entry form. We need to add an option for data entry clerk to select the type of visit (one of eight possible options). This should be possible using keyboard data entry (not mouse). This should be appended to each client record. There are different options that need to be added for male/female clients and for infant clients.

3) We need the following reports added to the existing report that can be generated by the database:
- The database report currently shows total number of clients between certain periods at certain geographic areas. This should be also broken down by gender - i.e. male/female/infant
- Two other existing reports should also be amended so they break down total client numbers by the reason the client came to the clinic. This should be in aggregate - i.e total clients (made up of x,y,z etc) and separately produce a report just based on that client type
- Options will be different as per point 2

Please provide an initial rough bid and an idea of your php/mysql expertise.

Shortlisted bidders will be shown a copy of the existing database and given an opportunity to adjust their bid based on their assessment.

A couple of people have asked for clarification about the export/import task.

Essentially:

1. Database runs on localhost so different sub clinics have a complete copy of the full database (even though they only edit/amend a portion of it
2. We are hoping to run weekly manual synchs between sub-clinics (as they need access to the full set of data - even if they are not going to edit all of it

At the moment

1. Client comes to Clinic A and their record is added to the database
2. The data is synched onto Clinic B's database
3. Client comes back to Clinic A and the data is edited
4. When the data is synched back from Clinic B the original older record overwrites the newer record

The first point in the project relates to the change we would like

1. The addition of a last edited tag to record
2. The adjustment of the import and export to take into account the last edited tag so that only data that is newer than the one in the host database is imported in.

Please pm if you need further clarification.

Post a Project Like This

This project was awarded to

gedgey

Geraint was a wonderful freelancer to work with. He methodically broke down our project and rebuilt whole sections (that were above and beyond the scope of the original project). He has the rare gift among GAF freelancers of being able to take an unknown code project and dissect it enough to understand both it's strengths and weaknesses. When part of the original specifications proved unfeasible he generously coded an alternative component to cover the difference. Definitely recommended. A pleasure to communicate with.
About the Freelancer
gedgey Profile Picture

Hello - I am a freelance IT consultant, with a degree in CompSci and 20+ years experience. I have put my hand to most things, but am most proficient in Internet (web, mail, etc) technologies and programming (perl, PHP, JavaScript, Java, C) backed with vast experience of Unix/Linux (shell scripting, system admin).

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • Rushiattechnopus Profile Picture

    Rushiattechnopus

    Rajkot,  India

    I have been familiar with World wide web and serving it with my programming skills from past 4.5 years. I am skilled in Core PHP, Javascript, Jquery, Jquery UI Lib, Mootools Library, Zencart, X Cart, Joomla, Wordpress, Magento and many other skilled areas. Our top priority is to earn reputation by our work and not by words.

    PHP, Javascript, XML, and Adobe Flash

  • NitinGour0 Profile Picture

    NitinGour0

    Indore,  India

    PHP, C Programming, Java, and JSP

  • speedster Profile Picture

    speedster

    Islamabad,  Pakistan

    In business since 2005. Can work in web as well as application technologies. Also work in electronics field, specially microelectronics IC design.

    PHP, ASP, C Programming, and XML

  • eddie09 Profile Picture

    eddie09

    Surabaya,  Indonesia

    Please visit http://www.indonesiandeveloper.com to view my portfolio of recent projects.

    PHP, Javascript, AJAX, and Joomla

  • phpMaestro Profile Picture

    phpMaestro

    Jaipur,  India

    Logicspice is serving for more than 9 Years all across the globe in the Industry of Software Development. We have been awarded as one of the Top 10 Leading Solution providers over Freelancer.com. We specialize in bespoke or Tailor made Web and mobile Applications with experts available on various technologies including but not limited to iPhone, Android, Magento, Wordpress, Joomla, Drupal, CakePHP, Zend, Yii, PHP/MySQL, ASP.Net etc. We have clients from around the globe, including Australia, Canada, USA and UK. Please check our Portfolio here and also check Client's feedback for the projects completed by our team. Our Service Highlights- ---------------------------------- - Custom and Complex Web application and Mobile Apps Development using custom coding (cakePHP, CodeIgniter, Yii, Zend) or open source solutions (Magento, Drupal, Joomla, Wordpress). - Experience with popular solutions like CRM, ERP, CMS - Digital Marketing including SEO and SEM - Experts in PHP5, HTML 5, CSS3, jQuery, Ajax, Java Script, XML, Objective C, Java Additional Benefits- --------------------------- - Extensive quality check and testing to ensure the quality of work delivered. - Documenting the requirements with innovative ideas, to ensure everything remains well planned from initial stage - Believe in providing required suggestions for improvements of the planned application - Support and Maintenance with good availability and quick turnaround - For Designing projects, we provide UNLIMITED REVISIONS until the client is completely satisfied - FREE technical support for 30 business days after the completion of the project and thereafter at a nominal cost of USD 15/hr. Team- ----------- - iPhone - iPad and Android Apps Developers - Web Designers - PHP Programmers - HTML Developers - Specialized open source Developers - Team Leaders - Project Managers - Quality Assurance engineers - SEO Experts - Business Analysts CONTACT US TODAY FOR YOUR PROJECT! Click the "Hire Me!" Button on my profile.

    PHP, Javascript, Website Design, and Graphic Design

  • foreverphp Profile Picture

    foreverphp

    antipolo,  Philippines

    I am Professional Web Developer with 9+ years proven experience in Web Development Using PHP/MySQL platform. I can also develop complex custom application using PHP. I knew Windows, Linux & Mac Operating System and etch..

    PHP, Website Design, Copywriting, and Linux

  • neoconcepts Profile Picture

    neoconcepts

    noida,  India

    We not do just coding. we help organization from planning to implementation of solutions using latest technology. we provide customized services specific to their requirement to achieve their goal.

    PHP, Website Design, SEO, and AJAX

  • sunztech Profile Picture

    sunztech

    Faisalabad,  Pakistan

    We work on company plate form.and has done hundard of projects in almost all tools through all online project outlets.Currently our company has great repute especially in QUALITY and work completion with in TIME FRAME. You can have a quick glance of couple of our work and a bit about our company at http://www.sunztech.com . Our technical support is at your service in any troubleshooting time for 24 hr. You will get a new passion to work with us! TRUST is our logo. SUNZTECH

    PHP, ASP, Javascript, and .NET

  • Msolutions7 Profile Picture

    Msolutions7

    Jaipur,  India

    Mindurge Technologies, a Web development and SEO company provides PHP Programming, Web Development, Application development, Search Engine Marketing & Optimization, PPC/CPC, Link Building, Web Design, WordPress, Joomla theme and customization and all related offshore services under one roof with qualified and experienced professionals from related domain expertise. We have expert team in CRE Loaded, OS Commerce, OS Commerce, Drupal, Virtuemart, Joomla, Wordpress and all Open Source based applications. We focus our proven experience providing best-of-breed solutions, deep industry knowledge across various domains, technology insight and innovation to help our clients achieving maximum returns from IT investments.

    PHP, ASP, Javascript, and XML

  • gedgey Profile Picture

    gedgey

    Cardiff,  United Kingdom

    Hello - I am a freelance IT consultant, with a degree in CompSci and 20+ years experience. I have put my hand to most things, but am most proficient in Internet (web, mail, etc) technologies and programming (perl, PHP, JavaScript, Java, C) backed with vast experience of Unix/Linux (shell scripting, system admin).

    PHP, Perl, C Programming, and Java