Latest Contributions by LorindaGilbert

Hi All, Is there a way in ArcPro that I could first test that a field has a value, if it doesn't, then have it select a value from a specific attribute in another feature class or a map service?  It would have to be from something that we don't have as a feature service since the data we are pulling the attribute from is not owned/maintained by us. Edited:  Reason for looking for an attribute rule method is that the client doesn't necessarily want to use a web app for editing the data.  Wants to learn to use ArcPro, but data edited has specific items to be added and calculated as data entered.  Moving from stored procedures in Oracle forms to graphic editing. Thanks, Lorinda ... View more

Hi All, Working on setting up a project and the client has asked if there is a way to enforce a column's value to always be upper case.  I see the arcade function of Upper(value), tested it and it didn't do what I expected. Any sage advice out there for how to do this?  It will be published to be used in a web app as well. Thanks, Lorinda ... View more

Hi, We're in the process of upgrading servers from 2012 to 2019 - both OS and SQL Server.  We have licenses for both Enterprise and Standard SQL.  What are the pros and cons of each?  We have at least two servers that will have the potential of several thousand users hitting it, the others will be limited to about 100 or less users, but could have heavy geoprocessing performed against the data stored there. Thanks, Lorinda ... View more

Hi All, Have spend many a day working on getting syntax correct for Attribute Rules in ArcPro to be able to publish a map/feature service to our enterprise portal for use in a web app.  Rules work as expected in ArcPro, but do not seem to be working in either Smart Editor or Editor widgets.  Nor do they work in the web map while editing. I've published with a registered datasource, saved the attribute rules in the project (and in the sde where the data is living - as evidenced by not being able to do anything to the data via arccatalog), added the updated feature service to the web map Have I missed something here? Thanks, Lorinda ... View more

Hi All, I'm creating attribute rules for a project and believe that I need to publish the data as a hosted feature service rather than a feature access service.  My question is where does this data actually get stored?  I think I read that it was a PostgreSQL database at one time (even though our enterprise data is in SQL Server).  If this is the case, what is the name of the database and where is it located?  I need to be able to perform backups of the data as it is parcel sensitive data that must be reported on each year.  We will also be moving our streets and situs address layers to this format, that also has to be backed up nightly or twice a day.  I've found the command line for performing the backup, but do need to know the name of the database as well.  We have a federated Portal, so if the hosted feature service can be in our enterprise database, that would be great, it already has scheduled jobs for backups. Additionally, if it is a hosted feature service that is not in the enterprise database schema, since I also need to be able to show this data in web apps, how do I publish a map service for viewing?  All of the services will need to be able to be viewed via an enterprise wide map service.  Also, can this data be set up for replication in order to have outside the firewall?  If not, then as long as I can locate the data in the database, I can set up FME (data interoperability) to be able to update the data in child databases. I'm new to this part of the equation and need to set it up as efficiently as possible with little to no chance of data integrity failure. Thanks, Lorinda ... View more