Latest Contributions by LindsayRaabe_FPCWA

This is something that our organisation could benefit from as well. Being able to include external reference data would save on internal administration and maintenance. At present, we just say no as we can't resource that level of maintenance.  ... View more

Small clause to add - it only works as long as the feature service doesn't have Sync enabled. More reading here: ArcGIS Pro Truncate Table GP Tool Could Work on Po... - Page 2 - Esri Community ... View more

Small update regarding Delete Rows vs Truncate Table: Truncate Table will work with feature services in ArcGIS Online, but only if they DON'T have Sync enabled.  ArcGIS Pro Truncate Table GP Tool Could Work on Po... - Page 2 - Esri Community ... View more

Hi All. I was using this python solution while I couldn't use the built in Truncate Table geoprocessing tool in ArcGIS Pro. I have received the below information that confirms it does work within the following parameters: Esri Inc. have provided a response to this case. During in-house testing, Esri Inc. observed the following: Published a hosted feature layer to ArcGIS Online via ArcGIS Pro Accessed its item details page and enabled "Editing" privileges Accessed the admin JSON of the hosted feature layer > Update Definition > confirmed that "supportsTruncate : false" Now accessed the child layer > Update Definition > observed that "supportsTruncate : true" < I can't seem to access the Update Definition option for the child layer so couldn't confirm this In ArcGIS Pro, added it to a new map and was able to execute "Truncate Table" tool over it without any issues. In ArcGIS Pro the above tool (either as a model or geoprocessing) fails to execute if the "Enable sync" privileges are enabled for the hosted feature layer. They provided a video of the testing steps which I have attached to this email (There is no sound on this video)   Check and confirm if the "Editing" privileges are enabled and "Sync" is disabled for the end user's layer in ArcGIS Online. Additionally, Esri Inc. found the following bug details: BUG-000155843 - Using the REST API Update Definition to set "supportsTruncate : false" results in a successful JSON response, however the setting is unchanged Public status - New To summarise, it doesn't matter what the supportsTruncate line is set to in the service definition, the tool in ArcGIS Pro will work as long as the data is not enabled for offline use.  Where I was using the early discussed python method of truncate/append and have replaced with the GP tools Truncate Table and Append, it has sped up the model as it's much faster to run. Unfortunately, where I update layers which are offline enabled, I still have to use the python solution, but at least the option is there! Now only 2 out of 5 sets of data use the python solution.  ... View more

Hi All ( @PeterHodkinson @RussellBrennan @KoryKramer @TimMinter ). I have got the below information back from ESRI Inc. and have tested to confirm that it does work as advertised.  Esri Inc. have provided a response to this case. During in-house testing, Esri Inc. observed the following: Published a hosted feature layer to ArcGIS Online via ArcGIS Pro Accessed its item details page and enabled "Editing" privileges Accessed the admin JSON of the hosted feature layer > Update Definition > confirmed that "supportsTruncate : false" Now accessed the child layer > Update Definition > observed that "supportsTruncate : true" < I can't seem to access the Update Definition option for the child layer so couldn't confirm this In ArcGIS Pro, added it to a new map and was able to execute "Truncate Table" tool over it without any issues. In ArcGIS Pro the above tool (either as a model or geoprocessing) fails to execute if the "Enable sync" privileges are enabled for the hosted feature layer. They provided a video of the testing steps which I have attached to this email (There is no sound on this video) Check and confirm if the "Editing" privileges are enabled and "Sync" is disabled for the end user's layer in ArcGIS Online. Additionally, Esri Inc. found the following bug details: BUG-000155843 - Using the REST API Update Definition to set "supportsTruncate : false" results in a successful JSON response, however the setting is unchanged Public status - New To summarise, it doesn't matter what the supportsTruncate line is set to in the service definition, the tool in ArcGIS Pro will work as long as the data is not enabled for offline use.  Where I was using the early discussed python method of truncate/append and have replaced with the GP tools Truncate Table and Append, it has sped up the model as it's much faster to run. Unfortunately, where I update layers which are offline enabled, I still have to use the python solution, but at least the option is there! Now only 2 out of 5 sets of data use the python solution.  ... View more

@Bud I don't think this is what we're looking for. Especially because most of our data is hosted in ArcGIS Online these days.  ... View more

No worries about the double up - reply is here for anyone else looking for it: ArcGIS Pro Truncate Table GP Tool Could Work on Po... - Esri Community ... View more

@PeterHodkinson Thanks for your info. I've tried updating them too through the Admin page and UpdateDefinition button, but same as you - no change despite a supposedly successful update. I'll subscribe to that bug. Do you have any idea on how to publish a new layer where the supportsTruncate property is set to True in the 1st instance? @bruss I hadn't looked at that link, only this one: Truncate Table (Data Management)—ArcGIS Pro | Documentation which is the tool I'm trying to use. It makes no mention in there about sync, change tracking or hosted views.  Supported data types are simple points, lines, or polygons stored in a database. Complex data types such as terrains, topologies, and network datasets are not supported as input. The input database table or feature class must be from a database connection established as the data owner. Versioned data is not supported as input. Data must be unregistered as versioned before the tool will run successfully. Truncate commands do not use database transactions and are unrecoverable. This improves performance over row-by-row deletion. It is recommended that you use this tool for workflows in which all rows are removed from a table or feature class and there is no need to back up the transactions, such as nightly reloading of data. This tool supports a feature service layer as input when connected as a user that can administer the service and the supportsTruncate service property is true. This tool does not support feature classes with attachments. To delete rows from a feature class that has attachments, use the Delete Rows tool. ... View more

@KoryKramer I'm at my wits end here. I had a layer published where supportTruncate = true but I can't repeat it !!! And I can't find any documentation anywhere that references how to make this setting supported. How can I use the Truncate Tool on a feature service if I can't change the service setting to support Truncate?  I've tried publishing from ArcGIS Pro directly from the layer, sharing the webmap as a layer, with editing turned on, turned off, sync on, sync off, update the settings through the "Update Definition" option. Nothing seems to work. It seems like a frozen setting! (running ArcGIS Pro 3.1) ... View more

@MiguelMartinezYordan Check out this page: Solved: Transfer Geonet Content to Different Account - Esri Community ... View more

@KoryKramer Welcome news! Can finally start tidying up our project layouts! ... View more

Yeah - I figured this would be the case. I have already started trying out Experience Builder with new apps, but the majority we have were built a while back when WebAppBuilder was the main offering. Think we're going to have to schedule an upgrade and migration process - just another thing on the to-do list! ... View more

Hi @CassKalinski I'm hoping you can clarify a couple of things for me. It looks like you would execute the domain_update code, and that calls in the arcgis_helper code (presumably stored in the same folder?).  You also mention that this would be used to update domains in multiple feature services, though I only see an input parameter for 1 feature service ID. Do you have this code copied for each feature service and run as required? Or do you have another solution (i.e. such as a 3rd code that contains the feature service ID's which get passed to the domain_update.py and iterates through each ID?) ... View more

Quick update seeming as how things have changed. Find more info on out-of-the-box geofencing capabilities in Field Maps here: Get Started with Geofences in ArcGIS Field Maps (esri.com) ... View more

I thought I'd let you know that the info in the links you provided has helped me successfully write Arcade codes which return the information I'm looking for in Popups. I was hoping to put these codes into the layers Visualisation settings, and for it to flow through to all maps that the relevant table is also loaded into (or it would return blank if table was absent). But it appears that this type of popup element doesn't seem to like WebAppBuilder apps. The popups are simply blank once implemented (even loses the existing fields list portion of the popup). Will have to dig further, and will also likely break the single Arcade code into chunks that can be returned individually (in a table format maybe?).  ... View more