Hi,
I'm attempting to convert hundreds of excel files to geodatabase feature classes in a dynamic workflow.
What I've done:
In the generate workspace dialogue,
Reader - Format: Microsoft Excel, Dataset: my excel files (testing with 5 for now but will have hundreds in reality), Coord. System: UTM83-20. In the parameters, it correctly selects the Easting column as x-coord and Northing as y-coord but incorrectly selects the column "Zn_4A_ICPMS_ppm" as z-coord. I then change the type to "Number" for the first file (only file that is listed in the "Sheets to Read")
Writer - Format: Esri Geodatabase (File Geodb Open API), Dataset: my gdb
...with Dynamic Schema selected in workflow options, press ok.
In the writer parameters, I changed the Geometry to gdb_point and also the Schema Definition Name to fme_feature_type
When I run it, the log says that the translation was successful and all 5 feature classes show up in my gdb but only the first plots spatially.
In every excel workbook there's 1 sheet and in each sheet the column for zinc is automatically being recognized as the z-coordinate (except for the first file, which I manually changed to number). The zinc columns are all different: Zn_4A_ICPMS_ppm, Zn_XRF_ppm, Zn_ICPMS_ppm, Zn_AQR_ICPMS_ppm, Zn_4A_ICPOES_ppm
Does anyone have any suggestions to work around this? Is there a way to somehow set what columns will be recognized as the x/y coordinates if they have the same name (and maybe set that there is no z-coordinate)?
Thanks!
