AgGateway ADAPT Schema Mapping Excel Template v3.1

The ADAPT Schema Mapping Excel Template v3.1 serves as a practical bridge between heterogeneous agricultural data sources—such as ISO 11783 (ISOBUS) task files, John Deere Operations Center exports, or Climate FieldView CSVs—and the vendor-neutral ADAPT XML schema. Each worksheet in the Excel file corresponds to an ADAPT schema module (e.g., 'Farm', 'Field', 'Operation', 'Harvest') and contains columns for source system field names, data types, units, cardinality, ADAPT element paths (XPath-like), business rules, and traceable notes. The template enforces semantic alignment using controlled vocabularies from the AgGateway ADAPT Controlled Vocabulary (CV) and mandates conformance with ADAPT v3.1’s namespace-aware structure and versioned element definitions. It is used collaboratively in AgGateway’s Data Interoperability Committee working groups to produce certified mappings, enabling plug-and-play integration of farm management information systems (FMIS), telematics gateways, and analytics engines. Validation is supported via embedded data validation rules (e.g., required vs. optional fields, enumerated value checks) and companion XSLT-based or Python-based schema validators distributed through AgGateway’s GitHub repositories.