Select to view content in your preferred language

Update Data -> Append Data Error: No compatible layer was found in the uploaded file. Please check your file and try again.

1509
5
Jump to solution
04-03-2023 07:02 PM
dwold
by
Occasional Contributor III

I am trying to use the Update Data -> Append Data to Layer feature and I receive this message: Error - No compatible layer was found in the uploaded file. Please check your file and try again.

The attribute names in my .csv file match the hosted feature layer attribute fields.

Any idea why I am getting this error?

@Katie_Clark 

@jcarlson 

@james-noble 

@ChristopherCounsell 

0 Kudos
1 Solution

Accepted Solutions
ChristopherCounsell
MVP Regular Contributor

It doesn't look like this csv layer can be appended to this Hosted Feature Layer for a few reasons:

  • I believe a spatial input is required (x,y fields for a point)
  • Don't imagine globalids are preserved here
  • Editor tracking fields are system-set, you can't define them (creationdate,editor,editdate etc)

From what @DanPatterson  said it also sounds like you have a different goal to 'append', where maybe instead you are looking to 'update' features?

Probably better to phrase your question as "I have this data, and want to do this workflow, what methods are available" rather than hit an error and focus on that. For example, we may be able to recommend Pro or other tools/workflows to better assist what you are doing.

View solution in original post

0 Kudos
5 Replies
ChristopherCounsell
MVP Regular Contributor

Likely either your CSV isn't formatted correctly.

Or your field attributes don't match the destination field type i.e. you're trying to insert text into an integer field.

https://doc.arcgis.com/en/arcgis-online/reference/csv-gpx.htm#GUID-4EDCE12E-285E-41D0-A3B8-1BAB4B111...

If you are still stuck, please share your CSV and layer schema

dwold
by
Occasional Contributor III

@ChristopherCounsell Attached is my CSV. Hosted Layer schema:

dwold_0-1680577595107.pngdwold_1-1680577627342.png

 

0 Kudos
ChristopherCounsell
MVP Regular Contributor

It doesn't look like this csv layer can be appended to this Hosted Feature Layer for a few reasons:

  • I believe a spatial input is required (x,y fields for a point)
  • Don't imagine globalids are preserved here
  • Editor tracking fields are system-set, you can't define them (creationdate,editor,editdate etc)

From what @DanPatterson  said it also sounds like you have a different goal to 'append', where maybe instead you are looking to 'update' features?

Probably better to phrase your question as "I have this data, and want to do this workflow, what methods are available" rather than hit an error and focus on that. For example, we may be able to recommend Pro or other tools/workflows to better assist what you are doing.

0 Kudos
DanPatterson
MVP Esteemed Contributor

like your other problem you can join a csv to features, you can't append them


... sort of retired...
ChristopherCounsell
MVP Regular Contributor

https://doc.arcgis.com/en/arcgis-online/manage-data/manage-hosted-feature-layers.htm#APPEND

For example, if you have a number of employees who do inspections in the field and they gather that information in a .csv file or a custom app that writes to a shapefile, you can take the file from each inspector at the end of the day and update the hosted feature layer with the new data.