topic How to use Field Mappings in Geoprocessing with C# and Geoprocessing.MakeValueArray in ArcGIS Pro SDK Questions

How to use Field Mappings in Geoprocessing with C# and Geoprocessing.MakeValueArray

ole1986 — Tue, 03 Aug 2021 13:33:43 GMT

A general question is how to define the Parameters when using FieldMapping arguments in Geoprocessing tools

For example the "FeatureClassToFeatureClass" allows (according to Feature Class To Feature Class (Conversion)—ArcGIS Pro | Documentation) the fields to be renamed, deleted, etc...

But there is no example avaialble for C#

Re: How to use Field Mappings in Geoprocessing with C# and Geoprocessing.MakeValueArray

Wolf — Tue, 17 Aug 2021 20:57:53 GMT

This sample code worked for me:

protected override async void OnClick() { try { var environment = Geoprocessing.MakeEnvironmentArray(overwriteoutput: true); var defaultGDB = Project.Current.DefaultGeodatabasePath; var srcLayer = "TestPoints"; var srcGdb = @"C:\Data\FeatureTest\FeatureTest.gdb"; var outputFeatureClass = @"TestTestPoints"; var fields = new string[] { @"TheDate ""TheDate"" true true false 8 Date 0 0,First,#,TestPoints,TheDate,-1,-1", @"CodePoint ""CodePoint"" true true false 4 Long 0 0,First,#,TestPoints,CodePoint,-1,-1", @"TheString ""TheString"" true true false 255 Text 0 0,First,#,TestPoints,TheString,0,255", @"TheInteger ""TheInteger"" true true false 4 Long 0 0,First,#,TestPoints,TheInteger,-1,-1", @"TheDouble ""TheDouble"" true true false 8 Double 0 0,First,#,TestPoints,TheDouble,-1,-1", @"NewString ""NewString"" true true false 255 Text 0 0,First,#,TestPoints,TheString,0,255'" }; var fieldMap = string.Join (";", fields); var toolParameters = Geoprocessing.MakeValueArray(srcLayer, srcGdb, outputFeatureClass, null, fieldMap, null); GPExecuteToolFlags executeFlags = GPExecuteToolFlags.AddOutputsToMap | GPExecuteToolFlags.GPThread | GPExecuteToolFlags.AddToHistory | GPExecuteToolFlags.RefreshProjectItems; IGPResult gpResult = await Geoprocessing.ExecuteToolAsync("FeatureClassToFeatureClass", toolParameters, environment, null, null, executeFlags); Geoprocessing.ShowMessageBox(gpResult.Messages, "GP Messages", gpResult.IsFailed ? GPMessageBoxStyle.Error : GPMessageBoxStyle.Default); } catch (Exception ex) { MessageBox.Show($@"Error: {ex}"); } }

Re: How to use Field Mappings in Geoprocessing with C# and Geoprocessing.MakeValueArray

ole1986 — Thu, 19 Aug 2021 05:49:36 GMT

This example works for me too (so far).

So i am still in the expression that the Tool "Append" seem to have a bug using field mappings.
See my bug report Bug in Geoprocessing.ExecuteToolAsync("Append") wh... - Esri Community

Re: How to use Field Mappings in Geoprocessing with C# and Geoprocessing.MakeValueArray

mcamp1 — Tue, 12 Jul 2022 17:55:27 GMT

Where is the sample code from? Thanks!

Re: How to use Field Mappings in Geoprocessing with C# and Geoprocessing.MakeValueArray

Wolf — Tue, 12 Jul 2022 19:36:48 GMT

I made up the sample that you see above to show that one can add different types of columns to a file geodatabase. If I remember correctly the bug had to do with adding columns to a shapefile.

Re: How to use Field Mappings in Geoprocessing with C# and Geoprocessing.MakeValueArray

mcamp1 — Tue, 12 Jul 2022 20:55:11 GMT

Hi Wolf,

Thank you for the quick response. I am trying to create a field mapping to pass as a parameter to the ‘Table to Table’ geoprocessing tool, and your example code is the best resource I have found for defining the Field Mappings so far. I have a couple more questions if don’t mind.

Does the c# SDK have a field mapping object like python? If so, can you point me towards any documentation or code examples?

If not, is there any documentation for the string field mapping? This link was the closest I could find.

Thanks!

Re: How to use Field Mappings in Geoprocessing with C# and Geoprocessing.MakeValueArray

Wolf — Fri, 15 Jul 2022 13:47:25 GMT

Unfortunately, the SDK does not have field mapping objects like python. This and better Pro SDK for .Net suited documentation and sample usage code has been (and still is) on the Pro SDK team's wish list for a while. If I remember correctly the example above (references in the 'bug' report) worked fine for geodatabases (file, etc.) but not for shapefiles. Are you trying read/write to a shapefile? I noticed that the 'bug' thread you mentioned above was never solved, I will reach out to Nobbir and find out where we left off. However, if you are just trying to copy / append data to a geodatabase the sample snippet should work. We also now have DDL support in the API: ProConcepts DDL · Esri/arcgis-pro-sdk Wiki (github.com) which will allow you to inspect the schema of existing tables/feature classes. However, DDL support is also limited to Geodatabases only.

Let me know what you try to do. You can also reach out to me at: wkaiser@esri.com if you want to keep samples/data confidential.

Re: How to use Field Mappings in Geoprocessing with C# and Geoprocessing.MakeValueArray

StefanDieters1 — Thu, 27 Jul 2023 05:21:43 GMT

I believe you can use field mapping to add a new field to the output table that does not exist in the input table. Is this correct?

In your example you have a field "NewString" the syntax is exactly like the previous entry for "TheString".

Would the syntax for a new string field be:

@"NewString ""NewString"" true true false 255 Text 0 0"

i.e. without the parameters from the input table.

Re: How to use Field Mappings in Geoprocessing with C# and Geoprocessing.MakeValueArray

StefanDieters1 — Thu, 27 Jul 2023 05:24:29 GMT

Is the setup for the fieldmapping is the same for all geoprocessing that use a fieldmap e.g. Merge (Data Management) ?