# GSoC 2018 - Merge Patient data from Multiple Installations **URL:** \ **Category:** GSoC\ **Created:** [March 7, 2018, 4:19am UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592 "2018-03-07T04:19:28Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![jayamal](https://talk.openmrs.org/user_avatar/talk.openmrs.org/jayamal/32/7077_2.png) [@jayamal](https://talk.openmrs.org/u/jayamal)\ **Post date:** [March 7, 2018, 4:19am UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/1 "2018-03-07T04:19:28Z")
Hey I am looking forward to participate to above project in GSoC 2018. I went through the guidelines and did the basic things and got familiarized openMRS. I take a looked at this project and the idea that I got is, there are data about patients, encounters, and observations at different places at different databases ant what we have to do is, that data should be collected and should be merged into one database and also should create a interface to reporting and analysis purposes. now I got some problems to clarify 1. different places means the places in a particular area or all over the world? 2. you mentioned in description ‘no guarantee of a consistent Internet connection’ so then how database can be accessed I like to study about this project further. and I think given details are not sufficient to get an idea about this project so If you have more information about this project I request that details to study this more thank you ---
**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\ **Post date:** [March 9, 2018, 11:30am UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/2 "2018-03-09T11:30:56Z")
Thanks @jayamal for expressing interest in this project! 🙂 As for different places, the implementation does not depend where they are. It could be two databases in the same room. All that matters is that data is coming from separate openmrs database instances. For cases of no internet connectivity, assume that the database will be physically brought over using storage media like external hard disks or others. In summary, assume that some how, the other databases will eventually be brought in proximity to the master database, for data to be transferred. ---
**Author:** ![hemalmamtora](https://talk.openmrs.org/user_avatar/talk.openmrs.org/hemalmamtora/32/6956_2.png) [@hemalmamtora](https://talk.openmrs.org/u/hemalmamtora)\ **Post date:** [March 9, 2018, 4:36pm UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/3 "2018-03-09T16:36:50Z")
Hello @dkayiwa I am interested in participating in GSOC 2018 and have gone through this project. I have gone through the developer manual and followed the steps on [Getting Started as a Developer](https://wiki.openmrs.org/display/docs/Getting+Started+as+a+Developer). I have setup the development environment following [this](https://wiki.openmrs.org/display/docs/How-To+Setup+And+Use+Your+IDE) and fetched the repository from github. I have also setup the server and can run it on my localhost but it doesn’t have any patient data. I have a few queries: 1. Do I have to setup the [Sync Module](https://wiki.openmrs.org/display/docs/Sync+Module) ? 2. I don’t have any data with me. From where can I have a look at the data to get an idea of what I have to merge? Thank you. ---
**Author:** ![jayamal](https://talk.openmrs.org/user_avatar/talk.openmrs.org/jayamal/32/7077_2.png) [@jayamal](https://talk.openmrs.org/u/jayamal)\ **Post date:** [March 9, 2018, 4:44pm UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/4 "2018-03-09T16:44:40Z")
Ok I got an idea, according to your description the data can be collected from different databases and we should develop a system using mysql quires to get that data to a one master database(Tell me if I am wrong) and also a API to present that data, right?? thank you ---
**Author:** ![ssmusoke](https://talk.openmrs.org/user_avatar/talk.openmrs.org/ssmusoke/32/8020_2.png) [@ssmusoke](https://talk.openmrs.org/u/ssmusoke)\ **Post date:** [March 9, 2018, 5:38pm UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/5 "2018-03-09T17:38:07Z")
@jayamal dkayiwa Is this not done within the current version of the Sync module [Sync 2.0 Planning](https://talk.openmrs.org/t/sync-2-0-planning/11799/107) ---
**Author:** ![jayamal](https://talk.openmrs.org/user_avatar/talk.openmrs.org/jayamal/32/7077_2.png) [@jayamal](https://talk.openmrs.org/u/jayamal)\ **Post date:** [March 9, 2018, 6:54pm UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/6 "2018-03-09T18:54:01Z")
Sorry I can’t understand I appreciate if you can please tell clearly ? thank you ---
**Author:** ![ssmusoke](https://talk.openmrs.org/user_avatar/talk.openmrs.org/ssmusoke/32/8020_2.png) [@ssmusoke](https://talk.openmrs.org/u/ssmusoke)\ **Post date:** [March 10, 2018, 5:52am UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/7 "2018-03-10T05:52:34Z")
@jayamal The solution to patient merging from multiple installations is currently being worked upon by the team building a new version of the sync module ---
**Author:** ![jayamal](https://talk.openmrs.org/user_avatar/talk.openmrs.org/jayamal/32/7077_2.png) [@jayamal](https://talk.openmrs.org/u/jayamal)\ **Post date:** [March 10, 2018, 6:58am UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/8 "2018-03-10T06:58:41Z")
So did you mean we can’t contribute to this project in GSoC 2018. But this project is in GSoC 2018 project Idea list thanks ---
**Author:** ![hemalmamtora](https://talk.openmrs.org/user_avatar/talk.openmrs.org/hemalmamtora/32/6956_2.png) [@hemalmamtora](https://talk.openmrs.org/u/hemalmamtora)\ **Post date:** [March 10, 2018, 7:26am UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/9 "2018-03-10T07:26:30Z")
@dkayiwa please clarify this. Thank you ---
**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\ **Post date:** [March 10, 2018, 7:29pm UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/10 "2018-03-10T19:29:08Z")
@ssmusoke does the sync2 module handle cases where data already exists in the different databases? ---
**Author:** ![ssmusoke](https://talk.openmrs.org/user_avatar/talk.openmrs.org/ssmusoke/32/8020_2.png) [@ssmusoke](https://talk.openmrs.org/u/ssmusoke)\ **Post date:** [March 11, 2018, 8:30am UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/11 "2018-03-11T08:30:45Z")
@dkayiwa That is my expectation as a use case, thinking master-slave, where facilities sync their data to a master server - without the master server controlling patient creation. Maybe this Gsoc project can be to handle that particular use case atop of sync ---
**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\ **Post date:** [March 11, 2018, 1:16pm UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/12 "2018-03-11T13:16:28Z")
@ssmusoke my understanding is that sync deals with cases where data is created or edited while sync is running. Not cases where you get databases that already have data and you just want to merge it into one database. ---
**Author:** ![burke](https://talk.openmrs.org/user_avatar/talk.openmrs.org/burke/32/17_2.png) [@burke](https://talk.openmrs.org/u/burke)\ **Post date:** [March 11, 2018, 1:37pm UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/13 "2018-03-11T13:37:40Z")
The [patient merge enhancement project](https://wiki.openmrs.org/display/projects/Patient+Merge+Enhancement) appears to be a mUzima use case. It may help to ask @mssavai or @ayeung how this differs from planned Sync 2 functionality. I believe the use case is a mobile client syncing with the server needing a semi-automated way to handle likely duplicates asynchronously. ---
**Author:** ![jayamal](https://talk.openmrs.org/user_avatar/talk.openmrs.org/jayamal/32/7077_2.png) [@jayamal](https://talk.openmrs.org/u/jayamal)\ **Post date:** [March 11, 2018, 3:34pm UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/14 "2018-03-11T15:34:07Z")
@dkayiwa Can you please tell us clearly whether this project is available for gsoc or not because if this is not available we can put our mind to another project Thank you ---
**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\ **Post date:** [March 11, 2018, 6:27pm UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/15 "2018-03-11T18:27:34Z")
@jayamal yes it is available for GSOC ---
**Author:** ![hemalmamtora](https://talk.openmrs.org/user_avatar/talk.openmrs.org/hemalmamtora/32/6956_2.png) [@hemalmamtora](https://talk.openmrs.org/u/hemalmamtora)\ **Post date:** [March 12, 2018, 2:12am UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/16 "2018-03-12T02:12:02Z")
@dkayiwa where can we submit our “drafted proposal” for review from your(i.e. OpenMRS) side ? Do we have to submit directly through Google channel ? Or could the mentoring organization review it for improvements before making final proposal through Google ? If yes, where can we submit our proposal on OpenMRS ? Thank you. ---
**Author:** ![hemalmamtora](https://talk.openmrs.org/user_avatar/talk.openmrs.org/hemalmamtora/32/6956_2.png) [@hemalmamtora](https://talk.openmrs.org/u/hemalmamtora)\ **Post date:** [March 12, 2018, 6:03am UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/17 "2018-03-12T06:03:35Z")
@dkayiwa, does the project have to make use of the sync module ? I read the [Sync Module Documentation](https://wiki.openmrs.org/display/docs/Sync+Module) which seems to do the work of merging by setting parent-child servers. Or do we need to do a stand-alone merging code that will take 2 databases(father and child) as input and outputs a single merged database(father instance)? Thank You. ---
**Author:** ![danfuterman](https://talk.openmrs.org/user_avatar/talk.openmrs.org/danfuterman/32/10800_2.png) [@danfuterman](https://talk.openmrs.org/u/danfuterman)\ **Post date:** [March 12, 2018, 6:09am UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/18 "2018-03-12T06:09:35Z")
@hemalmamtora The GSoC student application period opens later [today](https://summerofcode.withgoogle.com/how-it-works/#timeline). Once this has been announced, there will be a post on Talk with details on submitting draft and final proposals. ---
**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\ **Post date:** [March 12, 2018, 7:54am UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/19 "2018-03-12T07:54:09Z")
It will not use the sync module. Just pulling data from several databases into one, for analysis and reporting. ---
**Author:** ![shehanshaman](https://talk.openmrs.org/user_avatar/talk.openmrs.org/shehanshaman/32/7121_2.png) [@shehanshaman](https://talk.openmrs.org/u/shehanshaman)\ **Post date:** [March 12, 2018, 9:51am UTC](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592/20 "2018-03-12T09:51:17Z")
Hello I am interested to participated in GOSOC 2018. I went to project details and familiarized with above project. I have confident to do this project because I have good java and JavaScript and I was a contributor for ongoing these kinds of project which is **Patient Handling System for Dental Hospital Peradeniya** Tools and software used: Java, HTML/PHP, Eclipse EE, Struts, Apache Tomcat server, MySQL, bootstrap framework etc. GitHub Link: [https://github.com/namila007/relax-1](https://github.com/namila007/relax-1) These days we are doing another project which also has the similarities with above project. Which are, we send data to central database from provincial servers & merged data would be read-only, used reporting and analysis purposes. Some details about ongoing project **Automated and Centralized Electricity Billing System** GitHub Links: 1) [Main server](https://github.com/shehanshaman/EmbededProject) 2) [Provincial Server](https://github.com/shehanshaman/provincialServer) [short video](https://www.youtube.com/watch?v=45FeWnsaDwQ) I like to study about this project further. and I think given details are not sufficient to get full idea about this project so If you have more information about this project I request that details to study this more thank you [Next page](https://talk.openmrs.org/t/gsoc-2018-merge-patient-data-from-multiple-installations/16592.md?page=2)