Skip to main content.
Index | Support | Documentation | FAQ

I want to send Breeds/Species to my other site

Premvet has a list of common Breeds, Species, Colours etc. that are used when adding new animals. You may want to 'tidy' these up and then transfer these to the remote site(s) without manually changing them on the remote machines.

This is a two step guide, the 1st will show you an easy way to tidy up the data held in your lookup tables, then how to send it over to the remote machines.

Tidy up the breed list

If it is a minor set of changes then you are easier using the menu system, this is explained in the FAQ Manually changing the lookup tables. On the other hand if you have a few changes to make then this procedure can be used.

There is a Stand Alone utility that will export the required information to a CSV file. This CSV (Comma Separated Values) file can be loaded into Excel (or manually edited with a text editor) changed as you see fit and then imported back in.

Ok so how do we do this:

  1. Look in the list at the bottom of this guide for the item you want to change and make a note of the name.

  2. Shell out of the vet system with F6 to get to the Vet> prompt.

  3. Enter vet -p export NAME Where NAME is the option you want to export. e.g. for Canine breeds this would be vet -p export cabreed

  4. Type exit (or press Ctrl D) to return to the vet system.

  5. Use the option
    Reports -> Windows Export Files -> Scan {New Style Menu}
    Text Utilities -> Windows Documents -> Scan {Classic Menus}

  6. You should see the required csv file at the top of the list, in our example of Canine Breeds it is xcabreed.csv

  7. Select it followed by Look and Excel should start up (assuming you are on a Windows PC) with the file loaded. You can edit/delete as required. You MUST save the changes back out as a CSV file.

  8. If you don't want to use Excel (or are not on a PC) then use the following:
    • Exit to vet> prompt
    • Type ste text/NAME where NAME is the full filename e.g. xcabreed.csv
    • Make your changes, save the file (with ste this is F2 or Ctrl Y)

  9. These changes need to be added back into Premvet. Jump back to the Operating System with F6.

  10. Enter vet -p import NAME, where NAME is either the option name used earlier or the name of the CSV file.

  11. Type exit (or press Ctrl D) to return to the vet system.

  12. Check the changes have been made.

Sending them to the remote site

Now you have tidied up the Breed list you may want to send it over to your remote sites (if Cross Updating is installed). The procedure for this is as follows:

The CSV file will be sent, the next time the remote machine(s) check for work the data will be imported automatically e.g. you don't need to do anything at the remote sites.

* Note: Earlier versions of xmenu do not have the CSV option, if this is the case for you, then select 9 (None of the above), and then enter the FULL location of the file e.g. text/xcabreed.csv.

Export Options

Name Filename What
ALL   everything
STATUS xstatus.csv Status Codes
RECALLS xrecalls.csv Recalls in use
SPECIES xspecies.csv Species
CABREED xcabreed.csv Canine Breeds
FEBREED xfebreed.csv Feline Breeds
AVBREED xavbreed.csv Avian Breeds
OTBREED xotbreed.csv Other Breeds
EQBREED xeqbreed.csv Equine Breeds
CACOLOUR xcacol.csv Canine Colours
FECOLOUR xfecol.csv Feline Colours
OTCOLOUR xotcol.csv Other Colours
EQCOLOUR xeqcol.csv Equine Colours
SEX xsex.csv Sex Codes
ANALYSIS xana.csv Analysis Codes
STOCKPC xstkpc.csv Stock Product Codes
STOCKSC xstksc.csv Stock Supplier Codes
STOCKSL xstksl.csv Supplier Telephone and modem number
along with Purchase ledger ref and type.
STOCKMC xstkmc.csv Stock Manufacturer Codes
STOCKWA xstkwarn.csv Stock Warnings
STOCKDO xstkdose.csv Stock Dosages
LABEL xlabel.csv Label Abreviations
INSURED xins.csv Insured Options
ADDRESS xaddress.csv Address Lines
REFERRED xrefer.csv Referred by Options
USERS xusers.csv Premvet Users
PURCHASE xpl.csv Purchase ledger suppliers