LEI2JSON: Schema-based validation and conversion of livestock event information

Livestock producers often need help in standardising (i.e., converting and validating) their livestock event data. This article introduces a novel solution, LEI2JSON (Livestock Event Information To JSON). The tool is an add-on for Google Sheets, adhering to the livestock event information (LEI) sche...

Full description

Saved in:
Bibliographic Details
Published in:SoftwareX 2024-05, Vol.26, p.101629, Article 101629
Main Authors: Habib, Mahir, Kabir, Muhammad Ashad, Zheng, Lihong
Format: Article
Language:English
Subjects:
Apps script
Google sheet
Livestock event
Standardisation
Citations: Items that this one cites
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Livestock producers often need help in standardising (i.e., converting and validating) their livestock event data. This article introduces a novel solution, LEI2JSON (Livestock Event Information To JSON). The tool is an add-on for Google Sheets, adhering to the livestock event information (LEI) schema. The core objective of LEI2JSON is to provide livestock producers with an efficient mechanism to standardise their data, leading to substantial savings in time and resources. This is achieved by building the spreadsheet template with the appropriate column headers, notes, and validation rules, converting the spreadsheet data into JSON format, and validating the output against the schema. LEI2JSON facilitates the seamless storage of livestock event information locally or on Google Drive in JSON. Additionally, we have conducted an extensive experimental evaluation to assess the effectiveness of the tool.
ISSN:2352-7110
2352-7110
DOI:10.1016/j.softx.2023.101629