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

From: Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr>
To: Vincenzo Campanella <vinz65(at)gmail(dot)com>, stirling(dot)newberry(at)gmail(dot)com
Cc: avpro avpro <avprowebeden(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Re: [GENERAL] Link Office Word form document with data from PostgreSQL
Date: 2015-03-30 17:51:42
Message-ID: 20150330195142.679f46979311c6b80efc0f24@wanadoo.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice pgsql-sql

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Deven Phillips 2015-03-30 17:54:54 JSON "pretty" and selecting nested JSON fields
Previous Message Andy Colson 2015-03-30 16:48:21 Re: Link Office Word form document with data from PostgreSQL

Browse pgsql-novice by date

  From Date Subject
Next Message avpro avpro 2015-03-30 20:51:16 Re: Re: [GENERAL] Link Office Word form document with data from PostgreSQL
Previous Message Kevin Grittner 2015-03-30 17:32:02 Re: Optimize a big matrix select

Browse pgsql-sql by date

  From Date Subject
Next Message avpro avpro 2015-03-30 20:51:16 Re: Re: [GENERAL] Link Office Word form document with data from PostgreSQL
Previous Message Andy Colson 2015-03-30 16:48:21 Re: Link Office Word form document with data from PostgreSQL