System business rule specification batch specimen import - ESG-Project/documentation GitHub Wiki
← Home / Requirements / Business Rules
This business rule specifies the functionality for importing specimen data in batch from spreadsheet files, including template provision and comprehensive validation.
Rule Details
| Field | Content |
|---|---|
| Identification | BR10 |
| Business Rule | Batch Specimen Import |
| Description | Enables import of specimen data from Excel/CSV, providing templates and performing detailed data validation with error reporting. |
| Source | System Requirements |
| Priority | High |
| Status | Active |
Implementation Details
- Supports import of files in .xlsx (Excel) and .csv formats.
- The system provides a downloadable standard template with all required columns and their expected order to guide users.
- Validation checks include:
- File structure (correct columns and order).
- Data types (e.g., numeric for height, text for species name).
- Data ranges (e.g., height > 0).
- Presence of mandatory fields.
- In case of errors during validation, the system provides detailed feedback, such as "Error on line 5: Species missing."
- Users have the option to import only valid data and review/correct invalid entries, preventing partial data loss during import.
Related Components
- Batch Import Module
- File Uploader
- Data Parser and Validator
- Error Reporting Interface
History
| Version | Date | Author | Changes |
|---|---|---|---|
| 1.0 | 2025-07-29 | System | Initial version |
Notes
- Significantly speeds up data entry for large projects.
- Robust error handling helps maintain data quality despite batch processing.