python access oracle database
hi all, I'm using java write little program ,fetching data from oracle database (jdbc:oci),then open a spreadsheet to write in using java uno. Java need do lots query interface,i see that python is quite simple no that query staff.I can use python shipped with openoffice open a spreadsheet,write data in it,but i cant access oracle database. I know there is cx_oracle,but how can i let it work with the python shipped by openoffice(version3.2)? any help would be appreciated.
Re: [CWiki] Account Whitelisting
On 06/01/2015 Jamian Vieira wrote: username: Jamianv real name: Jamian Vieira Welcome, account whitelisted. Andrea - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
[CWiki] Account Whitelisting
username: Jamianv real name: Jamian Vieira
Directory of Volunteers Addition
Just writing a note to say I added myself to the list of volunteers on CWiki.
Infrastructure module
I'm working on the Infrastructure module
odd building issue in testtools...
My latest build is erroring out in this section of
/trunk/main/testtools/source/bridetest/makefile.mk (lines 135 - 144)
runtest : $(DLLDEST)$/uno_types.rdb $(DLLDEST)$/uno_services.rdb
makefile.mk \
$(SHL1TARGETN) $(SHL2TARGETN) $(SHL3TARGETN)
.IF $(COM)$(OS)$(CPU) == GCCMACOSXP || $(COM)$(OS)$(CPU) ==
GCCFREEBSDI || $(OS)$(CPU)==SOLARISS
@echo Mac OSX PPC GCC ad FreeBDS/i386 fails this test! likely broken
UNO bridge. Fix me.
.ELSE
cd $(DLLDEST) $(AUGMENT_LIBRARY_PATH) $(SOLARBINDIR)/uno \
-ro uno_services.rdb -ro uno_types.rdb \
-s com.sun.star.test.bridge.BridgeTest -- \
com.sun.star.test.bridge.CppTestObject
.ENDIF
-- error message --
terminate called after throwing an instance of
'com::sun::star::uno::RuntimeException'
/bin/bash: line 1: 7065 Aborted
LD_LIBRARY_PATH=/home/kschenk/AOO_source/openoffice/trunk/main/solver/420/unxlngi6/lib${LD_LIBRARY_PATH:+:${LD_LIBRARY_PATH}}
-- end error message --
I can't say absolutely NOTHING has changed on my system since my last
build about a month ago, but, does anyone have any ideas about this?
I see the warnings about MacOSX PPC, etc.
--
-
MzK
There's a bit of magic in everything,
and some loss to even things out.
-- Lou Reed
-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: python access oracle database
It works! During the installation, choose the python-core directory ,done.Thanks ,Alex 2015/01/06 4:21 Alexandro Colorado j...@oooes.org: some modules need to be compiled to the python virtual machine, that said, you could try to install the package manually, usually the README files will guide you, make sure the python path is correctly setup for the environment. https://bitbucket.org/anthony_tuininga/cx_oracle/src/880caaa70dac7969c4f553c26ba44e1996058add/README.txt?at=default#cl-22 On Mon, Jan 5, 2015 at 10:12 AM, Brick Ma brickman...@gmail.com wrote: hi all, I'm using java write little program ,fetching data from oracle database (jdbc:oci),then open a spreadsheet to write in using java uno. Java need do lots query interface,i see that python is quite simple no that query staff.I can use python shipped with openoffice open a spreadsheet,write data in it,but i cant access oracle database. I know there is cx_oracle,but how can i let it work with the python shipped by openoffice(version3.2)? any help would be appreciated. -- Alexandro Colorado Apache OpenOffice Contributor 882C 4389 3C27 E8DF 41B9 5C4C 1DB7 9D1C 7F4C 2614
RE: html code generated from Open Office
You need to download and read the OASIS ODF Specification. Since you are interested specifically in Writer, you might as well start with ODF 1.1 (a single document). You can get all of the bits at http://docs.oasis-open.org/office/v1.1/OS/. The ODT file is a Zip file that has multiple parts of the document as XML files within the Zip. You can see such a file by renaming it. E.g., rename test.odt to test.odt.zip and open it as a Zip. Then rename it back. The specification for OpenOffice 1.0 XML format does not apply to any version of OpenOffice since ODF was adopted and implemented. Also, the special Office Writer Web format is not singled out in the ODF specification. What I suggest you do is make test documents and save them as HTML Document (OpenOffice Writer) and see what is produced. Also, open such a document in Writer to see how it comes up. The latest specification is ODF 1.2. It is much larger and only Part 1 and Part 3 apply to Writer. (Part 2 is all about spreadsheet formulas.) You also might want to take a look at the new Corinthia project which is interested in document conversions using HTML as an intermediary. - Dennis From: Howard Morris (aka Col Boogie) [mailto:howard_cary_mor...@hotmail.com] Sent: Monday, January 5, 2015 20:36 To: dev@openoffice.apache.org Subject: html code generated from Open Office The reason I joined Open Office was to enhance the html code generated from writer. For now, I have constructed html code to upload an html file generated by Open Office and PHP code to tweak that code and download a better version. Everything I have doe so far is in the attached zzz.zip file. Explanations are in Readme.txt I would have liked to have done this directly, but when I asked how to get there, I was directed to a site where I could download all the modules one by one, and there seemed to be hundreds of them and no indication what any of them contained with dubious directions how to put them together. This is not how I like to do things, so I went the other way for now. I seem to have run across documentation that Open Office puts its files internally into a XML format. If I could extract the XML directly from the .odt file I could do everything from there. Assuming that is true, is there an updated copy of https://www.openoffice.org/xml/xml_specification.pdf ? I would hope that whoever is doing the documentation keeps that up to date. It will take me at least 20 hours to read that document, but at least I will retain most of it the first time. Howard Morris
RE: Hello Again!
I am thrilled for whatever you guys have in store... Kudos on the compatibility improvements for .docx document import today, I was able to view a highly complex formatted document without issues. Best of luck in your development plans. Best, Mike -Original Message- From: jan i j...@apache.org Sent: 1/4/2015 3:21 PM To: dev dev@openoffice.apache.org Subject: Re: Hello Again! On 4 January 2015 at 21:09, Michael J. Acevedo vea1...@gmail.com wrote: Greetings to the Apache OpenOffice Community! I just wanted to wish the development team a Happy New Year and just say that I am getting back into Apache OpenOffice. Funny enough my line of work after college has forced me to get an office suite and since Apache OpenOffice got me through college just fine I thought it would be great to help me out in my professional career. Glad to be home and I am eager to see what is in store for Apache OpenOffice in 2015 (perhaps AOO 5.0? ). Welcome back. One of the best ways to learn about what we have in store is to go one of the event where we participate, in the coming months that is: - FOSDEM, Brucelles, 31 januar - 1 Februar (free entrance) - ApacheCon North America, Austin Texas 13 - 17 april. At the moment we dont have plans for AOO 5.0. Going from 4.x to 5.x normally means incompatibility and it not something that should be done lightly, we are proud of keeping compatibility so watch out for new 4.x versions. rgds jan i. Warm Regards, Michael
New Volunteer
Hello there! My name is Jamian Vieira, I am from Los Angeles, California I'm Intereseted in Music, Rock-Climbing, Movies and Programming. This is my first time working on an open source project and I'm excited to get started.
Re: python access oracle database
some modules need to be compiled to the python virtual machine, that said, you could try to install the package manually, usually the README files will guide you, make sure the python path is correctly setup for the environment. https://bitbucket.org/anthony_tuininga/cx_oracle/src/880caaa70dac7969c4f553c26ba44e1996058add/README.txt?at=default#cl-22 On Mon, Jan 5, 2015 at 10:12 AM, Brick Ma brickman...@gmail.com wrote: hi all, I'm using java write little program ,fetching data from oracle database (jdbc:oci),then open a spreadsheet to write in using java uno. Java need do lots query interface,i see that python is quite simple no that query staff.I can use python shipped with openoffice open a spreadsheet,write data in it,but i cant access oracle database. I know there is cx_oracle,but how can i let it work with the python shipped by openoffice(version3.2)? any help would be appreciated. -- Alexandro Colorado Apache OpenOffice Contributor 882C 4389 3C27 E8DF 41B9 5C4C 1DB7 9D1C 7F4C 2614
