Skip to main content
Question

UUID braces missing?

rob_z
Forum|alt.badge.img

Hi,

using FME 2019.1.2 (32bit) I encounter the following issue:

Data Source is an ESRI FileGDB.

Table 1

- has a GlobalID column and content is shown with braces in FME

- has GUID column referencing GlobalID in table 2 and content is shown without braces in FME

Table 2 -

- has a GlobalID column, content is shown with braces in FME

 

Now, when I want to merge both tables with FeatureMerger (tab1.Guid = tab2.Globalid) no features are merged.

If I add braces to the GUID column features will be merged in FeatureMerger.

As far as I understand GlobalID and GUID are the same data type in ESRI - so why are the shown / treated differently in FME? I'm aware of this posting about missing braces - but in the situation I described above its not just a display issue.

It seems to me that GlobalID have braces in FME whereas GUID dont. And that prevents merging (joining) both tables easily.

 

Rob

 

 

 

 

 

 

 

4 replies

debbiatsafe
Safer
Forum|alt.badge.img+20
  • debbiatsafeSafer
  • Safer
  • January 8, 2020

Hi @rob_z

A parameter option for stripping braces off of GlobalID and GUID was added to the File and SDE Geodatabase readers in FME 2019. Could you please confirm this reader parameter is set to 'No' and rerun the workspace?

Are the braces still stripped from the GUID attribute?

rob_z
Forum|alt.badge.img
  • rob_z
  • Author
  • January 9, 2020

Hi @debbiatsafe,

 

thank you for your reply. I couldnt find any parameter option for that. Didnt find any reference to it in Help either. Could you let me know where I can find the parameter?

 

Thank you, Rob

debbiatsafe
Safer
Forum|alt.badge.img+20
  • debbiatsafeSafer
  • Safer
  • January 9, 2020
rob_z wrote:

Hi @debbiatsafe,

 

thank you for your reply. I couldnt find any parameter option for that. Didnt find any reference to it in Help either. Could you let me know where I can find the parameter?

 

Thank you, Rob

Please see the below screenshot of the parameter within the Navigator pane.

If you are unable to find this parameter, can you please confirm the workspace is not using the File Geodb Open API reader?

rob_z
Forum|alt.badge.img
  • rob_z
  • Author
  • January 10, 2020

Hi @debbiatsafe

 

the issue seems to be related to opening a FME 2016 workspace in FME 2019:

 

create new workspace using FME 2016.1

- Esri Geodatabase (File Geodb API) connect and connect to inspector

- inspector: braces are fine in 2016

- save workspace, close fme 2016

 

in fme 2019.1

- open workspace, run --> GlobalID still has braces, all other guid fields have lost the braces, no parameter to set with regards to braces (thats the situation I faced when running my workspace initially created with fme 2016 - which I didnt mention in my posting, sorry for that.)

 

- add "Esri Geodatabase (File Geodb)" -> paramter "Strip braces..." available and braces all there in inspector preview

 

For me question is solved, thanks.

Rob

 

Reply


Helpful Members This Week

Community Stats

31,459
Posts
119,258
Replies
39,079
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.