mailmerge using xml / xsl

Posts   
 
    
mdissel
User
Posts: 92
Joined: 16-Sep-2003
# Posted on: 28-May-2004 10:12:37   

Hello

I've developed an application for a specific branche. In this applicaton we want to use mailmerges to create document. The output should be merge with a specific template/style to send it out using email/fax or just on paper.

Currently i can extract data from the system and save it into XML (the xml contains several levels (including several root instances). For example: make a order confirmation for several customers with specific orderline details

 <customer>
    <name>Company A</name>
    <Order>
        <number>1</number>
        <orderlines>
            <orderline>
            <article>Article A</article>
            <Count>10</Count>
            <price>10.00</price>
                <orderlinedetails>
                    <color>red</color>
                    <height>1.50</height>
                </orderlinedetails>
            </orderline>
        </orderlines>
    </Order>
</customer>
<customer>
    <name>Company B</name>
    <Order>
        <number>1</number>
        <orderlines>
            <orderline>
            <article>Article B</article>
            <Count>10</Count>
            <price>10.00</price>
                <orderlinedetails>
                    <color>red</color>
                    <height>1.50</height>
                </orderlinedetails>
            </orderline>
        </orderlines>
    </Order>
</customer>

This can be solved using XML/XSLT/XPATH transformation to HTML, but the user that starts this mailmerge should be able to edit the document before mailmerging (for example to change the text). But you can't show the XSLT document into a (web)based html editor (like www.freetextbox.com). I need a user friendly GUI interface to change the document without showing the XSLT code..

The end result should be a generic "report/mailmerge" engine using XML as a datalayer. Seems handy in many projects!

Tips are welcome! Anybody seen a ready to use tool that can be used (having the look and feel of a mini MS Word editor).

Regards

Marco