Receiving "Create replica internal error." when using multi-sheet excel to append feature layer.
Hi everyone,
I've encountered an issue with my python script:
The script uses an excel file to update attributes of map objects in feature layers on Esri Online.
It gives an error if the excel has multi sheets. (I believe it has something to do with the combination of column headers and the number of sheets.)
Error Msg:
Unable to append data.
Create replica internal error.
Detailed Msg:
What the script does:
Uploads Excel to ESRI Online
Analyse Excel file
Source = gis.content.analyze(item= uploaded_item.id, file_type ='excel'
Grabs ID of layer to be updated
Update attributes using append (Error occurs here)
Lyr_to_Update.append(item_id=uploaded_item.id,
upload_format = 'excel',
source_table_name = "test_points_0",
field_mappings = [{"name":"FID", "source":"FID"},
{"name":"x", "source":"x"},
{"name":"y", "source":"y"}
],
source_info = source['publishParameters'],
upsert=True,
update_geometry=True,
append_fields=["FID"],
skip_inserts=True,
upsert_matching_field="FID")
Append will work fine if I change Analyse Excel file from:
Source = gis.content.analyze(item= uploaded_item.id, file_type ='excel'
to:
Source = gis.content.analyze(item= uploaded_item.id, file_type ='microsoft excel'
Changing the file_type to microsoft excel however will prevent the coordinates from being updated.
(looking at the output for analyze source, the excel file is being read as a csv for some reason.)
