How do you compare or use hospital-based Electronic Medical Records (EMR)?

We usually extract our study data manually from the EMR of any hospital. The data can be downloaded and imported into our database, or physically entered by our site coordinators.