Difference between revisions of "Including XML on an MS Word Merge Document"
(Created page with 'This article explain how to use the data stored within SmartSimple XML field to display on a Word Merge Field. XML data can be displayed on a Word Merge as either a singl…') |
|||
| Line 1: | Line 1: | ||
| − | This article explain how to use the data stored within [[SmartSimple]] XML field | + | This article explain how to use the data stored within [[SmartSimple]] XML field on a Word Merge document. |
Revision as of 11:07, 11 June 2012
This article explain how to use the data stored within SmartSimple XML field on a Word Merge document.
XML data can be displayed on a Word Merge as either a single value or table.
General Procedure
For single values use: project_budget=@xml.Submission Budget.Total-Expenses.total-exp.currency(total-expenses.nodevalue)@;
To display data in a table (dynamic number of rows) use the same syntax as used on a web page view (Custom_Field_Type:_Special_-_XML_Data) and delimit the cells using pipes "|". Note that there is a | at the beginning and end of the row.
table_x=@xml.fieldname.sectionname.nodename[#|~childnodename.nodevalue~|~childnodename.nodevalue~|#]@
table_5=@xml.Submission Budget.Other-Grants.Funders[#|~Funder.nodevalue~|~currency(Amount.nodevalue)~|#]@;
This example would render in a table with two columns. to specify the table use: "table_x =" where x is the table number as it appears in the template document. In the example above it's the fifth table in the document. Each XML section must be displayed in a separate table.
