topic Re: make all of the data in fields uppercase in Python Questions

make all of the data in fields uppercase

Anonymous User — Sat, 11 Dec 2021 21:02:50 GMT

>>> import arcpy
... fc = r'O:\path here...\Storm.gdb\Storm\JunctionBox'
... 
... desc = arcpy.Describe(fc)
... fields = desc.fields
... 
... for field in fields:
...      if field.Type == "String":
...          with arcpy.da.UpdateCursor(fc, str(field.name)) as cursor:
...              for row in cursor:
...                  if row[0] == None:  # Check for "<Null>"
...                      continue
...                  else:
...                      any(x.islower() for x in row[0]) == True
...                      row[0] = row[0].upper()
...                      cursor.updateRow(row)

Hello all,

I have this code that I pieced together in the past with your help. But it references a specific feature class on my network. How can I get it to now reference my sql express geodatabase feature class instead? The feature class is in my mxd where I run this, so can I just reference the feature class within this current map document somehow?

Thank you in advance,

Andrea

Re: make all of the data in fields uppercase

JeffWard — Thu, 21 May 2015 20:07:28 GMT

You can get to SDE feature classes through your connection file:

"C:\\Users\\<yourusername>\\AppData\\Roaming\\ESRI\\Desktop10.whatever\\ArcCatalog\\SDEConnection.sde"

Re: make all of the data in fields uppercase

JoshuaBixby — Thu, 21 May 2015 20:10:03 GMT

If you drag a feature class from any source into the interactive Python window of ArcGIS Desktop, it will show you the path. If the SDE connection file is in your "Database Servers" or "Database Connections" folder in ArcCatalog, the path will be relative to those folder, but the path will still be valid for the currently logged in user. Jeff Ward shows what a full path would look like.

Re: make all of the data in fields uppercase

JasonTipton — Thu, 21 May 2015 20:42:56 GMT

Put an r in front of that string and you won't have to escape all of the slashes.

r'C:\some\path'

Re: make all of the data in fields uppercase

Anonymous User — Sat, 11 Dec 2021 21:02:53 GMT

I was really excited about this idea. The first time I tried it, it worked like a charm. But now I get the error message, even though I am in an edit session:

Runtime error 
Traceback (most recent call last):
  File "<string>", line 10, in <module>
RuntimeError: The requested operation is invalid on a closed state [Ozark.DBO.BoxCulvert][STATE_ID = 58]

Does anyone have any ideas?

Thank you,

Andrea

Re: make all of the data in fields uppercase

JoshuaBixby — Sat, 23 May 2015 16:03:31 GMT

What is your exact syntax? Your original syntax doesn't show any edit sessions. The error message indicates you either havent started editing after creating the edit session or you haven't started an operation yet. The help for arcpy.da.Editor has some really good examples.

Re: make all of the data in fields uppercase

Anonymous User — Sat, 11 Dec 2021 21:02:55 GMT

So it's sql express SDE geodatabase so I have to start editing because you can't make changes to it outside of an edit session but then I don't know why it's giving me the error message after that. I'm dragging and dropping the feature class from ArcCat to my python window. This code works great when it's in a file gdb. Is there more I have to change because it's in a sql express SDE geodatabase? Thanks.

>>> import arcpy
... fc = r'Database Connections\DEFAULT@Ozark.sde\Ozark.DBO.Storm\Ozark.DBO.BoxCulvert'
... 
... desc = arcpy.Describe(fc)
... fields = desc.fields
... 
... for field in fields:
...      if field.Type == "String":
...          with arcpy.da.UpdateCursor(fc, str(field.name)) as cursor:
...              for row in cursor:
...                  if row[0] == None:  # Check for "<Null>"
...                      continue
...                  else:
...                      any(x.islower() for x in row[0]) == True
...                      row[0] = row[0].upper()
...                      cursor.updateRow(row)
...                      
... 
...

Re: make all of the data in fields uppercase

NeilAyres — Sat, 11 Dec 2021 21:02:58 GMT

Are you not doing something like this in your code.

# start editing
edit = arcpy.da.Editor(DB)
edit.startEditing(False, False)
edit.startOperation()

Re: make all of the data in fields uppercase

LukeWebb — Tue, 26 May 2015 15:14:06 GMT

If you are running the script from ArcMap, then it should work with the edit session, however you are not referencing the "Layer" in the map, just pointing to it on disk, so that particular instance is not in an edit session!

In the TOC rename the layer to something like "EditLayer"

Then in the code, instead of pointing to the path on disk:

fc = r'Database Connections\DEFAULT@Ozark.sde\Ozark.DBO.Storm\Ozark.DBO.BoxCulvert'

try:

fc = 'EditLayer'

If this doesnt work, you will have to use Arcpy.Mapping to point to the mxd, and then find the layer within the MXD.

Alternatively, as Neil Ayres has said, start an end the edit session in the code! (Then make sure you are not in an edit session in ArcMAP else the layer may be locked)

Hopefully this makes sense and explains what is happening.

Re: make all of the data in fields uppercase

Anonymous User — Tue, 26 May 2015 15:14:22 GMT

Nope, I'm not. I didn't figure I had to since I manually start editing before I run the code. But after starting to read the help it looks like I need something like that.

Re: make all of the data in fields uppercase

Anonymous User — Tue, 26 May 2015 15:20:28 GMT

Yeah, I was originally pointing to it from the TOC also. That doesn't work either. So it's back to my original idea (left over from VBA days) where I thought I had to reference the layer in the mxd somehow. Like you mention. But instead of that I'm going to try and start and end the edit session in the code using the bit that Neil just showed me above. thanks.

Re: make all of the data in fields uppercase

Anonymous User — Sat, 11 Dec 2021 21:03:01 GMT

So three people actually helped me answer this question as I had to look at the help for arcpy.da.Editor to copy the sample code there. Thank you for your help! Code that works below.

import arcpy
import os

fc = 'Database Connections/DEFAULT@Ozark.sde/Ozark.DBO.Storm/Ozark.DBO.BoxCulvert'
workspace = 'Database Connections/DEFAULT@Ozark.sde'

#start an edit session. Must provide the workspace.
edit = arcpy.da.Editor(workspace)

#Edit session is started without an undo/redo stack for versioned data. So True for versioned data.
edit.startEditing(False, True)

#start edit operation
edit.startOperation()


desc = arcpy.Describe(fc)
fields = desc.fields

for field in fields:
     if field.Type == "String":
         with arcpy.da.UpdateCursor(fc, str(field.name)) as cursor:
             for row in cursor:
                 if row[0] == None:  # Check for "<Null>"
                     continue
                 else:
                     any(x.islower() for x in row[0]) == True
                     row[0] = row[0].upper()
                     cursor.updateRow(row)


#stop the edit session
edit.stopOperation()

#Stop the edit session and save the changes
edit.stopEditing(True)

Re: make all of the data in fields uppercase

ThomasColson — Wed, 27 May 2015 14:02:22 GMT

If youre database is a SQL SDE, you can use a function and trigger to do this real-time as data is edited. A slight modification of this SQL Code will do the trick, the modification being you'd have to alter the function to upper-case every character.