# Practice Fusion Migration to OpenEMR **URL:** \ **Category:** Day-to-Day Users\ **Created:** [December 23, 2018, 1:41pm UTC](https://community.open-emr.org/t/practice-fusion-migration-to-openemr/11230 "2018-12-23T13:41:05Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Richardburt](https://community.open-emr.org/letter_avatar_proxy/v4/letter/r/90ced4/32.png) [@Richardburt](https://community.open-emr.org/u/Richardburt)\ **Post date:** [December 23, 2018, 1:41pm UTC](https://community.open-emr.org/t/practice-fusion-migration-to-openemr/11230/1 "2018-12-23T13:41:05Z")
I am a previous Practice fusion user, I have a full export with all my patient data but I have not been able to upload to open EMR. Can you help with how I can import patients notes? Thanks Richard ---
**Author:** ![Ralf\_Lukner](https://community.open-emr.org/user_avatar/community.open-emr.org/ralf_lukner/32/11962_2.png) [@Ralf\_Lukner](https://community.open-emr.org/u/Ralf_Lukner)\ **Post date:** [December 23, 2018, 8:00pm UTC](https://community.open-emr.org/t/practice-fusion-migration-to-openemr/11230/2 "2018-12-23T20:00:19Z")
This process is problematic, as far as I can gather from this thread: > [@Practice fusion data migrations](https://community.open-emr.org/t/practice-fusion-data-migrations/9849): > > Hi, We discussed this heavily at the conference call today. There are 2 mechanisms to export data from practice fusion. The first is the CCDA export, which we have been told does not export all the data. And the second is a complete data dump from PF, which takes 4-6 weeks to process, however we don’t know what that looks like. We are trying to find out: What does the complete data dump from PF look like (we had reports several years ago that the demographics was in csv form and then all th… Usually migrating EMR databases is very difficult / nearly impossible (besides migrating some limited demographic information or PDF’s) … and for practical purposes for a small clinic … nearly impossible from a cost standpoint. The way we have migrated information from NextGen’s Office (formerly Healthfusion) EMR is by exporting to PDF’s and storing those in an archival database. Then, we would populate the data into the the new charts on OpenEMR for upcoming appointments by manually cutting and pasting critical information into the new system. Practice Fusion also has an article that speaks to the many concerns you will inevitably run into as you migrate. They seem to suggest that they have something better, but there seem to be a number of issues remaining. > **[Switching to a New EHR and EMR System | Practice Fusion](https://www.practicefusion.com/blog/transitioning-from-one-emr-system-to/)** > > Switching EHR systems can be even more challenging than migrating from paper records. See how our EHR makes moving data and re-working workflows easy. ---
**Author:** ![sjpadgett](https://community.open-emr.org/user_avatar/community.open-emr.org/sjpadgett/32/21623_2.png) [@sjpadgett](https://community.open-emr.org/u/sjpadgett)\ **Post date:** [December 23, 2018, 9:43pm UTC](https://community.open-emr.org/t/practice-fusion-migration-to-openemr/11230/3 "2018-12-23T21:43:30Z")
I have done this on a multi site AWS docker configuration of 6000+ patients with limited success using Care Coordination Module import CCDA. What get created: - Encounters (minus notes and encounters need to be signed from PF) - Problem/Issues (snomeds are used instead of ICD) - Demographics (Will create new patient) - Medications Imported but placed in External as history: - External Providers - Procedures - Maybe some other things i’m not thinking about just now. The biggest issue with import is that as the number of ccda’s imported grows, the system slows relatively because of the nature of the UI. I solved by creating a sql to purge the offending import history. Once import is done then notes history or whatever chart log PF provides can be saved to patient documents. The CCDA is automatically saved on import. I’d not necessarily recm doing 6000+ patients again but this is much better than creating from scratch. Oh yeah, physicians tend to be patient souls so, there is that. 🙂 ---
**Author:** ![Richardburt](https://community.open-emr.org/letter_avatar_proxy/v4/letter/r/90ced4/32.png) [@Richardburt](https://community.open-emr.org/u/Richardburt)\ **Post date:** [December 27, 2018, 2:17am UTC](https://community.open-emr.org/t/practice-fusion-migration-to-openemr/11230/4 "2018-12-27T02:17:53Z")
Thanks for the information. I have tried multiple methods but all are unsuccessful. The full export from practice fusion is an excel file With multiple sheets and all information is there even unsigned charts. I am currently working on a possible mapping form excel to sql or do in steps demographics first and then encounter data. Any ideas please share. Thanks Richard Burt ---
**Author:** ![Ralf\_Lukner](https://community.open-emr.org/user_avatar/community.open-emr.org/ralf_lukner/32/11962_2.png) [@Ralf\_Lukner](https://community.open-emr.org/u/Ralf_Lukner)\ **Post date:** [December 27, 2018, 7:40pm UTC](https://community.open-emr.org/t/practice-fusion-migration-to-openemr/11230/5 "2018-12-27T19:40:00Z")
Do you know how to create HL7/CCDA files? If you can do that, there is a way of importing those. Do you or do you want to hire someone who take a delimited text file and PUT the records to the OpenEMR (MySQL) database? ---
**Author:** ![Richardburt](https://community.open-emr.org/letter_avatar_proxy/v4/letter/r/90ced4/32.png) [@Richardburt](https://community.open-emr.org/u/Richardburt)\ **Post date:** [December 27, 2018, 9:58pm UTC](https://community.open-emr.org/t/practice-fusion-migration-to-openemr/11230/6 "2018-12-27T21:58:23Z")
I am trying my best to create the CCDA files but I have not been successfull . Do you know someone who I can hire to help with the process?