topic Re: Save the edits before disconnecting users form an enterprise geodatabase in Data Management Questions

Save the edits before disconnecting users form an enterprise geodatabase

AhmadSALEH1 — Fri, 27 Feb 2015 16:31:33 GMT

Hello All,

Is there any method that enables the Administrator to save the users edits before disconnecting them for an enterprise geodatabase. Because I am disconnecting users as shown in the screenshot, but if they didn’t save their edits before disconnecting them all edits will be lost.

I am using ArcGIS 10.2.2 , and SQL server 2014

Thanks,

Ahmad

Re: Save the edits before disconnecting users form an enterprise geodatabase

AsrujitSengupta — Mon, 09 Mar 2015 15:22:13 GMT

No. there is no such way to automatically notify them or save the edits done till that point.

Re: Save the edits before disconnecting users form an enterprise geodatabase

AlicePence — Mon, 09 Mar 2015 15:26:18 GMT

I kinda use of version of this python script to let the people who are connected know when I'm doing any kind of maintenance on our geodatabases.

Re: Save the edits before disconnecting users form an enterprise geodatabase

AhmadSALEH1 — Mon, 09 Mar 2015 15:43:28 GMT

Many thanks Alice, but where should I past this code since I have no experience in scripting using python, and how could I create user lists and there emails ? I will be very thankful if you provide me with screenshots

Regards,

Ahmad

Re: Save the edits before disconnecting users form an enterprise geodatabase

AlicePence — Sat, 11 Dec 2021 09:49:44 GMT

Within ArcCatalog or ArcMap there is a Python tool found here:

Then all i do is copy the code from the link I gave above into the python box:

# get a list of connected users.
userList = arcpy.ListUsers("Database Connections/admin.sde")
# get a list of usernames from the list of named tuples returned from ListUsers
userNames = [u.Name for u in userList]

And we don't have very many people on our databases so from here I can usually just write a quick email to the few that are on. I just keep a draft of the generic email I send out, so i can pull it up and send it real quick and not have to retype it every time. The draft email pretty much looks like the one in the link -short and simple: Server maintenance will be performed in 15 minutes. Please log off

And if they don't log off by the time I give them, then they will lose their edits.

Re: Save the edits before disconnecting users form an enterprise geodatabase

AhmadSALEH1 — Mon, 09 Mar 2015 19:45:04 GMT

Many thanks Alice for your prompt help.

excuse me for my new naif question, I am trying first to get the list of users who are connected to the enterprise geodatabase "Admin"

in my case I have two users ( user1 and user 2 )

But when I past the code:

userList = arcpy.ListUsers("Database Connections/admin.sde")

nothing happens, what other issues should I consider ?

Best Regards,

Ahmad