LEI2JSON: Schema-based validation and conversion of livestock event information
Mahir Habib,
Muhammad Ashad Kabir,
Lihong Zheng
Affiliations
Mahir Habib
Correspondence to: Charles Sturt University, Panorama Ave, Bathurst, NSW 2795, Australia.; School of Computing, Mathematics and Engineering, Charles Sturt University, Bathurst, NSW 2795, Australia; Gulbali Institute for Agriculture, Water and Environment, Charles Sturt University, Wagga Wagga, NSW 2678, Australia; Food Agility CRC Ltd, Sydney, NSW 2000, Australia
Muhammad Ashad Kabir
School of Computing, Mathematics and Engineering, Charles Sturt University, Bathurst, NSW 2795, Australia; Gulbali Institute for Agriculture, Water and Environment, Charles Sturt University, Wagga Wagga, NSW 2678, Australia; Food Agility CRC Ltd, Sydney, NSW 2000, Australia
Lihong Zheng
School of Computing, Mathematics and Engineering, Charles Sturt University, Bathurst, NSW 2795, Australia; Gulbali Institute for Agriculture, Water and Environment, Charles Sturt University, Wagga Wagga, NSW 2678, Australia; Food Agility CRC Ltd, Sydney, NSW 2000, Australia
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.
