Re: Re: [GENERAL] Link Office Word form document with data from PostgreSQL

On Mon, Mar 30, 2015 at 1:51 PM, avpro avpro <avprowebeden(at)gmail(dot)com> wrote:

> thank you all for your responses.
>
> I think to easiest option for me would be to use the ODBC connection. Now
> my problem is where to start with the VBA code; but that's for another list.
> cheers
>
> On 30 March 2015 at 19:51, Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr> wrote:
>
>> On Mon, 30 Mar 2015 17:37:28 +0200
>> Vincenzo Campanella <vinz65(at)gmail(dot)com> wrote:
>> Stirling Newberry <stirling(dot)newberry(at)gmail(dot)com> wrote:
>>
>> >post the code
>>
>> Here you go :
>>
>> http://pastebin.com/eVXZiFws
>>
>>
>> This is a mod_perl module used in the HeaderParser phase of the Apache
>> request cycle; it first grabs the sql associated with the model, and passes
>> parameters to it; this sql is used to retrieve the required values for the
>> model, and the placeholders in the document are replaced with those values.
>> The user is then redirected to the newly created document
>>
>> You can see it in action in the demo account of the site referenced in my
>> signature : open any file (those are legal files/insurance claims), click
>> on the 'Contributors' tab (third tab from left; add a contributor if none
>> is present), and click on 'Templates'. Click on the template to generate a
>> document
>>
>>
>> --
>> Salutations, Vincent Veyron
>>
>> https://legalcase.libremen.com/
>> Legal case, contract and insurance claim management software
>>
>
>
If PHP is an option, you might want to look at the Tiny But Strong template
system (http://www.tinybutstrong.com/), along with the OpenTBS plugin (
http://www.tinybutstrong.com/plugins/opentbs/demo/demo.html).

We used it to replace some homegrown code similar to what Vincent described
that directly manipulated the document. There are enough idiosyncracies
among the file formats that I've been much happier using the TBS code. I
think this is especially true if you are merging multiple records into a
single, repeating template document as opposed to doing a single set of
replacements.

Cheers,
Ken

--
AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ <http://agency-software.org/>*
*https://agency-software.org/demo/client
<https://agency-software.org/demo/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.