Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YcXEy-0004mt-SR for pgsql-general@arkaria.postgresql.org; Mon, 30 Mar 2015 10:48:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YcXEy-0005rx-20 for pgsql-general@arkaria.postgresql.org; Mon, 30 Mar 2015 10:48:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YcXEw-0005rk-TJ; Mon, 30 Mar 2015 10:48:18 +0000 Received: from mail-am1on0746.outbound.protection.outlook.com ([2a01:111:f400:fe00::746] helo=emea01-am1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YcXEr-0001j6-C4; Mon, 30 Mar 2015 10:48:17 +0000 Received: from DB3PR05MB426.eurprd05.prod.outlook.com (10.141.7.13) by DB3PR05MB428.eurprd05.prod.outlook.com (10.141.7.20) with Microsoft SMTP Server (TLS) id 15.1.118.21; Mon, 30 Mar 2015 10:48:07 +0000 Received: from DB3PR05MB426.eurprd05.prod.outlook.com ([10.141.7.13]) by DB3PR05MB426.eurprd05.prod.outlook.com ([10.141.7.13]) with mapi id 15.01.0118.022; Mon, 30 Mar 2015 10:48:07 +0000 From: Hector Vass To: avpro avpro , "pgsql-novice@postgresql.org" , "pgsql-sql@postgresql.org" , "pgsql-general@postgresql.org" Subject: Re: [SQL] Link Office Word form document with data from PostgreSQL Thread-Topic: [SQL] Link Office Word form document with data from PostgreSQL Thread-Index: AQHQasJszVsDl2Ogp0yC4+fXZ6tfbJ001bME Date: Mon, 30 Mar 2015 10:48:07 +0000 Message-ID: <1427712486496.87731@metametrics.co.uk> References: In-Reply-To: Accept-Language: en-GB, en-US Content-Language: en-GB X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [81.148.80.242] authentication-results: gmail.com; dkim=none (message not signed) header.d=none; x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:DB3PR05MB428; x-microsoft-antispam-prvs: x-forefront-antispam-report: BMV:1; SFV:NSPM; SFS:(10019020)(53754006)(19627405001)(106116001)(107886001)(77156002)(62966003)(19580395003)(19580405001)(76176999)(2501003)(66066001)(2201001)(16236675004)(86362001)(54356999)(15975445007)(102836002)(2950100001)(50986999)(87936001)(92566002)(2656002)(2900100001)(19625215002)(40100003)(74482002)(19617315012)(46102003)(122556002)(36756003)(77096005)(117636001); DIR:OUT; SFP:1102; SCL:1; SRVR:DB3PR05MB428; H:DB3PR05MB426.eurprd05.prod.outlook.com; FPR:; SPF:None; MLV:sfv; LANG:en; x-exchange-antispam-report-test: UriScan:; x-exchange-antispam-report-cfa-test: BCL:0; PCL:0; RULEID:(601004)(5005006)(5002010); SRVR:DB3PR05MB428; BCL:0; PCL:0; RULEID:; SRVR:DB3PR05MB428; x-forefront-prvs: 05315CBE52 Content-Type: multipart/alternative; boundary="_000_142771248649687731metametricscouk_" MIME-Version: 1.0 X-OriginatorOrg: metametrics.co.uk X-MS-Exchange-CrossTenant-originalarrivaltime: 30 Mar 2015 10:48:07.1079 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 0245920b-b0ee-44df-a137-423185636e7a X-MS-Exchange-Transport-CrossTenantHeadersStamped: DB3PR05MB428 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org --_000_142771248649687731metametricscouk_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable If you have windows then yes something like vba to pull data into MS Office= Word .. search google for 'ms word odbc connection' a postgres mailing lis= t is not the right place to do this search If you are on *nix don't have/want windows & office products but want to ge= nerate/write to a MS Office Word document then postgresql extension perlu a= nd something from the CPAN library like Win32::Word::Writer will work Hector Vass +44(0)7773 352 559 * Metametrics, International House, 107 Gloucester Road, Malmesbury, Wilt= shire, SN16 0AJ * www.metametrics.co.uk ________________________________ From: pgsql-sql-owner@postgresql.org on be= half of avpro avpro Sent: 30 March 2015 09:20 To: pgsql-novice@postgresql.org; pgsql-sql@postgresql.org; pgsql-general@po= stgresql.org Subject: [SQL] Link Office Word form document with data from PostgreSQL Hi all, Have you ever experienced how to populate fields from a MS Office Word docu= ment 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 A= ccess. Thank you for your input --_000_142771248649687731metametricscouk_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

If you have windows then&= nbsp;yes something like vba to pull data into MS Office Word .. search= google for 'ms word odbc connection' a postgres mailing list is = not the right place to do this search


If you are on *nix d= on't have/want windows & office products but want to generate/writ= e to a MS Office Word document then postgresql extension perlu and som= ething from the CPAN library like Win32::Word::Writer will work



Hector Vass




+44(0)7773 352 559

*  Metametrics, International House, 107 Glouc= ester Road,  Malmesbury, Wiltshire, SN16 0AJ

8   www.metam= etrics.co.uk

 

From: pgsql-sql-owner@postg= resql.org <pgsql-sql-owner@postgresql.org> on behalf of avpro avpro &= lt;avprowebeden@gmail.com>
Sent: 30 March 2015 09:20
To: pgsql-novice@postgresql.org; pgsql-sql@postgresql.org; pgsql-gen= eral@postgresql.org
Subject: [SQL] Link Office Word form document with data from Postgre= SQL
 

Hi all,

Have you ever experienced how to populate fields from a MS O= ffice Word document with a PostgreSQL data available either in a table or v= iew?

I haven’t seen anything on the web; only possible with= MS products, VS or Access.

Thank you for your input

--_000_142771248649687731metametricscouk_--