Roslin Large Animal FarmDB Web Application
Web application providing an Interface to the Roslin Farm Database tracking the housing, breeding, health and usage of Animal Populations in the Roslin Large Animal Facilities.
Developed By: Bioinformatics Group, The Roslin Institute, Royal (Dick) School of Veterinary Studies, The University of Edinburgh, EH25 9RG
ROSLIN
Current Release:
28.3.0
built: Thu, Mar 21, 2024
Release History
v28.3.0 built: Thu, Mar 21, 2024
New Features
- Minor change to remove synchronization with now defunct MOBFARM app.
- Increased accuracy allowed for recorded weights.
Bug Fixes
- Reverted to pink highlighting of selected rows in jqgrid tables.
v28.2.0 built: Tue, Feb 06, 2024
Bug Fixes
- Fixed bug reporting null values.
- Fixed 'onload' issues with recent javascript update changes.
v28.1.0 built: Fri, Jan 05, 2024
New Features
- Updated jquery and jqgrid javascript libraries and associated css files for Avian and Farm apps.
- Removed superfluous maphilight javascript libraries from Farm app.
- Javascript libraries used in Mobile Farm app are end of life and cannot be updated.
Bug Fixes
- Fixed editing of User's Institution so that it can only be edited if it is from same context as User (BIRDS vs MAMMALS)
- Switched to using standard version of multiselect js (alt version seems broken).
v28.0.0 built: Wed, Aug 09, 2023
New Features
- Updated to Java to JDK 17, Jakarta EE, Tomcat 10.1 and the Spring Framework and Security 6.0.
v27.6.0 built: not known
New Features
- Updated jquery and jqgrid javascript libraries and associated css files for narf/spf and farm apps.
- Removed superfluous maphilight javascript libraries from farmdb.
- Javascript libraries used in mobfarm app are end of life and cannot be updated.
v27.5.0 built: Thu, Mar 23, 2023
New Features
- Artifact dependencies updated to most recent release versions (compatible with java 11/tomcat9/spring5).
v27.2.0 built: Thu, Dec 15, 2022
New Features
- Disabled PRINT options that try to use as yet unconfigured Azure CUPS Service.
Bug Fixes
- Fixed format/size of PPL CODE + TITLE on Pen Cards.
v27.1.1 built: Thu, Sep 15, 2022
Bug Fixes
- Separated out system reset times.
- Close mail attachments in a finally clause.
v27.1.0 built: Fri, Aug 19, 2022
New Features
- Increased potential precision of recorded animal weights (as decimal fractions of a gram).
v27.0.0 built: Thu, Aug 18, 2022
New Features
- Switched to using the Authenticated Mail Relay service - because we are moving hosting to the Azure cloud.
Bug Fixes
- Switch to using 'catalina.base' property to specify locate Tomcat conf and log directories (necessary on Azure).
v26.1.1 built: Tue, Dec 14, 2021
Bug Fixes
- Updated logging to safe version of Log4J (disallowing JNDI injection attacks).
v25.0.1 built: Thu, Jan 07, 2021
New Features
- Reduced exception information displayed to user for unexpected exceptions - improved logging instead.
- Improved removal(hiding) of Users.
Bug Fixes
- Fixed issues when working with Users who are permitted to work with Studies in both the FARM and BIRD data systems.
- Fixed missing js variable declarations on several pages - was breaking some js functionality.
v24.3.0 built: Wed, Sep 23, 2020
New Features
- Allow archiving of unused Breeds, and the reactivation of these.
v24.2.0 built: Wed, Sep 09, 2020
New Features
- Modified layout for Pen Cards showing licence/procedure information, grouped by study.
Bug Fixes
- Use correct 24 hour clock format on Pen cards/Jasper Reports.
v24.0.0 built: Mon, Apr 27, 2020
New Features
- Added ability to record and track weight of animals.
- Added LARIF building and pen layout.
v23.6.0 built: Mon, Mar 16, 2020
New Features
- Added ability to add a comment to multiple animals at the same time.
v23.5.0 built: Wed, Feb 19, 2020
New Features
- Added a nightly email alert of outstanding Off-Licence authorisation requests.
Bug Fixes
- Prevent an error when the system attempts to auto-email disabled users. RT9154
- Fix javascript calls to currentAction property before it is set.
v23.3.1 built: Mon, Sep 16, 2019
New Features
- Added an admin page for maintaining the email lists.
- Modified Training Records to be single species.
- Improved layout and filtering Training Records table.
- Added (admin-restricted) functionality to Correct or Delete bad Training Records.
- Added ability to record and display the (A,B,C...) Categorisation of users' PILs.
- Added new report for Procedures that may have been performed without relevant Training Records in place.
- Modified user information page to allow search for records of Procedure performed by the User.
- Improved handling of special studies that allow 'Off-Licence' authorisation.
Bug Fixes
- Fixed available search/filter types available for some table columns containing page links.
v23.1.1 built: Fri, Jul 26, 2019
New Features
- Separated login permissions to individual facilities (and Doc Review system).
- Added privileged action to reset users.
- Removed some images when print tables, use text in place.
Bug Fixes
- Allow editing of Users with no first name.
- Removed some potential double form submissions.RT9007
- Updated hard coded Institution IDs.RT9008
v23.0.1 built: Fri, Jul 12, 2019
New Features
- Merged all 4 animal/user databases into one 'Universal' database. RT8961
Bug Fixes
- Fixed permission error for saving severity downgrades.
- Fixed bug counting animals taken off licence for annual returns. RT8986
- Fixed bug if error in creating a new study, redirect to bad URL.
v22.0.1 built: Thu, Apr 25, 2019
New Features
- Added Global Procedures, as an editable hierarchy.
- Introduced Training Records for storing PIL competencies.
- Built infrastructure for recording PIL Training Records, and alerting expiry etc.
- Created new Database Permissions (PILADMIN & PILEDIT) for curating Global Procedures and Training Records.
- Added new page to list User Details (including Training Records).
- Modified user's home page to list PIL competencies expiring or certified within a calendar month (added webbapp history summary to Quick Menu).
- Changed the default search action to 'beginsWith' or 'before/after' instead of 'equals' for many table fields.
- Kept code base in sync with AvianDB-specific features (orders and genotypes).
- Added facility to correct/downrate Experienced Severity scores (permission controlled).
- Added ability to search on Experienced Severity scores and whether they have been downrated.
Bug Fixes
- Removed all instances of multi-column sorting of (jqgrid) tables, as this is buggy.
- Fixed occasional failure of email addresses containing apostrophes.
- Filter out Broken Pipe exceptions from Tomcat log files.
- Changed to use Bulk Mail Relay to solve grey list problems. rt 8857,8859.
v19.0.0 built: Wed, Oct 31, 2018
New Features
- Added wait messages & spinners across the application when uploading data or downloading files & printing.
- Added new Animal Fate: FOUND DEAD (OVERLAIN) (Notifications not sent to animal.services/NVS). RT8704
- Improved design of (jquery) results tables to replicate the footer functionality in the header.
- Changes to Database Schema to allow merging of avian databases. RT8621, 8637
Bug Fixes
- Major clean up of JSP/HTML using IntelliJ inspection .
v17.1.0 built: Mon, Jul 02, 2018
New Features
- Added New Animal Fates; Cull be PEL, and Cull by Practice Vet. RT8541
v17.0.0 built: Mon, Jun 25, 2018
New Features
- Added Home Office contacts page.
- Code Base: Improved unit testing of Service and Controller layers.
- Architecture: Migrated to Spring Framework version 5.
- Architecture: Migrated development platform to IntelliJ.
- Improved Error Logging.
Bug Fixes
- Fixed Bug blocking editing of any Study details lacking a Charge Code. c20df57
v16.1.0 built: Thu, May 03, 2018
New Features
- Recording a 'Terminal Procedure' now automatically records the animals as 'Culled'. RT8466
- Code Base: Improved unit testing of Model and Data Access layers.
Bug Fixes
- Fixed error on edit-animal page due to missing (but never used) 'Possible Mothers' field.
v16.0.1 built: Mon, Apr 23, 2018
New Features
- Added ability track changes and display history of Study Charge Codes. RT8386
- Various schema and code changes to keep in sync with bird datasystem updates (release57).
v15.4.1 built: Mon, Mar 12, 2018
New Features
- Added ability to search for animals with particular mother, father or group of possible fathers. RT8378
- Split Institution Model into separate Institutions and Suppliers. RT8381
- Added Admin ability create and edit Institutions and Suppliers. RT8381
Bug Fixes
- When editing historical records where a person may no longer be 'current', add them to the list of current users to prevent them being lost from the record. RT8388
- Name not email used on Report of expiring licenses. RT8390
- Clone the current Person Sets that I want to be mutable rather than use the actual list from commonService. RT8390
v15.4.0 built: Fri, Mar 09, 2018
New Features
- Added ability to define a group of animals as potential father of an animal (or group of animals). RT8378
- Added ability to search for animals with particular mother, father or group of possible fathers. RT8378
- Split Institution Model into separate Institutions and Suppliers. RT8381
- Added Admin ability create and edit Institutions and Suppliers. RT8381
Bug Fixes
- When editing historical records where a person may no longer be 'current', add them to the list of current users to prevent them being lost from the record. RT8388
v15.3.0 built: Mon, Mar 05, 2018
New Features
- Added system to add and display alerts on home page. RT8368
- Remove block for privileged users to modify genetic status of multiple animals at a time.
- Display users PIL number alongside name in drop down menus (requested by JAGE).
- Added a new Report of animals approved for reuse in the last 5 years.
- Added widget for Admin users to edit permissions of other users.
- Added email alerts for animals approved for reuse 12 and 24 months ago.
Bug Fixes
- Fixed bug with procedure recording: the record creator wasn't being noted
- Fixed bug displaying multiple users sharing exact same name.
v15.1.2 built: Fri, Jan 05, 2018
New Features
- Added a count of outstanding cull requests to home page (Office and Shed apps). RT8239.
- Refined options for Cull list exploration on quick menu. RT8239.
- Added new canned search for any removed animals lacking GM/Phenotype score.
Bug Fixes
- Excluded non dead removed animals from PEL table 1 query.
- Restricted PEL table 2 query to July-December 2017.
v15.0.1 built: Mon, Nov 27, 2017
New Features
- A major refactoring of the Data Model to allow the avian system to represent incubating Embryos in Eggs, and to allow procedures to be recorded against these. No new features introduced to the Farm system, but the new model allows capability to track embryo age and procedures if required.
- Add-Animal interface modified to require the date of database entry. Typically this defaults to NOW, but can be set earlier if it is necessary to record historical procedures.
Bug Fixes
- Specify the BOM (Byte order Mask) for UTF-8 so that Excel Exports have the encoding identified and therefore open in the correct format.
- Restrict the deficient data queries to 'reportable' animals only
- Fixed Monday deficiency email-report to skip Studies with no deficiencies.
- Minor bug fix on a query for mammals without eartags.
v15.0.0 built: Mon, Nov 20, 2017
New Features
- A major refactoring of the Data Model to allow the avian system to represent incubating Embryos in Eggs, and to allow procedures to be recorded against these. No new features introduced to the Farm system, but the new model allows capability to track embryo age and procedures if required.
- Add-Animal interface modified to require the date of database entry. Typically this defaults to NOW, but can be set earlier if it is necessary to record historical procedures.
Bug Fixes
- Specify the BOM (Byte order Mask) for UTF-8 so that Excel Exports have the encoding identified and therefore open in the correct format.
- Restrict the deficient data queries to 'reportable' animals only
- Fixed Monday deficiency email-report to skip Studies with no deficiencies.
v14.0.4 built: Tue, Oct 10, 2017
New Features
- Major updates to software architecture and dependencies (and removed redundant features and links). RT8079
- Added automatic email alerts for removed birds with deficient severity/GM scores. RT8090.3
- Added automatic email alerts for licences approaching expiry. RT8090.5
- Added (collapsible) histories of procedures performed to animal cull page. RT8114
- Applied various modifications to enforce READ_ONLY and PRIVILEGED permission level roles for Study Members, Study Owners and Licence Holders. RT8090.4
- Activating log-in for study members and licencees. RT8090.4
Bug Fixes
- Fixed wrong warning that a pre-severity-scored animal needs scoring after culling. RT8090.2
- Enforce single owner for a Study.
- Major refactoring of email architecture.
- Synchronized Mailer sendEmail method with 2.5 second delay - so don't exceed Server limit of 30 mail/minute.
- Added missing list of Vets to UpdateHealthIssue page.
- Turned off a Mybatis query Logger.
- Fixed study permission bug when working without a preferred Species.
- Fixed bug with email alert for expiring studies, if no owner of a study. RT8157
- Fixed loss of READ ONLY restriction when reload jquery tables from json. RT8157
v13.1.1 built: Thu, Aug 17, 2017
New Features
- Add reporting of procedures and culls performed by users. RT8048
Bug Fixes
- Fixed bug where on moving protocol, the line and owner of an animal was lost. RT8059
v13.0.0 built: Fri, Aug 04, 2017
New Features
- Add reporting features for generating Annual HO Return data.
- Add reporting features for Special PEL 2017 HO Return.
- Add various report queries to interrogate annual return data for deficiencies and inconsistencies.
Bug Fixes
- Defensively deal with any invalid Study History records encountered.
- Fixed minor bugs with Excel Cull Reports output.
v12.1.0 built: Mon, Jul 31, 2017
New Features
- Improved 'TAKE OFF LICENCE' function. Unless study is marked to allow re-use, vet authorisation is required for this.
- Added tracking of animal reuse; necessary for annual returns.
- Enforce Severity scoring prior to taking Off Licence for reuse: prevent GM/GA animals being taken off.
v12.0.0 built: Mon, Jul 17, 2017
New Features
- Added ability to record Health Updates on multiple animals. RT7964
- Added new permission ADMIN to control editing users, with ability to remove, disable and create users. RT7980
- Added various Cull and Health alert Reports (developed for avian database originally). RT7847
- Block ability to rollback licensing records for GA or procedured birds.
v11.5.1 built: Tue, Jun 27, 2017
New Features
- Added new Animal Husbandry techniques to record ear-notching (and whether sample retained for genotyping).
Bug Fixes
- Removed error thrown if husbandry details are null.
v11.5.0 built: Mon, Jun 12, 2017
New Features
- Added new cull/removal page to capture details of Severity/GA status for each animal. RT7866
- Altered way that animals can be moved off licence to capture the authorising Vet and details of Severity/GA status for each animal. RT7867
- Added page and actions to allow Vets to view, confirm and deny authorisations of taking off licence. RT 7672
v11.3.0 built: Wed, Apr 19, 2017
New Features
- Removed all traces of Vaccination/Vaccine Protocol functionality.
- Added new feature: record, edit, display Animal Husbandry procedures. RT 7672
v11.2.0 built: Fri, Feb 24, 2017
New Features
- Introduced some new Report generators.
- Added tracking of whether procedures are performed for genotyping.
- Added tracking of whether studies are for the creation or maintenance of GM lines.
- Added alert and guidance when licensed animals are culled that lack SEVERITY or GM Status scores.
- Added canned query to reports page to find reportable animals not yet severity/gm scored.
- Added canned query to reports page to find GM animals not on licence.
- Added these two queries to the weekly ambiguity email and archive table.
- Improved ability to edit records of procedures performed.
v11.1.1 built: Thu, Dec 01, 2016
New Features
- Allow creation, admin and log in by Non-EASE users. (Branch: DEV user login improvements).
- Added hint & automatic research against ALL animals if LIVE/CURRENT search fails.
- Improved Procedure Recording: check correct Study/Protocol/Alive at time of recorded Procedure .
- Improved Procedure Recording: Added optional Cost field (STD, HI, LOW) .
- Improved Procedure Recording: Capture Study at time of Procedure for accurate costing etc.
- Improved Procedure Recording: Added safe method for recording historical Procedure records against the correct Study at that time.
- Improved Security to control read and edit access to Mobil App.
- Added three alternative weekly snapshot Excel reports of animal head counts. (Branch: report features).
- Added monthly 'Orygen' B&B and Procedures Excel report. (Branch: report features).
- Added monthly 'All Projects' B&B and Procedures Excel report. (Branch: report features).
- Added ad hoc Excel report of Procedures performed. (Branch: report features).
- Added ad hoc Excel report of B&Bs. (Branch: report features).
Bug Fixes
- Fixed liveAnimal sql query (used birthday instead of hatched). 0b6b72b
- Add method to cancel any remaining requests when an animal is removed. RT 7561
- Repaired addition of procedures to a protocol. 14c03db
v11.0.4 built: Fri, Nov 04, 2016
New Features
- Added ability to search (and report) on operator responsible for Cullings RT7519
- Added a comment field to Culling of a Sick Animal report so that will be included in email alert. RT 7493
- Improved 'Report Problem' function so that more complete information is captured and included in the email to System Admin. RT7483
- Multiple changes to underlying code-base to deal with Lines/Families and changes to Egg handling: only relevant to Bird system not Farm Animals.
Bug Fixes
- Fixed minor bug when switching Species on personal home page. GIT e8f185
- Fixed bug in printing Cull Lists. GIT b70960
- Converting bare Integer parameters from ModelAtributes to RequestParameters to make Null-safe. RT7513
- Fixed fatal error on page listing all Cull Lists. GIT d79459
- Fixed error in several pages causing 'Report Problem' Form failure. GIT afa677, cb3cc0, 7eb838
- Added checks on Dev/Sandbox deployment to prevent email alerts of Study Watchers. GIT 1428ba
- Fixed date typo issue in Excel Report of Removals. GIT a66541
- Typo in SQL of search for cull details of mammals fixed. GIT 80e223
- Typo in SQL for get Location by ID. GIT 869142
- Fixed major bug - failing to add licensed study cos referring to a null licence. GIT 4184eb6
v10.1.1680 built: Mon, Sep 26, 2016
New Features
- Show outstanding Sample requests on the 'Animal Details' page: and allow fulfilment from there. RT7401, 7403
- Allow cancellation of outstanding Blood Requests when perform a licensed Procedure containing the word 'blood'/'bleed'. RT7406
- Provide new View of Outstanding Requests sorted by Location, and also now supports searching by Location. RT7406
- Introduced the Health Issue reporting/update and alert system. RT7320 RT7426
- Modified Culling to record any Health Symptoms if Sick. RT7320 RT7415
- Modified Animal Search Page to display simple or detailed search routes. RT7416 7480
- Added ability to filter searches by 'Farm' for current animals. RT7481
- Simplified Home Page view. RT7482
Bug Fixes
- Made id searching case insensitive across the board. SVN1580
- Removed option to place animals on new Protocol when change Study. This was causing date mismatch issues in the Avian Database. RT7405
- Fixed no display of 'hidden'/historical users. RT7485
v9.5BF.1570 built: Tue, Jul 12, 2016
New Features
- Removed all of the Mobile App / Touch Screen functionality from the application. RT 7366.
- Added end/expiry date to Studies - so that we can sort and filter on current studies etc. RT 7347.
- Sort Studies and Project Licences according to their current status. RT 7357.
- Improved Sample Search page to allow specification of the current Study or the study at time of sampling. RT 7360.
- Extra icons/text informing the user of Current Species added to the Create Animal(s) page. RT 7362.
- Added OMNI box to search any ID field on the Search Animals page. RT 7363.
Bug Fixes
- Animal Editor Page was wrongly demanding a Name or Line be set... this was a hangover from the Bird System. SVN1557.
- Fixed error thrown when only one animal is returned by a search for animals on a specified study. SVN1525
- Fixed bug in saving Animal parentage when create a Animal. RT7382
- When log in current species was defaulting to CHICK! RT7382
v9.4.1522 built: Thu, Jun 23, 2016
New Features
- Improved Page for creating multiple animals - now spawns a form for entry of different identifiers for each animal. RT 7318.
- Improved search for animals to use the primary ID fields : eartag and passport; and also allow user to return/enter on these fields. RT 7317.
- Added configurable email alerts for sudden loss of animals. RT 7339.
- Improved data capture for tracking moves between Studies and Protocols (captures personal authorisation for HO reporting purposes, particularly when move off licence). RT 7296.
- Added special studies to hold animals moved off licence but kept alive at establishment. RT 7321.
- Minor changes to Study definitions to be species-specific, and to allow working in a non-specified species context. RT 7331.
Bug Fixes
- FIX BUG WITH getStudy queries - where no STUDY_OWNER recorded, but does record other members - the query returned null. SVN1514
- FIX BUG WITH retrieving permitted Study lists for non-privileged users. SVN1515
v9.3.1499 built: Thu, Jun 09, 2016
New Features
- Repaired the Mobile App functionality for demonstration purposes. RT 7297.
- Changed naming of 'lines' to 'breeds'. RT 7292
- Improved data capture for tracking moves between Studies and Protocols (captures personal authorisation for HO reporting purposes, particularly when move off licence). RT 7297.
- Updated the 'Fates' available to match the HO terms used in the Avian system, PLUS 'ABATTOIR' and 'SOLD'. RT 7297.
- Updated the Schedule1 Culling Methods available for FarmDB. RT 7310.
Bug Fixes
- Fixed inability to enter dates prior to 2010. RT7291
- Fixed broken widgets for selecting Location/Enclosure on Quick Menu pages. RT7294
- Fixed failure to display comments in animals table. SVN 1498
v9.2.1476 built: Fri, May 27, 2016
New Features
- First Production Release of the Roslin FarmDB Webapp. Note that the release version (9.2) is that of the underlying code shared with AvianDB.
Bug Fixes
- BUGGY FIRST RELEASE: MOBILE APP IS CURRENTLY BROKEN....
|