June 2003 - Zope - Zope lists

text and html emails from zope
by Norman Khine 04 Jul '03

04 Jul '03

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 hello, i am trying to create an email from zope that can send the email in both plain text and html, so that users who only use text can view it, as well as those who have html enabled. how do i seperate the two within the <dtml-sendmail> tag. can i just put the <dtml-sendmail> text bit before the html <dtml-mime type="text/html" encode="7bit"> this part for the html </dtml-mime> </dtml-sendmail> thanks norman -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQA/AwUBPwB7hXGyKIoODyswEQIgtgCg8ry67TBrsA33fsn9tGKk9AQ6ntEAoKJm QnLBs1pwfP8SUxlH1Ca1UtXf =gh8q -----END PGP SIGNATURE-----

2 1

Zcatalog, full text index, and size issues
by Stacy Roberts 04 Jul '03

04 Jul '03

My Data.fs is growing by an average 200K each time I add an object to my application. Please note that I have added the code to cause a reindexing of the Catalog after such an object is added. I have narrowed this size increase down to being a result of calling the reindex_object() method in order to update my Catalog with the change. My question is if this is a side effect of having my classes be CatalogAware. I have a full text index that is rather lengthy. It handles the container object and all subobjects (possibly 200+ 'data element' objects). Once I removed my full text index, the size decreased to about 27K per operation. If my problem is a side effect of using a full text index or the ZCatalog, what alternative can I explore? I MUST be able to provide a search capability on the entire text, but I can't afford a 200K increase for each little change. I have to be able to handle 2K+ of these operations daily. Thanks in advance, Stacy __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com

3 2

ZODB startup error
by Uwe Schuerkamp 04 Jul '03

04 Jul '03

Hi folks, I just tried Zope 2.6.2b3 on Red Hat 8.0 in order to check wether it fixes the "integer overflow in pack()" problem (Collector issue 946), and trying to start Zope now results in the error attached below. Is there any way to check the Data.fs file manually from the command line? Thanks in advance for your ideas, uwe ###################################################################### [zope@dev02l Zope-2.6.2b3-linux2-x86]$ ./start -X -w9080 ------ 2003-06-30T10:44:38 INFO(0) zdaemon Started subprocess: pid 7577 ------ 2003-06-30T10:45:14 PANIC(300) ZODB FS FS21 ERROR: /web/server/cvs/zope/Zope-2.6 .2b3-linux2-x86/var/Data.fs data record exceeds transaction record at 244778885 ------ 2003-06-30T10:45:14 PANIC(300) z2 Startup exception Traceback (innermost last): File /server/cvs/zope/Zope-2.6.2b3-linux2-x86/z2.py, line 585, in ? File /web/server/cvs/zope/Zope-2.6.2b3-linux2-x86/lib/python/Zope/__init__.py, line 46, in startup (Object: startup) File /web/server/cvs/zope/Zope-2.6.2b3-linux2-x86/lib/python/Zope/App/startup. py, line 53, in startup File /web/server/cvs/zope/Zope-2.6.2b3-linux2-x86/lib/python/ZODB/FileStorage. py, line 287, in __init__ (Object: /web/server/cvs/zope/Zope-2.6.2b3-linux2-x86/var/Data.fs) File /web/server/cvs/zope/Zope-2.6.2b3-linux2-x86/lib/python/ZODB/FileStorage. py, line 1865, in read_index File /web/server/cvs/zope/Zope-2.6.2b3-linux2-x86/lib/python/ZODB/FileStorage. py, line 176, in panic CorruptedTransactionError: /web/server/cvs/zope/Zope-2.6.2b3-linux2-x86/var/Data .fs data record exceeds transaction record at 244778885 ###################################################################### -- Uwe Schuerkamp, Nionex GmbH http://www.nionex.com/ Uwe.Schuerkamp(a)nionex.net FON: +49 (0)5241 / 80 10 66, FAX: / 806 23 38 GnuPG KeyID: 5887047D Avenwedder Str. 55, 33311 Guetersloh GnuPG Fingerprint: 2E 13 20 22 9A 3F 63 7F 67 6F E9 B1 A8 36 A4 61

3 2

Cooperative work on zope projects
by Stefan Loidl 04 Jul '03

04 Jul '03

Hello, as I understood from discussions on the zope mailing list the version feature in zope shouldn't be used any more due to some problems and may disappear in future zope versions. I think the version feature is quite helpful in doing cooperative work on zope projects (i.e. > 1 persons develop a zope application together). So what I would like to know is, how others handle this and what a "recommended" way to do this is. Thanks. Greetings, Stefan -- Stefan Loidl Phone: +49 89 289 28882 Leibniz Supercomputing Center Fax: +49 89 2809460 Barer Str. 21 mailto:loidl@lrz.de 80333 Munich, Germany http://www.lrz.de

3 2

Unpickling Error
by Ian Firmin 04 Jul '03

04 Jul '03

Dear All, I'm trying to import a zexp file and get Error Type: UnpicklingError Error Value: invalid load key,". I have looked but cannot find any reference to what may be wrong with the file, Any ideas? TIA Ian

2 1

ZOPE IN WINDOWS, ANY WARNINGS I SHOULD KNOW? .RE: [Zope] crystal reports
by Ramon Linan 03 Jul '03

03 Jul '03

thank you Edward, what you say make a lot of sense, although, I will try to do that, I am sure is going to take me some time because I am just starting with zope. I have another question, I have found some people and books who don't advice at all to use Zope on windows system, especially with mysql for windows, is there any problem? I would like to know a real reason for not to (especially if I am going to be using crystal report). Also, I have read in a couple of books that the database that comes with Zope it is not very strong, I want to do a "project" to share pictures with my family (on the other side of the Atlantic), is there any reason for not using the DB that comes with zope. Thank you very much for making this learning experience lot quicker. Rezuma -----Original Message----- From: Edward Muller [mailto:edwardam@interlix.com] Sent: Wednesday, June 25, 2003 12:26 AM To: Ramon Linan Cc: zope(a)zope.org Subject: Re: [Zope] crystal reports The following is complete conjecture based on working with python/windows/zope... If you were to run the zope server on windows and install the complete python-win32 utilities you could connect python to Crystal Reports via COM/ActiveX and make calls to the Crystal Reports API. If you could then get the Crystal Reports COM/ActiveX control to spit out HTML you could then capture that and use it as you need it. The above would require at least writing some of your own external methods or a product. Plus you would have to understand COM programming under python-win32 (which isn't really that hard). A few years ago I made an Outlook/Exchange <-python -> XMLRPC gateway. It used python-win32's COM support and the DMAPI/MAPI (whatever they are called) APIs of Outlook/Exchange and exposed it via XMLRPC. It was neat. On Tue, 2003-06-24 at 15:26, Ramon Linan wrote: > Hi, anyone knows if there is a product that allow you to use already created crystal reports? > > Is also welcome advice about reporting tools to use with ODBC database connection. > > Thanks > > > (very new at this) > > _______________________________________________ > Zope maillist - Zope(a)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 ) -- Edward Muller Interlix (http://www.interlix.com) Phone: 417-862-0573 - Cell: 417-844-2435 - Fax: 417-862-0572 Web Hosting - PC Service & Support - Custom Programming - Network Service & Support Specializing in Open Source Solutions

7 10

Exporting zodb data (Urgent)
by Sukhwinder Singh 03 Jul '03

03 Jul '03

Hello, (I posted this question to zope-db(a)zope.org but no one replied so I am posting it here as it is urgent.) I have a web application which is written by some other person using zope/zodb/python. Now client wants to write this application using php/mysql. But existing data stored in zodb database has to be exported to mysql database. Zodb uses fileStorage to store data. I have tried zope's xml export but that doesn't make any sense to me. Now problem is I don't have much knowledge about zope. I have only basic knowledge that everything is stored as an object. I also have some knowledge of python. I have searched the web for any information about zodb but could not find much. I have only 2-3 days so I cannot learn zope then zodb and then python. My problems are: 1. How do I identify which of these objects store data(tables) because zope stores everything (images, dhtml files, folders etc) as objects so I want only objects which store data(rows) and then how many of these tables are there? 2.How do I determine how many fields are there in each data object and what are their names and data types. 3. How do I extract data from these objects and then store that to some intermediate format (csv) and then import it to mysql. So what I want to do is introspection. I don't know where to start. There are many sub-folders under this web applications. I know that I have to use external methods and I have tried it like this: from ZODB import FileStorage, DB storage = FileStorage.FileStorage('data.fs') db = DB( storage ) connection = db.open() root = connection.root() // up to this point it works. now when I try something like: students = root['students'] error message is displayed that students not found. For this reason I want to determine in which objects data is stored so that I can get its values. I also have to determine the name of the attributes (fields) used in this objects so that I can create mysql table fields of the same name and data type. If possible, please give me complete code which I can just copy and paste in external method file. If that is no possible then provide some other working example or explain the steps in detail as I don't have much knowledge about zope and co.

7 18

Thanks for all of you who participated on Zope-track in Europython 2003
by Heimo Laukkanen 03 Jul '03

03 Jul '03

Europython 2003 is now behind and Zope-track was a great success. We had more than 30 talks and on many of the talks there were almost all the seats taken. It was my pleasure and honor to manage the Zope Track with Paul Everitt - and I hope that those of you who were there also enjoyed your time. To be able to make next year even better in Europython, I would like to hear feedback from people who participated and also from those who did not participate: What would you like to see on Zope Track next year? If you participated this year, what was good and what would need improvement? If you did not participate, could you tell us what we could do differently next year - so that you would be interested to join us? Thank you! -huima

3 2

upgrading zope on windows
by Kelley, Sean 02 Jul '03

02 Jul '03

Is there any good documentation on upgrading zope on windows? I am running 2.5.1 on windows 2000 and would like to upgrade to 2.6.1. do i just uninstall 2.5.1 install 2.6.1 and then copy over data.fs and the products folders? thanks sean

4 3

ParsedXML Documentation / Examples?
by zoper＠disturbance.dhs.org 01 Jul '03

01 Jul '03

Hello, After searching all afternoon, I have found a ton of periphery 'about' type information re: ParsedXML, but I am having trouble locating any substantive documentation, or in particular, examples. I'm interested in DTML examples, PythonScript examples, anything. Any pointers appreciated. -Bryan

3 4