November 2003 - Zope

lines property issue
by David Chandek-Stark 17 Nov '03

17 Nov '03

It seems that lines properties initialize to [''] -- shouldn't they initialize to []? I would have assumed that lines properties are parsed with splitlines(), but ''.splitlines() returns []. '\n'.splitlines(), however, returns ['']. Can someone enlighten me on this? This is a problem, for example, in ZPT b/c I'd like to do things like tal:condition="object/lines_property". Thanks! David Mozilla 1.5/Win Zope 2.6.2/Linux -- David Chandek-Stark dc(a)duke.edu

2 4

TAL conditional statement - newbie question
by Gautam Saha 17 Nov '03

17 Nov '03

Hi ALL: I am just starting to learn zope/plone and templates. I have a portal that uses plone templets and skins. My question is how I can HREF conditionally using TAL syntax. I defined a macro in my plone template file (*.pt file) like this: <p metal:define-macro="news_link"> <-- Just link the News Archive --> <a href="/my.portal.edu/news">News Archive </a> </p> But, as this macro is called form the the right_slots via the "properties Tab" for the CFM site object (eg. here/news_slot/macros/news_link), this link will display in all the pages in the right slot. But I don't want this link to be displayed when I am actually in that page itself (my.portal.edu/news) Note: "news" is a CMF portal action called by action "string: $portal_url/news" So the ideal code will be: If the current URL != $portal_url/news then <a href="/my.portal.edu/news">News Archive </a> else do nothing Here are my questions: 1. How to get the ID of an object (say "news" in this case so that I can conditionally suppress the HREF, so that if I am in the $portal_url/news page, the link will not display? 2. How can I use tal so that I don't have to hard code my portal URL path (like href="/my.portal.edu/news")? I want something like href="$portal_url/news"). 3. Any online ref/example of how to use the Tal/python scripts with ZOPE/CMF/Templates with small example will be helpful. Thanks, Gautam

2 2

Filtering HTML received via WebDAV
by Warwick Barnes 17 Nov '03

17 Nov '03

G'day! I've been searching Zope.org and the web in general for information on the following, but can't find anything. I'd appreciate it if anyone on this list had some ideas... Is it possible to put in some sort of 'hook' function so that HTML/DTML pages saved to the Zope database using WebDAV (or HTTP PUT or FTP I guess) are filtered to remove 'bad' HTML before being saved in the database. I've written a function to strip HTML from the awful files produced by Microsoft Word - leaving quite a clean page. I thought PUT_factory was the place to hook something in, but that only seems to be for new files. The 'holy grail' I'm looking for, is a setup where web pages can actually be edited in Microsoft Word. On save I'd remove useless Microsoft markup and add any other lines needed. Thanks in advance for your help, Warwick

2 1

ZGDChart on Windows
by Robert Jean 17 Nov '03

17 Nov '03

Hello, I cannot intall ZGDChart successfully. I run Zope 2.6.1 on Windows XP. I have downloaded ZGDChart 0.6.5. After restarting Zope, the product seems to be installed correctly judging by the fact that it is listed as a closed box, but there is no new entry in the Add menu of the ZMI. In the demo project, all ZGDChart objects are broken. Do I miss libraries or something? Any help would be appreciated. Thanks, Robert __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree

2 1

example ?
by Kate Legere 17 Nov '03

17 Nov '03

I would like, within a ZPT to get a global variable called 'now' to the present date and time. I can do this in dtml with <dtml-call "REQUEST.set('now', ZopeTime())"> but how do I do I it in TAL ? This was my guess : <span tal: define="now string: ZopeTime()"> but it wasn't correct :( Kate

4 3

get_transaction().commit() does not commit: Zope: OOBTree definition & creation
by Harm_Kirchhoff＠mail.digital.co.jp 17 Nov '03

17 Nov '03

Thank you very much for your comments. Yes, I shortened the code, because otherwise the mails get too long. This is a basic accounting db, using Zope, which I intend to make publicly available once it is stable, so disclosing the code is no problem at all, just a question of length and this mailing list is already very active. I researched further, and it seems that it is the question of where you define the OOBTree. I naively thought you simply define the entire DB as an OOBTree, but I realized that you only define sub-branches as OOBTrees and only upon creation. I made some changes and now it runs. However, I am puzzled by your comment that an OOBTree does not allow these transactions. How do you open a db with an OOBTree ??? When I open the file AccDB.fs with a text editor I can see, that my code must have been executed, because I can see the strings for the nodes ! The new code (again shortened, because the original is still work in progress and contains a lot of scrap, if you want the full code, because there is something fundamentally strange, let me know I can mail it directly.): (PS: I know that my style is extremely unpythonic, but don't be too strict, I am only on python since a couple of months) The main loop: def test(): db = AccountingDB() print 'Database file:',db.mountedDB # create a ledger r = db.ledger_create('001','2003') if r[0] == False: if r[1][0] == 2: print "The database file does not exist, Will be created new now!" db.mount_db(True) db.unmount_db() print "DB Created, now creating ledger anew !" r = db.ledger_create('001','2003') if r[0] == False : print 'failed miserably ! aborting ...' ; return print "Created new DB & ledger, congrats !" else: print r print "Can not find DB file. Aborting ..." return # open the ledger print db.ledger_open('001','2003') print db.ledger_close() Produces this output in the shell, provided the db file does not exist: >>> AccDB.test() Database file: C:\Documents and Settings\Kirchhoff\My Documents\Python\AccDB\AccDB.fs The database file does not exist, Will be created new now! DB Created, now creating ledger anew ! Created new DB & ledger, congrats ! (True, 'Opened:C:\\Documents and Settings\\Kirchhoff\\My Documents\\Python\\AccDB\\AccDB.fs') (True, 'Closed') The functions, ledger_create: Creates a new DB and a basic ledger in dictionary form and closes the ledger. ledger_open: Opens an existing ledger. ledger_close: Closes an existing ledger. I am 100% sure that the code is executed, because all functions perform basic entry checks and do abort if they can not find a valid ledger structure in place. On top, the function basic_validation() performs an extensive validation of the infrastructure, so that the code would abort with an error message, if the ledgers were not correctly created: def __init__(self): # Defines variables to be used throughout the instance, while the # session is in place. # self.mountedDB = 'C:\Documents and Settings\Kirchhoff\My Documents\Python\AccDB\AccDB.fs' self.cust_acc = '' self.fin_yr = '' self.open = '' self.maxper = 13 self.periods = ','.join(map(str,range(1,self.maxper+1))) self.open_per = '' self.closed_pers = [] self.user = '' def mount_db(self, flag=False): """ Mounts the accounting database.""" # Check that my DB exists. This is the default. However, when the very first ledger is created, # Zope must create a DB and for this, the check must be skipped. if flag == False: r = hkToolBox.Test_File(self.mountedDB,'w') if r == False: r = hkToolBox.Test_File(self.mountedDB, 'e') if r == False : return(False,[2,'File does not exist']) else : return(False,[1,'File can not be opened for writing']) # Mount DB: # Note: If you have an error in this section, upon re-run it is likely # that the db is still locked and that FileStorage wil fail, because no connection.close() was executed. # Solution: End python and restart python. self.st = FileStorage.FileStorage(self.mountedDB) self.db = DB(self.st) self.connection = self.db.open() self.dbroot = self.connection.root() #self.dbroot = OOBTree() I found that when you define # entire root as OOBTree on every start # data is not stored. return (True,'db mounted:'+ self.mountedDB) def unmount_db(self): """ Unmounts the database. This is required to free the locking that ZODB tracks in its lock table.""" get_transaction().commit() # commit any changes that may be pending. self.connection.close() self.db.close() self.st.close() def ledger_create(self,CstNo,FY): """Creates a new ledger for a customer and a new financial year.""" #Input Validation: CstNo & FY must be strings. # Input validation: if type(CstNo) <> str : return(False,[1000,'CstNo no string']) if type(FY) <> str : return(False,[1001,'FY must be string']) r = self.mount_db() if r[0] == False : return(False,r[1]) # Ensure that this account and financial year does not exist: if self.dbroot.has_key(CstNo) == True : if self.dbroot[CstNo].has_key(FY) == True : self.unmount_db() ; return(False, FY+' exist for '+CstNo) else : # if CstNo sub-branch does not exist self.dbroot[CstNo] = OOBTree() # Only define the OOBTree once, upon creation. self._p_changed = 1 get_transaction().commit() # Since neither this FY or neither this FY nor CstNo do exist, create base ledger: # Note: This ledger must pass the basic_validation() ! zero=chr(0)+chr(0)+chr(0)+chr(0) # Set up basic infrastructure self.dbroot[CstNo] = { FY :{} } self.dbroot[CstNo] [FY] = { 'ini' : {} , 'accper' : {} } self.dbroot[CstNo] [FY] ['ini'] ['lastE'] = zero self.dbroot[CstNo] [FY] ['ini'] ['lastS'] = zero self.dbroot[CstNo] [FY] ['ini'] ['locked'] = '' self.dbroot[CstNo] [FY] ['ini'] ['closed'] = [] self.dbroot[CstNo] [FY] ['ini'] ['open'] = '1' self.dbroot[CstNo] [FY] ['ini'] ['templ'] = '' self.dbroot[CstNo] [FY] ['1'] = {} self.dbroot[CstNo] [FY] ['1'] ['E'] = {} self.dbroot[CstNo] [FY] ['1'] ['S'] = {} self.dbroot[CstNo] [FY] ['1'] ['accno'] = {} self.dbroot[CstNo] [FY] ['1'] ['acba' ] = {} self._p_changed = 1 get_transaction().commit() # I recommend always to leave validation here, because it ensures that both routines # are always in concordance & will help in future debugging. r = self.basic_validation(CstNo,FY) self.unmount_db() if r[0] == False : return (False, r[1]) return (True,[0,'ledger created ok']) def ledger_open(self,CstNo, FY, User='guest'): """iniializes the class with basic settings.""" # Initializes the database environment. # These variables will be used throughout the instance to access records. # If this ledger does not yet exist, a new one is created. # Returns: # Tuple:(False/True , 'error message if False') #Input Validation if type(CstNo) <> str : return(False,[1000,'CstNo must be string']) if type(FY) <> str : return(False,[1001,'FY must be string']) r = self.mount_db() if r[0] == False : return(False,r[1]) # if you need to validate the user (pathword &c.), do it here. # Verify that DB is not locked. If not, lock it now. if self.dbroot.has_key(CstNo) == False : self.unmount_db() ; return(False, [3,'Customer account does not exist']) if self.dbroot[CstNo].has_key(FY) == False : self.unmount_db() ; return(False, [4,'Financial Year does not exist']) # Test that this branch (Fin Year of Customer) is not in use & reserve: if self.dbroot[CstNo] [FY] ['ini'] ['locked'] <> '' : return(False,[5,self.dbroot[CstNo] [FY] ['ini'] ['locked']]) self.dbroot[CstNo] [FY] ['ini'] ['locked'] = User get_transaction().commit() # Debug: Validate the database: m=self.basic_validation(CstNo,FY) if m[0] == False : self.unmount_db() ; return(False, m[1]) # Set the environment variables for the instance self.cust_acc = CstNo self.fin_yr = FY self.user = User self.open_per = self.dbroot[self.cust_acc] [self.fin_yr] ['ini'] ['open'] self.closed_pers = self.dbroot[self.cust_acc] [self.fin_yr] ['ini'] ['closed'] # ... happy booking ! return(True,'Opened:' + self.mountedDB) def ledger_close(self): """Closes currently opened ledger & unmounts DB.""" # check that environment variables are proper and that branch is actually locked. if self.dbroot.has_key(self.cust_acc) == False : self.unmount_db() ; return(False, [3,'Custumer account does not exist']) if self.dbroot[self.cust_acc].has_key(self.fin_yr) == False : self.unmount_db() ; return(False, [4,'Financial Year does not exist']) # unlock branch u0 = self.dbroot[self.cust_acc] [self.fin_yr] ['ini'] ['locked'] self.dbroot[self.cust_acc] [self.fin_yr] ['ini'] ['locked'] = '' self._p_changed = 1 get_transaction().commit() # unmount DB self.unmount_db() # reset all variables. u1 = self.user self.__init__() # just for checking consistency: if u0 <> u1 : return(False,[6,'User who closed was not same as opened']) return(True, 'Closed') Dieter Maurer <dieter(a)handshake.de> 2003/11/15 04:50 宛先: Harm_Kirchhoff(a)mail.digital.co.jp cc: zope(a)zope.org 件名: Re: [Zope] get_transaction().commit() does not commit Harm_Kirchhoff(a)mail.digital.co.jp wrote at 2003-11-14 19:28 +0900: > I guess it is another newbie question, but I can not save data to the DB: > > I open the DB like this: > > self.st = FileStorage.FileStorage(self.mountedDB) > self.db = DB(self.st) > self.connection = self.db.open() > self.dbroot = self.connection.root() > self.dbroot = OOBTree() > return (True,'db mounted:'+ self.mountedDB) > > Next I make a number of changes to self.dbroot: > > self.dbroot[CstNo] [FY] ['1'] ['E'] = {} Are you sure, this code is executed? An "OOBTree" would not allow these operations. > ... > When I open again and try verify whether the keys exist, using > self.dbroot.has_key(CstNo) # for example > they do not exist. > Looking at the DB with a text editor to see what is in there, reveals that > there is nothing. > The entire program runs through without any error. There must be more about which you do not tell us. Somewhere inside this darkness is something that confuses you. -- Dieter

2 1

Re: [Zope] Sendmail and smtphost
by Felipe Barousse Boué 17 Nov '03

17 Nov '03

> I've a big problem with smtphost and dtml-sendmail > > I encountered this problem when i ran this dtml codes: > > <dtml-sendmail smtphost="mail.mysmtphost.net"> > To: <myaddress(a)mysmtphost.net> > Message: I wish to see U later > </dtml-sendmail> > > Error Type: SMTPSenderRefused > Error Value: (505, 'Authentication required', > 'myaddress(a)mysmtphost.net') > > > I've the problem: the smtphost needed id and pwd but i don't know how > send it! > Can you say me a solutions please? > > > Massimiliano smtphost/sendmail do not support authentication. The easy approach may be to send your message from Zope to the "localhost" sendmail and then validating this under sendmail and the underlying operating system security methods and procedures (tcp wrappers, sendmail rules, firewalls, etc.) Of course you should validate at a higher level within Zope which users are allowed to send email.

1 0

Zope Book mentions "Fragility"
by Brad Allen 17 Nov '03

17 Nov '03

Hi, I'm a Zope newbie, still in the process of reading the documentation and working on my first Zope project. I'm at the stage of organizing all my scripts and DTML documents in a folder hierarchy, but am unclear on how to design against the "fragility" issues discussed in the Zope book. Should I try to avoid a deep folder hierarchy and go with something more flat (but less well-organized?) Does anyone have any recommendations for me? Thanks! (see below for the excerpt from the Zope book) http://zope.org/Documentation/Books/ZopeBook/2_6Edition/ScriptingZope.stx Fragility Over-use of context acquisition can also lead to fragility. In object-oriented terms, context acquisition can lead to a site with low cohesion and tight coupling. This is generally regarded as a bad thing. More specifically, there are many simple actions by which an unwitting developer could break scripts that rely on context acquisition. These are more likely to occur than with container acquisition, because potentially every part of your site affects every other part, even in parallel folder branches. For example, if you write a script that calls another script by a long and torturous path, you are assuming that the folder tree is not going to change. A maintenance decision to reorganize the folder heirarchy could require an audit of scripts in every part of the site to determine whether the reorganization will break anything. Recall our Zoo example. There are several ways in which a zope maintainer could break the feed() script: Inserting another object with the name of the method This is a normal technique for customizing behavior in Zope, but context acquisition makes it more likely to happen by accident. Suppose that giraffe vaccination is controlled by a regularly scheduled script that calls Zoo/Vet/LargeAnimals/giraffe/feed. Suppose a content administrator doesn't know about this script and adds a DTML page called vaccinate in the giraffe folder, containing information about vaccinating giraffes. This new vaccinate object will be acquired before Zoo/Vet/vaccinate. Hopefully you will notice the problem before your giraffes get sick. Calling an inappropriate path if you visit Zoo/LargeAnimals/hippo/buildings/visitor_reception/feed, will the reception area be filled with hippo food? One would hope not. This might even be possible for someone who has no permissions on the reception object. Such URLs are actually not difficult to construct. For example, using relative URLs in standard_html_header can lead to some quite long combinations of paths. Thanks to Toby Dickenson for pointing out these fragility issues on the zope-dev mailing li

4 7

ZMySQLDA problem.
by Rajeev Sharma 17 Nov '03

17 Nov '03

Hello List, I tried to ass ZMySQLDA and got the following error. I copied the required files in $ZOPE_HOME/lib/pyhon2.1/site-packages as per discribed in the documentations. But is is giving me the folowing error. Please tell Where can i be wrong? ERROR(200) Zope Could not import Products.ZMySQLDA Traceback (innermost last): File /usr/local/zope/lib/python/OFS/Application.py, line 522, in import_product File /usr/local/zope/lib/python/Products/ZMySQLDA/__init__.py, line 91, in ? File /usr/local/zope/lib/python/Products/ZMySQLDA/DA.py, line 91, in ? File /usr/local/zope/lib/python/Products/ZMySQLDA/db.py, line 89, in ? ImportError: _mysql: init failed Thanks in advance Rajeev -- ======================================================= ---------------- "Linux drives you from creativity to innovation" ------------------------- ==================== ---------------------------------------------------------------- NETCORE SOLUTIONS *** Ph: +91 22 5662 8000 Fax: +91 22 5662 8134 MailServ and FlexiMail: Messaging Solutions: http://netcore.co.in Pragatee: Integrated Server-Software Suite: http://www.pragatee.com Emergic Freedom: Server-centric Computing: http://www.emergic.com BlogStreet: Blog Profiles and RSS Ecosystem: http://blogstreet.com Deeshaa: Rural Development: http://www.deeshaa.com Rajesh Jain's Weblog on Technology: http://www.emergic.org ----------------------------------------------------------------

2 1

RE: [Zope] Anyone doing any Zoped based project management products?
by Wilson, Derek 17 Nov '03

17 Nov '03

Short answer: No. Long answer: Yes I am, though I'm not sure you'd find ZSQL / DTML / TAL pages any good as they aren't very customizeable. It's just something internal I'm working on. Currently I have NO python code, and I plan on bypassing python entirely. I've searched and apparently the community doesn't have a need for a "project management product". They are fine with a "collector". You might want to take a look at a collector if your project is a 'programming' project. Otherwise, you'd be better off writing your own project management product. Thanks, Derek Wilson -----Original Message----- From: Bobb [mailto:rawbobb@hotmail.com] Sent: Saturday, November 15, 2003 8:57 PM To: zope(a)zope.org Subject: [Zope] Anyone doing any Zoped based project management products? like netoffice? It's pretty impressive. (don't think so, i looked in the archives, but there's just discussion). tia

1 0