Latest Contributions by JamesFerne

‎02-04-2021

@DaltonBloom you may need to unzip (extract) the files once downloaded, and rename the extracted directory to be something other than 'Update_Aliases.tbx', as it also didn't appear for me, but when I renamed the directory that the Toolbox was in it appeared / would add to ArcGIS Pro. @Jordan I also experienced the 'Error: iterator should return strings, not bytes', on inspecting the toolbox script at the identified line it appears the csv is opened in binary mode. If you amend the text from; with open(in_csv, 'rb') as csvfile: to with open(in_csv) as csvfile: then it may work - as it appeared to start working for me. I am updating alias' to a PostgreSQL GeoDatabase to a table that has +1m rows and the tool is a bit slow at setting the alias', I could possibly have renamed them manually quicker - however using the tool will obviously free me up to do other things. To set the alias' for 92 attributes it took (my computer / Windows Surface Book 2) 57 minutes. I tried again with an empty table and it wasn't any quicker. Thanks to @MatthewLeonard for this solution, having explored FME (long winded) and ESRI user interface options (non-existent) this script is the best way I've come across to batch update many attribute alias' in one go, which is incredibly helpful

‎07-21-2020

No this won't be possible due to server capacities and our on-site infrastructure - we have outgrown our current allocated server, and will be moving our live RDBMS to a new server (which will co-incidentally get renamed with the old hostname to mitigate risk of services not working), and the old server will be allocated a new hostname.

‎07-21-2020

The ArcGIS Data Store (Managed Database) is on the same server as ArcServer. This will not be changing. The change is for RDBMS SDE (Database) which will move from one server (hostname) to another. By making this change I would anticipate services will stop working, as there will no longer be a database for it to connect to (as this database will be removed). I'm not sure the OS matters, and it isn't changing.

‎07-21-2020

Our organisation has ESRI Enterprise with an onsite Portal for ArcGIS. We are looking to migrate one or more of our RDBMS (PostgreSQL) SDE databases to a new server, and therefore a new hostname. Is there a method for performing such a migration without severing links to ArcGIS Server / Portal? Can the hostname be updated in bulk (perhaps in the Data Store sources somehow), as all other references will remain the same (the database and registrations will be backup / restored with the same values)? Otherwise is it a case of republishing all services (which seems a little cumbersome)? Edit 1: I guess I need to add a new data store (pointing to the new host) and update the services so they look at this new data store (this would not be every service on our ArcServer). Is there a way of doing this? Edit 2: I have noticed on looking in the data store it is possible to 'Edit Database Connection', so will test if keeping the 'Name' the same but changing the 'Publisher Database Connection' alters associated services to this Data Store to point to the new location. Edit 3: Attempting to alter the 'Publisher Database Connection' did not work, an unhelpful error icon was displayed without details. I then tried updating the 'Server Database Connection', restarted the web service, and it is now reading the data from the new host. This is useful, as I can edit all our Data Store RDBMS connections and it will en masse change the service sources. This will be useful in the future when we want to divide our RDBMS onto further servers in order to increase redundancy and improve query performance as we scale users.

‎08-05-2019

A list of dependencies would be really helpful in being able to manage Portal content more effectively. A great suggestion.

Online Status	Offline
Date Last Visited	‎08-04-2022 05:42 AM

My Ideas

Latest Contributions by JamesFerne

Re: Batch Update Aliases

Re: Migrate a RDBMS to a new hostname. Can the Data Store be updated so that ArcServer / Portal references to the data aren't lost?

Re: Migrate a RDBMS to a new hostname. Can the Data Store be updated so that ArcServer / Portal references to the data aren't lost?

Migrate a RDBMS to a new hostname. Can the Data Store be updated so that ArcServer / Portal references to the data aren't lost?

Re: When deleting / un-sharing a layer, warning of what maps / apps may be disrupted as a result!

Re: When deleting / un-sharing a layer, warning of...