Updating with DataMajor

You can use DataMajor to update Premvet.

You may have used the Tidy-Up options and noticed miss-spellings on some breeds, you may have both Rabbits and Lagomorphs listed as species. This option allows you to make changes back into Premvet to correct the data. Any changes made this way will:

What Can I Update?

• Equine and Small Animal Breed
• Small Animal Species
• Equine and Small Animal Sex
• Admin Lock e.g. lock all card mark 'Bad Debt'
• Surgery Number on management card

How?

There are some sample scripts in Stored Reports on the 'Update' Sub-Menu, if those do not handle it then just write your own using one of the examples. As this does Update both Premvet and DataMajor it is protected via an Access Permission - Only staff with access to '130' will be allowed into this sub-menu.

Once the script has run, you will get the question.

Do you still want to update the records? Yes No

The script is created as per any of the standard scripts on the system, as you are only dealing with the Animal Table they are usually a lot simpler.

To enable the update option you need to:

• Add to the script one off:
  • SET UPDATE SPECIES
  • SET UPDATE BREED
  • SET UPDATE SEX
  • SET UPDATE LOCK
  • SET UPDATE BRANCH

  Depending on what you want the script to do, (you cannot apply multiple updates in the one script).

• The 1st Field output must be the Animal Number (pvid) and the Last field is what you want to set it to. Everything in the middle is ignored.

Lets look at one of the sample scripts, this will look for any rodents in the breed field and update the Species to 'Rodent'.
The important lines are in Bold.

## Scan all the Breeds for any Rodents and update Species
##
## WARNING THIS OPTION WILL UPDATE THE DATABASE
# SET UPDATE SPECIES

SELECT  
  pvid as "Record",
  species as "Existing", breed as "Breed",
  "Rodent" as "Change To"
FROM animal
WHERE breed in ("Rat","Ferret","Hamster","Mouse","Gerbil","Guinea Pig")
AND species not in ("Canine","Feline","Rodent") ;

• The SET UPDATE SPECIES tells the system this is an update script and that it is updating the Species field.

• The pvid is the Animal Number and it is the 1st field.

• "Rodent" is the last field and that is what the Species will be set to.

If these basics are followed it will work.

There are a couple of things to keep in mind.

• Narrow down the search as much as possible, for example, you may decide to change all 'DSH' to 'Domestic Short Hair' but remember if the 'Contains' option is used (the supplied scripts do) it will also find Staffordshire Bull, in this case add a 'AND species = "Feline"' clause. Another example, how about changing all breeds with Pig to 'Rodent' as you may think this will just find Guinea Pig but it will also find Pigeon.

• Use the Management Reports to look at the selection first.

• Check the report is working BEFORE answering 'Y'es to update as it is NOT reversible on the whole.

• Searches will be case insensitive, e.g. PiGeOn, pigEON, Pigeon are all the same as far as the search goes.

• Use the scripts in combination, change all 'Guinea Pig' to the species 'XXXXX', check all the XXXXX's are correct then change the Species XXXXX to 'Rodent'.

• Don't try to do too much at one time, take it step by step.

The current supplied reports are:

uproad

Look for exact matches of "Rat", "Ferret", "Hamster", "Mouse", "Gerbil" or "Guinea Pig" in the breed field and if the Species in NOT one of "Canine", "Feline" or "Rodent" then change the Species to Rodent.

upspec

You will be asked the Species you want the field set to if the Breed CONTAINS something e.g. Look for 'Rabbit' in the Breed and set the Species to 'Lagomorph'.

upspec1

Change Species, look for records currently containing one thing and change to to something else. e.g. Rabbit to Lagomorph

upbreed

Change the breed, e.g. miss-spellings, you will be asked the Breed to set the record to, the existing breed (contains) and an optional question regarding the Species e.g. all GSD to German Shepherd Dog

Power Users

The upsec, upspec1 and upbreed scripts will use Regular Expressions for the match as will any future scripts if the contain 'Regex' on the information screen - all this means is some characters have a special meaning. These are:

Examples

^Pig	This will match text starting with pig e.g. not Guinea Pig
^Pig$	This will match exactly pig
dsh$	This will entries ending with dsh, will not match with Staffordshire.
Budgie|Goose	This will match if it contains either Budgie or Goose

You will have problems when you try to match some punctuation characters e.g. ?, there are ways around this, that is use [[:punct:]] but as you can see it is a little cryptic. We will not be documenting any of the advanced Regular Expressions here, if you need help contact support. [Back to Data Major Manual]