Latest Contributions by CalvinHarmin

@RyanUthoff thanks for this idea I think that's a fantastic option for federated Enterprise instances. If anyone on 12.x can share a screenshot of what that About > Patches page looks like I would be curious to know! ... View more

This is a shot in the dark but is sa just the super-admin user for the SQL Server instance? Is it possible there is another user/schema that is the owner of the enterprise gdb? I recall when creating egdb's in SQL Server there are a couple different ways you can set up the schema model and maybe although sa can see everything, it may not behave the same as the actual database owner or other users with read/write permissions enabled within Arc- ecosystem.  ... View more

I can definitely see the confusion and desire to know more about potential free connectors to enable you to work with Arcgis* resources, whether that may be Portal, ArcGIS Online, or otherwise.  To my knowledge, the Survey123 connectors remain free (non-premium). However, as you can see, the other main Arcgis connectors for ArcGIS Online or Enterprise are premium connectors.  Further, the ability to make actions using the built-in HTTP action - meaning any use of REST API calls via HTTP actions within Power Automate - is also a premium feature.  So besides the Survey123 connectors, I'm not sure what other methods are available for interacting with Arcgis resources that are not locked behind a premium power automate license. I hope someone else may be able to follow up with more context, and maybe there are actually ways to do it. That said, a single power automate premium license is fairly economical (~$15/month for my local government tenant), but the red tape in your - or anyone's - business use case may a daunting task to get  through if you have to go through layers of organizational, financial, or IT/security gauntlets. ... View more

That makes perfect sense! I wasn't sure if you were using the 'unified' Light Grey Canvas or the 'sandwich' version with the split reference/base. Sandwich is a great term for that  😄 ... View more

I'm curious about your goal for exporting and analyzing/displaying these results. Is it only for your own internal purposes of reviewing the data? Is the Survey123 'Analyze' tab (which I believe shows descriptions rather than codes values) too limited for your needs? ... View more

Hi Dennis, would you be able to paste your calculation expression here so we can see it and it might provide more context or clues to what might be happening? In my experience there can also be some unintuitive behavior when using subtypes, since each subtype can have their own domain and default values settings independent from the other subtypes and independent from the 'Data Source' field settings. I might be able to try to reproduce your calculation on my end and see if I'm having the same behavior.  ... View more

When you say “interface” are you thinking of an ArcGIS Enterprise or Online experience builder app? That opens up plenty of opportunities to filter these particular records and display them within that kind of interface in their own special way. ... View more

After we established our proof of concept after setting up the Azure SAML settings, I put a pin in the project temporarily as we have had to tackle some other projects. So unfortunately I don't have much in the way of further testing or "aha's" to share.  But on my end I did notice some new avenues for testing: When you have a SAML login configured and enabled, you will see some new options for adding users. One of these is : This lets you send an email to individual users, or any number of users via a list (CSV) with the fields of Email, Role, and User Type, that you can specify. The user gets an email with a link to basically log in with only the SAML login option and you can pre-configure the Role and User Type with CSV, or, individually, you can go ahead and configure the normal new user options for Add-On licenses, groups, etc.  However, after you invite with this method, the user account doesn't automatically show up in the Members list. The user only shows up after the user logs in. So I'm not sure how much that helps besides just notifying the user that they should login. You would still have to transfer content, assign groups and licenses if you didn't already, etc.  Regarding Transfer Content, there is an interesting new option I didn't notice before where you can 'Transfer member' (limited documentation) from one existing member account to another account. This includes the ability to transfer user Type, Role, and add-on licenses, and Content! However, strangely... it doesn't seem to transfer the user's group assignments to the other user in my quick test. So that may need some testing to see the limitations of what is- and isn't- transferred.  I have heard elsewhere that ESRI support may be able to help transfer ESRI community and training records, but I don't know if that's true or how that would work if you have many users you want to transfer records like that. So, in conclusion... you may have the best experience if you can retain your existing user accounts, and have the SAML login create a different username. Then you could at least perform certain 'transfer' options from one user to another, but again it doesn't seem to be complete in terms of tranferrring everything  😞  So that would need some more testing.  ... View more

This is somewhat related: I think the gist of this previous idea is to have the field order and visibility settings in the Data tab be persistent.  https://community.esri.com/t5/arcgis-online-ideas/hiding-fields-using-data-tab/idc-p/1664084#M13462 ... View more

I am also working on a similar thing with ArcGIS Python API, so I can collate all existing relevant user info for licensing (arcgis pro),  groups, user level, roles, etc. So hopefully I can re-apply all of that to the new user automatically once I start nuking accounts and restoring them after SSO-login occurs.  ... View more

This may not be relevant to your use case but here's my experiences: In the case of query using ArcGIS REST API and doing something with the response and for updating the values, you can use SQL-friendly time operations. In the case of Survey123 and Power Automate, it receives the datetime from AGOL hosted feature layer date fields as UNIX Epoch time, or I think it's also referred to as an 'epoch milliseconds' integer. It's a weird thing that references 1970 as the starting point in time and counts up in milliseconds from there. I assume this is the 'real' value stored in AGO databases, and ArcGIS Pro is just interpreting that at either UTC, or showing it as local time zone if ArcGIS Pro settings are configured for that. I recall some confusion about if this local time zone is something you can actually configure or not so I'm not sure about that. It might automatically display UTC times as local times in Pro. Have you already perused this documentation page? It might give you some more information about date/time issues. There is a newer field type called TimestampOffset which may be useful if you want to retain original UTC times. https://pro.arcgis.com/en/pro-app/latest/help/data/tables/date-fields.htm https://doc.arcgis.com/en/arcgis-online/manage-data/work-with-date-fields.htm  P.S. Converting epoch milliseconds to EST string date time in Power Automate is really fun: convertTimeZone(   addSeconds('1970-1-1',      div(<source AGO datetime>,1000),     'MM/dd/yyyy hh:mm:ss tt'    ),   'UTC','Eastern Standard Time',   'MM/dd/yyyy hh:mm:ss tt' ) ... View more

Piling on - we have this use case now as well where we need to 'map' Azure AD login to the same naming convention as existing users. It seems like we will have to systematically migrate user content, delete all of our users and have them re-created upon Azure SSO login, and then restore content. This also breaks any collaborations they were invited to. I can't find any other alternative so far. ... View more

Checking in with identical use case: We've got Azure AD SSO enabled for ArcGIS Online. We're in a testing phase. I've hit a fork in the road... We are already using the naming convention for AGO usernames where it follows our Town email base name, which is first initial / last name, follow by _tofv , since that's our AGO tenant short name. Example in my case: charmin_tofv That's what we want to continue to use, but upon first Azure AD SSO login, there is not a method I can find to 'map' the existing user to the Azure AD login. So on AGO side it creates, for example, a new charmin_tofv2 user automatically. Can anyone confirm if there is still no viable a method of 'mapping' Azure AD to existing accounts like this, so we don't have to wipe out and recreate users? That process also breaks any collaboration invites they may have had, aside from the content migration issue. ... View more