is there a zope product for generating spreadsheets?
hello all, I am right now browsing through the grok tutorial and found it to be really amaising. I had been confused a few days regarding how I can put my application into zope. Thanks to all you who patiently answered my queries. Now I am wondering whether there is a product which can generate spreadsheet like output for some typicle data such as balance sheets or ledgers (with cell merging capability)? I would also like to know if there is some way I am make grok integrate open office in a way that I can generate open office spreadsheets and send it to a browser or open it in some way? I know there is a python library called odfpy which can fill up spreadsheets with data, but I don't know whether similar things are possible with zope. I have searched but did not find some thing like this. so is any thing of the above possible? happy hacking. Krishnakant.
On 04.05.09 23:07, Krishnakant wrote:
hello all, I am right now browsing through the grok tutorial and found it to be really amaising.
I had been confused a few days regarding how I can put my application into zope. Thanks to all you who patiently answered my queries.
Now I am wondering whether there is a product which can generate spreadsheet like output for some typicle data such as balance sheets or ledgers (with cell merging capability)?
I would also like to know if there is some way I am make grok integrate open office in a way that I can generate open office spreadsheets and send it to a browser or open it in some way?
http://lmgtfy.com/?q=python+excel http://pypi.python.org/pypi?%3Aaction=search&term=excel&submit=search
I know there is a python library called odfpy which can fill up spreadsheets with data, but I don't know whether similar things are possible with zope.
Why shouldn't that work?! Zope 2, Zope 3 and Grok allow you to import almost any Python package (as long as it makes sense). So where is the problem? -aj -- ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany Web: www.zopyx.com - Email: info@zopyx.com - Phone +49 - 7071 - 793376 Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535 Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK ------------------------------------------------------------------------ E-Publishing, Python, Zope & Plone development, Consulting
On Tue, 2009-05-05 at 04:55 +0200, Andreas Jung wrote:
http://lmgtfy.com/?q=python+excel http://pypi.python.org/pypi?%3Aaction=search&term=excel&submit=search
Thanks a lot, but I don't use, promote or recommend proprietory standards, so Open office is what I am looking for integrating
I know there is a python library called odfpy which can fill up spreadsheets with data, but I don't know whether similar things are possible with zope.
Why shouldn't that work?! Zope 2, Zope 3 and Grok allow you to import almost any Python package (as long as it makes sense). So where is the problem?
But I read that zope has some kind of restricted python. So will odfpy integrate? Further more, I would like to create my application as a self containing package like the plone installer which also installs python, zope and other dependencies. So I really don't know if odfpy will work. Or for that matter any library. May be I am asking this because I am very new to all this, happy hacking. Krishnakant.
On 05.05.09 08:23, Krishnakant wrote:
On Tue, 2009-05-05 at 04:55 +0200, Andreas Jung wrote:
http://lmgtfy.com/?q=python+excel http://pypi.python.org/pypi?%3Aaction=search&term=excel&submit=search
Thanks a lot, but I don't use, promote or recommend proprietory standards, so Open office is what I am looking for integrating
I know there is a python library called odfpy which can fill up spreadsheets with data, but I don't know whether similar things are possible with zope.
Why shouldn't that work?! Zope 2, Zope 3 and Grok allow you to import almost any Python package (as long as it makes sense). So where is the problem?
But I read that zope has some kind of restricted python. So will odfpy integrate? Further more, I would like to create my application as a self containing package like the plone installer which also installs python, zope and other dependencies.
Please check the available documentation. Zope 2: External methods: unrestricted, Product code: unrestricted, BrowserViews: unrestricted Zope 3: Browser view, Z3 package code: unrestricted Grok: everything unrestricted -aj-- ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany Web: www.zopyx.com - Email: info@zopyx.com - Phone +49 - 7071 - 793376 Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535 Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK ------------------------------------------------------------------------ E-Publishing, Python, Zope & Plone development, Consulting
Quoting Krishnakant <krmane@gmail.com>:
On Tue, 2009-05-05 at 04:55 +0200, Andreas Jung wrote:
http://lmgtfy.com/?q=python+excel http://pypi.python.org/pypi?%3Aaction=search&term=excel&submit=search
Thanks a lot, but I don't use, promote or recommend proprietory standards, so Open office is what I am looking for integrating
I know there is a python library called odfpy which can fill up spreadsheets with data, but I don't know whether similar things are possible with zope.
Why shouldn't that work?! Zope 2, Zope 3 and Grok allow you to import almost any Python package (as long as it makes sense). So where is the problem?
But I read that zope has some kind of restricted python. So will odfpy integrate? Further more, I would like to create my application as a self containing package like the plone installer which also installs python, zope and other dependencies.
So I really don't know if odfpy will work. Or for that matter any library. May be I am asking this because I am very new to all this, happy hacking. Krishnakant. There are a couple of things on Zopelabs that may be of interest:
http://www.zopelabs.com/cookbook/1075841024 http://www.zopelabs.com/cookbook/994090604/1090929950 HTH Regards Garry
garry@schoolteachers.co.uk wrote:
Eee gads that's a horrible hack... It does work, but there are *much* better options...
CSVs suck ;-) Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk
Krishnakant wrote:
On Tue, 2009-05-05 at 04:55 +0200, Andreas Jung wrote:
http://lmgtfy.com/?q=python+excel http://pypi.python.org/pypi?%3Aaction=search&term=excel&submit=search
Thanks a lot, but I don't use, promote or recommend proprietory standards, so Open office is what I am looking for integrating
Don't be a muppet. "Excel" often refers to the file format, which is read and written by all sorts of software, not just evil empire stuff...
But I read that zope has some kind of restricted python. So will odfpy integrate?
As Andreas has pointed out, you should do a bit more research before making silly comments like this ;-)
Further more, I would like to create my application as a self containing package like the plone installer which also installs python, zope and other dependencies.
That's got nothing to do with any of this...
Or for that matter any library. May be I am asking this because I am very new to all this,
I would use the Excel file format and generate the files with: http://pypi.python.org/pypi/xlwt If you need to parse excel files after they are uploaded to extract their data, I'd do so with this: http://pypi.python.org/pypi/xlrd Help on both of these libraries can be obtained here: http://groups.google.com.au/group/python-excel cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk
On Tue, 2009-05-05 at 15:38 +0100, Chris Withers wrote:
Don't be a muppet. "Excel" often refers to the file format, which is read and written by all sorts of software, not just evil empire stuff...
Issue is not the software, ut the standard. Our policy is not just to discourage proprietory software, but also closed standards. never the less, I just got to know that odfpy would work with my application. Now I will try and look at the possibility of having the browser open the odf spreadsheet or opening calc itself.
But I read that zope has some kind of restricted python. So will odfpy integrate?
As Andreas has pointed out, you should do a bit more research before making silly comments like this ;-)
The documentation is a bit overvelming and donting, so there is a lot of things to read before getting to what one actually wanted to know. I come from the world of apache, php and pure python where I would not face such problems. But it's true that some research reveals the solution.
Further more, I would like to create my application as a self containing package like the plone installer which also installs python, zope and other dependencies.
That's got nothing to do with any of this...
Yes, it is just one of those things I am worried about because I might lavishly include all the modules I need and set my development environment right, but I don't expect it from my customers who are not eaven techi let alone being hackers. So thwy will not take paines to do all the settings fromthe commandline. Any ways things now seem to be perfectly all right with me. thanks a million. happy hacking. Krishnakant.
hello all, Seems my problem with reports is almost solved and I know that office integration is also possible with zope. Now my question is while I was reading grok tutorials, I realise that I could not quite find some widgets which can do dynamic self updating or database based validations. For example if a user is making an invoice, the field holding entered quantity must quickly query the db for the available current stock and there has to be an error message which says "you don't have sufficient stock for the given item ". I don't see such widgets available in grok. Am I missing some part? I believe some ajax like functionality is needed here. Further more, I will also need to develop drop down menus and such other widgets. I had discovered toscawidgets but get the impression that they can be used on pylons and turbogears but not on zope? Is this true? happy hacking. Krishnakant.
On Tue, May 5, 2009 at 23:22, Krishnakant <krmane@gmail.com> wrote:
Now my question is while I was reading grok tutorials, I realise that I could not quite find some widgets which can do dynamic self updating or database based validations.
Eeeehhhh, no, they are HTML widgets. You might as well ask for SQL-statements that generate HTML widgets. It just doesn't make any sense.
For example if a user is making an invoice, the field holding entered quantity must quickly query the db for the available current stock and there has to be an error message which says "you don't have sufficient stock for the given item ".
Yes, you want to make a Javascript app. That's fine and good. For that you would likely want some sort of Ajax library. Grok isn't an Ajax library, but you can use Ajax libraries with Grok if you wish.
I believe some ajax like functionality is needed here.
Exactly. -- Lennart Regebro: Python, Zope, Plone, Grok http://regebro.wordpress.com/ +33 661 58 14 64
I don't know if there is a reason not to use this but no one has mentioned PyUNO. http://wiki.services.openoffice.org/wiki/Python From that page: "OpenOffice.org ships with a python scripting language, version 2.3.4. This Python distribution comes with the Uno module which connects the UNO API with the python scripting language." I'm thinking it should allow you to read from a spreadsheet and then you would have to format output as you want. There are a lot of other links related to pyuno, I notice one is a tutorial. http://www.google.com/search?hl=en&q=openoffice+3+python&btnG=Search and if you add 'calc' to the search you can narrow down the search and find things like "OpenOffice.org Utility Library, or ooolib in short, is actually more than one library module. Included are a Python module (ooolib-python) and a Perl module (ooolib-perl). The Python module is currently focused on Calc and can be used to create OpenDocument Format Calc spreadsheets." Thomas On Monday 04 May 2009 17:07:28 Krishnakant wrote:
hello all, I am right now browsing through the grok tutorial and found it to be really amaising.
I had been confused a few days regarding how I can put my application into zope. Thanks to all you who patiently answered my queries.
Now I am wondering whether there is a product which can generate spreadsheet like output for some typicle data such as balance sheets or ledgers (with cell merging capability)?
I would also like to know if there is some way I am make grok integrate open office in a way that I can generate open office spreadsheets and send it to a browser or open it in some way?
I know there is a python library called odfpy which can fill up spreadsheets with data, but I don't know whether similar things are possible with zope.
I have searched but did not find some thing like this.
so is any thing of the above possible?
happy hacking. Krishnakant.
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
-- ========================================== Thomas McMillan Grant Bennett Appalachian State University Operations & Systems Analyst P O Box 32026 University Library Boone, North Carolina 28608 (828) 262 6587 Library Systems Help Desk: https://www.library.appstate.edu/help/ ==========================================
Thomas Bennett wrote:
I don't know if there is a reason not to use this but no one has mentioned PyUNO.
Running open office on a server is pretty shaky... Been there, done that, never rolled it into production 'cos it was that shaky... Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk
I could suggest taking a look at oood from erp5 project http://www.erp5.org/HowToUseOood it needs a little tweaking to work with calc files, but nothing impossible... and it seems even stable... Regards Marco On Tue, May 5, 2009 at 3:30 PM, Thomas Bennett <bennetttm@appstate.edu> wrote:
I don't know if there is a reason not to use this but no one has mentioned PyUNO.
http://wiki.services.openoffice.org/wiki/Python
From that page: "OpenOffice.org ships with a python scripting language, version 2.3.4. This Python distribution comes with the Uno module which connects the UNO API with the python scripting language."
I'm thinking it should allow you to read from a spreadsheet and then you would have to format output as you want.
There are a lot of other links related to pyuno, I notice one is a tutorial.
http://www.google.com/search?hl=en&q=openoffice+3+python&btnG=Search
and if you add 'calc' to the search you can narrow down the search and find things like
"OpenOffice.org Utility Library, or ooolib in short, is actually more than one library module. Included are a Python module (ooolib-python) and a Perl module (ooolib-perl).
The Python module is currently focused on Calc and can be used to create OpenDocument Format Calc spreadsheets."
Thomas
On Monday 04 May 2009 17:07:28 Krishnakant wrote:
hello all, I am right now browsing through the grok tutorial and found it to be really amaising.
I had been confused a few days regarding how I can put my application into zope. Thanks to all you who patiently answered my queries.
Now I am wondering whether there is a product which can generate spreadsheet like output for some typicle data such as balance sheets or ledgers (with cell merging capability)?
I would also like to know if there is some way I am make grok integrate open office in a way that I can generate open office spreadsheets and send it to a browser or open it in some way?
I know there is a python library called odfpy which can fill up spreadsheets with data, but I don't know whether similar things are possible with zope.
I have searched but did not find some thing like this.
so is any thing of the above possible?
happy hacking. Krishnakant.
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
-- ========================================== Thomas McMillan Grant Bennett Appalachian State University Operations & Systems Analyst P O Box 32026 University Library Boone, North Carolina 28608 (828) 262 6587
Library Systems Help Desk: https://www.library.appstate.edu/help/ ========================================== _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
-- Marco Bizzarri http://sf.net/projects/qt-asterisk/ http://notenotturne.blogspot.com/ http://iliveinpisa.blogspot.com/
participants (7)
-
Andreas Jung -
Chris Withers -
garry＠schoolteachers.co.uk -
Krishnakant -
Lennart Regebro -
Marco Bizzarri -
Thomas Bennett