Skip to main content
  • EN

Hi FME community.

I have a simple task to change Japanese field names in a shapefile to English field names. So I was using SchemaMapper to do this task.

I created a simple csv file which has two columns, old_name and new_name. Then, I used this csv file in the ShemaMapper.

I save the resulted layer as a shapefile. But the shapefile I crated had the exactly same field names as original one. All Japanese field names...

I realized that when I inspect the output with the Inspector, I can see that SchemaMapper actually changed attribute names. Please see an image below.

However, it did't reflect these changes when I save this result as a shapefile. Can someone tell me what I am doing wrong??

Thank you in advance.

Hiroo

Hi @hirooimaki,

On your shapefile writer the dropdown list is showing the attributes it is going to write out. From your image these still display the old names so I suggest you need to go into the writer and change the Attribute Definition under User Attributes to expose the writer to these new attribute names.

Hi @hirooimaki, FME renames the attributes according to the SchemaMapper configuration at run-time, but Workbench won't expose the new attribute names automatically, since Wokbench cannot recognize the new names while creating the workspace.
In this case, just change User Attributes names in the writer feature type to the new names manually. It's not essential to expose the new attribute names

Note: Shapefile format doesn't allow attribute names greater than 10 bytes. You cannot define attribute names 11 byte or longer, unfortunately.

An advanced approach.If you create a lookup table for a dynamic schema configuration and add the "old_name" column to the table, you can use the lookup table to configure both dynamic schema (destination schema derived from a lookup table) and the SchemaMapper.See these links to learn more.

Hi @hirooimaki,

On your shapefile writer the dropdown list is showing the attributes it is going to write out. From your image these still display the old names so I suggest you need to go into the writer and change the Attribute Definition under User Attributes to expose the writer to these new attribute names.

Thank you so much for your tip, @hollyatsafe. I wanted to this task with a dynamic way, so I followed a way @takashi suggested.

Hi @hirooimaki, FME renames the attributes according to the SchemaMapper configuration at run-time, but Workbench won't expose the new attribute names automatically, since Wokbench cannot recognize the new names while creating the workspace.
In this case, just change User Attributes names in the writer feature type to the new names manually. It's not essential to expose the new attribute names

Note: Shapefile format doesn't allow attribute names greater than 10 bytes. You cannot define attribute names 11 byte or longer, unfortunately.

An advanced approach.If you create a lookup table for a dynamic schema configuration and add the "old_name" column to the table, you can use the lookup table to configure both dynamic schema (destination schema derived from a lookup table) and the SchemaMapper.See these links to learn more.
Thanks @takashi, again. I followed your instruction "Common Table for SchemaMapper and Dynamic Schema" and I somehow could make it work. Now I can rename Japanese field names into English easily.

 

Again, thank you!

Reply


Community Stats

31,821
Posts
120,861
Replies
39,452
Members

Latest FME

Terms & ConditionsCookie 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.