- Zope - Zope lists

reportlab and images
by Nicholas Wieland 27 Jul '05

27 Jul '05

I know, I'm flooding the list ... I use images inside my reports, so I have to open PIL-image objects inside my product. Everything is fine, but I must use the full path, like /Zope-Instance/Products/foobar/image/blah.png, and this is a problem, because the product will have a different path when put in production. My solution is to have a class variable to use, like: imagepath = "/Zope-Instance/.../image" and then use that variable to build the path, but I think it's ugly. How do you solve this problem and just use 'image/blah.png' just like ZPTs, knowing that all image files will be stored in an "image" subdirectory of the product ? TIA, ngw --------------------------------- Yahoo! Messenger: chiamate gratuite in tutto il mondo

2 1

Re: [Zope] product organization
by Nicholas Wieland 27 Jul '05

27 Jul '05

Well, not exactly - just a way to separate access to data from everything else in the product. Maybe a separate class that needs the connection as argument and that just returns the data I need in appropriate data structures by calling class methods. class DataModel (object): def __init__ (self, conn): self.conn = conn self.sqlFetchSomething = SQL (.....) def fetchSomething (self): return self.sqlFetchSomething This is really simple, but I think it gives the idea. Obviously I'd like to perform various operation at the data level, for example return a list of lists for reportlab tables and so on. TIA, ngw --------------------------------- Yahoo! Mail: gratis 1GB per i messaggi, antispam, antivirus, POP3

2 1

Re: [Zope] product organization
by J Cameron Cooper 27 Jul '05

27 Jul '05

Nicholas Wieland wrote: >> As usual, my question is rather simple :) >> I'd like to know what are the best practices for product organization >> - for example I have _tons_ of queries to sqlserver, and my main >> class is becoming less manageble every time I look at it :/ >> I like the way SQL integrates in Zope, what I don't like is having a >> giant __init__ and a lot of _sqlSomething at the end of the class. >> >> Can I associate queries to something else than a _variable ? >> Something like a dictionary or a class ? Can I move SQL calls outside >> the initializer ? I'd prefer to have a class for data access and >> another one to glue all the parts together, maybe I'm plain wrong but >> I think that my product would be a lot cleaner. >> What are the best practices for FS based products ? > If you're writing SQL queries attached to a Product and using them in said Product, you should look at ExtZSQL: http://www.zope.org/Members/jccooper/extzsql It was made for precisely this problem. --jcc -- "Building Websites with Plone" http://plonebook.packtpub.com/ Enfold Systems, LLC http://www.enfoldsystems.com

1 0

use combined propertysheet variables to form a file name for a zObject
by Allen Huang 27 Jul '05

27 Jul '05

I made a propertysheet for a customed zclass and I wish to use some variables and combine them to form a name for my newed created object. Say I have variable a = 'name a' b = 'value b' c = 'string c' what do I encode in my dtml method some_add <dtml-with "NewsClass.createInObjectManager(REQUEST['??????'], REQUEST)"> ?????? into the combination of a, b, and c ? --------------------------------- Start your day with Yahoo! - make it your home page

2 1

find a file's type
by Allen Huang 27 Jul '05

27 Jul '05

is there any dtml codes that can display a file's type? I made a site that allows a person to send up a document file. But in the end what I really wanted is to let people to upload .doc files. Since I didn't put any restriction on it, people always send up a smaller .pdf file instead. So how do I encode my webpage to show the file type of the file that have already being uploaded?? --------------------------------- Start your day with Yahoo! - make it your home page

2 1

ZPsycopg - Losing Connections
by David 27 Jul '05

27 Jul '05

Python 2.3.5 - Zope 2.7.5 - PostgreSQL 7.3.4 - Psycopg 1.1.18 - Solaris 8 (Intel) Hi I am experiencing a new problem, that was not present in the past on the above server. From the Zope error log: Exception Type OperationalError Exception Value PQsendQuery() -- There is no connection to the backend. Traceback (innermost last): Module ZPublisher.Publish, line 92, in publish Module ZPublisher.BaseRequest, line 433, in traverse Module Products.exUserFolder.exUserFolder, line 869, in validate Module Products.exUserFolder.exUserFolder, line 1133, in listOneUser Module Products.exUserFolder.pgAuthSource.pgAuthSource, line 244, in listOneUser Module Shared.DC.ZRDB.DA, line 454, in __call__ <SQL instance at 922dd70> Module Products.ZPsycopgDA.db, line 228, in query OperationalError: PQsendQuery() -- There is no connection to the backend. When I check in psql, I can see a connection still being there. Using the query: SELECT count(pg_stat_activity.datname) AS count, pg_stat_activity.datname FROM pg_stat_activity GROUP BY pg_stat_activity.datname; (Is this really showing active connections? Or just recent usage?) If I use the close connection and then open connection buttons in the Z Psycopg Database Connection in Zope, I get the connection usually back. Sometimes I have to re-submit the properties to make it work, though. Properties settings are: "Connect immediately" is checked "Use Zope's internal DateTime module (instead of mxDateTime)" is checked Transaction isolation level: Serializable Backend encoding: UTF-8 "Output Unicode strings" is not checked This is fast becoming a real headache for us! What has changed? We have recently increased the max_connections and shared_buffers for PostgreSQL and now run more Zope instances with now averaging about 40 connections from the database (using the query above). So this is an increase. Any help on how I can find out what's going on here is very welcome! (or in short: HELP, PLEASE!) Cheers

4 4

unwise.exe missing on linux
by michael nt milne 27 Jul '05

27 Jul '05

Hi Does anyone know if the zope uninstall program 'unwise.exe' can be got separately? I have installed zope on linux but the unwise.exe program isn't within the package. Thanks Michael

2 1

Zope Foundation Update
by Rob Page 27 Jul '05

27 Jul '05

Foundation Update ---------------- This note updates progress on forming of the Zope Foundation. To remain transparent as possible, we are communicating in as timely a manner as possible. First, we have contacted the Software Freedom Law Center (SFLC) which specializes in the formation and maintenance of the legal structures that support open source software. From our first conference call with our primary POC there (who also helped with the Plone Foundation), we took away some homework items including: (1) draft trademark license agreement between Zope Corporation and the Zope Foundation (2) draft/initial set of ByLaws and related formation documents that capture the spirit of what we've been discussing for a while now (i.e., Eclipse Foundation-inspired membership and Apache Software Foundation-inspired operations). We have made progress on (2) but stopped when we discovered a trademark violation that needs to be addressed before Zope Corporation can properly license the trademarks to the Zope Foundation. During my stay at EuroPython I learned that eighteen months ago (and without Zope Corporation's knowledge or consent) Zope Europe Association (ZEA) registered a trademark consisting of the Cirlce-Z (the stylized Z surrounded by a circle) followed by the word ZOPE (hereinafter "Circle-Z-Zope"). The mark they registered is identical to the corporate logo used by Zope Corporation. In the three weeks since learning of ZEA's illegitimate registration of our marks we have tried diligently (but unsuccessfully) to get ZEA to unconditionally transfer the rights of the registration. We have offered to reimburse the registration fees paid by the ZEA to the WIPO (World Intellectual Property Organization) in order to facilitate the transfer. We have further offered to preserve their license to use the Zope mark in the conduct of their business as an association of Zope companies. ZEA's registration represents an abuse of registration and management of international trademarks and the misappropriation of a mark that is clearly the property of Zope Corporation. We are sorely disappointed that ZEA is unwilling to transfer the marks quickly and quietly so that we can proceed swiftly toward the formation of the Zope Foundation. We know that the establishment of a fair trademark license for the entire Zope community is an _essential_ component of the Zope Foundation. It is possible that we will come to a conclusion with the ZEA prior to the conclusion of a trademark dispute process. However, as a result (and unfortunately), until this matter is resolved using the established legal/trademark management processes, we are not able to proceed with the Zope Foundation. We will keep the community updated as milestones are reached, so that you know what the new target dates are for the formation of the Foundation at the same time that we do. We recognize that there are lingering questions about the trademark and our management thereof. We have captured our position on these marks in an open letter to the Zope Community. You can find this letter at: o http://www.zope.com/about_us/legal/ ZopeCorpTrademarkManagement_OpenLetter.html As an aside, the ZEA has also registered the Plone logo as a trademark. It is not our business, but came as a surprise to us, that the Plone Foundation is not the owner of the Plone trademark. -- Rob Page V: 540 361 1710 Zope Corporation F: 703 995 0412

6 6

Traceback Lines for Send Mail Error
by Asad Habib 26 Jul '05

26 Jul '05

If it helps, the last lines in the traceback are as follows: Module DocumentTemplate.DT_String, line 474, in __call__ Module Products.MailHost.SendMailTag, line 116, in render Module Products.MailHost.MailHost, line 125, in send Module Products.MailHost.MailHost, line 144, in _send Module smtplib, line 254, in __init__ gaierror: (7, 'No address associated with nodename') Thanks. - Asad

4 9

How to display unicode character given its code
by Itai Tavor 26 Jul '05

26 Jul '05

Hi, This is a bit OT but this list is the best place I know to ask it :) I have a form which uses UTF-8, the text entered in the form then has to be converted to iso-2022-jp. If any character is entered that isn't valid for iso-2022-jp I get: UnicodeError: ISO-2022-JP encoding error: invalid character \u2013 What I need to do is display the offending character in the error message. So the question is, how do I take the '2013' and display the appropriate character? TIA, Itai

2 3