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

2015-03-30 Thread Stephen Davies
Open Office etc can populate fields via JDBC from any database including PostgreSQL. Cheers, Stephen On 30/03/15 19:52, Tim Clarke wrote: Two options that I know of: 1) Use Java and the Apache POI project 2) Write a file containing the data in some other format like HTML then open that with Wo

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

2015-03-30 Thread Ken Tanzer
On Mon, Mar 30, 2015 at 1:51 PM, avpro avpro 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 Veyr

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

2015-03-30 Thread avpro avpro
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 wrote: > On Mon, 30 Mar 2015 17:37:28 +0200 > Vincenzo Campan

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

2015-03-30 Thread Vincent Veyron
On Mon, 30 Mar 2015 17:37:28 +0200 Vincenzo Campanella wrote: Stirling Newberry 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

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

2015-03-30 Thread Andy Colson
On 3/30/2015 10:18 AM, John R Pierce wrote: On 3/30/2015 1:20 AM, avpro avpro wrote: Have you ever experienced how to populate fields from a MS Office Word document with a PostgreSQL data available either in a table or view? I haven’t seen anything on the web; only possible with MS products, V

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

2015-03-30 Thread Vincenzo Campanella
Il 30.03.2015 15:01, Vincent Veyron ha scritto: Hi, I use Perl for this. The process is : -unzip the .docx document, and look for /word/document.xml in the resulting directory -substitute field names with their values in this file (I don't use MS Word 'fields', though, just placeholders that

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

2015-03-30 Thread John R Pierce
On 3/30/2015 1:20 AM, avpro avpro wrote: Have you ever experienced how to populate fields from a MS Office Word document with a PostgreSQL data available either in a table or view? I haven’t seen anything on the web; only possible with MS products, VS or Access. Thank you for your input

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

2015-03-30 Thread Vincent Veyron
On Mon, 30 Mar 2015 10:20:15 +0200 avpro avpro wrote: > Have you ever experienced how to populate fields from a MS Office Word > document with a PostgreSQL data available either in a table or view? > > I haven’t seen anything on the web; only possible with MS products, VS or > Access. Hi, I us

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

2015-03-30 Thread Tim Clarke
Two options that I know of: 1) Use Java and the Apache POI project 2) Write a file containing the data in some other format like HTML then open that with Word. Tim Clarke On 30/03/15 09:20, avpro avpro wrote: > > Hi all, > > Have you ever experienced how to populate fields from a MS Office Word >

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

2015-03-30 Thread avpro avpro
Hi all, Have you ever experienced how to populate fields from a MS Office Word document with a PostgreSQL data available either in a table or view? I haven’t seen anything on the web; only possible with MS products, VS or Access. Thank you for your input