How do i set the writers data type from this list. I have tried importing the csv the using the "duplicate on writer" function. This is great for setting the name of the writer attributes but doesnt set the data Type fields. Is this possible ? Any suggestions to save me from setting 1000 data types manually.
THanks Steve
Thanks for your help , as always
I don't think there is a way to import schema definition to static writer feature types from an external schema definition table.
Instead, I would recommend you to consider applying the Dynamic Schema mechanism (Lookup Table method).
See these links.
Dynamic Workflow Tutorial: Introduction (http://fmepedia.safe.com/articles/Samples_and_Demos/Dynamic-Workflow-Tutorial)
Dynamic Workflow Tutorial: Destination Schema is Derived from a Lookup Table (http://fmepedia.safe.com/articles/Samples_and_Demos/Dynamic-Workflow-Tutorial-Destination-Schema-is-Derived-from-a-Lookup-Table)
To apply the method, you will have to create a lookup table, but I think it will not take so long time since you already have a CSV table which describes all the required schema definition. You can modify the CSV table easily to fit the requirement for the look up table format.
Hope this helps.
Takashi