Re: [Zope] is there a zope product for generating spreadsheets?

2009-05-05 Thread Krishnakant
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.


___
Zope maillist  -  [email protected]
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 )


Re: [Zope] is there a zope product for generating spreadsheets?

2009-05-05 Thread Marco Bizzarri
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  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  -  [email protected]
>> 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  -  [email protected]
> 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/
___
Zope maillist  -  [email protected]
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 )


Re: [Zope] is there a zope product for generating spreadsheets?

2009-05-05 Thread Chris Withers
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
___
Zope maillist  -  [email protected]
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 )


Re: [Zope] is there a zope product for generating spreadsheets?

2009-05-05 Thread Chris Withers
[email protected] wrote:
> http://www.zopelabs.com/cookbook/1075841024

Eee gads that's a horrible hack...
It does work, but there are *much* better options...

> http://www.zopelabs.com/cookbook/994090604/1090929950

CSVs suck ;-)

Chris

-- 
Simplistix - Content Management, Zope & Python Consulting
- http://www.simplistix.co.uk
___
Zope maillist  -  [email protected]
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 )


Re: [Zope] is there a zope product for generating spreadsheets?

2009-05-05 Thread Chris Withers
Thomas Bennett 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

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
___
Zope maillist  -  [email protected]
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 )


Re: [Zope] is there a zope product for generating spreadsheets?

2009-05-05 Thread Thomas Bennett
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  -  [email protected]
> 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 AnalystP O Box 32026
University LibraryBoone, North Carolina 28608
(828) 262 6587

Library Systems Help Desk: https://www.library.appstate.edu/help/
==
___
Zope maillist  -  [email protected]
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 )


Re: [Zope] is there a zope product for generating spreadsheets?

2009-05-04 Thread garry
Quoting Krishnakant :

> 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



___
Zope maillist  -  [email protected]
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 )


Re: [Zope] is there a zope product for generating spreadsheets?

2009-05-04 Thread Andreas Jung
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: [email protected] - 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


begin:vcard
fn:Andreas Jung
n:Jung;Andreas
org:ZOPYX Ltd. & Co. KG
adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany
email;internet:[email protected]
title:CEO
tel;work:+49-7071-793376
tel;fax:+49-7071-7936840
tel;home:+49-7071-793257
x-mozilla-html:FALSE
url:www.zopyx.com
version:2.1
end:vcard

___
Zope maillist  -  [email protected]
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 )


Re: [Zope] is there a zope product for generating spreadsheets?

2009-05-04 Thread Krishnakant
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.



___
Zope maillist  -  [email protected]
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 )


Re: [Zope] is there a zope product for generating spreadsheets?

2009-05-04 Thread Andreas Jung
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: [email protected] - 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


begin:vcard
fn:Andreas Jung
n:Jung;Andreas
org:ZOPYX Ltd. & Co. KG
adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany
email;internet:[email protected]
title:CEO
tel;work:+49-7071-793376
tel;fax:+49-7071-7936840
tel;home:+49-7071-793257
x-mozilla-html:FALSE
url:www.zopyx.com
version:2.1
end:vcard

___
Zope maillist  -  [email protected]
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 )