Hi Piotr and other also interested in "merging" DP data into Word.
I have created a sample DP to Word XML "merge application". It is a contrived newsletter application, just to demonstrate the process. For a start, this is the link to a PDF of the final document to get a perspective on what the final result should look like. The application only works for Word 2003 and later; it will not work with Word 97, Word 2000 and probably not with Word XP either) This Word 2003 document includes includes multiple graphics, section breaks, columns, headers and footers and text boxes, so not a trivial document. It is a more complex merge than say as simple merge letter as I am "merging" data into the header, a textbox and each article into columns. Additionally I have made the structure of the XML data from DP a little more complex, than say Word would like. Which I will explain a little later, in a separate post. Download the http://www.brileigh.com/DPWEB/DPNewsPart1.zip file, and unzip its contents into a folder. (By the way the zip includes the latest DP2.6Y so I could include things like line breaks in the newsletter articles.) open any panel and run the report "DPNews XML ". You will need to choose a customer from the list, and then choose a number of articles from the articles list. This will create a file called DPNEWS.DOC (It is not a Word format .DOC, but because of the extension will be opened by Word by default. Open the document in Word; it should display a very bland looking XML document (this is a Data only view). In the XML Document Task Pane, under XML Data Views, one of the options should be "DPNews.xsl" (This is the transformation template, that I have associated with the DP News XML document.) Still when you select this it will show the text, (more like a Normal View) but to show its formatting you will need to select the Word menu option "View" and select "Print View". In this example Word itself is performing the XSLT transformation of the file, but it is possible to do the transformation with other tools, so that result a user would see is just the final document. I will post details of how the XML structure works, how to create the XSLT and how to create the final document without using Word in separate postings. Regards Brian
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
