Skip to main content
  • EN
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

 

 

 

 
Hi Steve,

 

 

You cannot leave the geometry field blank.

 

Try setting "fme_no_geom" to the field.

 

 

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

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
Members
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.