Latest Contributions by BlakeTerhune

Your example code has a lot of syntax errors. If I'm interpreting it correctly, then something like this should work.   import arcpy import datetime fields = ['date_diag','periodicity','maj_previsional'] expression = "date_diag <> '' and date_diag is not null" with arcpy.da.UpdateCursor(inFeatures, fields, expression) as cursor: for date_diag, periodicity, maj_previsional in cursor: if date_diag: maj_previsional = maj_previsional + datetime.timedelta(days = periodicity * 365) cursor.updateRow([date_diag, periodicity, maj_previsional])   If you need to account for leap year/day, then you'll have to update the date calculation. ... View more

Maybe Geodatabase Replication is what you need. ... View more

Rest is Up to the Task (esri.com) ... View more

If the field is a date type, then Python will read the value as a datetime object (at least it does with data access cursors). You can use the .year attribute to get only the year portion of a datetime object. my_date_field.year   ... View more

Thank you for sharing your thoughts. It does indeed list all versions, including grandchild and replica versions. The version objects include the immediate child (not grandchildren), parent version, and ancestors (parent lineage all the way up to default). So it is possible to break up the versions logically. I did a test where I posted a sample of child versions but only reconciled the rest. The versions were grouped by parent, but that seems unnecessary at the moment. Eventually, we will post all direct children of Default and only reconcile everything else so that's why I have it that way. versions_to_post = [ "QAQC_LIS.QAQC_LIS", "QAQC_GPS.QAQC_GPS", "QAQC_UTILITIES.QAQC_UTILITIES" ] versions = defaultdict(list) for v in arcpy.da.ListVersions(sde_egdb_conn): if v.name != "SDE.DEFAULT": versions[v.parentVersionName].append(v.name) for version_parent, version_list in versions.items(): v_to_reconcile = [v for v in version_list if v not in versions_to_post] if v_to_reconcile: print(f"\nReconcile {len(v_to_reconcile)} versions with {version_parent}") arcpy.management.ReconcileVersions( input_database=sde_egdb_conn, reconcile_mode="ALL_VERSIONS", target_version=version_parent, edit_versions=v_to_reconcile, acquire_locks="NO_LOCK_ACQUIRED", abort_if_conflicts="NO_ABORT", conflict_definition="BY_OBJECT", conflict_resolution="FAVOR_TARGET_VERSION", with_post="NO_POST", with_delete="KEEP_VERSION" ) # Post v_to_post = [v for v in version_list if v in versions_to_post] if v_to_post: print(f"\nPost {len(v_to_post)} versions to {version_parent}") arcpy.management.ReconcileVersions( input_database=sde_egdb_conn, reconcile_mode="ALL_VERSIONS", target_version=version_parent, edit_versions=v_to_post, acquire_locks="LOCK_ACQUIRED", abort_if_conflicts="ABORT_CONFLICTS", conflict_definition="BY_OBJECT", conflict_resolution="FAVOR_TARGET_VERSION", with_post="POST", with_delete="KEEP_VERSION" )  This was successful and posted changes in a QAQC version to Default. @Anonymous User, do you have any automated post operations in your organization? ... View more

That is my observation as well. It seems ArcGIS Pro makes some kind of temporary copy of the connection file while the app is open. However, I've been able to do everything I need with this connection file (short of knowing where the original sde file is). ... View more

I haven't tested it with broken data sources. I'm not sure how it would handle that. ... View more

You could either hard code the path (if it's a shared toolbox) or have an additional input parameter on your tool where the user can browse to the toolbox. ... View more

Double post. See Correct Codeblock Python syntax for CalculateField - Esri Community ... View more

@CCWeedcontrol, there are some gaps in the explanation of your logic there, but here's another take on evaluating your progress field. I organized evaluation of the larger groups separately to make the evaluation of the progress field a little easier to follow. Please correct as needed to clarify logic gaps.   # Get arcpy.da cursor rows back as dictionary with field names # https://arcpy.wordpress.com/2012/07/12/getting-arcpy-da-rows-back-as-dictionaries/ def rows_as_dicts(cursor): colnames = cursor.fields for row in cursor: yield dict(zip(colnames, row)) fields = [ "reviewField1", "reviewField12", "reviewField3", "reviewField4", "EventField", "EventRes1", "Certif", "CertifDate", "ProgressFiledField" ] where = "AppType = 'SFR Active'" with arcpy.da.UpdateCursor(table1, fields, where) as cursor: for row in rows_as_dicts(cursor): # Evaluate Review fields review_approved_count = [ row["reviewField1"], row["reviewField12"], row["reviewField3"], row["reviewField4"] ].count("Approved") # Evaluate Event eventField = row["EventField"] if eventField in ["Foundation", "Setback", "Shear Panel 1"]: event_state = "Foundation" elif eventField in ["Framing" or "BC- Framing"]: event_state = "Framing" elif eventField in ["Insulation" or "Stucco"]: event_state = "Insulation" elif eventField in ["Final"]: event_state = "Final" else: raise Exception(f"EventField value {eventField} not handled.") # Evaluate eventRes1 eventRes1 = row["EventRes1"] if eventRes1 in ["Needs corrections", "In progress", "partial Pass", "Cancelled"]: eventRes1_state = "Not Passed" elif eventRes1 == "Pass": eventRes1_state = "Pass" else: raise Exception(f"EventRes1 value {eventRes1} not handled.") # Evaluate Progress progress_filed = row["ProgressFiledField"] if review_approved_count == 4: if event_state == "Foundation": # Doesn't matter what EventRes1 is? progress_filed = "15%" elif event_state == "Framing": if eventRes1_state == "Passed": progress_filed = "50%" else: # eventRes1 not passed progress_filed = "25%" elif event_state == "Insulation": if eventRes1_state == "Passed": progress_filed = "75%" else: # eventRes1 not passed progress_filed = "50%" elif event_state == "Final": if eventRes1_state == "Passed": progress_filed = "100%" else: # eventRes1 not passed progress_filed = "75%" else: # review_approved_count < 4 and # doesn't matter what EventField or EventRes1 are. progress_filed = "0%" # These dates override all other logic evaluations? if row["Certif"] and row["CertifDate"]: progress_filed = "100%" # Update row with progress. row["ProgressFiledField"] = progress_filed row_values = list(row.values()) cursor.updateRow(row_values)   ... View more

@NephtaliChavez wrote: That path is to a folder saved on the cloud(onedrive), which I'm not sure if that's an issue.  Is that different from how you run it? Does it work for you with a OneDrive path? ... View more

Installing ArcGIS (ArcMap or Pro) includes a full install of Python (2.x for ArcMap, 3.x for Pro). There's no need to install Python if you've already installed ArcGIS. ... View more