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. 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]