GN 838 Pathology Import Enhancements QUOTE v1 1 ns approved 20 05 2025
This change request (GN‑838) prepared by Storyboard Multimedia for the GRDC National Variety Trials (NVT) details an enhancement to the Disease Ratings import process. The current workflow requires a separate template per disease, causing inefficiency. The proposed solution adds a new Excel import template that can contain multiple crops, diseases, and trials in a single file, introduces a mandatory Trial Reference Number, allows alphanumeric replication values, and adds a dropdown‑driven Trial Type field. Supporting changes include database updates (CPResultRep RepValue becomes alphanumeric, new PathologyTrialType table maintenance function), GUI redesign of the Pathology dashboard (new tabs for template creation/download and upload, updated wireframes), and a set of business rules governing naming conventions, validation, and duplicate detection. The document outlines business justification, benefits (streamlined data entry, reduced manual effort), risks (user data entry accuracy), impacts on documentation and training, test case and user guide updates, related change requests, a detailed quote (170 hours across development, testing, QA, deployment), and approval status (approved by GRDC on 20 May 2025).
Topics
Multi‑Crop/Disease Import Template – Core Enhancement
Defines the new Excel template that supports multiple crops, diseases, and trials in a single import file, including added Trial Reference Number and Measurement List worksheets.
Business Justification and Expected Benefits
Explains why the current single‑disease template is inefficient and outlines the benefits of the new approach: reduced preparation time, ability to handle decimal/alphabetic replication values, and mandatory trial type selection.
Database Schema Adjustments – CPResultRep & PathologyTrialType
Details the change to CPResultRep where RepValue becomes alphanumeric and introduces a system‑admin function to maintain PathologyTrialType entries, with uniqueness and deletion constraints.
GUI Redesign and Workflow – Dashboard, Template Creation, and Upload
Describes the updated Pathology dashboard layout, new menu items (Template → Create/Download), step‑by‑step screens for selecting crops, cultivars, diseases, and the revised upload confirmation page showing the Trial Reference Number.
Business Rules, Validation Logic, and Naming Conventions
Enumerates mandatory fields, naming conventions for generated files, calculation of mean values only when all Rep values are numeric, duplicate row checks incorporating Trial Reference Number, and constraints on trial type deletion.
Project Planning – Quote, Effort Estimate, and Approval Workflow
Provides a breakdown of estimated effort (170 hours across development, testing, QA, deployment), the quote validity period, warranty terms, and the approval timeline culminating in GRDC sign‑off on 20 May 2025.