In Progress

Updates to mysql/php medical database

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.

Hi Guys,

A few providers seem to have misunderstood. I am not looking for a database to be built from scratch. I just need the changes as specified above.

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.

Skills: MySQL, PHP

See more: medical php mysql database, php mysql medical database, php mysql medical form, writing a to z, using numbers in writing, select medical, php 5 assessment, medical writing clients, medical data entry clerk, i need a data entry clerk, date entry clerk, data entry keyboard, data entry form php mysql, data entry assessment, php medical database, mysql php medical, php mysql medical, mysql client, medical report writing, php writing, mysql report, Mysql php, mysql copy, medical\, medical writing

About the Employer:
( 42 reviews ) Sydney, Australia

Project ID: #794118

Awarded to:

alexias

Hello Experienced with JavaScrpt/Ajax/PHP/MySQL/XML. Have more than 50 projects completed and can confirm it. Can do it with the best quality. Thanks Alex

$150 USD in 5 days
(60 Reviews)
6.6

43 freelancers are bidding on average $421 for this job

krishdts

Please check PMB for details.

$500 USD in 15 days
(67 Reviews)
8.1
toinnisfree

pls chk pmb

$250 USD in 4 days
(546 Reviews)
7.9
phpexp

Please check PM

$380 USD in 4 days
(172 Reviews)
7.8
websree

Please provide the database info in pmb.

$450 USD in 5 days
(159 Reviews)
7.5
NickolaS

Hi, please, check your PM

$630 USD in 3 days
(323 Reviews)
7.5
MuktoSoftware

Please check PMB. Thanks.

$400 USD in 5 days
(404 Reviews)
7.4
HighEndSolutions

Hello Sir, Experts are here! Please check PMB for more Information! Kind Regards,

$999 USD in 15 days
(91 Reviews)
7.4
DesignSolutionSW

Please check PM.Thanks.

$300 USD in 10 days
(59 Reviews)
7.0
phpgenin

all seems clear to me. php, mysql excellent knowledge. please see reviews for references to my previous [url removed, login to view], alex

$400 USD in 10 days
(68 Reviews)
7.0
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our More

$400 USD in 20 days
(43 Reviews)
6.9
Sphinks

Hello sir. I have the required skills to complete this project in a professional timely manner. Please contact me to discuss more. Regards, Sphinks!

$525 USD in 5 days
(87 Reviews)
6.6
SICS

Please see PM

$1300 USD in 10 days
(31 Reviews)
6.5
khanhhuyna

Can do this. Thanks!

$350 USD in 10 days
(78 Reviews)
6.4
freeworks

Please check my PM

$1000 USD in 7 days
(75 Reviews)
6.3
RedhopIT

Ready to start now, please check pm for more details.

$100 USD in 2 days
(62 Reviews)
6.1
vsscomputers

Hi Please check your inbox for details

$250 USD in 2 days
(56 Reviews)
6.0
Indispensable

Please see your PMB. Thanks.

$400 USD in 5 days
(36 Reviews)
5.9
stanxp

Hello markkitchener, Please check your PMs. Thanks! Best Regards, Stan.

$349.99 USD in 7 days
(63 Reviews)
5.9
itmentorspk

Please see PMB for details - Thanks

$450 USD in 7 days
(10 Reviews)
5.9
euphern

dear markkitchener, We are highly interested in doing this project. We have enough talented personnel to accomplish this project in [url removed, login to view], please consider our bid. Please check PMB for further details. Th More

$300 USD in 15 days
(14 Reviews)
5.9