I am reading the feature classes and tables from an Oracle Reader, and many of those are not having any records, the tables are empty. But I want all of those in my ESRI FGDB output which I am using in the Feature Writer dynamically. How to achieve this? Any leads?
Question
How to write the feature classes with no records from an Oracle Reader to the Fgdb writer dynamically?
+21- Enthusiast
A nofeaturestester transformer is the way to do it. I have built one but I need to look for it,
+21- Enthusiast
Found it…. you just need to wire it to your exact workflow. The logic is there.
+6- Contributor
Found it…. you just need to wire it to your exact workflow. The logic is there.
It's working but only when I have already defined the schema in the Feature Writer, but dynamically it is not working as expected as it's changing the feature type name to some random value like 'NoFeaturesTester_Creator', so feature class is created with some random names like this.
Is there a way where it can work dynamically?
+21- Enthusiast
Found it…. you just need to wire it to your exact workflow. The logic is there.
It's working but only when I have already defined the schema in the Feature Writer, but dynamically it is not working as expected as it's changing the feature type name to some random value like 'NoFeaturesTester_Creator', so feature class is created with some random names like this.
Is there a way where it can work dynamically?
Please show a screenshot of your workspace or share your workspace, if you can.
Did you use the format parameter fme_feature_type from the source tables as dynamic feature class names in the destination FGDB feature classes or tables?
BTW, your comment in the Community post took several hours to appear in this question, after I received an email notification from the Safe Community site. Other notifications I received today were instant. I found that weird. I’ve been clicking on the email link the whole morning to see read this comment.
+6- Contributor
Found it…. you just need to wire it to your exact workflow. The logic is there.
It's working but only when I have already defined the schema in the Feature Writer, but dynamically it is not working as expected as it's changing the feature type name to some random value like 'NoFeaturesTester_Creator', so feature class is created with some random names like this.
Is there a way where it can work dynamically?
Please show a screenshot of your workspace or share your workspace, if you can.
Did you use the format parameter fme_feature_type from the source tables as dynamic feature class names in the destination FGDB feature classes or tables?
BTW, your comment in the Community post took several hours to appear in this question, after I received an email notification from the Safe Community site. Other notifications I received today were instant. I found that weird. I’ve been clicking on the email link the whole morning to see read this comment.
I am also finding this weird, whenever I am adding comment it's saying The Moderator will review it first and then it will appear. Even I tried to add 2-3 comments where I shown the screenshots as well, but seems like they did not even appear
I will share my workspace meanwhile I also need help if you can provide on How to read tables from Oracle Feature Reader if the Table Names to read is coming from an attribute from an excel file, I am trying some options but they are not working
+6- Contributor
Found it…. you just need to wire it to your exact workflow. The logic is there.
It's working but only when I have already defined the schema in the Feature Writer, but dynamically it is not working as expected as it's changing the feature type name to some random value like 'NoFeaturesTester_Creator', so feature class is created with some random names like this.
Is there a way where it can work dynamically?
Please show a screenshot of your workspace or share your workspace, if you can.
Did you use the format parameter fme_feature_type from the source tables as dynamic feature class names in the destination FGDB feature classes or tables?
BTW, your comment in the Community post took several hours to appear in this question, after I received an email notification from the Safe Community site. Other notifications I received today were instant. I found that weird. I’ve been clicking on the email link the whole morning to see read this comment.
Yes I used fme_feature_type in the dynamic schema of the Feature Writer, but it is not capturing the actual feature class name, instead of that it is auto-creating some random names like NoFeaturesTester_Creator as feature class name (example). So if I have to write 100s of feature class dynamically it is not working
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.