Latest Contributions by JakeSkinner

‎05-09-2022

@JoabelBarbieri @JonathanWhite1 I've updated the script to disable sync, perform the truncate/append, and then re-enable sync once complete. There's is also a video of the workflow posted as well. This should eliminate the issue of OBJECTIDs growing too large.

‎04-29-2022

@ssintelmann here is some info from the help: Characters that are not within a range can be matched by complementing the set. If the first character of the set is '^', all the characters that are not in the set will be matched. For example, [^5] will match any character except '5', and [^^] will match any character except '^'. ^ has no special meaning if it’s not the first character in the set. [^a-zA-Z0-9_]: Matches any character which is not a word character

‎04-28-2022

Hi @ssintelmann, I would recommend using the Excel to Table function to convert the excel sheets. To iterate through an excel workbook to get the sheets, you could use pandas to do this. Ex: import pandas as pd import arcpy, os, re # Variables arcpy.env.workspace = r"C:\Projects\Documents" outputGDB = r"C:\Projects\Data.gdb" for file in arcpy.ListFiles("*.xlsx"): f = os.path.join(arcpy.env.workspace, file) # Get excel sheets sheetNames = pd.ExcelFile(f).sheet_names # iterate through sheets for sheet in sheetNames: # Replace non alphanumeric characters with underscore sheetName = re.sub(r'[^0-9a-zA-Z]+', r'_', sheet) # Convert sheet to GDB table arcpy.conversion.ExcelToTable(f, os.path.join(outputGDB, sheetName), sheet, 1, '')

‎04-27-2022

@MikeOnzay your username is case sensitive. For example, my username is jskinner_CountySandbox. In a web browser I can log in using jskinner_countysandbox, but if I try that iteration of the username in the above code, it would fail.

‎04-25-2022

Hi @kavi88, I believe the issue is how you're specifying the array. Try data.slots[0].id. Here's what worked for me: Flattened the output GeoEvent Definition using the following script Created a Field Mapper as below:

‎04-06-2022

@CatherineKoerber This is what I think would work: As a GeoEvent Input, poll the Trip Info table which contains the total time at a location Create a GeoEvent Service Add the GeoEvent Input in bullet one Add a Filter for when the total time is greater than 30 minutes Add the Event Controller to send only one e-mail at a given time interval Add the E-mail Output

‎04-05-2022

Instead of performing an append are you able: Publish the uploaded file (shp/gdb) as a feature service Perform your calculations on the published feature service Add the published feature service to target service using /addfeatures Delete published feature service

‎04-04-2022

@ewagstaff are you able to apply the calculation before the append?

‎03-27-2022

@davedoesgis I'm having trouble locating the documentation as well. One way is to print the properties of a feature layer collection. A good example of this can be found here: https://developers.arcgis.com/python/guide/updating-feature-layer-properties/

‎03-27-2022

@JoshConrad1 instead of using the CreationDate field, you can use the EditDate when Editor Tracking is enabled. Not quite sure if this will work since the EditDate field will update when any field is edited.

‎03-17-2022

@PaulVepraskas I don't believe this will be possible as the applyEdits function is only supported via POST. You would need additional code, other than just a URL, to apply a POST operation.

‎03-16-2022

Replace the print statements to arcpy.AddMessage instead. This will print which layer the script is failing on, and this should give us some insight on what's going on. Ex: arcpy.AddMessage(f"\t{lyr.name}")

‎03-16-2022

You can add this logic to the Calculate Field tool: Or you can add a script to a model: https://desktop.arcgis.com/en/arcmap/latest/analyze/modelbuilder/integrating-scripts-within-a-model.htm

‎03-16-2022

Hi @PaulVepraskas, Quick question about the service, will it be secure? Meaning, will a user need to access it via a username/password? If so, the URL will also need to contain a token, which would need to generated dynamically.

‎03-16-2022

@2Quiker, Does it matter if the Permits field is populated for all rows? Ex: If not, you could do something like below: dict = {} with arcpy.da.SearchCursor(table, ['PermitNum1', 'ParcelNum']) as cursor: try: for row in cursor: dict.setdefault(str(row[0]), []) dict[str(row[0])].append(str(row[1])) except: pass del cursor with arcpy.da.UpdateCursor(table, ['PermitNum1', 'Permits']) as cursor: try: for row in cursor: permitsList = dict[row[0]] permits = ', '.join(permitsList) row[1] = permits cursor.updateRow(row) except: pass del cursor

Online Status	Offline
Date Last Visited	Friday

My Ideas

Latest Contributions by JakeSkinner

Re: Overwrite ArcGIS Online Feature Service using Truncate and Append

Re: Looping through Excel Worksheets within a Workbook, then Creating XY points

Re: Looping through Excel Worksheets within a Workbook, then Creating XY points

Re: Overwrite ArcGIS Online Feature Service using Truncate and Append

Re: Failure to parse incoming JSON

Re: Calculate Total Time Spent at a Location

Re: Any way to run /append and then /calculate on ONLY those appended features?

Re: Any way to run /append and then /calculate on ONLY those appended features?

Re: Enable "Export Data" with the ArcGIS API for Python

Re: Send Email When a Feature is Added to an ArcGIS Online Hosted Feature Service

Re: Not sure where to ask.... I want to build a applyEdits URL string that updates a single features attribute field?

Re: Is there a way to remove layers from the Table of Contents if no features are present?

Re: Model Builder calculate field expression

Re: Not sure where to ask.... I want to build a applyEdits URL string that updates a single features attribute field?

Re: Model Builder calculate field expression

Re: Remove empty tilecache 11.3 before upgrade to ...

Display Latest Feature In a Feature Service

Re: Licenses for the parallel prod

Re: Change Portal Admin URL in Portal Administrato...

Re: Update the organization URL in ArcGIS Enterpri...

Web AppBuilder Custom Widgets