Skip to main content
Question

How do you get the fme_basename parameter to update for each filename opened in a workspace runner?

  • June 8, 2018
  • 2 replies
  • 22 views

philipwhitten
Supporter
Forum|alt.badge.img+15

I need to copy all of the features in a folder containing many zipped shapefiles to tables in a SQL Server.  The table names in the SQL Server need to reflect the shapefile names.  Currently I am using the Table Name Expression: 

NatTitl_@Value(fme_basename)

When I run the workspace runner that I created, the same table name is applied to every shape file.  Hence, the fme_basename parameter is not updating when a subsequent shapefile is opened.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

takashi
Celebrity
  • June 8, 2018

Consider using "fme_feature_type" instead of "fme_basename". "fme_feature_type" stores feature type name, which is equal to the source file name without extension if the source format is a folder-based one, such as Esri Shapefile.


philipwhitten
Supporter
Forum|alt.badge.img+15
  • Author
  • Supporter
  • June 12, 2018

The problem occurs regardless of whether fme_basename or fme_feature_type is used. I have attached the fme files with fme_feature_type instead of fme_basename.

I don't understand how changing the parameter to fme_feature_type from fme_basename presents a solution to the question?