AnsweredAssumed Answered

Mass Edit AGO Table

Question asked by konzelt on Jul 15, 2016
Latest reply on Jul 21, 2016 by mminami-esristaff

Like • Show 0 Likes0
Comment • 4

Is it possible to mass edit a feature table in ArcGIS Online either through the default viewer or is there a Web AppBuilder widget that enables this functionality?

We have a some values that need to be updated in a hosted feature service and the user has limited knowledge of editing. Alternatively, is there a workflow for updating the data en-masse from an Excel spreadsheet? That kind-of defeats the purpose for us though, but I'd take it to speed up their update process.

Any thoughts or suggestions? Thanks everyone.

konzelt Jul 21, 2016 2:16 PM

Correct Answer

Wow, I can't believe this was right under my nose for the past few weeks. I received information from Kelly Gerrow (ESRI) who let me know that there is new functionality for hosted Feature Layers in AGO. Navigate to your content, click the drop-down next to your Feature Layer, navigate to "View item details", and when the Feature Layer Description page loads, click the Data tab at the top of the page. You're now able to edit the underlying Feature Layer data en masse, like in a data grid or Excel.

She also said this feature has been available for about 3 weeks and also works for Feature Services hosted within the organization that are served out to AGO.

This is exactly what we were looking for. Thanks Kelly Gerrow

Tom K.

See the reply in context

No one else had this question

Outcomes

jskinner-esristaff

Jul 15, 2016 12:57 PM

Hi Thomas,

The Batch Attribute Editor widget may be a solution.

https://doc.arcgis.com/en/web-appbuilder/create-apps/widget-batch-attribute-editor.htm

Actions

konzelt @ jskinner-esristaff on Jul 15, 2016 1:05 PM

Good afternoon Jake,

Thank you for this information. After reviewing the widget, it appears that this will do part of what we're looking to do - that is, it will provide the same value for all selected records, similar to ArcGIS for Desktop's Calculate. We're wanting to have an editable data grid that individual records can be updated separately and individually, like the edit mode in ArcGIS for Desktop.

We will look at the possibility of using this widget if not other solutions pan out.

Thank you again.

Best regards,

Tom K

Actions

konzelt @ konzelt on Jul 21, 2016 2:16 PM

She also said this feature has been available for about 3 weeks and also works for Feature Services hosted within the organization that are served out to AGO.

This is exactly what we were looking for. Thanks Kelly Gerrow

Tom K.

1 person found this helpful

Actions

mminami-esristaff

Jul 21, 2016 3:32 PM

Another option is to use the Map Viewer of AGOL If the layer supports editing, you can use the calculate tool on a field to set it's value. If the layer has a filter, only those filtered records will be calculated. You can access the calculate tool from by displaying the layer's attribute table. Click the header of the field you want to calculate to access the calculate tool.

Apply filters—ArcGIS Online Help | ArcGIS

Work with fields—ArcGIS Online Help | ArcGIS

Note the Data tab doesn't currently support the Calculate tool...It will eventually.

1 person found this helpful

Actions

4 Replies

jskinner-esristaff Jul 15, 2016 12:57 PM
Mark Correct
Correct Answer
Hi Thomas,

The Batch Attribute Editor widget may be a solution.

https://doc.arcgis.com/en/web-appbuilder/create-apps/widget-batch-attribute-editor.htm
Like • Show 1 Like1
Actions
- konzelt @ jskinner-esristaff on Jul 15, 2016 1:05 PM
  Mark Correct
  Correct Answer
  Good afternoon Jake,
  
  Thank you for this information. After reviewing the widget, it appears that this will do part of what we're looking to do - that is, it will provide the same value for all selected records, similar to ArcGIS for Desktop's Calculate. We're wanting to have an editable data grid that individual records can be updated separately and individually, like the edit mode in ArcGIS for Desktop.
  
  We will look at the possibility of using this widget if not other solutions pan out.
  
  Thank you again.
  
  Best regards,
  Tom K
  Like • Show 0 Likes0
  Actions
  - konzelt @ konzelt on Jul 21, 2016 2:16 PM
    Unmark Correct
    Correct Answer
    Wow, I can't believe this was right under my nose for the past few weeks. I received information from Kelly Gerrow (ESRI) who let me know that there is new functionality for hosted Feature Layers in AGO. Navigate to your content, click the drop-down next to your Feature Layer, navigate to "View item details", and when the Feature Layer Description page loads, click the Data tab at the top of the page. You're now able to edit the underlying Feature Layer data en masse, like in a data grid or Excel.
    
    She also said this feature has been available for about 3 weeks and also works for Feature Services hosted within the organization that are served out to AGO.
    
    This is exactly what we were looking for. Thanks Kelly Gerrow
    
    Tom K.
    1 person found this helpful
    Like • Show 1 Like1
    Actions
mminami-esristaff Jul 21, 2016 3:32 PM
Mark Correct
Correct Answer
Another option is to use the Map Viewer of AGOL If the layer supports editing, you can use the calculate tool on a field to set it's value. If the layer has a filter, only those filtered records will be calculated. You can access the calculate tool from by displaying the layer's attribute table. Click the header of the field you want to calculate to access the calculate tool.

Apply filters—ArcGIS Online Help | ArcGIS
Work with fields—ArcGIS Online Help | ArcGIS

Note the Data tab doesn't currently support the Calculate tool...It will eventually.
1 person found this helpful
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

Mass Edit AGO Table

Outcomes

Related Content

Recommended Content