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)
- PDSA - When the PO is generated when the 'Sub-Total' lines
are printed it will update Purchase Ledger there and then -
this should handle the breakdown by Expense code.
- Scanning the Tote sheet.
It will 'update' the order file, if all goods have been received
the order will be removed.
- Goods on the PO but not delivered will be printed out
Goods short shipped - order file will be updated (but not killed)
Goods NOT on the PO but on tote will be flagged.
- The order file will be updated with all changes and an option
to delete it has been added to 'Process an order' option.
EnServe
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:
- The reserved word &ref is used, this will be replaced with the animal number (pvid) and
- the script has specifically selected the premvet database. You must select the database to use.
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
- When using the large text box if you enter || it will force the
line to be split at that point (the ||'s will NOT be displayed).
- Estimate printed lines (analysis code 228) will no longer be
printed on type D/C invoices. If you wish to revert to the
old behavior add
Inv_Inc_228
= Yes to params.txt - Idexx LaserCyte and Idexx 'New' format results from the 8008 are
now supported - it is automatic no setup changes required.
- Operation List - when displaying ops - if the operation date is today the
date will be highlite.
- Stock History - When printed from stock cards you will be asked
start/end dates.
- Protocols - When using the [include filename] option, you can stop
lines being formatted by prefixing them with a quote ('). Saved
scripts will have to .txt extension added automatically.
- Lab E-Mail: Results from Finn Pathologists will be passed through
a formatter (par) to ensure their long lines print out correctly
on laser printers. You can apply this formatter to other lab's by
adding
Lab_Pipe=parto/etc/default/premvet(option on admin menu). - The locking routines have been tightened up when starting/exiting
Premvet - the system will no longer remove what may be valid locks.
You _may_ see either of these:
Unable to remove lock file
Lock file present - unable to create device entryThen it is not currently possible to access the system. Leave it a couple of minutes and re-try - if you are sure there is not a valid reason there is an option on the Admin Menu to allow you to remove the lock file(s).
- Graphs: The Average figure for the current year is worked out
correctly for the number of months to date rather than 12.
Back to Release Note Index