Latest Contributions by ModernElectric

‎08-18-2023

Doing a Follow-up on this to see if there has been any changes that I am unaware of. I too, would need to assign multiple surveys to a specific assignment. An example would be an Electric Investigation assignment would be assigned for our Field Crew to go out and investigate an issue. When its determined, for an example, there is damage to an OH transformer. They would have to fill-out a Tailboard safety form, an inventory form and an As-Built/Transformer Exchange form. Do not see having (3) separate Assignments for (1) job. Appreciate the feedback

‎08-18-2023

I am presently working on an integration project with ArcGIS Online and ArcGIS Workforce for our Electric Department composed of our Department Supervisor and electric field crew(s). One of the task(s) is to include our infrastructure in the Dispatcher and Field Worker Map(s) in AGOL and Workforce. As many know, for this to work the Hosted Feature Layer has to have the Enable Editing and Enable Sync checked in the settings for the Hosted Feature Layer. Currently, I am unable to check Enable Sync, keeps giving me a "Save wasn't successful. Try Again Later" error message. However, it does not give me that error if I Enable Editing. Is this an issue with AGOL OR is there something that I am doing wrong? I am working with a Hosted Feature Layer that was uploaded to AGOL via ArcGIS Pro that originated from a File GDB. I have also tried to publish a Web Map via ArcGIS Pro with the same problems. Thank You

‎03-10-2023

Thank you Tim. That did the trick. Apparently, I had to add the path to the .EXE and the .PY in quotes. That is why it was not running. Appreciate it

‎03-09-2023

C:\Python27\ArcGIS10.5\python.exe "C:\Users\cwafstet\Documents\MODERN GIS WORKING FILES\PYTHON SCRIPTS COLLECTION\CIS DATA GIS UPDATES\CISMIS_ElectricAccounts_ActiveStatus.py" This is what my Python 2.7 call-out looks like within my BATCH file via Notepad. Trying to rewrite it to match with the online files says is not working. How should this look for Python 3? I know this should be very simple but is really frustrating me. Appreciate it.

‎03-08-2023

I am in the process of converting everything from ArcMap to ArcGIS Pro. For years, I have had a series of Batch Files that were used in Window's Task Scheduler to run dozens of Stand Alone Python scripts overnight to update my GIS data from external databases. Part of the project is to convert the code from Python 2 to Python 3. One of the items I cannot figure out is how to convert the existing BATCH files with the collection of Python 2 scripts to an executable BATCH file with Python 3 scripts. I learned how to put a script into a BATCH file and run it outside of ArcGIS Pro, but I need to add multiple Python Scripts in a single BATCH file to run them one after another, similar to what I was able to do with Python 2 (2.7). I am stuck, so any help would be great. Thank You

‎11-03-2022

UPDATE Talked to our IT Department who manages the networked drives, the particular directories I was writing to were compressed, unknown to myself. After they decompressed those directories, the ArcPy Copy Tool worked like a charm with no error code(s).

‎11-03-2022

Vince: I talked with our IT Department regarding this issue. They say our Anti-Virus software shouldn't be affecting anything. However, if the drive folder is compressed/uncompressed, does that have anything to do with it? The drive folder I am writing too may be having issues due to that compress/uncompressed process our IT department has in place.

‎11-01-2022

Danny Thank you for the quick reply. Very simple solution and probably helps me build a couple dozen different trace result tools knowing the very basic elementary features of the trace tool.

‎11-01-2022

I am working with ArcMap 10.5.1 and ArcGIS Pro and recently, in the past few months, have been having issues using the Copy tool in my Python script and in ArcCatalog to copy my working GDB(s) from my local drive (C-Drive) to our network drivers (Y-Drive). The purpose of this is our network drives are backed-up each night versus the data on my local hard-drive. I have been getting ExecuteError: 000260: Failed to Copy. Not sure why this has become an issue since I have not had a problem in the past. I can copy the GDB from location to location on my local hard-drive, but NOT from the local hard-drive to a network drive. Any suggestions?

‎11-01-2022

I am working on putting together a series of custom traces on my Electric Utility Network model in ArcGIS Pro from the Utility Network from ArcSolutions. I have multiple different feeder and upstream traces built. The only one I am having issues trying to figure out how to configure is be tracing the system on a particular phase designation and identifying the number of Transformers and Services that are on that phase. The goal is to do the starting point at the substation and trace down-stream on a specific feeder (subnetwork) to produce those results. Any advice? Thank You in advance

‎10-31-2022

Rich: If I wanted to run a trace from a specific starting point and only have the result come back on a particular phase, how would I program that filter? Not having much luck with setting that up. Appreciate it

‎10-21-2022

I am using ArcMap. However, this script is being done outside of ArcMap/ArcPro in IDLE, stand-alone Python script that will eventually be combined into a series of Batch file(s).

‎10-21-2022

Jeff: Wondering, based on the existing code that I have there with the GDB table path and the Oracle table path and the fields, could you assist me with the proper way to write the code for updating the Oracle table via the Update cursor? Would greatly appreciate it since I am struggling with this big time.

‎10-21-2022

Thank you for the feedback. I will take a closer look at the newer cursor to see if that may get me better results. I looked at the pyodbc sql module and that might be possible as well. Yeah, I am accessing the oracle database thru a ArcGIS connection. I will look into the Oracle Python Package as well to see if that might work better compared to the update cursor.

‎10-21-2022

Good day: I am working on a project that requires me to take data from a file GDB table and update a non-gis table in an Oracle database. I have multiple Update Cursor scripts that I use to update GDB FC(s) and table(s) and have no problems with that. When I build the script to update the Oracle database table, I keep getting DBMS error [ORA-00923: FROM keyword not found where expected] I cannot figure out what is going on and how to fix this. The fields, to and from and path(s) are 100% correct. I've attached the update cursor python script. Is there something I am missing? I have 100% read/write permission on the Oracle database that is connected via an ODBC connection. Is it possible that the ObjectID in the GDB table is causing a conflict since it doesnt exist in the Oracle table? def AttributeUpdate(source_table, in_field, update_fields, join_table, join_key, join_values): # Make sure there is matching number of join and update fields update_dict = {} if len(update_fields) == len(join_values): for i in range(len(update_fields)): update_dict[join_values[i]] = update_fields[i] for k,v in update_dict.iteritems(): # Create Dictionary path_dict = {} srows = arcpy.SearchCursor(join_table) for srow in srows: keyrow = srow.getValue(join_key) valrow = srow.getValue(k) path_dict[keyrow] = valrow del srow, srows # Update Cursor urows = arcpy.UpdateCursor(source_table) for row in urows: upkey = row.getValue(in_field) if upkey in path_dict: row.setValue(v, path_dict[upkey]) urows.updateRow(row) else: pass # skip nulls del row, urows print '\'%s\' field in "%s" updated successfully' %(v, p.basename(source_table)) else: print 'ERROR: Number of update fields and value fields does not match' if __name__ == '__main__': DCSI = r'Database Connections\DCSI.sde\DCSI.MEWCO_TRANS_RATING' GDB = r'C:\Users\cwafstet\Documents\GIS WORKING FILES LOCAL\ELECTRIC\MEWCo ELECTRIC SYSTEM.gdb\MEWCO_TRANS_RATING' # Attribute Update DCSI_fields = ['XFMR BANK RATING'] GDB_fields = ['XFMR_BANK_RATING'] AttributeUpdate(DCSI, 'XFMR BANK ID', DCSI_fields, GDB, 'XFMR_BANK_ID', GDB_fields)

Online Status	Offline
Date Last Visited	a month ago

My Ideas

Latest Contributions by ModernElectric

Re: Multiple surveys linked to one Assignment Type

Enable Sync - Hosted Feature Layer - Unable to save

Re: ArcGIS Pro Stand Alone Scripts in Batch File

Re: ArcGIS Pro Stand Alone Scripts in Batch File

ArcGIS Pro Stand Alone Scripts in Batch File

Re: Copy GDB - Error 000260

Re: Copy GDB - Error 000260

Re: Utility Network - Trace - Specific Phase

Copy GDB - Error 000260

Utility Network - Trace - Specific Phase

Re: Custom Upstream Electric Trace to nearest Protective Device

Re: Python - Update Cursor - Oracle Database - ORA-00923

Re: Python - Update Cursor - Oracle Database - ORA-00923

Re: Python - Update Cursor - Oracle Database - ORA-00923

Python - Update Cursor - Oracle Database - ORA-00923

Re: Using Workforce? Check out the new, upcoming t...

Re: Flow error/fail to run notification

Re: Water Utility Network - Model Blow-Off

Re: Workforce Project Sync Delay & Ongoing Issues

Survey123 Power Automate Notification