Latest Contributions by lelaharrington

if it helps these are sql servers i am trying to basically tell the script if the old connection is something like WBlmnpoGOGIS04 server then now connect to the KCF GIS PROD on KCF-GLE-SQL1.sde. i just don't know who to write the connections in. ... View more

yes! that is the script i am using however the part on it that says mxd.findAndReplaceWorkspacePaths(r"C:\Project\Old Connection.sde..." that is the part i cannot seem to get right. if my SDE is a database connection in arc catalog how to i write the C:\Project. part? ... View more

i have and i honestly cant understand it. i have the connection it needs to go to and the connection it came from but i an not sure how to actually write it ... View more

Thank you. I am interested to see the repair script as that is my goal as well. to repair some of the broken sources. I know that some I will have to manually repair but if I can identify all broken sources and repair like 50 % of them even that is better than manually opening each one. ... View more

ok so I tired this. here is my script. it still never got past the first three mxd's with the last one having a broken table source in it. yes yes I can fix that table... but I need this to walk thru an entire F: and tell me where all and any broken sources are... even if it is just noting " hey there is a broken source here" ... View more

here is the script that i used in case any others run into this. this works!!! and it generates a log for you. import arcpy, time, os, sys from subprocess import * arcpy.env.overwriteOutput = False import arcpy, time, os, sys Date = time.strftime("%m-%d-%Y", time.localtime()) Time = time.strftime ("%I:%M:%S :p",time.localtime()) LogFile = file(r"C:\UGM_Projected\Scripts\TEST_1_" + Date + ".txt", 'w') Generate = open(r"C:\UGM_Projected\Scripts\TEST_1_" + Date + ".txt", 'w') Generate.write("Script Started At: " + str(Date) + " " + str(Time) + "." + "\n") #run child script 1 p = Popen([r"C:\UGM_Projected\Scripts\UDF_FeatureclasstoSHP.py", "ArcEditor"], shell=True, stdin=PIPE, stdout=PIPE) output = p.communicate() print output[0] Generate.write("Success!! UDF_FeatureclasstoSHP.py" + str(Date) + " " + str(Time) + "." + "\n") #run child script 2 p = Popen([r"C:\UGM_Projected\Scripts\SHP_FeatureClass.py", "ArcEditor"], shell=True, stdin=PIPE, stdout=PIPE) output = p.communicate() print output[0] Generate.write("Success!! SHP_FeatureClass.py" + str(Date) + " " + str(Time) + "." + "\n") #run child script 3 p = Popen([r"C:\UGM_Projected\Scripts\Delete_SHP.py", "ArcEditor"], shell=True, stdin=PIPE, stdout=PIPE) output = p.communicate() print output[0] Generate.write("Success!!  Delete_SHP.py " + str(Date) + " " + str(Time) + "." + "\n") # reset date and time from when  started lDate = time.strftime("%m-%d-%Y", time.localtime()) lTime = time.strftime("%I:%M:%S %p",time.localtime()) Generate.write(str("Script Ended at  " + str(lDate) + " " + str(lTime) + "." )) Generate.close() now = time.time() print "Script Complete" ... View more

Thank you i will try this in the next coming weeks and report back my findings. ... View more

Thank you all for your information on this. here is what i finally went with. imported arcpy,os from subprocess import * then i ran 4 child scripts after i converted each model to a script. i then called each script as a child script, had log findings embeded in the script to report back success ... View more

so is the test data the folder with the sub folders in it? and then it pulls the feature class name and then converts it to the gdb? ... View more

ya but how do you put that together. walk thru this folder and when you get .shp move it to mdb.? ... View more