Latest Contributions by MichaelVolz

jacobne: What do you mean by synchronize?  Do you mean putting the data together in the same projection? ... View more

renatognog: Is your data being consumed by an ArcGIS Server service or ArcIMS service?  If it is I would recommend a truncate and append process that bypasses schema locks that are in place from the above mentioned services.  DeleteRows_Management followed by Append_Management ... View more

Mathew: I do not have an answer for your question, but I am interested in the performance of your script. I have written a replacedatasource script for SDE layers that loops through a directory searching for mxds and then resourcing the SDE layers.  Unfortunately, the script eventually uses all the computer's RAM and it just hangs so I have to kill it in Task Manager. Would you know if the memory on your python script keeps increasing?  Your script might not have frozen because you did not process enough mxd files in your batch. Any insight on your script and system would be greatly appreciated.  Thanks. ... View more

Greg: Have you tried looking at python to accomplish this task?  It would probably result in a lot less code on your part.  In v10.1 you will be able to associate python code with buttons on a toolbar which should make this even easier. ... View more

Does anyone from ESRI have any ideas on how I would accomplish this goal in a bat file? Or is there another method of calling the python files that can be used?  I currently use the bat file to sequentially call python scripts so they proceed in a specific order making sure the previous task has been completed. As I said in the original Post, I need to add the full path to the python script and log files in the bat file on a Windows 2008 Server which I did not need to do in Windows 2003 Server.  Also I would like to use the txt file for the paths so it acts as a config file to be used by multiple scripts so 1 file can be changed for multiple scripts instead of needing to change multiple files. ... View more

Curtis: I think my original post might be a bit misleading.  The variables I am trying to pass into the bat file are the location of the the python script and the location of the log file generated from the bat file.  When I ran bat files as Scheduled Tasks in Windows Server 2003, I only needed to provide the name of the python script and log file because it understood it was a path relative to the location of the bat file.  Now on Windows Server 2008, the bat file never calls the python script or log file unless I supply the entire path to these files.  I want to store these paths in a text file to simplify the update of my system and the scripts that are used.  I have 2 reasons for this.  I can have multiple scripts that need the same python scripts, so I can use the text file to supply this information to all bat files.  In addition, if the location changes or this bat file is used on a different server, I only need to make the change in the text file and not each bat file.  I hope this clears up why I want to be able to read in information from a txt file in a bat file. ... View more

Jeremy: Here is a bat file example that calls a python script: @echo off set pyexePath="C:\Python26\ArcGIS10.0\python.exe" set pylogPath="C:\GIS\ServerProcesses\Bezier_Removal\Bezier_Remover_Simplify.log" set BezRemove_pyPath="C:\GIS\ServerProcesses\Bezier_Removal\01_Bezier_Remover.py" echo Start time: %time% > %pylogPath% REM Run the python script echo ------  Update time: %time% echo ------  Removing Bezier curves from RDCL in Transportation GDB  -------- echo ------  Removing Bezier curves from RDCL in Transportation GDB  -------- >> %pylogPath% %pyexePath% %BezRemove_pyPath% >> %pylogPath% echo End time: %time% >> %pylogPath% Here is the python script that this bat file is calling: # --------------------------------------------------------------------------- # Bezier_Remover.py # Created on: 2011-11-15 15:27:13.00000 #   (generated by ArcGIS/ModelBuilder) # Description: # --------------------------------------------------------------------------- # Import arcpy module import sys, string, os import arcpy import arcpy.mapping from arcpy import env import smtplib #E-mail library # Set environment arcpy.env.overwriteOutput = True # Local variables: RDCL_SRCH__2_ = "RDCL_SRCH" TRANS_RDCL_SRCH = r"\\Server\GIS\Enterprise\Data\transportation\Transportation.gdb\TRANSPORTATION_RDCL_SRCH" try:     print("Densifying TRANSPORTATION_RDCL to remove Bezier Curves")     # Process: Densify     arcpy.Densify_edit(TRANS_RDCL_SRCH, "DISTANCE", "25 Feet") except:         print arcpy.GetMessages(2)     SUBJECT = "Road Densify Script Failed"     TO = "[email protected]"     FROM = "Process_Server"     text = "Removal of Bezier Curves in Roads failed"     BODY = string.join((             "From: %s" % FROM,             "To: %s" % TO,             "Subject: %s" % SUBJECT ,             "",             text             ), "\r\n")     server = smtplib.SMTP('mail server address',mail server port #) #server = smtplib.SMTP(HOST)     server.sendmail(FROM, [TO], BODY)     server.quit() This is a very simple script that I have had running successfully on my Windows Server 2008 server for about 2 months now.  The script simply removes Bezier curves from a polyline feature class as the web application that uses this data, fails when working with Bezier curves.  I hope this helps you to solve your problem ... View more

Jeremy: I am also in the process of migrating python scripts from a Windows Server 2003 server to a Windows Server 2008 server.  I thought it was going to be a straight forward process, but it has been more difficult than I had expected. Do you call your python scripts from a bat file?  That is how I call my python scripts.  I did not need to modify the python scripts in the Windows Server 2008 server environment, but I did need to modify my bat files that called the python scripts. Some of the differences in the bat file syntax included: 1.) Need to call the python scripts using their full path - I was able to call the script in Windows Server 2003 because it recognized the relative path 2.) Need to call other dependent files (script log files) using their full path  - I was able to call the script in Windows Server 2003 because it recognized the relative path 3.) In order to make the bat file code more readable, I set variables for the path to the python script and log files and used these variables to reference the files throughout the bat file (again due to the fact that relative paths to dependent files of the bat file are not recognized) Unlike yourself, my code to generate an E-mail if errors were encountered worked without modification when I moved from Windows Server 2003 server to a Windows Server 2008 server ... View more

Miroslav: I have also created a script that performs this task but I do not need to specify credentials as you say when I open the new mxd.  Are you using the ReplaceDataSource method to make this server switch? Also, I have the script loop through all subfolders in a user selected folder where it targets mxd files and changes the SDE connection from one SDE server to another.  The problem I have is that the memory keeps building up until the script locks up.  Do you perform this script on one mxd at a time or is it a batch process? If its a batch process and you do not have a memory buildup, I would be interested in taking a look at your python code.  Thanks. ... View more

Felix: As a workaround you might want to write a script that just saves the file through python before running the BrokenLinks script.  Maybe the Save operation flushes out old SDE connections, but the SaveACopy operation does not.  Are the mxds that you are processing currently saved as v9.3 or earlier?  Or have these mxds been created or saved previously in v10? I had some issues where I tried to run python scripts on v9.3 mxds where they crashed python in v10 and I was unable to open the mxd in v10.  If I save the file in v9.3 or I saved the mxd back to v9.3 in python, the mxd would then open in v10.  It seems that this Save operation in v9.3 was flushing out bad or corrupt objects for v10. ... View more

Felix: I had a similar problem when I performed an SDE conversion from 9.1 to 9.3 using VBA.  In this case, we created another SDE database on a new server with ArcGIS v9.3.  After running this conversion, some layers were still looking for the 9.1 connections which caused the mxd to hang when opening because the 9.1 database and server was now retired.  I was unable to locate the old connections, so I added a dummy domain name to route the connections with the old server name to the new server name.  This solved the problem, but the mxd still contains references to the old server.  The only way to fix this is to recreate the entire mxd (time consuming and we have hundreds of files like this). It seems that the newly saved mxd might still have references to the old server which causes it to hang.  I guess saving it again outside of python removes these references as you are then able to open the mxd in a normal amount of time. Do you have any 3rd party software that is used in this mxd?  This could be a cause of your problems. Also, I would contact tech support and log an incident with them to see if the SaveACopy is supposed to flush out references to old servers.  I would be interested in the results as I will need to perform this operation on thousands of mxds when my organization migrates from Oracle Client 10g to either 11 or 12 depending upon when my organization is ready for this upgrade. ... View more

I have never had to perform this operation before, but maybe you should save the layer to disk in the new projected coordinate system.  Then try calculating the area on the new layer instead of the reprojected original layer. ... View more

Thanks for your reply with code Ben.  I believe that might work, but I think the following Post has a better solution: replaceDataSource not working in the same python forum The method that appears to work best is the UpdateLayer method.  This incorporates RemoveLayer and AddLayer in the same method and the task of tracking the index of the layer is bundled up for free with this method. ... View more