Skip to main content
  • EN
Hi,

 

 

I'm reading in some data via the FeatureReader transformer and I would like to write it out dynamically, but when I try to setup the dynamic proprties I get a pop-up message No reader or schema reader found.  Please add a reader or schema reader to workspace that can be used as a schema source.

 

 

I can't add a reader or schema reader because the data does not exist prior to the workspace being run.  Any ideas?
Hi,

 

 

can this be of help?

 

http://fmepedia.safe.com/articles/Samples_and_Demos/Dynamic-Workflow-Tutorial-Destination-Schema-is-Derived-from-List-Attributes

 

 

You might also want to know the FME 2015.1 will probably introduce the complementing FeatureWriter transformer, which might simplify this for you.

 

 

David
You could add a reader reading same table as your featurereader, read just 1st line or so, either sampling but better to set it in the navigator panel.

 

That way you have a schema availabel for your writer.

 

 

You could even add a parameter and link it to the featurereader parameter (this is done in the navigator). Then you could use this parameter in your reader.
To expand on my post above:
  • FeatureReader followed by a SchemaSetter (https://store.safe.com/transformers/SchemaSetter.htm), make sure to exclude prefixes (such as "fme_" etc that you don't want to write)
  • Insert at NULL reader somewhere in your workspace, this just serves as a dummy to "distract" the workbench dialogs
  • On your output feature type, select Dynamic schema and point it to the NULL (dummy) reader.
The "magic" list created by the SchemaSetter containing the schema from the FeatureReader will now be used to define your output features.

 

 

David
Forgot the screendump:

 

 

The null reader was the piece I was missing.  Thank you David.

Reply


Community Stats

30,351
Posts
115,342
Replies
38,082
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.