nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Read a MXD file and change all comma and blank spaces to nothing with Python, how to?

OskarKarlsson2

I am going to upgrade a system from ArcIMS to ArcGIS Server and the MXD documents that ArcIMS used contained commas and blanks pace.
In ArcGIS Server they can not contain commas or blank spaces. I will get a error message if I use it.

Is there someone that has a Python Script that reads a MXD file and changes the comma (,) and blank spaces to nothing?

Best Regards
Oskar

Vind meer berichten getagd met

Accepted answers

All comments

BruceNielsen

This may not be the most efficient or elegant, but it works:

newName=''.join(''.join(oldName.split()).split(',')) #All of the quotes are single quotes

OskarKarlsson2

But the other thing is that I have about a hounded MXD documents that I want to change the layer names within the Map document. Is there a script that will do this automatically?

Thanks for your response!

BruceNielsen

Assuming that you're using ArcGIS 10, you will have to write a script that loops through all of the MXDs. Within that loop is another loop that works through all of the layers, and applies the changes.

I'm stuck at 9.2, so I can't help you on that part. I believe that some other posts in this forum may give you some clues on how to accomplish it.

Good Luck,

JakeSkinner

Here is an example on how to do this:

import os
workspace = r"C:\temp\python"

for (path, dirs, files) in os.walk(workspace):
    for file in files:
        if ".mxd" in file.lower():
            if "," in file:
                str = os.path.join(path, file)
                new = str.replace(",", "")
                os.rename(str, new)
            elif " " in file:
                str = os.path.join(path, file)
                new = str.replace(" ", "")
                os.rename(str, new)

You will just need to update 'workspace = r"C:\temp\python"' with the directory that contains the MXDs. The example above will also loop through all sub directories.

OskarKarlsson2

Thanks Jake S but the intention of the script is not to change the name of the MXD file but to change the name of each layer within the MXD file.

But the script works great to change the name of the MXD. 😃
I think I am going to learn to script in Python it seem like a great language to program in.

I simply want to change the layers namne Conturs, height to Contursheight inside of a MXD document.

Is there some way to do this?

Grateful for the help!

// Oskar

JakeSkinner

Sorry for the misunderstanding. Here is an example on how to change the layer names:

import arcpy, os
from arcpy import env
from arcpy import mapping
env.workspace = r"C:\temp\python"

env.overwriteOutput = True

for (path, dirs, files) in os.walk(env.workspace):
    for file in files:
        if ".mxd" in file.lower():
            mxd = os.path.join(path, file)
            mxd = mapping.MapDocument(mxd)
            for df in mapping.ListDataFrames(mxd, "*"):
                for lyr in mapping.ListLayers(mxd, "*", df):
                    if " " in lyr.name:
                        lyr.name = lyr.name.replace(" ", "")
                for lyr in mapping.ListLayers(mxd, "*", df):
                    if "," in lyr.name:
                        lyr.name = lyr.name.replace(",", "")
            mxd.save()
            
del mxd

OskarKarlsson2

Thanks works absolutely perfect!

You have inspired me to program for myself in Python and have started to do so now.

Thanks a lot!

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.