Good morning,
In the Excel document SchemaMapper.xlsx the name of this column is "_UNFeatureClass", but when I run the FME workbench it returns this warning. It looks like it does not refresh the column name.
Is there a way to force FME to refresh the SchemaMapper Transformer (SchemaMapper_18)?
Log file Message: "SchemaMapper_18 Transformer
Excel Reader: Sheet 'Assettypes' of dataset 'C:\Workspace\UtilityNetwork_Migration\SchemaMapper.xlsx' has column '_UNFeatureClass' that does not match a header column in the file. This column will not be read."
Thanks
Esri assisted us with this issue. It appears that when using ArcGIS Pro 3.5.x together with FME, the libxl.dll file from ArcGIS Pro needs to be replaced with the libxl.dll file from FME.
To resolve this, we copied the libxl.dll file from:
C:\Program Files\ArcGIS\Data Interoperability for ArcGIS Pro\plugins
to:
C:\Program Files\ArcGIS\Pro\bin
After making this change, everything worked as expected.
This is a known issue: FMEENGINE-87239.
Hope this helps.