Bonjour,
Je forward ici le mail de Clément Varaldi qui a développé un pont entre
MySQL et OOo pour réaliser un mailing par voie postale ou e-mailing.
Ce patch est sous licence GPL et n'est pas complètement 'out of the
box', vous aurez besoin de le modifier pour le faire fonctionner.
A bientôt
Sophie
-------- Original Message --------
Subject: [api-dev] pyOOomailing: a bunch of scripts to perform emailing
using mysql&OOo
Date: Fri, 02 Dec 2005 11:20:58 +0100
From: "Clément Varaldi (ML)" <[EMAIL PROTECTED]>
Reply-To: dev@api.openoffice.org
To: dev@api.openoffice.org
Hi,
As annonced quite a while ago (about one month or two), I worked on a
bridge between mysql and OOo that prepares and actually... do a mailing
(postal mailing or via email).
Today, I striped the code to remove all parts I can't communicate, and
freed the code as GPL.
I called it pyOOomailing, as it uses python and OOo. It's far from being
perfect, but it's sufficient for the use I'll make of it.
Dependencies:
* pdftk to make a fusion of multiple pdfs to one (used on postal sent
only, to make a single pdf that must be printed).
* OOo (2.0 should be better). Tested on Mac OS X Panther (many thanks to
all the mac porting team, and more specifically ericb2 and lgodard).
* python2.4, with the standard modules, and _mysql _mysqlExceptions
modules.
Features:
* use a mysql database to get datas
* fill fields marked in the .sx*, od*... files as {field}
* perform a mailing: the email is sent in HTML format only (for the
moment), and all attached files are added. OOo attached files are
interpreted and fields are replaced, then converted in pdf format.
* perform a postal mailing: a standalone pdf ready-to-print is
generated, containing all pages for all contacts.
Not Featured:
* all the database scheme. I added a part of the scheme, just to make
sense for some datas to extract.
* read README.txt to see an improvment that could fasten the process.
* it's not really an outofthebox script. You'll have to put your hand
into the code to make it work.
How does it work?
the dev is made in two parts:
* OOo launched as server, and a python script that will perform the mailing
* mysql datas are asked to a XMLRPC server that makes the bridge between
OOo and mysql.
* it uses file locks to perform the mailing. This meand you can put all
this in a cron service and pyOOomailing will wait for a file to be here,
so he could perform the mailing concerned.
* By the way, the XMLRPC server, mysql and OOo can be launched on
different places :)
Now, here is the URI: http://www.varaldi.org/pyOOomailing/
it could be used freely as it's GPL'ed. If you want to put it in the
list of python scripts for OOo, please tell me, just for self
satisfaction :D
--
Clément Varaldi
(IRC contact: iznogoud on freenode/#openoffice.org)
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.10/190 - Release Date: 01/12/2005
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.10/190 - Release Date: 01/12/2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
