Lukasz Szybalski wrote:
Hello,
I have updated the manual and give example on how to use sqlalchemy
(python database wrapper for mssql,mysql,postgres,sqlite,oracle) and
openoffice. The code shows you how to use openoffice as a document
template and fill in the data from the database.
SqlAlchemy and OpenOffice
http://lucasmanual.com/mywiki/OpenOffice#head-a6f86c6beea8170c083cd3f45438066e6f20760f
The program works great. I'm able to create around 100 letters per
minute which is way better then typing them. Because it is so easy to
create mini tempalte in openoffice I can let marketing people design
the forms, and I just fill it in. Great Combination!!!
Few problems I was hoping you could could help with.
1. I would like to skip creating the temp file.
Template.odt ->(find and replace)->(save as)-> temp.odt >
insertDocumentFromURL ->(final.odt)
and just do
Template.odt ->(find and replace )->append ->(final.odt)
How can I do it?
2. Is there a way to open openoffice in some kind of quite mode?
openoffice -accept="socket,host=localhost,port=2002;urp;" This opens
up the actual program. I think if I was able to run it in a background
that would speed things up.
you should maybe use a second user installation and start the office
headless.
Try the additional parameters
-env:UserInstallation=<somewhere>/myuserdir -headless -nofirststartwizard
Juergen
3. How can I "find" things inside of textbox. I had to remove all
textbox fields because "find" couldn't look into them.
Ideas?
Thanks,
Lucas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Sun Microsystems GmbH Juergen Schmidt
Nagelsweg 55 Technical Lead Programmability
20097 Hamburg, Germany
Registered Office: Sun Microsystems GmbH, Sonnenallee 1, D-85551
Kirchheim-Heimstetten
Commercial register of the Local Court of Munich: HRB 161028
Managing Directors: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Chairman of the Supervisory Board: Martin Haering
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
