The script below iterates through a folder and determines what version of ArcMap (9.0 - 10.5) each MXD was saved in then writes to a text file. The file is saved with the string in line 11. It's telling me this script also has a syntax error in line 11, but I can not see why? I'm running PythonWin 2.7 on Windows 10. What I want is to have the file named after the directory (i.e. whatever the user puts in the workspace parameter of the script tool). Is there a way to do that? import glob , os , sys from oletools . thirdparty import olefile import arcpy arcpy . env . overwriteOutput = True Workspace = arcpy . GetParameterAsText ( 0 ) mxdFiles = glob . glob ( os . path . join ( Workspace , '*.mxd' ) # Write to textfile txtFile = open ( Workspace + "{}" . format ( "Identify ArcMapVersion.txt" ) , "w" ) txtFile . write ( "The folling list is the file path(s) to the MXD(s) followed by the ArcMap version" + "\n" ) txtFile . write ( "-------------------------------------------------------------------" + "\n" ) def mxd_version ( filename ) : ofile = olefile . OleFileIO ( filename ) stream = ofile . openstream ( 'Version' ) data = stream . read ( ) . decode ( 'utf-16' ) version = data . split ( '\x00' ) [ 1 ] return version for mxdFile in mxdFiles : fileName = os . path . basename ( mxdFile ) print mxdFile , ( mxd_version ( mxdFile ) ) arcpy . AddMessage ( "\t Successful: " + mxdFile + " " + ( mxd_version ( mxdFile ) ) + "\n" ) txtFile . write ( "\t Successful: " + mxdFile + " " + ( mxd_version ( mxdFile ) ) + "\n" ) arcpy . AddMessage ( "------------------All MXDs Completed-------------------" ) txtFile . write ( "------------------All MXDs Completed--------------------" ) txtFile . close ( )

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; } } }

Write to Text; Directory Name

JaredPilbeam1

The script below iterates through a folder and determines what version of ArcMap (9.0 - 10.5) each MXD was saved in then writes to a text file. The file is saved with the string in line 11. It's telling me this script also has a syntax error in line 11, but I can not see why? I'm running PythonWin 2.7 on Windows 10.

What I want is to have the file named after the directory (i.e. whatever the user puts in the workspace parameter of the script tool). Is there a way to do that?

<SPAN class="keyword token">import</SPAN> glob<SPAN class="punctuation token">,</SPAN> os<SPAN class="punctuation token">,</SPAN> sys
<SPAN class="keyword token">from</SPAN> oletools<SPAN class="punctuation token">.</SPAN>thirdparty <SPAN class="keyword token">import</SPAN> olefile
<SPAN class="keyword token">import</SPAN> arcpy

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

Workspace <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>
mxdFiles <SPAN class="operator token">=</SPAN> glob<SPAN class="punctuation token">.</SPAN>glob<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>Workspace<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'*.mxd'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Write to textfile</SPAN>
txtFile <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>Workspace <SPAN class="operator token">+</SPAN> <SPAN class="string token">"{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Identify ArcMapVersion.txt"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"w"</SPAN><SPAN class="punctuation token">)</SPAN>
txtFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"The folling list is the file path(s) to the MXD(s) followed by the ArcMap version"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\n"</SPAN><SPAN class="punctuation token">)</SPAN>
txtFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"-------------------------------------------------------------------"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\n"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">mxd_version</SPAN><SPAN class="punctuation token">(</SPAN>filename<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; ofile <SPAN class="operator token">=</SPAN> olefile<SPAN class="punctuation token">.</SPAN>OleFileIO<SPAN class="punctuation token">(</SPAN>filename<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; stream <SPAN class="operator token">=</SPAN> ofile<SPAN class="punctuation token">.</SPAN>openstream<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Version'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; data <SPAN class="operator token">=</SPAN> stream<SPAN class="punctuation token">.</SPAN>read<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>decode<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'utf-16'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; version <SPAN class="operator token">=</SPAN> data<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'\x00'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> version

<SPAN class="keyword token">for</SPAN> mxdFile <SPAN class="keyword token">in</SPAN> mxdFiles<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; fileName <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>basename<SPAN class="punctuation token">(</SPAN>mxdFile<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> mxdFile<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN>mxd_version<SPAN class="punctuation token">(</SPAN>mxdFile<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\t Successful: "</SPAN> <SPAN class="operator token">+</SPAN> mxdFile <SPAN class="operator token">+</SPAN> <SPAN class="string token">" "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="punctuation token">(</SPAN>mxd_version<SPAN class="punctuation token">(</SPAN>mxdFile<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\n"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; txtFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\t Successful: "</SPAN> <SPAN class="operator token">+</SPAN> mxdFile <SPAN class="operator token">+</SPAN> <SPAN class="string token">" "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="punctuation token">(</SPAN>mxd_version<SPAN class="punctuation token">(</SPAN>mxdFile<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\n"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"------------------All MXDs Completed-------------------"</SPAN><SPAN class="punctuation token">)</SPAN>
txtFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"------------------All MXDs Completed--------------------"</SPAN><SPAN class="punctuation token">)</SPAN>
txtFile<SPAN class="punctuation token">.</SPAN>close<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

IanMurray

The open function requires a valid file name(it doesn't have to exist, it just has to be a file, right now you are using a directory as the input, which probably causing the issue.).

If you are needing to use the name of the folder that the txt document is being saved in as the name, I would use os.path.basename to get the name of the folder you are operating in then use that as the name of your text document.

Something like this:

file = os.path.join(Workspace, "{}" .format(os.path.basename(Workspace) + ".txt"))

https://docs.python.org/2/library/os.path.html#os.path.basename

All comments

JaredPilbeam1

@ Ian. Thanks, I understand what you're saying, and I was able to run it with os.path.join() as such:

<SPAN class="comment token"># Write to textfile</SPAN>
file <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>Workspace<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"MXDS.txt"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> file
txtFile <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>file<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"w"</SPAN><SPAN class="punctuation token">)</SPAN>
txtFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"The folling list is the file path(s) to the MXD(s) followed by the ArcMap version"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\n"</SPAN><SPAN class="punctuation token">)</SPAN>
txtFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"-------------------------------------------------------------------"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\n"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

And the script ran fine and saved the text file as "MXDS", as the string has it doing. But now I realize I wasn't really asking for the correct procedure. What I really want it to do is save as the workspace folder name. So, when the user is running the script tool the folder being saved to will be what the text file is named.

I tried a couple things such as:

<SPAN class="comment token"># Write to textfile</SPAN>
file <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>dirname<SPAN class="punctuation token">(</SPAN>Workspace<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> file
txtFile <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>file<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"w"</SPAN><SPAN class="punctuation token">)</SPAN>
txtFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"The folling list is the file path(s) to the MXD(s) followed by the ArcMap version"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\n"</SPAN><SPAN class="punctuation token">)</SPAN>
txtFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"-------------------------------------------------------------------"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\n"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

and got the following error (line 21 in error is line 4 above):

Tried this:

<SPAN class="comment token"># Write to textfile</SPAN>
<SPAN class="comment token">#file = os.path.dirname(Workspace)</SPAN>
<SPAN class="comment token">#print file</SPAN>
txtFile <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>Workspace<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"w"</SPAN><SPAN class="punctuation token">)</SPAN>
txtFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"The folling list is the file path(s) to the MXD(s) followed by the ArcMap version"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\n"</SPAN><SPAN class="punctuation token">)</SPAN>
txtFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"-------------------------------------------------------------------"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\n"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

and got the same error.

Any ideas?

IanMurray

I'd use a print statement on Workspace + "{}".format("Mapbook_MXDs.txt") to make sure its creating the output you think it should. I think you are getting the wrong output due to the fact you are trying to concatenate your workspace and file name but don't have another backslash seperator to have the folder and file name separate. Why not use os.path.join as you did previously?

JaredPilbeam1

To be a bit clearer:

This line...

txtFile <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>Workspace <SPAN class="operator token">+</SPAN> <SPAN class="string token">"{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Mapbook_MXDs.txt"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"w"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

...saves as a text file, in a workspace folder named "Townships", as such:
TownshipsMapbook_MXDs

I want to have the text file saved as:
"Mapbook_MXDs"

JaredPilbeam1

Thanks Rebecca, that was it.

The bigger problem is arranging the script to get it to save with the directory name instead of what I have as the string in line 11-- "Identify ArcMapVersion.txt". When using the script tool I have it set up with only one parameter, the workspace folder. How can I change the script to have the text file saved as the name of the folder where the user is saving?

I've tried changing things around in line 11, but I only got errors as the open() function parameters can't be changed.

RebeccaStrauch__GISP

See if the missing ) in line 8 is the issue.

I always look at the preceding line first, if I get a syntax error I can't find in the line it says is in error.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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