About Joel Mansford

Together with David Padbury started a software development company called ProvenWorks utilising our many years experience in building marketing databases, BI and CRM.

I consider myself a SysAdmin at heart but running a development company obviously spend some time coding as well as lots of boring business stuff! Generally my tool of choice these days is SQL Server 2008 with a soft-spot for the quick-wins that Reporting Services (SSRS) can give.

Recently I have found myself MCITP qualified on Windows Server 2008 and a certified Salesforce.com developer  – you know what they say about variety.

2 responses to “About Joel Mansford

  1. Clayton Hampton

    Hi Joel,

    For the past day and a half I have been following your instructions on ‘Creating a Word 2007 document from a template and XML data(or Infopath) programmatically’. Our business uses Infopath to allow users to work off-line and then upload data to the system via the Infopath template. However, we also create a Word 2007 document from the Infopath document, using a cumbersome process that really doesn’t provide the best results, requiring a lot of editing. Your directions seem to provide a good way to open the Infopath XML file in Word without the need for further formating/editing issues. However, my Infopath XML files have ‘repeating tables’ in them and your instructions to not really provide and answer for that, except the statement under LIMITATIONS: This type of data merging / generation is only really suitable for simple text insertion, if you have repeating data for example you will probably need to use an XSL approach. Unfortunately, I do not know what the XSL approach is. Can you advise with detailed instructions as you have provided in this document for XML?

    Thanks,

    Clayton Hampton

    • Clayton,

      The XSL approach is basically converting the XML MS Word file in to an XSL. I did attempt this and found it to be extremely cumbersome, also from the point at which you have created the XSL all changes to the template must be made manually as MS Word can no longer use the file. I simply don’t think it’s a practical approach.

      Personally I would look to some kind of tool that can output MS Word documents. Maybe something like SoftArtisans, but I don’t have any experience with that.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s