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.


Extension of the Month: Wildlife Rehabilitation MD Backup

Posted on:

There is often a concern about losing data. We at The Wild Neighbors Database Project agree that loss of data would be a tragedy. We have taken several precautions to eliminate this from happening. We can never be 100% sure of anything when it comes to data. If your data is on paper there could be a fire or if it’s on a server, the server could be damaged. There could be any number of creative ways it could disappear no matter what we do to protect it.

Wildlife Rehabilitation MD Backup is designed to put our users minds at ease.  At anytime you can backup all of your data in your account to your computer, flash drive, dropbox account, etc. If you ever decide to leave WRMD you can take your data with you.

There are 2 ways you can save your data.

Screen Shot 2013-11-20 at 12.32.04 PM

The first way is to download it into a sql file. When you activate the Wildlife Rehabilitation MD Backup extension, a link will show up near the bottom of the left side bar. Click on this link and it will take you to the Wildlife Rehabilitation MD Backup page. Then click on Make New Backup and a new backup will be made. The file will be listed below which shows that it is saved on the WRMD server. If you click on the file name you can download it to where ever you choose. Keep in mind in order to access this data you must have someone who knows how to read this file and translate it for you.

The second way to save your data is to do a normal export of all the data to an excel file. This is much easier to read, but is a massive amount of information for excel to deal with easily.

Rest assured that we backup the database twice a day on two separate servers, just in case anything happens that is out of our control.