topic Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet) in ArcGIS Survey123 Questions

GlobalID in lowercase from Collector to Survey123 (Windows tablet)

DSIProvince_Nord — Tue, 29 Oct 2019 00:48:01 GMT

Hi,

I try to pass a globalID from Collector to Survey via URL parameters. Everything works fine except the GlobalID is always in uppercase in my feature service, but once it goes into an esri.fieldtype:GUID in Survey123, it turns into a lowercase.

I noticed that in iOS, it is passed as an uppercase text, but not in Windows10 tablets (collector and survey123 up-to-date).

The only way I found is to create an "incoming" field with fieldtype=null that stores the value passed by Collector, and then my GUID field that calculate the first AND with InputMask= ">XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX" to ensure every lowercase letter is set to uppercase.

BUT this only works if the field type in Survey123 (not the esri.fieldtype) is set to "text" AND is NOT readonly AND the user enters into the field (by clicking the field without changing anything) when doing the survey.

This is the only way Survey123 sends Uppercase GUID.

Otherwise, Survey123 is always sending a lowercase GUID.

Any idea ??

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

JamesTedrick — Fri, 01 Nov 2019 18:08:49 GMT

Hi,

Just to check, is there a data issue with the submission of a 'lowercase' GUID? The case of a character in a GUID (which is a hexadecimal number, not text) should not matter.

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

DSIProvince_Nord — Sun, 03 Nov 2019 23:08:59 GMT

Hi,

Yes, there is a problem with lowercase GUID : it is not recognized in the relationship class.

In a webmap, if I select a parent object (polygon) and try to select all related records (point), only those with an uppercase are found. I have to manually change in the related record from lower to upper, then it works as expected.

The service is a hosted feature service with a polygon layer, a point layer and a table and with relationship :

polygon (1) <-> point (n)

point (1) <-> table (n)

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

DougBrowning — Mon, 04 Nov 2019 14:57:37 GMT

I am seeing this issue in Pro as well.

https://community.esri.com/thread/243002-globalid-inconsistent-display

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

DougBrowning — Tue, 21 Sep 2021 20:03:30 GMT

Here is a video now. Some, but not all, forms in 123 are storing lowercase globalids. When you do an edit Pro changes them to uppercase.

This can cause all kinds of programming issues. Not even sure which one it correct.

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

DougBrowning — Thu, 16 Dec 2021 15:52:22 GMT

Ok this one is getting me in the web map now.

It shows globalid as lower case in the attribute table but when I run a simple calc to put it into the FormID field it suddenly goes upper case!

Now the super fantastic part is relationship classes see the uppercase and lowercase and different so it breaks all the relates!

At this point how are we supposed to program around all of this? I know this is not really 123 at this point but these kinds of inconsistencies is a killer. Thanks

When I open in Pro I see both again.

I think the lower case may be coming from Field Maps. If I add a feature in a web map in the browser I get uppercase GlobalID. If I use the exact same map and add in Field Maps it does lower case.

AGOL Add

Field Maps add

Then ArcPro changes the lower to upper for display

So the exact same record shows lower in AGOL and upper in Pro.

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

DougBrowning — Thu, 16 Dec 2021 18:24:09 GMT

Looks like 123 is doing lower case also?

And when I look at this form in Pro I again get both depending on the attribute table or the popup

No idea which one is "correct" still.

Also uuid() does lowercase.

thanks

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

DougBrowning — Tue, 25 Jan 2022 18:35:02 GMT

Since I am not getting anywhere I went to support. They agree 123 and Field Maps is doing lowercase when everyone else is doing upper. But they say it is not a bug but an enhancement.

ENH-000130624

One possible workaround I am testing is to make any ID field a GUID. GUID does not seem to care about upper and lower so the relationships work. It is harder to use a GUID and it forces me to add the {} and it cannot be a diff text key which is a bummer.

Also even when I paste in a upper GUID it changes it to lower in AGOL

But In ArcMap they are all upper and show as upper.

So AGOL, 123, and Field Maps is all lower or shows lower but ArcMap, Pro, SQL, etc it is all upper and shows upper.

For sure a inconsistency that is very confusing. I hope all the teams can just agree on one choice and use it.

Also 123 uuid() does all lower.

Going to try and get it escalated so hope 123 can make the switch.

thanks

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

DougBrowning — Wed, 02 Feb 2022 15:16:42 GMT

Esri now agreed to update this to a bug BUG-000146406

thanks

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

DougBrowning — Mon, 15 Aug 2022 20:18:06 GMT

Just proved today that if you use the Attributes window to edit in Pro it will change the 123 parentGlobalID field to uppercase - and this does break the relationship! Support said that would not break it but it for sure does. I thought so also as did @JamesTedrick

If you use Field Calculator it will not change to upper case so use that.

Note domains not being updated also breaks editing in Pro.

FYI to all.

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

ahargreaves_FW — Thu, 04 Apr 2024 20:03:15 GMT

This is:

1. Unbelievable.

2. Affecting a workflow we need to work

3. Being escalated by us.

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

DougBrowning — Fri, 05 Apr 2024 15:59:02 GMT

I escalated also 3 years ago and even talked to the team about it in person. Esri really needs a standards board for the company.

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

AaronGlanville — Thu, 18 Apr 2024 19:55:04 GMT

I wanted to provide another example where this bug causes issues.

My office uses an asset management system that connects work orders to GIS features using the GlobalID. We are currently migrating data to the cloud and thus changing all of the GlobalIDs to lowercase and breaking all connections between the GIS features and years' worth of work orders.

We are currently pursuing a solution with the makers of our asset management system and hopefully will find one shortly. But, this bug points to the larger issue among Esri products that there aren't standards/uniformity across the entire platform.

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

Kevin_MacLeod — Mon, 29 Apr 2024 16:57:21 GMT

I also hope this design issue is resolved. This similar to how AGOL and Portal differ for field names and case (PostgreSQL). The Esri ecosystem is fragile if you want to change something. These two specific issues are simple but high impact. Perhaps creating a position at Esri like "Enterprise QC Coordinator" to be on the lookout specifically for things that "break" or cause pain points like this would be useful. They could hold quarterly meetings with leaders from each Support dept and reps from Services, and perhaps even a few customer MVPs.

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

DougBrowning — Mon, 29 Apr 2024 18:40:24 GMT

I wonder if @MikeBranscomb is on here? I talked to him in person about it at Dev Summit. At almost 5 years now, and being escalated 3 years ago, just makes no sense to me as it is a rather major error. I also talked to each team about it.

And I agree teams not communicating with other has been a major issue for Esri for a long time. (To be fair that is true in most companies.)

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

MichaelBranscomb — Tue, 30 Apr 2024 14:42:18 GMT

@DougBrowning Thanks for adding me to the thread, I'll see what I can find out.

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

MattSteging — Wed, 12 Jun 2024 19:35:21 GMT

Any additional information on this issue being corrected? Thanks in advance.

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

DougBrowning — Thu, 13 Jun 2024 13:11:31 GMT

Got me again last week where I had to update some records in Pro, it changed to upper case and broke my relates.

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

DougBrowning — Thu, 29 Aug 2024 15:32:32 GMT

Got this update today. Of course you cannot change to GUID in 123 land. They still do not get the problem.

Bug fixes are addressed in upcoming releases or general patches, or they may be addressed as ad-hoc fixes. Enhancement requests are implemented in upcoming releases.

Updates have been made to the following defect which you are associated with:
BUG-000146406 - Inconsistent letter cases for the Global ID values between ArcGIS Desktop and ArcGIS Online products.

Status: Duplicate (Learn More)
Duplicate record #: BUG-000167548
Additional Information: Duplicate of BUG-000167548

Alternate Solution:

For relationship class operations, use a GUID field as the destination key.

Thank You,

Re: GlobalID in lowercase from Collector to Survey123 (Windows tablet)

PegGronemeyer1 — Sun, 01 Sep 2024 20:26:09 GMT

@DougBrowning and @MichaelBranscomb

I've been trying to follow this, but I've only dealt with the related tables of a draft survey - so we have not yet collected data THEN needed to edit in Pro.

Maybe someone will tell me I'm wrong, (please!), but it sounds like when our biologists test our survey in the field, it will work at first, but if we try to update a record in Pro - when we actually are dealing with 'real' data, my relates will break??? 😱🤯