Update: April 2016

Posted on:

It is the beginning of the “Season” here in the Northern hemisphere. Spring is definitely in the air and the birdies are well into breeding, at least here in California. March was a very very busy month for us. Not only did we attend NWRA in Oklahoma but we spent a week in Hawaii working directly with our users.

Yes, I know what you are thinking, “oh you poor things you had to go to Hawaii“… On occasion there is a IMG_0015organization that needs our help getting set-up and if they have a lot of previous data, they may need our help importing it as well. Save our Shearwaters on Kaua’i was in need of our help to get them set-up. They have records dating back to 1979 on many species of pelagic Hawaiian birds that are affected by light attraction. The young of these species fledge at night and are drawn to the lights of urban development where they get disoriented and either crash or come to the ground in large numbers in a phenomenon called ‘fallout’. SOS as they are called had very special needs so they invited us out Kauai to transfer all of their data which was in 2 different formats into WRMD. This could IMG_0017not have been done without their generous financial support to WRMD. We worked in their office for 4 full days figuring out exactly how to manipulate and sort their data so that it would fit into the WRMD format. I think we all learned a lot with this experience, especially how important and beneficial it is to keep good, consistent records. We are still working on cleaning up this data, but once we do they will have nearly 35,000 records dating back to 1979.

With their help we were able to create the Banding and Morphometrics Extensions and we were able test the Import feature that we’ve been working on. The ability to import is almost done and should be up and running by the end of this month. The moral of this story is that as a community when one organization needs something and can help us build it, it then benefits the whole community! If we are needed to help an organization transition, we are willing to travel to them and help with their data needs if the organization can financially support the travel expenses.

Recent Updates

  • Import: Should be up and running by the end of the month at the latest.
  • Locking Record Function: We are continuing to improve how records lock and get unlocked so that others can’t use records opened by someone else.
  • Latitude, Longitude and County: You may have already noticed, in Settings under General WRMD Settings, you can choose to see the Lat, Long and County found, if it is a location or address that can be found in Google Maps.
  • Searching in Extensions: We have been working hard on being able to search more of the fields then just the rescuer, initial care and continued care fields. This was mostly pressed by the need to search in Lab. Well unfortunately Lab is being very difficult and will take some time to figure out how to search appropriately, but in the mean time you will be able to search Prescriptions, Necropsy and Banding/Morphometrics.

Searching Extensions

Pending Issues

These are issues that are high up on our list of things to get done.

  1. Searching Lab Values
  2. Batch Updating
  3. Printing Necropsy Reports
  4. Exporting/printing extension fields

WRMD Import

Posted on:

One of the neat extensions that we have created in WRMD is “WRMD Import”. If your facility has digital records from past years, you can import these records into the current system. In order to do this, the information has to meet certain standards. Basically, it has to match what the terms and formatting are, in WRMD.

Since “WRMD Import” is an extension it first has to be activated in order to use it. Screen Shot 2015-08-12 at 3.12.35 PMOnce activated it will show up on the far left under “Extension Settings” as “WRMD Import”. When you click on this it will take you to a page that is full of information. Importing is a relatively easy process itself, but cleaning up the data is tedious, that is the reason for all of the instructional material.

There are certain fields that you can import and certain ones that you can not. To start with, importing just the required information is a really good start for most past year records.

The required fields are as follows:

Case Number: A unique incrementing integer that is assigned to each case.

Case Year: The 4 digit year (ex: 2015) that the animal was admitted to your clinic.

Disposition: The final or current disposition of the animal chosen from the available disposition options.
Pending
Released
Transferred
Dead on arrival
Died +24hr
Died in 24hr
Euthanized +24hr
Euthanized in 24hr
Void

Species: The common species name of the animal, matching a known species in Wildlife Rehabilitation MD. You can find this list here.

Date admitted: The date the animal was admitted to your clinic in YYYY-MM-DD format.

So, ideally what you have is an excel type spread sheet with this information on it. As you see from this list some of these require very specific formatting. This is required, because the database has to recognize the information for what it is. To view a list of the other accepted values, you must be signed in and have the “WRMD Import” activated. Once it is activated you can view that information here.

Hopefully, once you have your data prepared, you then need to move it into a .CSV (comma separated values) delimited file. Once that is accomplished you can follow the basic steps for import.

The WRMD Import Steps:
Prepare Your CSV File
Data Import Policy
Upload Your File
Map the Field Names
Validate Your Data
Process Your Data

Validating your data will be the hardest part. If one thing is off and the database doesn’t recognize something you have to change that info on your file and then start all over again with a new CSV file.

It can be a long tedious process, but if you can spend the time to get all your information correct to begin with, it will make the import process much easier and smoother.