I'm trying to automate a daily workflow using ModelBuilder. I have several tasks that I do daily in this order:
- Import an Excel file that contains 16 fields including two fields with x and y coordinates (xcoordinate and ycoordinate). The Excel is always stored in the same folder with date as the file name.
- Map the information using the Display XY function
- Append the resulting shapefile to a master shapefile
I've attempted to build a model that reflects this workflow (see attached).
The model appears to run, the resulting shapefile is blank. Upon re-runs to test, I get this message:
Traceback (most recent call last): File "c:\program files (x86)\arcgis\desktop10.3\ArcToolbox\Scripts\ExcelToTable.py", line 254, in <module> arcpy.GetParameterAsText(2)) File "c:\program files (x86)\arcgis\desktop10.3\ArcToolbox\Scripts\ExcelToTable.py", line 225, in excel_to_table template=tmp_table) File "c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\management.py", line 15242, in CreateTable raise e ExecuteError: ERROR 999999: Error executing function. The maximum record length has been exceeded. Failed to execute (CreateTable). Failed to execute (Excel To Table).
Outside the model, the excel imports into ArcMap without any issues. I've tried switching to the "1904" option in excel as well but it still does not run.
Any ideas on where the error is coming from?
I'm running ArcMap 10.3.