On Fri, 02 Dec 2005 10:20:58 -0000, Clément Varaldi (ML)
<[EMAIL PROTECTED]> wrote:
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
Sounds like a great choice, OOo currently has a male module within UNO,
however there have been some problems when constructing the latest build
so the email module is not yet done (this sound like a duplication of
efforts). You can learn about the mail module on the IDL reference here:
This contain everything you will expect from the mail module, XMailServer
XMailMessage you can find further information here:
http://api.openoffice.org/docs/common/ref/com/sun/star/mail/module-ix.html
You can look at the current code on the Word Processing project
http://sw.openoffice.org, the code can be checked on the Version Control
link. Is hard for me to pin-point the location of the actual code but I am
sure that the Project Lead (Andreas Marten
[EMAIL PROTECTED]) can help you find it and the current
mantainer of the code.
--
Alexandro Colorado
CoLeader of OpenOffice.org ES
http://es.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
