Repost: Modifications to Mysql/php medical database

Closed

Description

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.

Skills: Javascript, MySQL, PHP

See more: writing out numbers, writing numbers 1 10, writing copy freelancers, writing a to z, what is record in data structure, what is medical data entry, what is manual data entry, what is data entry clerk, what is a data entry form in a database, what is a data entry clerk, what freelancers want in clients, what do you mean by data structure, what do you mean by data entry, value options, using numbers in writing, type of data structure, total freelancers, set in data structure, select medical, php manual, php 5 assessment, one medical freelancers, offices for freelancers, mysql freelancers, mysql data access

Project ID: #820677

Awarded to:

gedgey

Please see PM

$350 USD in 5 days
(7 Reviews)
4.3

24 freelancers are bidding on average $678 for this job

phpMaestro

Hi, We are a team of developers and designers who are in this field from more than 10 years. We are a web Design and Development Company, providing web development in PHP, CMS based websites, E-commerce website, Wor More

$750 USD in 21 days
(270 Reviews)
9.6
sristerweb

Kindly check PM for more details

$600 USD in 25 days
(294 Reviews)
8.2
toinnisfree

pls chk pmb

$875 USD in 10 days
(628 Reviews)
8.1
rockerstech

check out standard proposal and please shoe me demo or dev link please.

$790 USD in 20 days
(79 Reviews)
7.6
neoconcepts

i ready the this, i got the modification required on existing system. we can do this, let's start.

$400 USD in 10 days
(125 Reviews)
7.4
sunztech

Please see PMB.

$1000 USD in 10 days
(31 Reviews)
7.4
srinichal

I can deliver the project in steps with great progress

$800 USD in 9 days
(111 Reviews)
7.2
netxpertindia

NetXpertIndia is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. Our team can More

$750 USD in 12 days
(89 Reviews)
6.8
Msolutions7

Hi We are confirmed we are going to start this project in this reasonable price need your confirmation.We have complete full confidence on you. We read the details and Clear with your requirements.Let us know your res More

$850 USD in 20 days
(53 Reviews)
6.7
jarvisliu

Please check your PM

$1100 USD in 15 days
(32 Reviews)
5.6
eddie09

please accept my bids sir, read PM for more details thanks,

$275 USD in 10 days
(22 Reviews)
5.4
PauloSam

Hello, I can do this. Please check PM.

$1000 USD in 13 days
(45 Reviews)
5.4
alldesigner

Hi, I have had a lot of experience with php and mysql and implementing business solutions such as this. I am in Asutralia (Canberra) so it would be easy to communicate by whatever means you prefer. If you want a More

$400 USD in 10 days
(4 Reviews)
4.5
saasfreelancer

Hello Sir, See PMB for details. SAAS

$500 USD in 30 days
(18 Reviews)
4.3
speedster

Hi, please see pm, thanks!

$400 USD in 17 days
(9 Reviews)
3.6
donkihot

Hello! I can do this big work. Check PM, please.

$650 USD in 14 days
(4 Reviews)
0.6
NitinGour0

Hello! Please See PMB

$830 USD in 30 days
(0 Reviews)
0.0
Rushiattechnopus

************* PLEASE CHECK PMB *******************

$650 USD in 20 days
(0 Reviews)
0.0
sivajohn

dear client,ping me soon.

$800 USD in 15 days
(0 Reviews)
0.0
vramusg

I can complete it for u... I am expert in PHP & MySQL, Javascript, etc... I am also readily available for chat (10 hrs/day) in SKYPE / GTALK / MSN / YAHOO Messenger Available Days : Mon - Fri Available Time : 8:30 More

$501 USD in 10 days
(1 Review)
0.0