Latest Contributions by CortWilson

Kim, Did you find a solution for this?  I need to do something similar with our water distribution system. Were you using the snap geoprocessing tool? ... View more

LarryAdgate‌ & rastrauch‌ Sure!  Give me a bit to strip out any sensitive information from the script and add in some more descriptive comments. If you don't hear from me within a few days give me a shout. ... View more

A little late to your post, but figured I'd put in my $0.02.  Hopefully you've found a solution that will work for you! We are a small-ish sized water utility: 27,000 service connections on over 600 miles of water main.  I am using python to automate the reconcile-post process.  It works well for us because there are only 3 of us editing at one time and rarely are there any conflicts.  I perform QAQC edits in the DEFAULT version and favor all conflicts towards that version, and that's good enough for me.  If the automated conflict resolution is a concern, you can set a parameter in the script process to abort if any conflicts are found, review the conflicts, then re-run the script.  You might want to re-search the implications of aborting the process when a conflict is found.  One problem of course is that usually you would want to run the script after-hours or on the weekends and now that possibly leaves you attached to reviewing conflicts after hours.   I built in error handling throughout the script and have it write to a SQL Server logging table the specific error that was found or if the script was run successfully.  A SQL Server trigger on the logging table or function in python to send an email after an error is raised would take it to the next level; I have yet to do that....   In general, I have found automating the process to be a big help.  There are many errors that can be introduced when doing this process manually, and hard-coding in all the steps in the right order has reduced a lot of headaches for me. ... View more

What to do if the permission changes wont take effect?  Tried multiple times to make the changes and they wouldn't take.  Called ESRI support and they said to re-boot; only after re-boot did the changes take effect. ... View more

Step 1: Grant read/write Using SQL server management studio expand the security tab, then the logins tab open the properties for the AGS server account login (by default the username is "arcgis" and it could be a domain or local user), then click User mapping in the top pane, select the db in question now in the bottom pane check the boxes nect to datareader and datawriter roles click ok Step 2: Remove AGS account from sysadmin server role Expand the security tab, expand the Server Roles tab open the properties for the sysadmin role select your AGS account user and click "remove" Step 3: reboot the server. I had our IT department do this for me. ... View more

Thank you. I mapped the ArcGIS Server account to all of it's associated databases with read/write privileges, then removed it from the sysadmin server role, and then had to re-boot the server for the changes to take effect. ... View more

Confusing. I can see why many people would make the same mistake as me.... Thanks again. ... View more

Was I incorrect to have "home" at the end? or is there another issue? ... View more

I was using https://<domain-URL>/webadapter/home I removed "home" from the end and tried logging into collector.  It works! Thank you so much! ... View more

Ok, Yes, it is fully secure and there is no wildcard certificate assigned. ... View more

Aravind, thanks for the reply! Not coming from GoDaddy.  I'll have to check with our IT Dept to find if it is a wildcard certificate. The cert is issued by thawte SSL CA - G2 (not sure if that says anything about it being a wildcard or not)..... ... View more

Built-in named user.  I am using the initial administrator username and password to try and sign in on Collector. ... View more