Skip to main content
Question

Creating one xml file per feature (row in Oracle database)

  • Feb 21, 2013 1:16 PM UTC
  • 3 replies
  • 80 views

I have a workspace that reads an Oracle database table and creates an xml document.  I would like to create one xml document per row in the table and name that xml document based on the value of an attribute.

 

 

I was able to accomplish this by using a parameter and referencing the parameter in the reader "sql where clause" and in the textline writer dataset name.  But this approach requires me to execute the transform externally for each row in the database.

 

 

Sorry for the remedial questions - I know I am just missing some basics...

 

 

Thank you in advance.

 

 

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

3 replies

ebygomm
Evangelist
Forum|alt.badge.img+54
  • Evangelist
  • Feb 21, 2013 3:15 PM UTC
You can set Fanout Dataset to Yes within the Advanced parameter settings of the writer and then fanout on the relevant attribute

davideagle
Contributor
Forum|alt.badge.img+21
  • Contributor
  • Feb 21, 2013 4:05 PM UTC
There's more information on this technique here http://fmepedia.safe.com/articles/How_To/Fanout

  • Author
  • Feb 21, 2013 4:17 PM UTC
Thank you!  Working great!