- Zope - Zope lists

help with an application folder based
by Carrer Yuri 10 Dec '03

10 Dec '03

Dear Zopers, I'm developing a little application which is folder based. I have this structure: / - |- Folder1 |- Folder2 and so on. Each folder is "managed" by a responsable. A costumer come in, choose which folder (department) want to submit a request, and does its request. The request (a folder with property set with the input data contained in the dept folder he choosed) has to: - be seen only by the costumer when he came back and the responsable of that dept. - be edited only by folder responsable and created by the costumer - be seen by a global manager, which can read and write all the depts and do statistics. Is there a similar product? I want to write it, what should I do? (security settings, which roles...) For example, I use the owner of the object to see to which customer the object belongs. Is it ok? Thanks for your help :)

2 1

Dynamic Update SQLs like in Delphi
by fowlertrainer＠anonym.hu 10 Dec '03

10 Dec '03

Hello ! In Delphi I have a my own created mechanism what help me to do less code/error, and more performance in database/dataset handling. The technology is that: 1./ When I open a table with TDataSet.Open method, then it was generate updatesql array, and updatesql components. 2./ It is cache the modifications. 3./ In apply it is process the cache, and rewrite modifications in RW transaction. It is same with TClientDataSet class, but enhanced. When I was write an site in php, I rewrite this mechanism in php, and it is working good. Ok, but in this time I want to port it to Zope. In the 1./ the code is like this: a.) Get table name from SQL b.) Get the pyhisical fields of the table -> filter (omit) the another table fields, exmp: joined/grouped/etc. c.) Get a key fields from parameter, or the first field. d.) Generate SQL for INS/DEL/UPD e.) Store it In Zope I don't see any possibility to I create on-fly statements. My mechanism is good, because in my database I have 200 tables, and if I want to create all zsql method to all table, then I must write 200*3 update sql statement, and 200*1 select by id sql statement. And I don't say about the special selects - my way is handle all of these statements. So there are the ways I see to do it: 1./ I write it by hand. Many time,.... :-((((((((((((( 2./ I write an xml section creator in py. I create din. sqls in python+xml, and I insert into exported zope site file. Then I import it to zope. 3./ I write an subsite, what load all table descriptors to arrays, and create the zsql methods into zope site's folder. When the database content (structure) is changed, I recreate all zsql method. 4./ I access the zsql-s on-fly, and when it is must change (the table structure is changed) then I change the zsql method. But I don't know, what is happening, when another zope request thread is working with this method... 5./ I access the DA object, and can create dynamic SQL-s. But I can do that ???? 6./ I change the zope to the mod_python. (I don't want to do it, only if I haven't any solution) 7./ I am going to Antarctis, or to the Moon. Or to insane... 1/2/3 solutions are very ugly things, because the many zsql method is many text, and the zope fs is grow to very large. And when I forget to recreate this methods, the site is unavailable. Please help me: what I can do ? Thanx for any advance. -- Best regards, fowlertrainer mailto:fowlertrainer@anonym.hu

3 4

get_transaction().commit() seems not to work ?
by Harm_Kirchhoff＠mail.digital.co.jp 10 Dec '03

10 Dec '03

I seem not to be able to save my data to ZODB, I wonder what I do wrong here: At the python shell: >>> test() Here it is: ['testme'] {'testme': {'i love tests': [1, 2, 3]}} ... and now its empty ! Magic ??? {} >>> where test() is defined as: def test(): storage = FileStorage.FileStorage('C:\Documents and Settings\Kirchhoff\My Documents\SALES\DataBase\SalesDB.fs') db = DB(storage) connection = db.open() dbroot = connection.root() DB.dbroot = { 'testme' : {'i love tests' : [1,2,3]}} get_transaction().commit() print 'Here it is:' print DB.dbroot.keys() pprint.pprint(DB.dbroot) connection.close() db.close() storage.close() storage = FileStorage.FileStorage('C:\Documents and Settings\Kirchhoff\My Documents\SALES\DataBase\SalesDB.fs') db = DB(storage) connection = db.open() dbroot = connection.root() print '... and now its empty ! Magic ???' pprint.pprint(dbroot) connection.close() db.close() storage.close() return

3 2

variable passing in DTML
by Dilley, Hara 10 Dec '03

10 Dec '03

Is there an elegant way of passing a variable from one DTML method to another DTML method without using a form? I have a page with many images that when I click on an image I like to pass the image name to the next page. Thanks Hara

2 1

<dtml-mime>
by Daniel Hoffman 10 Dec '03

10 Dec '03

My question is about sending an HTML attachment with the mime tag. I have tried every combination of the mime tags arguments, but I cannot get a true attachment. The HTML comes out concantenated to the message. This works ok for some mail clients but not MS products that my clients use (the ones who pay the bills). Can someone help please? code: dtml-var small_html_header> <dtml-sendmail smtphost=x.x.x.x> To:<<dtml-in expr="client_print(t_client=c_client)"><dtml-var c_email></dtml-in>> From:automatic invoicing foo(a)bar.com Date:<dtml-var ZopeTime fmt="rfc822"> Subject:Invoice# <dtml-var i_invoice>-<dtml-var "ZopeTime()" fmt="%y%m%d"> <dtml-mime type=text/plain encode=7bit> <dtml-boundary type=text encode=7bit name=invoice.html> <dtml-var expr="invoiceprintemail(_.None,_)"> </dtml-mime> </dtml-sendmail> <h3>email was sent</h3> <dtml-var standard_html_footer>

2 1

Creating DBTab mountpoint inside a Plone site produces a ConflictError
by Heimo Laukkanen 10 Dec '03

10 Dec '03

I've been playing with Ape and just hit my head to wall, when trying to create an DBTab mountpoint to inside a Plone site. Creating mountpoint and using posgtgres as a database works - if I put mountpoint to the root level, but trying to get the mountpoint inside Plone-site fails. I've tried to follow guide on: http://plone.org/events/sprints/castlesprint/wiki/ApeSupport In my dbtab.conf I have: [Storage: PostgreSQL] type=apelib.zodb3.storage.ApeStorage factory=apelib.zope2.mapper.createSQLMapper module_name=psycopg params=dbname=ape user=postgres [Database: PostgreSQL] class=apelib.zodb3.db.ApeDB container_class=Products.CMFPlone.PloneFolder.PloneFolder mount_paths=/plone/pg I have created the plone site with id plone and when I try to create the DBTAb mountpoint, I get conflic error: ZODB.POSException.ConflictError Sorry, a site error occurred. Traceback (innermost last): Module ZPublisher.Publish, line 150, in publish_module Module Products.Localizer, line 58, in new_publish Module ZPublisher.Publish, line 127, in publish Module Products.Localizer, line 58, in new_publish Module ZPublisher.Publish, line 127, in publish Module Products.Localizer, line 58, in new_publish Module ZPublisher.Publish, line 127, in publish Module Products.Localizer, line 58, in new_publish Module ZPublisher.Publish, line 122, in publish Module Zope.App.startup, line 159, in zpublisher_exception_hook Module ZPublisher.Publish, line 102, in publish Module Zope.App.startup, line 217, in commit Module ZODB.Transaction, line 234, in commit Module ZODB.Transaction, line 340, in _commit_begin Module ZODB.Connection, line 453, in commit_sub Module apelib.zodb3.storage, line 156, in store ConflictError: (1L,) already exists And if I try to create the mountpoint without the Plone-site in place, I will get a different error: Traceback (innermost last): Module ZPublisher.Publish, line 98, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 39, in call_object Module Products.DBTab.MountedObject, line 296, in manage_addMounts Module Products.DBTab.MountedObject, line 85, in traverseOrConstruct TypeError: _construct() takes exactly 4 arguments (3 given) Zope 2.6.2 Plone 1.0.5 Ape 0.7.1 Any help would be appreciated. -- -huima

2 1

JOB: Zope/Python Programmer in Reston, Virginia USA
by info＠dlc-solutions.com 10 Dec '03

10 Dec '03

DLC Solutions is seeking a senior-level software engineer with experience in application development using Zope, Python, and ActionScript. Five or more years experience in systems architecture, database design, and legacy systems integration is required. Experience in medical education or e-learning field is a plus. This hire will be the programming lead for DLC Solution's product development for web-based educational technologies. We are looking for someone to integrate Flash interfaces with our Zope/Python/DTML-based learning management system, as well as continue to develop our core learning management system built using Zope/Python/DTML. This position requires dedication to and a love of building elegant, modular products that are optimized for administrative simplicity, top-notch user experiences and rich reporting capabilities. The successful applicant will also be able to understand and participate in the business process of our product development effort. We are looking for a team player who is willing to contribute both lines of code and design leadership; therefore, strong communication skills are necessary. A strong applicant would also have experience working in a small, fast-growing software development department and be willing to embrace the challenge of developing processes and mentoring junior level programmers. This position does not require managing employees. Two or more years of experience are required in the following areas: Zope Python ActionScript DTML SQL Server and database architecture Windows 2000 Server ASP/VBScript Familiarity with the following technologies is a plus: HTML, CSS, JavaScript Streaming audio Flash Communications Server PHP Learning management systems Content management systems To apply for this position, email your resume (in Word format) and salary requirements to info(a)dlc-solutions.com.

1 0

Image as Cell Background
by fowlertrainer＠anonym.hu 10 Dec '03

10 Dec '03

Hello zope, How to I do it in zope ? <td width="30" height="30" background="../Images/DUR.jpg"><img src="1PIX.gif" width="30"></td> I want you set the background - but how ? Thanx for any advance ! -- Best regards, fowlertrainer mailto:fowlertrainer@anonym.hu

3 2

How do you secure webdav_source_port?
by Matt Burleigh 10 Dec '03

10 Dec '03

Is it possible to have WebDAV over SSL? Do I need ZServerSSL?

2 1

FYI: Zope 2.6.1 beta 1 today...
by Brian Lloyd 10 Dec '03

10 Dec '03

Hi all - We're planning on releasing a Zope 2.6.1 b1 today, and I wanted to give the dev folks a heads-up and let people know the plan for getting to 2.6.1 final. The release today will contain some ZODB / ZEO fixes as well as the datetime fix and some other fixes added since 2.6.0. We will be having a "bug day" next Tuesday, and the goal will be that those fixes will also go into the Zope-2_6-branch to be included in a 2.6.1 beta 2 to be release hopefully around the end of next week. Assuming there are no issues with the b2 release, we'll plan on making it final a week or so after that for a late xmas present :) This schedule should also provide enough time for the valiant volunteers working on the 2.6.1 version of the Zope Book to finalize things for the release. Brian Lloyd brian(a)zope.com V.P. Engineering 540.361.1716 Zope Corporation http://www.zope.com

1 0