When importing Excel data via the Excel Connector, datatype mismatches between Excel source columns and target schema properties result in values being ingested as NULL without any warning or error.

Issues -
Target schema properties (e.g., in OpenPlant Administrator Process Functional Schema) are defined as string.
Excel source columns may contain alphanumeric or decimal values.
During ingestion, mismatched values are silently converted to NULL.The connector does not flag or report datatype mismatches.

Impact:

Causes silent data loss
Users are unaware until manual validation
Leads to time-consuming troubleshooting and rework
Affects data quality in PlantSight ingestion

Current Workaround:

Manually identify failing columns
Convert Excel columns to text/string
Re-import data

Expected Behavior / Enhancement Request:

Pre-validation or validation of datatypes during import
Display clear warning/error messages for mismatches
Highlight specific columns/rows causing issues
Prevent data ingestion until errors are resolved

Business Value:

Prevents silent data loss
Reduces manual troubleshooting effort
Improves data accuracy and user experience

Reference:
CS0676797 – Mopco LTA Acquisition