- Zope - Zope lists

RE: [Zope] Re: Novell NDS (Was: LDAPUserFolder and Zope 2.5.1)
by Schmidt, Allen J. 09 May '02

09 May '02

Has anyone done anything to connect to a Netscape Directory? I understand its LDAP also but I know next to nothing about it or LDAP in general for that matter. I have all the server, port, user, etc. info but just don't know how to go about getting data out of it. Thanks -Allen -----Original Message----- From: Brad Clements [mailto:bkc@murkworks.com] Sent: Wednesday, May 08, 2002 1:56 PM To: Zope user list Subject: [Zope] Re: Novell NDS (Was: LDAPUserFolder and Zope 2.5.1) On 8 May 2002 at 11:44, Tille, Andreas wrote: > On Tue, 7 May 2002, Brad Clements wrote: > > > I'm using LDAPUserFolder to talk to eDirectory running on Linux.. Works > > fine. > Sorry, I'm talking about the NDS which is (IMHO) bundled with Novell 5. It's the same thing. NDS == eDirectory. Wether or not it's running on NetWare or Linux doesn't matter. Brad Clements, bkc(a)murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax AOL-IM: BKClements _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

4 3

odd iteration semantics in ZPT
by dman 09 May '02

09 May '02

I created a collection and iterator class in an External Method for use by my web app. I implmented the iterator protocol introduced by python 2.2, but also included a __getitem__ method to provide the "old" iteration mechanism. For various reasons, the client of my iterator needs to know some information regarding where in the iteration process the iterator is at. I had little trouble making the iterator itself, but I kept getting odd assertion errors and minor defects in the way data was retrieved from my iterator. I managed to track it down to the fact that __getitem__ is called twice with 0 as the index. The sequence of index values looks like : [0, 0, 1, 2, 3, 4, 5, 6, 7, 8] I can work around this anomaly by resetting my iterator every time the index is 0. Is this a bug in zope? (I expect that the bug is in ZTUtils/Iterator.py) I'm using zope 2.5.1, python 2.1.3, debian 3.0. -D -- The way of a fool seems right to him, but a wise man listens to advice. Proverbs 12:15 GnuPG key : http://dman.ddts.net/~dman/public_key.gpg

3 3

Shop Systems
by Thomas Mathes 09 May '02

09 May '02

Hello, Does anybody know a well known and good Open Source Shop System which is based on the Zope Web Application Server. I tried several, which I found on www.zope.org. But none of them was working!

2 1

Squishdot 1.4.1 Released!
by Chris Withers 09 May '02

09 May '02

Squishdot 1.4.1 is now available from: http://www.squishdot.org/Download. The following changes were made: - You can now delete specific postings using the Moderation page. - The Posting and Article editing forms have been improved. - The tests and updaters were improved slightly. See http://squishdot.org/Documentation/Changes for full details. **This release requires Zope 2.3.2 or later!** If you run into problems, remember Squishdot has a mailing list at YahooGroups and a bug collector on SourceForge. cheers, Chris

1 0

SQL to Excel
by Bruce Dykes 09 May '02

09 May '02

Okay, I'm trying to publish the data from an excel spreadsheet via an ODBC connection. The connection starts okay, and I found this SQL snippet from a Java site: select URL from [qas$] where Month='March' and Year=2000 Note that the table name is the name of the worksheet with a $ appended to the end. You have to append the $ in order for the query to work. Why? Because. The brackets are there because $ is a reserved character in SQL. Life is never easy. ----------------------- Now all I want to do is SELECT *...I don't need anything fancier than that, I'm just trying to publish the entire worksheet. No variation on the above code snippet seems to work. Has anybody gotten SQL queries into excel to work? And how did you do it? thanks in advance bkd As an aside, I'm currently publishing this document via Apache, with an excellent program, xlhtml set up as a handler....but that's proven less than useful as of late.

2 7

RE: [Zope] SQL to Excel Redux
by Christian.Fissgus＠haufe.de 09 May '02

09 May '02

> Okay, now that's fixed, I'm getting the error I initially expected: > > Error Type: KeyError > Error Value: Company_Name > > This doesn't surprise me, as the Browse tab on the ODBC connector comes up > empty, and this being an Excel spreadsheet, not a database table proper, > there are no field names specifically assigned to the data. > > Now, where should the field names be declared/assigned? The best way would be to insert a new first row in your excel-sheet with the field names you want. Or: use the names which are shown when you test your ZSQL method. > > And as a more general question, in the ODBC connector docs, it says that not > all databases support browsing...what is the specific limitation? I've been > able to browse both Access and FoxPro databases, and I find it an invaluable > tool. The Excels spreadsheet is the first thing that's ever come up blank > for me, and that's kind of an odd duck anyway... If you really want to use the Browse tab, you have to use named ranges in your excel sheet (look in your excel manual how to name ranges); then you will see the named ranges just like 'normal' tables in a database. (and you can also do something like "select * from nameOfRange " as ZSQL method ...) chris

2 1

cmf 1.2
by Baldocchi Massimiliano 09 May '02

09 May '02

I have updated cmf from 1.1 to 1.2, but now all types i've defined as zclass don't works! If i add content, i've this error: Traceback (innermost last): File C:\sviluppo\zope251\lib\python\ZPublisher\Publish.py, line 150, in publish_module File C:\sviluppo\zope251\lib\python\ZPublisher\Publish.py, line 114, in publish File C:\sviluppo\zope251\lib\python\Zope\__init__.py, line 159, in zpublisher_exception_hook (Object: 1020938962193) File C:\sviluppo\zope251\lib\python\ZPublisher\Publish.py, line 98, in publish File C:\sviluppo\zope251\lib\python\ZPublisher\mapply.py, line 88, in mapply (Object: invokeFactory) File C:\sviluppo\zope251\lib\python\ZPublisher\Publish.py, line 39, in call_object (Object: invokeFactory) File C:\sviluppo\zope251\lib\python\Products\CMFCore\PortalFolder.py, line 335, in invokeFactory (Object: 1020938962193) File C:\sviluppo\zope251\lib\python\Products\CMFCore\TypesTool.py, line 701, in constructContent (Object: portal_types) File C:\sviluppo\zope251\lib\python\Products\CMFCore\TypesTool.py, line 430, in constructInstance (Object: esercizi) File C:\sviluppo\zope251\lib\python\OFS\ObjectManager.py, line 232, in _getOb (Object: 1020938962193) AttributeError: (see above) Why???? Help me, please!!! Massi

1 0

creating an instance of your own product within Python Scripts
by Tom Deprez 09 May '02

09 May '02

Hi Michal, You're kidding right? :-) Boy, how stupid can a person be! I feel dumb here.... Man, I need to stop working these hours :-) Thanks a lot! You really made my day. Now I can finish this project before the deadline Tom. --------------------------------------- Hi Tom, try changing ['OFSP'] to ['YourProductPackage'] context.documents.manage_addProduct['YourProductPackage'].manage_addCasusDoc ument(id='new_id2') Michal On Wed, May 08, 2002 at 06:43:24PM +0200, Tom Deprez wrote: > Hi, > > What do I've to accomplish to call > > context.documents.manage_addProduct['OFSP'].manage_addFolder(id='new_id2') > > with my own product? eg: > > context.documents.manage_addProduct['OFSP'].manage_addCasusDocument(id='new_ > id2') > > I've already made it possible to import manage_addCasusDocument through > python scripts. > However now I'm stuck and don't know how I can create an instance of my > product inside a BTree folder > > Thanks in advance, > Tom.

1 0

Possible error in Sams Publishing Zope book?
by Michael Kleymann 09 May '02

09 May '02

Hey, y'all... New to the list, new to ZOPE, trying to learn. As the subject line implies, I have a book from Sams Publishing, titled "Zope," subtitled "web application construction kit" which has examples in it. I love examples... Most of the first 3 chapters revolve around setting up, making database connections and what not. Chapter 4 starts an example for a type of discussion board. The security that they ask you to set is no view for anonymous access, basically requiring a login before you can see the page. They give the following section of code for the index_html: <dtml-var standard_html_header> <center> <dtml-if "AUTHENTICATED_USER.has_role('Anonymous')"> <h3>Welcome to your Message Board</h3> <p> Please identify! <p> <a href="login_html">Login</a> </dtml-if> </center> <dtml-var standard_html_footer> Using this code, exactly as-is, I receive the following error: Compilation failed TAL.HTMLParser.HTMLParseError: malformed start tag, at line 3, column 10 The given location is the first " in the dtml-if statement. Now, I'll admit, I'm not a programmer, and I've never played one on TV, but there are other pages in the same site that use the dtml-if statement with a ", and none of them throw that same error. Can someone clue me in on this? It's been driving me nuts.... Michael Kleymann

2 1

creating an instance of your own product within Python Scripts
by Tom Deprez 09 May '02

09 May '02

Hi, What do I've to accomplish to call context.documents.manage_addProduct['OFSP'].manage_addFolder(id='new_id2') with my own product? eg: context.documents.manage_addProduct['OFSP'].manage_addCasusDocument(id='new_ id2') I've already made it possible to import manage_addCasusDocument through python scripts. However now I'm stuck and don't know how I can create an instance of my product inside a BTree folder Thanks in advance, Tom.

2 1