I'm trying to create a task that configures multiple different fields starting from an excel sheet within ArcGIS Pro. An issue I'm facing, and wondering if anyone else has experienced, is related to when I load fields/import field mapping (not to be confused with the Field Maps application). One of the first steps I'd like to have completed within my task would require a user to import an excel sheet that will then have very specific field types and lengths configured through an Export Table conversion tool (as the default text length for an imported excel sheet is 8000 characters -- way too large for my already large dataset). I've found that when the excel .csv table's name is different from the initial field map export, i can never import my '.fieldmap', and have to manually set the field mapping properties each time I run my task.
Is this a bug, or is there a work-around for importing the fieldmapping of my to-be feature layer? Has anyone else had this issue before?
I'm considering having my task create duplicates of all my fields, having a step calculate the new field based off the old field, and then deleting the old fields, but this would result in my new fields being named something that could break an application this data is displayed within due to the fields not matching.....
