Skip to main content
Solved

loop? for this.. if so how?

  • August 4, 2015
  • 6 replies
  • 88 views
R
Forum|alt.badge.img
Hi All,

 

 

I'm a novice. I have a MSSQL_ADO reader working on a non spatial table. My next challenge

 

is to find the best way to iterate through a field in that table and use that value (which is a set of table names) to copy a Feature Class of the same name to another DB. I have done some reading and video watching on loops but haven't been able to implement anything that does feature by feature only the entire record set. If that's the best approach.

 

 

I've no problem writing loops in Python\\.NET or cursors in SQL Server but I'm trying to avoid code.

 

 

Regards,

 

Richard

 

 

Best answer by takashi

Hi Richard,

 

If you are using FME 2015.1, FeatureReader and Dynamic writer would be a quick way.

 

 

 

Hope this helps.

 

Takashi
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.

6 replies

takashi
Celebrity
  • takashiCelebrity
  • Best Answer
  • August 4, 2015
Hi Richard,

 

If you are using FME 2015.1, FeatureReader and Dynamic writer would be a quick way.

 

 

 

Hope this helps.

 

Takashi
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
R
Forum|alt.badge.img
Hi Richard,

 

If you are using FME 2015.1, FeatureReader and Dynamic writer would be a quick way.

 

 

 

Hope this helps.

 

Takashi

Hi Takashi,

My FeatureReader is iterating through all of the Feature Types in the Tablenames table (SQL Select statements). However I'm wondering how to expose the attributes for each of the corresponding tables found? The only attributes I have are from the TableNames table.

Regards,

Richard

takashi
Celebrity
  • takashiCelebrity
  • September 4, 2017
Hi Richard,

 

If you are using FME 2015.1, FeatureReader and Dynamic writer would be a quick way.

 

 

 

Hope this helps.

 

Takashi
Hi @richardtriesfme, there is no way to expose attribute names automatically. If necessary, you will have to manually enter the attribute names into the Attributes to Expose parameter in the FeatureReader or use the AttributeExposer transformer.

 

However, in this case, I don't think you need to expose any attribute, since the dynamic writer will configure the schema of destination tables automatically.

 

Do you have any specific reason to expose attributes?

 

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
R
Forum|alt.badge.img

Thanks Takashi, I was planning on using the changedetector after to identify any changes in all attributes for data replication.

R
Forum|alt.badge.img
Hi Richard,

 

If you are using FME 2015.1, FeatureReader and Dynamic writer would be a quick way.

 

 

 

Hope this helps.

 

Takashi

Thanks Takashi, I was planning on using the changedetector after to identify any changes in all attributes for data replication.

takashi
Celebrity
  • takashiCelebrity
  • September 5, 2017
Hi Richard,

 

If you are using FME 2015.1, FeatureReader and Dynamic writer would be a quick way.

 

 

 

Hope this helps.

 

Takashi
I don't think it's essential to expose any attribute if you intend to use a ChangeDetector with Match All Attributes strategy. However, if you need to select some attributes in the Selected Attributes parameter field (Match Selected Attributes or Match All Except Selected Attributes strategy), you will have to expose them beforehand.

 

 

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,154
Posts
122,047
Replies
39,812
Members

Latest FME

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