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

Read220b Premvet 5 (Version 2.20.00) - May 2004 -> July 2004


Access Permissions

The following access permissions have been added or changed.

139 Can the user access the 'V'iew and 'D'elete options on the sheets screen.  
140 Custom Sheet Setup See later section
141 Custom Sheet View for details of these
142 Custom Sheet Edit options.


DataMajor

The 'Run a Script' option on the Stored Reports menu as been expanded.

Enter a ? to allow you to search for 'text' in any of the scripts on file - the 'text' can appear in any index or in any comment included in the script. The line displayed will be the line with the text in it - this may not be the 1st line (description) of the script.

The 'Search' option is only available to those users that can access the 'Finance' section (access 48 or 105)

On the Utility menu there is an option to printout all the scripts on file. These can be printed sorted by script name, Category, Date changed or by description. The detailed report will list the script comments to allow you to see what it does.

If you develop your own script, when asking 'Time' questions, if you include 'HH:MM' in the question then the prompt will drop to 5 characters and pad the answer to resemble a time. e.g.

     OR transactiontime < "!!Before when e.g. 08:00 (HH:MM) !!" 

There are two new option to the re-build script 'wdb'
-o incnoclin includes records with no clinical work
-o noopt Skips the optimisation phase of the re-build

The shop card is no longer ignored.

New Transaction: The algorithm to determine if the line is a 'new' transaction has been altered to take different users doing work on the same day into account. It will now treat switching users as the start of a new transaction.


Write Screen

New option 'Look' on sheets - will call a viewer (less) e.g. no edit options. This will be available on all 'text/' Mime types automatically. It can be added to other options by adding '; lookat' to the appropriate entry in filecap.

The 'viewer' will default to less - if you add a mime type text/view then this will be used in it's place.


Diary

Standard Block Bookings will be applied when diaries are expanded or re-used - this allows for dates well into the future to be added to all diaries e.g. Bank Holidays etc.

The 'Reminder' option has been re-instated. The additional reserved words you can use are:

&DDATE Appointment Date
&DTIME Time slot the appointment is for
&DWHO Contents of the User ID field
&REASON Reason client is attending

Canceling Appointments - You can by switching 'Log_Diary_Cancel = Ask|Yes' in params.txt get the user to enter the reason why the client canceling. However as this is free hand text it can give you a wide range of reasons. A new option has been added that presets the choices presented to the user. This allows you to have a limited range and reports and statistics can be a little more helpful.

Set Diary_Cancel_Reason = reason 1 | reason 2 | reason 3 | reason 4

As the reasons may go over one line you can use the 'continuation character' (\) at the end of the line e.g.

   Diary_Cancel_Reason = reason 1 | \
         reason 2 | reason 3 | \
         reason 4 | etc | etc 


Stock (Dunlops On-Line Services)

The Batch Pickup option will NOT now by default ask if Quantity and Price should be updated - if you do need/want this option add Dunlops_Qu_Update = Yes to params.txt.

The login used has been changed from 'barcode' to 'barcode2' to enable non-batch traceable items to be picked up.


Kennel Booking

Two new params.txt options:

KB_Add_Clinical = No Will suppress adding a clinical record
KB_Ask_Per_Day = Yes Will ask an amount per day (Default NOT to)


Stock (Ordering)


EnServe

  • The on-line help has been updated with a User section.

  • A script 'update_uvscan' has been added to /usr/utilities to allow you to automate the pickup of Virus definition files. You can add this to root's cron to run how often you want.


    Invoices and Hidden Text

    You have (and still do) the ability to suppress clinical lines from appearing on the invoices by starting the line with an !. This is very cumbersome, looks ugly and does not work with the large text boxes. You can now:

    Add a params.txt entry Hidden_Text = ana_code and if the 1st character of the 1st line is an ! then all text lines will be allocated to the 'ana_code' specified. The Invoice program will ignore all of those lines (assuming they are un-priced).


    Custom Sheet

    There may be occasions where there is animal information you want to record but there is no room on the screen. This update includes a 'custom' screen. You can set the custom screen to have additional fields.

    It is accessed via Management -> Additional -> Custom (or the shortcut key 7).

  • Users will need access to password option 141 to be able to view the screen. There are two options 'Edit' - allows users to change details on the screen (need access option 142) and 'SQL' - the SQL option is explained later on.

    Before the screen can be used you do need to set it up. The setup option located (need access to option 140):

    System Management -> Setup -> Parameters -> Fields & Defaults -> Custom

    You will be taken into a text editor box, you type in the field name followed by <space for answer>, you keep adding fields and answers as required.

    NOTE:

    Add the Fields and Answers across the screen not down the left hand side leaving space later on on the right. If you do leave space on the right you will have problems later on.

    Do NOT add duplicate field names e.g. Other < > Other < > the field names must be unique.

    For example, you want to add three new questions; Primary Contact, Staff member and Height of Animal. Select the Custom setup option and enter the details:

            Primary Contact <                        >  Staff <    >
            Height <     >
    

    Then press <ESC>. This has added the basic information, the question to ask and space for the answer. To help with entering the correct information you will be asked to assign what type of data you want the user to enter. Currently this can be:

    T Text Anything
    D Date Only a valid date
    Y Yes/No Either Yes or No
    N Number A Number

    Once this has been entered you will be returned to the prompt line.

    The Custom Sheet setup criteria will automatically be cross updated.

    Information on the Custom screen will be cross-updated.

    The fields will be added to the Animal DataMajor table for reporting purposes (the files will have CS added as a prefix and any spaces will be translated to under scores).

    To come back to the earlier note - add new fields across the screen; at a later date you may want to add new question - do NOT fill in gaps e.g. This is a No No

            Existing <          >     Existing <    >    NEW <       >
            Existing <      >
    

    The New option will cause existing data to be displayed in the wrong place. This is correct:

            Existing <          >     Existing <    >  
            Existing <      >         NEW <        >
    

    It is also not a good idea to alter the size if existing answers.

    SQL

    The SQL option is to allow you to access animal specific data from other sources e.g. DataMajor. It may be you want to pull out a list of all batch numbers issued over the last 6 months. While the clinical report option will handle 99% of the common queries, this SQL option can supplement it for obscure queries.

    Queries are created in an identical manner to those within DataMajor, however with this option they are stored in the text folder. A top level 'index' will be displayed (custom.idx again in the text folder) in a similar manner to definition files and DM queries. To allow for animal queries, the script is passed through the basic definition file processing system so you can use any of the standard reserved words. e.g. to look at all drugs issued the script may be:

          use premvet;
          select * from clinical where pvid = &ref  and analysiscode = 254 ;
    

    You will note:

    Generally the results will be displayed at the bottom of the screen and you can move down as required, you cannot scroll sideways with the default settings, so for simple queries make sure the required information is displayed in the 1st 79 characters of the query.

    Tip: Rather than end the query with a semi-colon use a \G, this will cause the results to be displayed down the screen rather than across it.

    If you do need more screen space and the ability to scroll up/down and side by side add '-- Use Less' somewhere in your script. e.g. the earlier script if you wanted to use less then this would do it:

          -- Use Less
          use premvet;
          select * from clinical where pvid = &ref  and analysiscode = 254 ;
    

    The -- indicate a comment, it will be ignored by everything, however, after processing the system will check for it, if found it will pass the results to a viewer that allows scrolling. If the Less option is used the screen will clear and client details will not be re-displayed until you return to the management card.


    Password Maintenance

    A new option 'Switch Option' has been added to the password setup screen. This will go through all users and set an option to Yes or No. You can set all users or a specific group of users. For example, the new custom screen (see above) - rather than go through each user individually, select this option, enter 'A'll, option 141 (Custom View) and set it to 'Yes' - all users will now have access to it.


    Itemised/Pos Bills/Receipt

    There may be times when generating a Itemised bill (inc POS) where you want the system to use the figures from when the last time the account was zero.

    The default behavior for the bills are to list the work entered from the date you enter at the prompt (usually today). If you enter a 'Z' it will back track to when the account was last cleared and print from there.

    If you find you are using the 'Z' option the majority of time you can set Itemised_Zero_Balance = yes in params.txt, this will alter the default so 'Z' is always used unless a date is entered.

    With receipts, as you are not asked the start date by default, there will be no change. If you have 'Itemised_Zero_Balance = Yes', then the start date prompt will appear and you have the same options for either showing current work or from last time account was zero.


    Directions to Client

    A new option on the 'W'rite screen 'Map - Client Location' will display a map of where the client is located. This will use the postcode so it has to be filled in; also this uses www.multimap.com so you do need a web connection and a graphical browser (a pc).


    Misc


    Back to Release Note Index