Skip to main content
Solved

Add Aliases to File Geodatabase

  • November 29, 2022
  • 8 replies
  • 545 views

vxn43
Supporter
Forum|alt.badge.img+18

My Reader is Excel. My Writer is ESRI File Geodatabase. I use AttributeManager to rename the fields. How do I add field name aliases to the Writer in this situation?

Best answer by dustin

Working with Geodatabase Field Aliases: Altering Alias Values (safe.com) This article will walk you through the methodology.

View original
Did this help you find an answer to your question?

8 replies

dustin
Influencer
Forum|alt.badge.img+31
  • Influencer
  • Best Answer
  • November 29, 2022

Working with Geodatabase Field Aliases: Altering Alias Values (safe.com) This article will walk you through the methodology.


vxn43
Supporter
Forum|alt.badge.img+18
  • Author
  • Supporter
  • November 29, 2022

Thank you. I read this article, and it is relevant only if you are reading from a geodatabase. I am reading from an Excel file and writing to a geodatabase. Do you think I need to create a 2nd workspace that I run after I write the feature classes? this 2nd workspace would assign aliases to the feature classes using a geodatabase in the reader. I think this would work, but wondering if there is way to incorporate this workflow into a single workbench?


egge
Contributor
Forum|alt.badge.img+14
  • Contributor
  • November 29, 2022

And what do you think of the answer to this Question: How do I create an alias on an attribute in my FME workspace?


dustin
Influencer
Forum|alt.badge.img+31
  • Influencer
  • November 29, 2022
timh wrote:

Thank you. I read this article, and it is relevant only if you are reading from a geodatabase. I am reading from an Excel file and writing to a geodatabase. Do you think I need to create a 2nd workspace that I run after I write the feature classes? this 2nd workspace would assign aliases to the feature classes using a geodatabase in the reader. I think this would work, but wondering if there is way to incorporate this workflow into a single workbench?

Check out the Advanced section of the article. It explains how to create aliases from scratch on features writing to geodatabase. In this manner, the input format won't affect your ability to write them.


vxn43
Supporter
Forum|alt.badge.img+18
  • Author
  • Supporter
  • November 29, 2022

@egge​ and @dustin​ thank you. I read the information. I tried adding the FacilityName_alias (value = FACILITYNAME) to a new field in AttributeManager (not the Writer) and it ends up adding a new field in the feature class named "FacilityName_alias". In ArcMap I checked the field properties for FACILITYNAME, and it still shows the Field Alias as "FACILITYNAME". I would like FACILITYNAME to have the alias "FacilityName".

 

Alias1I think I am missing something, what could it be? thanks.

 


dustin
Influencer
Forum|alt.badge.img+31
  • Influencer
  • November 29, 2022
timh wrote:

@egge​ and @dustin​ thank you. I read the information. I tried adding the FacilityName_alias (value = FACILITYNAME) to a new field in AttributeManager (not the Writer) and it ends up adding a new field in the feature class named "FacilityName_alias". In ArcMap I checked the field properties for FACILITYNAME, and it still shows the Field Alias as "FACILITYNAME". I would like FACILITYNAME to have the alias "FacilityName".

 

Alias1I think I am missing something, what could it be? thanks.

 

First, I would imagine it is case sensitive, so it needs to be FACULTYNAME_alias. The Attribute Value of FACULTYNAME_alias needs to be whatever you want the alias to be. As it is now, you are pulling the attribute value from FACULTYNAME, which I don't think is what you want.


vxn43
Supporter
Forum|alt.badge.img+18
  • Author
  • Supporter
  • November 29, 2022

@dustin​ Apologies I must be obtuse today. You pointed me in the right direction, and I finally was able to figure it out. It works. Here is a screenshot of how to insert aliases for anyone else who may need assistance with this.

 

Alias2


dustin
Influencer
Forum|alt.badge.img+31
  • Influencer
  • November 29, 2022
timh wrote:

@dustin​ Apologies I must be obtuse today. You pointed me in the right direction, and I finally was able to figure it out. It works. Here is a screenshot of how to insert aliases for anyone else who may need assistance with this.

 

Alias2

No worries, glad you got it working!


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