October 1999 - Zope - Zope lists

Re: [Zope] Upload to Filesystem
by Peter Sabaini 14 Oct '99

14 Oct '99

On Thu, 14 Oct 1999, David Kankiewicz wrote: :Peter Sabaini wrote: :> :<snip> :> :> i just wrote something like this if you need it contact me :> (it works -- but beware i'm no python programmer) since some people requested this i tried to make it into an howto. --> http://zope.org/Members/sabaini/externalfiles-howto/ hope it is of any value. send comments (other than: "i've never seen such ugly code!" ;)) if any. peter. -- _________________________________________________ peter sabaini, mailto: sabaini(a)niil.at -------------------------------------------------

1 0

Problems installing Zope
by Jan-Oliver Wagner 14 Oct '99

14 Oct '99

Hello, following doc/INSTALL.txt (the quick start) the first command finishes with "Done." which seems to hint at success. However, the INSTALL description says that I will be given a user name and password. This is not the case, nor can I find any point where the procedure is unhappy. Bravely executing the second command ( ./start ) results in a somehow running zope which of course I can not log in. Furthermore, ./start does not return. Environment: Mandrake 6.1, Roxen Any clue? Jan-Oliver Wagner -- Jan-Oliver Wagner http://www.usf.uos.de/~jwagner/ Intevation GmbH Sci. Ass. Inst.of Environmental Systems Res. http://www.usf.uos.de/

6 5

Multiple DTML-questions
by Samu Mielonen 14 Oct '99

14 Oct '99

Hello, I have multiple problems with a short DTML thingy I'm putting together. Let's go through them one at a time. I have folder hierarchy (from KM|NetNews) like this ArticleStorage Year Month_x Month_y ... Day_p Day_q Day_r ... Article1_id Article2_id Article3_id So, year, date, month and article are all folderish objects that contain further objects (article contains images that have been submitted alongside the article itself). I have a rudimentary (copied) dtml-code that displays all articles (from any year, month, day): <dtml-in "objectValues('KMYear')"> <dtml-in "objectValues('KMMonth')"> <dtml-in "objectValues('KMArticle')" sort=release reverse> <dtml-if "(release.isPast()) and current"> <H1><dtml-var title></H2> <A HREF="mailto:<dtml-var email>"><dtml-var author></A> <BR> <dtml-var teaser> <br> <dtml-if "text_content"> <a href="<dtml-var "absolute_url() +'/index.html'">">Read more...</a> </dtml-if> <P> </dtml-if> </dtml-in> </dtml-in> </dtml-in> So, nothing fancy in that. It looks through all the year objects and through all month objects and through all the day objects and displays all articles that have a release date (release-variable) past now and that are current (curret variable is set to 1). Easy, at least that's how I understand it (i.e. ObjectValues(X) looks through all the subfolders of type X??). There is no good documentation for objectValues anywhere in the DTML Guide (just 2 obscure examples and one reference in index). Now, to my problems: 1. I want to display only articles from year_x, month_x, day_x. Can I somehow only list articles from year_x/mont_x/day_x? How? I can't find any command nor reference how to do this via objectValues. I don't want to make an if-loop inside the above original code that check for all articles (regardless of their folder) that if theyr year, mont and day are the same as today. This would require 3 if statements for ALL of my articles. This would be silly, dont you think? 2. I have a method from KM|NetNews product called add.html and another one called approve.html (these are my modified copies of incoming.html and index.html respectively). I want users with writer role to access add.html and add.html ONLY. I want users with editor role to access add.html and approve.html. Both of these methods are under the KMArticleStorage product folder How do I do this? I can't find anywhere in the documentation ways to define permissions for a single dtml_method (call me thick, but I can't find it!). Also, trying to check the authenticated user with has_role only results in key_error every single time (works on one page, doesn't work on another. There is some peculiar namespace trickery going on here that I don't understand.). 3. If I want to render visible objects that are inside objects (e.g. images that are inside particular folderish article objects), how do I do it? I understand that I can iterate through all of the folder objects (e.g. images) and display their id, the actual image itself and then even give a form submit button to upload a file to replace that image. But I can't figure out the DTML code to do this... I've tried a gazilliion different permutations (with, let, objectvalues, sequence-item, etc. tags) Any takers? All help mucho appreciated, Samu Mielonen PS About my earlier e-mail about Zope consulting. Yes, I'm buying that, but it's goingg to take awhile to produce anything so I need to get up running quickly with my mini-mini-mini-version. This is why I'm still fighting with DTML :) -- "The world will not evolve past its current state of crisis by using the same thinking that created the situation." - Albert Einstein

2 1

ZQR / ZClass / Property Sheets suggestion
by Loren Stafford 14 Oct '99

14 Oct '99

In the ZQR, I think it would be worth pointing out at the top of the Property Sheets section that, if you have a property sheet with a non-standard name (as you can easily have in a Z Class), you need to qualify the references to its methods. For example, <dtml-if "propertysheets.InstanceConstants.hasProperty('pub_date')"> -- Thanks -- Loren

2 1

interesting design patterns contest
by Simon Michael 14 Oct '99

14 Oct '99

at http://www.jyu.fi/~hjtoi/mozpat/ "___ is hard for newcomers to understand, and there isn't as much documentation as we would like. We are holding a contest that will help people learn ___, and will help us make better documentation for it. The contest involves "design patterns", which are a hot new idea about how to design systems and how to document them. ___ already uses lots of patterns; we just have to discover them and capture them so that other people can learn from them." (for ___, substitute "mozilla"; wouldn't "zope" fit well though)

1 0

Re: [Zope] Zope a good solution for this?
by Andrew M. Kuchling 14 Oct '99

14 Oct '99

John P. Corradi writes: >clumsy (these are long lists), but it's also not interactive. Ideally, >we'd like to display the data as a hierarchical tree, allowing expansion >and collapse of each node ... We've done something similar for browsing through a database of processes (http://www.mems-exchange.org/z/process/) However, our database is a bunch of Python objects, not a set of tables in a relational database. I wouldn't expect it to be too difficult, mostly a matter of writing objects with the right methods for the tree tag. -- A.M. Kuchling http://starship.python.net/crew/amk/ The greatest gift that Oxford gives her sons is, I truly believe, a genial irreverence toward learning, and from that irreverence love may spring. -- Robertson Davies, "Shakespeare over the Port"

1 0

Re: [Zope] Thanks! New stuckage: newlines...
by Jim Sanford 14 Oct '99

14 Oct '99

this works for me although there may be a much better way (probably writing a python method: *********** update sqltable set memofield=<dtml-sqlvar "_.string.replace(_.string.replace(mdata,_.chr(13)+_.chr(10),_.chr(13)),_.chr(10 ),_.chr(13))" type=string> *********** This replaces all carriage-return+line-feed pairs with just carrriage-returns, and then changes any leftover line-feeds to carriage-returns. ==================== This however doesn't address the problem of adding a large amount of memo data (more than 150 to 200 characters) because of the sql statement length (at least with ODBC) limitation. The workaround I found was to write write memo data back in chunks of 120 characters. like below: (This is adding data to a notes field. Previous notes are not editable in our application. We use javascript to clear the previous notes field on the form before submitting, so only the additional notes are sent back. Some of our notes filed are several k long.) <dtml-comment>*****START UPDATE NOTES*****</dtml-comment> <dtml-if "_.len(_.string.strip(wadd2notes))>0"> update names set notes = strtran(strtran(notes,chr(10),'')+chr(13),chr(13)+chr(13),chr(13)) + ttoc(datetime())+': ' where val(id)==<dtml-sqlvar cust_id type=int> <dtml-var sql_delimiter> <dtml-let memodata="_.string.replace(wadd2notes,_.chr(10),'')" memolen="_.int(_.len(memodata)/120+1)" zt="Range(memolen)"> <dtml-in zt> <dtml-let z1=sequence-item> update names set notes = notes + <dtml-sqlvar "_['memodata'][(120*z1):(120*z1+ 120)]" type=string> where val(id)==<dtml-sqlvar cust_id type=int> </dtml-let> <dtml-var sql_delimiter> </dtml-in> </dtml-let> </dtml-if> <dtml-comment>*****END UPDATE NOTES*****</dtml-comment> Hope this helps __________________________________________________________________ Jim Sanford ^ Database Engineer ^ ^ ^ Accelerated Technology, Inc. ^ ^ 720 Oak Circle Drive East ^ ^ ^ Mobile, AL 36609 ^ ^ ^ Voice: 334-661-5770 fax: 334-661-5788 ^ ^ E-Mail: jsanford(a)atinucleus.com Web: http://www.atinucleus.com Source Code, No Royalties, Any CPU...It just make sense ! __________________________________________________________________ -----Original Message----- From: Gustin Kiffney <gustin_kiffney(a)fd.org> To: zope(a)zope.org <zope(a)zope.org> Date: Thursday, October 14, 1999 1:05 PM Subject: [Zope] Thanks! New stuckage: newlines... To those who showed me how to access items in a list (put the identifier in quotes, e.g., don't say parms[0], say "parms[0]") - thanks! I think a 'quoting-howto' would be a wonderful thing. Right now I paw through the egroups zope index hoping I'll find an incantation that will show me how to call a particular method (like, why doesn't <dtml-var "_.int(_.time.time())"> work when the time module is right there big as life?) Now I can't get past newlines. I have an input form that uses a couple of textareas where newlines can be inserted. I'm sticking all those form inputs - mostly textboxes, but some textareas - into an mailhost method that calls a SQL method that inserts them into a database. These textarea fields are supposed to go into a 'memo' field in the database that can accept newlines. As long as I put no newlines in the form, the SQL insert goes fine. But if newlines exist, I get parse errors from the SQL interpreter. I can't see exactly what's going to the SQL interpreter because the SQL is not returned. But it's got to be a newlines problem - if there are no newlines in the textarea, there are no parse problems. I tried (in the SQL method) changing the <dtml-sqlvar textitem type=string> to "<dtml-var textitem newlines_to_br>" (adding quotes around the dtml-var to help stringify it) but this made no difference. Anybody figured this out? _______________________________________________ Zope maillist - Zope(a)zope.org http://www.zope.org/mailman/listinfo/zope (Related lists - please, no cross posts or HTML encoding! To receive general Zope announcements, see: http://www.zope.org/mailman/listinfo/zope-announce For developer-specific issues, zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev )

1 0

RE: [Zope] Using Property Sheet Methods in Z Class
by Loren Stafford 14 Oct '99

14 Oct '99

> >In a Z Class I am creating (the one I wrote about in > >http://www.zope.org/Members/lstaffor/zProperties) I have property sheet > >named "InstanceConstants" which contains a property "pub_date". > > > >When accessing an instance of that class, "pub_date" is clearly available > in > >the namespace of the object. > > > >However, the property sheet method <dtml-if "hasProperty('pub_date')"> > >always returns FALSE. > > > >I presume that somehow I have to qualify "hasProperty" with > >"InstanceConstants", but after spending an hour trying to follow the > >Property Sheets and ZClasses code, I still haven't found the answer. > > I've never tried it, but it seems like: > > <dtml-if "propertysheets.InstanceConstants.hasProperty('pub_date')"> > > would be consistent with the other propertysheet handlers... (but > you never > know when something will turn out to be inconsistent :) > > Kevni > Kevin, That works! Actually I tried that earlier but misspelled it, so I thought it didn't work. -- Thanks -- Loren

1 0

Zope a good solution for this?
by John P. Corradi 14 Oct '99

14 Oct '99

Hi All, This is a general question because I don't have Zope up and running now. We have a large (Sybase) database of gene expression information which includes an anatomical dictionary. The anatomical dictionary is hierarchical - i.e. organized by embryonic stage, anatomical structures, substructures, cell types. Currently there is a (Python) script that periodically generate HTML files from the database which list all of the dictionary terms in a space-delimited text format. This format is not only clumsy (these are long lists), but it's also not interactive. Ideally, we'd like to display the data as a hierarchical tree, allowing expansion and collapse of each node (e.g. click on "brain" node and get all the substructures of the brain, click on a brain substructure and get the cell types found in that substructure). Also, we might like to have users be able to make queries directly from the anatomical dictionary (e.g. what genes are expressed in this cell type in the cerebellum?) >From the Zope docs that I've read, it seems like Zope is well suited for this. We also have some very good Python programmers here (and I've done a bit). However, before I go full bore in trying to convince my boss, I'd like to hear from the Zopistas: Does this problem scream Zope!? I know you can use SQL with the tree tag, but are there examples that I could look at? (recent posts to the list about this haven't gotten a lot of responses) What is the status of the Sybase DA? Thanks in advance. John

2 1

Using Property Sheet Methods in Z Class
by Loren Stafford 14 Oct '99

14 Oct '99

In a Z Class I am creating (the one I wrote about in http://www.zope.org/Members/lstaffor/zProperties) I have property sheet named "InstanceConstants" which contains a property "pub_date". When accessing an instance of that class, "pub_date" is clearly available in the namespace of the object. However, the property sheet method <dtml-if "hasProperty('pub_date')"> always returns FALSE. I presume that somehow I have to qualify "hasProperty" with "InstanceConstants", but after spending an hour trying to follow the Property Sheets and ZClasses code, I still haven't found the answer. Can anyone help? -- Thanks -- Loren

1 0