Skip to main content
Question

Excel records to multiple XMLs using a predefined XML template

  • May 20, 2015
  • 0 replies
  • 9 views
T
Forum|alt.badge.img
G'day everyone,

 

 

I am working on a metadata project for my organisation using MapInfo Manager (Pitney Bowse). I have filled a template metadata record using the program and exported to XML.

 

 

With FME, I have converted the XML to Excel format using Feature Paths (MD_Metadata) and Flatten options as specified in an FME XML help video (thank you Safe).

 

 

I would like to distribute an Excel template to users who would fill in metadata details. Each record in Excel will be a metadata record that needs to be converted back to XML. I have tried the XMLtemplater with Root Template Expression to copy the template XML text and replacing the attributes.

 

 

Is there any other automated way to do this process of matching attibutes to the template attributes? There are about  200 attributes that I need to match.

 

 

Thanks in advance,

 

 

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

Community Stats

32,208
Posts
122,306
Replies
39,892
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.