FME and Schema Mapper Excel file

[SanchezNuñez]

Good morning,

After creating a new Excel file by copying the existing Schema Mapper Excel file and updating it, I modified the corresponding parameter in FME under Edit User Parameter → SchemaMapper_Master to point to the new file.
However, when I run the FME workspace, the log file shows that several SchemaMapper_NN parameters (e.g., SchemaMapper_18) are still referencing the previous schema mapper file instead of the new one.

Do you have any suggestions on how to ensure all SchemaMapper_NN parameters correctly load the new Excel file?

[RenatoSalvaleon3]

The question needs to be posted here: 

https://community.esri.com/t5/arcgis-data-interoperability-ques/bd-p/arcgis-data-interoperability-qu....

In Manage User Parameter, what is the type of user parameter did you use? File, Choice, Text, etc.

I need some more context, can you share your FME workspace? What is this SchemaMapper XLS file for in relation to AGOL? Are you reading and writing to the same Excel file? A copy of the FMW and Excel files would definitely help.

[JoseSanchez]

Good morning @RenatoSalvaleon3 

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.