Latest Contributions by ErnestoCarreras3

Hi, will this script assist identifying the front of a house? ... View more

Issue solved. The script was working but for some reason the field storing the time difference got renamed with an underscore at the end. After removing it, the script is working as expected. The datetime module was not required since it is included as part of the python functions within the Field Calculator GUI. I really appreciate your assistance Dan. Good day. ... View more

Thanks for the info... I was just checking out your blog I will try to run the same process with a File GDB in order to isolate the issue. If it does work, I will report it here for the record. ... View more

No, the arcpy module was not imported when using the Field Calculator. If needed, can you provide an example of how to? BTW, I found it odd that it is needed since I already tested it before within the Field Calculator wand I don't recall adding the import module part. ... View more

Yes, I am working on a python IDE. When executed from the IDE, it says in runs but the record is not updated in the Time_Diff field. That is why I went to the field calculator to just test the script which was working last week. This is a simple script that used to update one of the widgets in a dashboard. # Import arcpy module import arcpy conn = r"C:\Users\gispu\Documents\GIS_Python_Scripts\Map_Change_Request\GISHW.sde" arcpy.env.workspace = conn # Local variables: Input_MapChangeRequest = r"C:\Users\gispu\Documents\GIS_Python_Scripts\Map_Change_Request\GISHW.sde\gishw.PU.HW_FieldCollection\gishw.PU.MapChangeRequest" MapChangeRequest_Layer = "PU.MapChangeRequest_Layer" MapChangeRequest_Layer2 = MapChangeRequest_Layer PU_MapChangeRequest_Layer = MapChangeRequest_Layer2 # Process: Make Feature Layer arcpy.MakeFeatureLayer_management(Input_MapChangeRequest, MapChangeRequest_Layer) # Process: Select Layer By Attribute arcpy.SelectLayerByAttribute_management(MapChangeRequest_Layer, "NEW_SELECTION", "STATUS = 'Open' OR STATUS = 'Validation'") # Start an edit session. Must provide the workspace. edit = arcpy.da.Editor(conn) # Edit session is started without an undo/redo stack for versioned data edit.startEditing(True) # Start an edit operation edit.startOperation() # Process: Calculate Field arcpy.CalculateField_management(Input_MapChangeRequest, "Time_Diff", "(datetime.datetime.now() - arcpy.time.ParseDateTimeString( !DATE! )).days", "PYTHON_9.3", "") # Stop the edit operation. edit.stopOperation() # Stop the edit session and save the changes edit.stopEditing(True) EDIT: 2016-04-28 The above script is good and works as expected. ... View more

Thanks! ... View more

It did worked as expected in IE 11. I have not tried in Firefox though nor any other option. Chrome definitely is not working for me...unfortunately since it is my prefer browser. ... View more

Yes Well, it appears it was not. I assumed it got unversioned after adding a new feature class to the Feature Dataset. Is that correct? Now, the script works as expected. Thanks a lot! ... View more

It returns the following error even though I have enabled the editing within the script... arcgisscripting.ExecuteError: ERROR 999999: Error executing function. Objects in this class cannot be updated outside an edit session [gishw.PU.MapChangeRequest] Failed to execute (CalculateField). ... View more

I have modified the script so that it point to the SDE connection locally for the workspace but still I get the same runtime error... any help will he really appreciated . The SDE connection used in the script points to the version where I need to update the data. # Import arcpy module import arcpy conn = r"U:\GIS\GISHW.sde" arcpy.env.workspace = conn # Local variables: Input_MapChangeRequest = r"U:\GIS\GISHW.sde\gishw.PU.HW_FieldCollection\gishw.PU.MapChangeRequest" MapChangeRequest_Layer = "MapChangeRequest_Layer" # Start an edit session. Must provide the workspace. edit = arcpy.da.Editor(MapChangeRequest_Layer) # Edit session is started without an undo/redo stack for versioned data edit.startEditing(True) # Start an edit operation edit.startOperation() # Process: Calculate Field arcpy.CalculateField_management(MapChangeRequest_Layer, "Time_Diff", "(datetime.datetime.now() - arcpy.time.ParseDateTimeString( !DATE! )).days", "PYTHON_9.3", "") # Stop the edit operation. edit.stopOperation() # Stop the edit session and save the changes edit.stopEditing(True) Jake Skinner​ I noticed you commented on a similar question and thought you may be able to assist me with this issue. Thanks in advance ... View more

Anyways, thanks for you input. ... View more

I just added the following below Import arcpy and got the same error: arcpy.env.workspace = "Database Connections\\GISHW.sde\\gishw.PU.HW_FieldCollection" ... View more