Latest Contributions by BenVan_Kesteren1

No you are 100% correct, I have only just now re-looked at this problem I listed a couple of months ago and it has clicked (i'm slow thats for sure! haha). I can simply list all versions, then reconcile said versions then delete. I will give this angle a go. Thanks for your help all. PS. Can someone confirm that if a user forgets to reconcile/post before I delete the version, all the add/deletes will be lost during a compress? Or are they lost as soon as the user is deleted? And secondly, if a user does forget, and I were to use reconcile version tool, do these two options achieve the exact same thing? There is no difference between me forcing the reconcile and the user remembering to? Thanks for the help. ... View more

I have just tried adding the newly created Mosaic Dataset to a MXD to publish as map service, but it says I do not have Imagery Licence in order to do this... so it looks like I need to find another way to server this image to all other users.... Back to drawing board.... I have looked at what my predecessor (recently retired) had done in the past, it seems he has somehow created a raster on a server and added it that way. It must be a different licence using a mosaic than using a raster. Strange.... Thanks ... View more

So I have just created a mosaic dataset. I then right clicked and add raster. (see screenshot for window), then clicked ok, and it seems the raster is visible by my by single clicking the mosaic in ArcCatalog and looking at the preview window. I assume because it took < 1min to do that this is just a reference to the ECW on my network drive? It did not move a copy of it? The aerial photo I want to make available currently resides on a network share that only people in my dept can view, will this cause a problem? The alternative solution I can think of is that I move the aerial onto the C drive of my server, and make a copy of this folder (for example C:\Aerial2014) and set it up on my PC to reference the C drive, then when it is added to the mosaic will it look on the server C:\Aerial2014 instead of my PC?? Im a little new to working with rasters. Cheers ... View more

Excuse my n00bidity, but where would a default *.mxd be found?? Thanks ... View more

Hi, Did you end up finding a solution to this problem? Have you got it working now? Thanks -Ben ... View more

ah excellent, good point. Yes all the users are informed to reconcile or post each week prior to my weekly maintenance. This is generally successful, but as people are sometimes away at last minute we try to hold off the maintenance until everyone is at work. One thing I would like to consider, is reconcile/post on everyone's behalf. It is very unusual for someone not to want to reconcile/post each week, so to elimate this user error possibility I would like to automate it, so this is something else I am looking at setting up during this process. I have just had a quick look at the Reconcile Versions tool, and it is exactly what I am looking for, thanks for that Jake Skinner‌, greatly appreciated. ... View more

Hi Owen, thanks very much for that, has worked well for this little script. So are you saying that print statements are not recognised by this ESRI window at all? I need to use AddMessage and AddWarning instead from now on? Thanks again. ... View more

Just to give you a better idea of my problem, the below script returns a list of Users currently connected to my SDE... this script is only useful if i run it from the CMD window, if I run it from Catalog as a script it displays the window shown in my first post.. and as you can see it does not return a list of connected users. Cheers #------------------------------------------------------------------------------- # Name:        Find current users connected to SDE # Purpose:      This script is specifically written to be able to return a #               list of all current users connected to the SDE_Spatial database. # # Author:      Ben Van Kesteren & Nathan Duncan # # Created:     14/11/2014 # Copyright:   (c) Ben Van Kesteren 2014 # #------------------------------------------------------------------------------- import arcpy import csv def main():     PCNameKey = pc_name_key()     UserList = user_list()     outputFinal = output(PCNameKey, UserList)     for name in outputFinal:         print name   print name     print "\n" + str(outputFinal)+ "\n"     ## Creates a dictionary from the listed CSV file def pc_name_key():   reader = csv.reader(open('H:\\GIS Admin\\PCNumbers.csv'))   key_dict = {}   for row in reader:   key = row[0]   if key in key_dict:   pass   key_dict[key] = row[1]   return key_dict def user_list():   # Set the admistrative workspace connection   arcpy.env.workspace = "H:\\ESRI SDE Connections\\GISADMIN@[email protected]"   user_list = arcpy.env.workspace   # Create a list of users   '''   NOTE: When the arcpy.env.workspace environment is set, a workspace   does not need to be provided to the function.   '''   users = arcpy.ListUsers(user_list)   # Create a list of SDE connected usernames.   id_users = [user.ClientName for user in users]   current_users = []   for user in id_users:      if user != str(u'gisserver'):          user = user.upper() # set PC Numbers to uppercase          user = str(user)          if user in current_users:              pass          else:              current_users.append(user)      else: pass   # Count all users currently connected   total_users = len(current_users)   # Print the total number of users currently connected   if total_users > 0:        print "\nTotal number of connected users " + str(total_users) + "\n"   else:        print "\nNo Users Connected\n"   return current_users def output(PC_Key, name_list):     output_list = []     for id in name_list:         if id in PC_Key:             output_list.append(PC_Key[id])         else: pass     return output_list ## Boilerplate if __name__ == '__main__':   main() ... View more