June 2000 - Zope - Zope lists

Importing ACL Users
by Christopher Behnke 06 Jun '00

06 Jun '00

I am new to the Zope world, but very impressed, I am working on a new website in which I have a few hundred users with different user names and passwords, is there a way to import from some type of excel or star office spreadsheet the users and passwords, or do I have to enter them all by hand? You help would be greatly appreciated. Thanks!! -Chris... Christopher Behnke (503) 246 3630 VP Product Development fax: (503) 246 3124 Avalon Technology Group email: crb(a)exceptionalminds.com 0607 SW Idaho Street web: www.exceptionalminds.com Portland, OR. 97201 cell: (503) 789 9931 ---------- Linux, because you can't do that on a windows box! ----------

2 1

detail record editing
by Robert Del Huerto 06 Jun '00

06 Jun '00

I'm just beginning my journey into Zopeland so please forgive my ignorance. I'd like to be able to give users a chance to edit records found in a table by selecting the desired record's checkbox and then clicking 'Modify'. This is similar to the Zope management screen. I just don't know how to approach it. I can get Zope to generate a table and form like this from an SQL database. I'm stuck after that. The form only has one 'action' so how would I get it to handle the right function depending on the button that was pushed? I'm no HTML expert but I've looked around quite a bit for an answer and I can't seem to find any info on handling multiple submit buttons. Can Zope make this any easier? (using ZClasses, maybe?) I've also tried searching through the mail archives but I haven't found anything yet. (There are a lot of messages to go through them one at a time.) +---+---------------+---------+------------+ | |Doe |Jane |$100.00 | +---+---------------+---------+------------+ | X |Doe |John |$250.00 | +---+---------------+---------+------------+ | |Haggis |Meister |$100.00 | +---+---------------+---------+------------+ | |Zoper |Doper |$723.00 | +---+---------------+---------+------------+ | +----------+ +----------+ +----------+ | | | ADD | | MODIFY | | DELETE | | | +----------+ +----------+ +----------+ | +------------------------------------------+ thanks, robert

4 3

Deleting folders from root
by Josh Glover 06 Jun '00

06 Jun '00

When I try to delete a folder from the root of Zope, it does not allow me to do so. No error message, just displays the index_html method in my browser window. Same story if I attempt to rename them. Any ideas? Thanks, Josh Glover

1 0

trouble with acquisition
by Erik Myllymaki 06 Jun '00

06 Jun '00

Hello, I am new to OOP and Zope so please forgive me if I am being a chowderhead ;-) I have a root report folder called "ReportParent". Within this folder, I have 47 folders called, for simplicity, "report1, report2 ... reportN". Within each of these folders I have a ZSQL query called "query" that is a simple select statement. In the ReportParent folder, I have an external method called columnNames: #----------------------------------------------- def columnNames(self): """ docstring """ fieldnames = [] tempList = [] res=self.query() columns = res._schema.items() for (name,value) in columns: tempList.append((value,name)) tempList.sort() for name, value in tempList: fieldnames.append(value) return fieldnames ------------------------------------------------- This returns the column names of the batch returned by the "query" ZSQL Method in each reports1..N folder. In each folder is also an "index_html" DTML Doc that renders the batch returned from the ZSQL Method: ------------------------------------------------- <dtml-var standard_html_header> Created for <dtml-var "REQUEST.AUTHENTICATED_USER.getUserName()"> on <dtml-var ZopeTime fmt="%d/%m/%Y"> at <dtml-var ZopeTime fmt="%H:%M"> <br> <p> <table border="2"> <tr> <dtml-in columnNames> <dtml-comment> Click on column header to re-order by that column!!!!!</dtml-comment> <td><a href="<dtml-var URL1>?orderby=<dtml-var sequence-item>"><dtml-var sequence-item></a></td> </dtml-in> </tr> <dtml-in query> <tr> <dtml-in sequence-item> <td align=right><dtml-var sequence-item></td> </dtml-in> </tr> </dtml-in> </table> </p> <dtml-if "REQUEST.AUTHENTICATED_USER.getUserName() == 'root'"> <hr> <p> SQL Source:<br><pre> <dtml-var expr="_.string.replace(query(src__=1),_.chr(0) ,'<hr>')"> </pre></p> </dtml-if> <dtml-var standard_html_footer> -------------------------------------------------------------------- I can call these queries with - www.mysite.net:8080/ReportParent/reportN and get the desired results. I have two questions on how I would like to change things: 1. The DTML Doc "index_html" is the same in the case of 45 of the 47 reports folders. Seems to me I should be able to move the common index_html up to the ReportParent folder, and just leave the two specialized ones where they are, in their report? folders and continue to call the reports the same way. Those that have a local index_html will use that, the others will look up the hierarchy and find the common one in ReportParent. However, when I do this and call the reports with the same URL I get: "Error Type: AttributeError - Error Value: query" ? Seems the index_html DTML Doc (or columnNames extended Method) can't find "query" below it. How do I address this properly? 2. How do I pass in the ZSQL Method object to the external method "columnNames.py"? I'd like to name the queries what I want and reuse this method anywhere, without the query having to be named "query". Out of frustration, I named all the queries with the same name and then addressed "query" explicitly in the external method, because no matter what I tried, I couldn't get the cloumnNames methos to accept the ZSQL Method name as a second parameter?! Thanks for your input, Erik Myllymaki erik(a)pacific-shores.com

1 0

Problems installing PTK
by Joe Hewitt 06 Jun '00

06 Jun '00

So I followed all the instructions on the installation page, restarted zope (the PTKBase and PTKDemo do not appear to be broken) and tried to import DemoPortal.zexp, but I keep get a page that says: ! The object DemoPortal does not support this operation What can I do to solve the problem? I'm running Zwiki on this machine with Mandrake Linux 7.0. Any help would be welcomed, Joe -- Joe Hewitt email: joe(a)apollo.wuacc.edu Linux Coordinator Washburn University Law School

2 1

syndication??
by Webmaster 06 Jun '00

06 Jun '00

A few weeks ago I went to an Allaire Spectra seminar (Spectra is Allaire's $15,000 Zope). It was a very nice presentation and the fundamental principles were quite similar. I have played around with Spectra and I found it to be super clunky with waaaaay to many steps from point A to point B. Not to mention the fact that it is only "object like". I could go on but this is not meant to be a comparison study. However, with that said, there was one particular "out-of-the-box" feature that really impressed me. In spectra you can take and "object" (article, image, etc) and set it up for syndication. One of the syndication options is to send the "object" via email at a set time. So you could have a news page summary set up to send itself out to a distribution email list on a certain day. The concept is simple enough, but I just don't know how I could do the same thing in Zope. I am setting up a system where daily articles can be entered weeks in advance and will only appear on the web site when the date matches their "go live date" (easy). But I would also like the article to be emailed to my distribution email list on its "go live date". Is anyone doing this? If so could you enlighten me on how? Thanks!! -Jamey

11 21

LONG datatype with ODBC adaptor
by Satheesh Babu 06 Jun '00

06 Jun '00

Hi, I'm using ODBC connection to an Oracle 8i database on NT4. Zope 2.1.6 is also running on NT. The connection is through ZODBC adaptor through Oracle's ODBC driver. One problem though, we can't select LONG columns from the table. Any patch/solution/work around for this? Thanks ~ V.Satheesh Babu sbabu(a)tnc.org(Xt: 5348) . . http://vsbabu.csoft.net/ /V\ - Duct tape is like the force. It has // \\ a light side, and a dark side, and /( )\ it holds the universe together ... ^'~'^

1 0

WorldPilot - Regular messages are attachments?
by Bryan Stillwell 06 Jun '00

06 Jun '00

I'm posting this message to the Zope mailing list, because I haven't had much luck with emailing the WorldPilot folks directly and I've seen posts about WorldPilot in the list archives. Here's my problem. I've created an rpm of WorldPilot that follows all the instructions that are in the INSTALL.txt file that comes with it, I've installed courier-imap and tested that it works correctly with Netscape Mail, I've installed qmail and tested that I can send and receive email, but the problem I have is when I try and view messages in my inbox using WorldPilot. If you want to know what I see, here's some screen shots of what happens: http://www.verinet.com/~arcane/worldpilot/wp_inbox.png http://www.verinet.com/~arcane/worldpilot/wp_message.png http://www.verinet.com/~arcane/worldpilot/wp_zopeerror.png Here's the traceback I received: Sorry, a Zope error occurred.<p>  Also I want to bring to attention that in the wp_inbox.png picture that I don't have any folders to choose from. Does anyone know where those would be at? Another strange thing is the path to the mimetools.py file in the traceback: /var/tmp/python/python-root/usr/lib/python1.5/. The /var/tmp/python/python-root path should have only been used during the creation of the python rpm, but it's showing up now. It doesn't seem to matter that much though, because it is able to find mimetools.py at the correct path of /usr/lib/python1.5/mimetools.py. The python-root directory doesn't exist either. I didn't recompile the python rpm either, it's the stock rpm that comes with Redhat 6.2. My setup is as follows: Redhat 6.1 qmail 1.03+patches-8j (Set up to use Maildirs) courier-imap 0.33-1 (IMAP program that supports qmail's Maildir format) python 1.5.2-13 Zope 2.1.6-1 worldpilot 1.0.4-1 (Installed with my own rpm) Thanks for any help any one can provide in advance! Hopefully I can get these problems resolved and I could then post the rpm for others to use. Bryan Stillwell -- http://www.tummy.com/ Consulting and Software for Linux and Unix KRUD - Kevin's Red Hat Uber Distribution - the Freshest Red Hat every month

1 0

A new development model for Zope?
by Paolo Bizzarri 06 Jun '00

06 Jun '00

Hi everybody, I was just wondering if Zope could not get a better development model. I will explain briefly. Currently, Zope seems to have a model for major releases, in which bugs are corrected and features (possibly large features) are added in each new release. This model, IMHO, performs poorly on the stability and bug fixing side. My proposal is that Zope should go through a stable/development version, in a similar way to the linux-kernel. New heavy features should be only for the development Zope, whereas the stable Zope should receive only the bugfixes and the (micro) new features. This should be of major importance, because I would like to have Zope to increase stability on normal versions, without any further feature that I do not need. What do you think about it ? Paolo -- Paolo Bizzarri - Responsabile Marketing I3 Icube Srl Sede: Via Ridolfi 15 - 56124 Pisa (PI), Italia E-mail: p.bizzarri(a)icube.it WWW: www.icube.it Tel: (+39) 050 97 02 07 Fax: (+39) 050 31 36 588

5 8

Re: [Zope] GadFly DB and Zope
by Dieter Maurer 06 Jun '00

06 Jun '00

Hi Jilani > I am recently using the database GadFly and yesterday, I discovered with > pleasure that it is part of Zope (ZGadflyDA); so, I will be happy if > somebody tells me with a little example, or point me where to find some > information to get GadFly interact with it Zope (just how to call field1 > and field2 from the database test.gfd). > > Thank you. Zope looks for directories in "var/gadfly" as possible data sources for Gadfly. You can use it like any other DA -- see the ZSQL Methods User Guide for details. At least an earlier version of Gadfly was cribbled in Zope (2.1.0). It did not write changes to disk, such that each Zope restart removed any changes to the Gadfly database. I may still find the patch I made for this. However, I am not sure, whether it is still necessary and whether it still can be applied without problems. Dieter

1 0