Import Patients to Wildlife Rehabilitation MD

Using the Wildlife Rehabilitation MD Import tool, you can import patients and various related data into your database from other sources. We have created templates and a guide to help you organize your data so that it can easily be imported into WRMD.

Before You Start

Here are some things to know before you begin this process.

• The data that you want to import needs to be formatted into an MS Excel (.xlsx) file.
• At this time, we (the Wildlife Rehabilitation MD team) prefer to do the actual importing for you. This is because importing can be tricky and we want to make sure everything goes where it needs to. You send us the file(s) and we import them. ^*have us prepare your data for you

You Can Import...

• Patients with their rescuer and initial exam
• Treatment logs
• Location / enclosure history
• Rescuer donations
• Volunteers / Members
• Banding & Morphometrics
• Daily Exams
• Hotline Incidents
• Labs
• Prescriptions
• Other: If want to import something that's not in this list then we can likely make it possible. Just ask!

Required Data

Make sure your data has the required columns and each row has values for those columns. The required columns for importing patients are:

• Common Name
• Date Admitted
• Disposition

The required columns for importing anything other than patients depends on what you are importing. However a column that is always required is one with a unique identifier to correlate the data to the patient it belongs to. The data may correlate to a patients case number, reference number, microchip number or band.

Species

Entering the correct common names is incredibly helpful for all data analysis and reporting. The easiest way to choose a common name is to just look them up in the WRMD new patient screen. Anything that auto populates within WRMD is an appropriate common name. Typically the most common common-names are known to WRMD. After importing your patients, WRMD will verify the species common names and identify any that are unrecognized.

Prepare for Import

1. Download one of our template files to help you organize your data.
   • Patients with their rescuer and initial exam
   • Treatment logs
   • Location / enclosure history
   • Rescuer donations
   • Volunteers / Members
   • Banding & Morphometrics
   • Daily Exams
   • Hotline Incidents
   • Labs
   • Prescriptions
2. Add your data to the template file.
3. If there is a column who's values are always empty, then you can delete that column as long as it is not a required column.
4. Standardize your date values for consistency. Ideally into yyyy-mm-dd format.
5. Standardize your "translatable" values. For example, when filling in the Disposition column you should ideally use the same disposition terms used in WRMD. If however you use your own terms, we will need to know their meaning so that we can translate them into the correct WRMD equivalent.
6. Once your data is cleaned and standardized, email us at [email protected] with your name, account and Excel file(s). We will then coordinate the importing process with you.

Below are Some Examples of Fields In WRMD Who's Values are Chosen From Drop-down Menus.

Have us Prepare Your Data For You

Your data may be in a format or database that you are unfamiliar with or perhaps there is so much of it that you are overwhelmed. If that's the case then, for a negotiated fee, we can prepare and import your data for you.

There are too many variables to try and describe how this process could work. However; in the past, we have had data emailed to us that we were able to access and prepare for import. We have also visited organizations and worked directly with their staff to export, prepare and import their data. Depending on time lines and budget we are willing to help however we can.

Past fees for preparing other organizations data have ranged from $300(US) to $5,000(US). It all depends on how much data there is, what shape it's in and how soon you need it imported.

If you would like to discuss this option further then please email us at [email protected] with your name, account and needs.