Skip to main content
Solved

dynamic writer lookup table

G
Forum|alt.badge.img
Afternoon All, I am having trouble with the dynamic writer functionality of FME when i try and dynamicly read the schema from a "lookup" csv. it says its written the data to my output file but no file is created in the output dir.

 

 

I have run thru the tutorials for dynamic writing  (link below) serveral times

 

 

http://fmepedia.safe.com/articles/Samples_and_Demos/Dynamic-Workflow-Tutorial-Destination-Schema-is-Derived-from-a-Lookup-Table

 

 

I still cant get it to work in my example:

 

 

I have a CSV reader for my input data, 100,000 records

 

i have added a workspace resource of a "schema from table" csv as my dynamic output schema for my writter.

 

i have an xls writer to write my data too (ie the 100,000 records that use the schema supplied in the schema form table csv.

 

 

In my schema csv i have the similar format as per the tutorial (except my data has no geometry info - its just rows in the csv) so i leave the "geometry" field blank. 

 

 

The transformation runs smoothly - no errors and says its written out my records but there is no xls table in my output dir ??

 

 

I have tried this on multipule pc's with fme 2013,2014 so i guess im doing something wrong here ?? 

 

 

Anyone with suggestions on steps i have missed or settings i am missing ?? 

 

 

Thanks for your help, if you requre more info on my logs i can supply/. 

 

 

 

Thanks agian Steve

 

 

 

 

Best answer by takashi

FME identifies feature type (class) based on the value of "fme_feature_type".

 

Check if fme_feature_ type of the features contains correct feature type name exactly matched with "pipes". 
View original
Did this help you find an answer to your question?
<strong>This post is closed to further activity.</strong><br /> It may be a question with a best answer, an implemented idea, or just a post needing no comment.<br /> If you have a follow-up or related question, please <a href="https://community.safe.com/topic/new">post a new question or idea</a>.<br /> If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

takashi
Evangelist
  • takashiEvangelist
  • March 20, 2015
Hi Steve,

 

 

You cannot leave the geometry field blank.

 

Try setting "fme_no_geom" to the field.

 

 

Takashi
G
Forum|alt.badge.img
  • goatboy
  • Author
  • March 20, 2015
Thanks Takashi for your suggetsion. Im still getting no putput file written ??? i get the error ....  "Features With No Schema defined"..... in blue and no output file ? do i need to do anything to the data reader.

 

 

below is some sample play data im using to try and get it to work ??

 

 

 

this is the format of my schema table csv

 

 

class, attribute, datatype, geom, order

 

pipes, name, fme_varchar(50), fme_no_geom, 1

 

pipes, size, fme_varchar(50), fme_no_geom, 2

 

 

this is my data table (xls)

 

 

name, size

 

bob, 50

 

mary, 100

 

sue, 34

 

steve, 25

 

 

 

Any further suggestions ,

 

 

Much appreciated as always

 

 

Steve
takashi
Evangelist
  • takashiEvangelist
  • Best Answer
  • March 20, 2015
FME identifies feature type (class) based on the value of "fme_feature_type".

 

Check if fme_feature_ type of the features contains correct feature type name exactly matched with "pipes". 
G
Forum|alt.badge.img
  • goatboy
  • Author
  • March 22, 2015
That was it thanks Takashi, yes ensuring the fme_feature_type was the same did the trick. Many Many Thanks for your help as always, Your such a great resouce on this forum. Steve

Helpful Members This Week

Community Stats

31,468
Posts
119,284
Replies
39,083
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

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