November 2001 - Zope

dtml-sendmail error with pine (2)
by Julián Muñoz Domínguez 16 Nov '01

16 Nov '01

The dtml I have used to generate my last message is: <dtml-var standard_html_header> <dtml-sendmail mailhost="MailHost"> From: jmunoz(a)softhome.net To: jmunoz(a)julian.ea4acl.ampr.org Subject: dtml-sendmail error with pine <dtml-mime type="text/plain" encode="7bit"> Hello, this email is sent from a dtml document, with the dtml-sendmail tag. I have followed the instructions in the zope book and some examples in this mail list, but the viewing of attached file doesn't work with my pine email client !! It works well with kmail, but no with pine, so I suppose that the format of the message is not 100% correct. Attached is a pdf document. <dtml-boundary type="application/pdf" disposition="attachment" encode="base64" filename="1.pdf"><dtml-var 1.pdf></dtml-mime> </dtml-sendmail> <dtml-var standard_html_footer>

1 0

XML-RPC timeout
by Nuno Maltez 16 Nov '01

16 Nov '01

Hi, How do I define the timeout for a XML-RPC call to a Zope method? If I use the XML-RPC library to call a Zope method that never returns, or takes a *very* long time to return, it seems that the calling side will wait forever for that function to return. Is this correct? If so, how I set a timeout so that the call raises an exception instead of hanging? Thanks in advance, Nuno

1 0

Re: [Zope] grabbing external content
by Bak ＠ kedai 16 Nov '01

16 Nov '01

>Hi Stephan, > >I think this is what you're looking for: > >http://www.zope.org/Members/lstaffor/ZClientMethod or http://www.zope.org/Members/kedai/KebasData :) > >Bey! Antwan. > > > >At 14:58 16-11-01 +0000, you wrote: is there any functionality like > ><dtml-var grab="http://www.yahoo.com/weather"> > >which loads the content of www.yahoo.com/weather without installing External methods? I thought that I saw such a product some time ago. > > > > >_______________________________________________ >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 ) >

1 0

dtml-sendmail error with pine
by jmunoz＠softhome.net 16 Nov '01

16 Nov '01

Hello, this email is sent from a dtml document, with the dtml-sendmail tag. I have followed the instructions in the zope book and some examples in this mail list, but the viewing of attached file doesn't work with my pine email client !! It works well with kmail, but no with pine, so I suppose that the format of the message is not 100% correct. Attached is a pdf document.

1 0

RE: [Zope] updating excel as an odbc datasource
by Meilicke, Scott 16 Nov '01

16 Nov '01

I think I explained this incorrectly. I just want to display information from excel with zope. I have no need to update the excel spreadsheet from zope. The customer needs to be able to update the excel spreadsheet by opening the excel file with excel, modifying the contents, and save the contents back to the file. Zope should then see these changes and display the web page appropriately. Based on the feedback so far, I have a few options: 1. Build it all in zope - more work, but may be worth it 2. Since it is zope that is doing the locking, have an access db that gets it's info from excel, and use the access db as the datasource feeding zope 3. Update everything manually, as the data change about once a week I'm currently using #3, and I will be pursuing #2 today. The advantage of #1 is I can reuse the functionality across more applications, all user maintained - the best long term solution, as I understand the requirements. Thanks for everyone's feedback. Scott -----Original Message----- From: Alan C [mailto:alanc@tech-world.com] Sent: Friday, November 16, 2001 7:50 AM To: zope(a)zope.org Subject: RE: [Zope] updating excel as an odbc datasource Uncheck Read only on the ODBC driver. It is possible to write to Excel via ODBC, but I haven't tried it with Zope. - Alan --------------------------------------- Zope tips and tricks site http://twsite.bizland.com/zopetips.htm > -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Casey > Duncan > Sent: Friday, November 16, 2001 9:10 AM > To: Meilicke, Scott; 'zope(a)zope.org' > Subject: Re: [Zope] updating excel as an odbc datasource > > > On Thursday 15 November 2001 06:22 pm, Meilicke, Scott allegedly wrote: > > Hi all, > > > > I'm using excel as an odbc datasource, and my customer needs to > be able to > > update the excel spreadsheet. However, when zope has connected to the > > database connector, I can not open the file read/write, nor can > I replace > > the file with another. Read-only is checked on my odbc driver. > > > > Any thoughts on how to get around this? > > > > My connection string is just the name of the odbc connector - is there a > > 'read only' flag I can send it? > > > > Thanks - Scott > > I don't know that an ODBC driver could write to an excel file, > since excel > isn't really a database, at it doesn't really support SQL. I > would suggest > that you implement this differently. Here are two suggestions: > > 1. Have Zope generate a csv (Comma separated values) file from > the data. This > can be read by Excel or imported using a macro. The disadvantage > to this is > that you do not have much formatting control. > > 2. Create a separate database that Zope can write to (MySQL or > even Access). > Then hook excel to this database via ODBC. This is more complex, > but probably > will give you the most flexibility. > > hth, > /---------------------------------------------------\ > Casey Duncan, Sr. Web Developer > National Legal Aid and Defender Association > c.duncan(a)nlada.org > \---------------------------------------------------/ > > _______________________________________________ > 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 ) > _______________________________________________ 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 )

2 1

grabbing external content
by Stephan Goeldi 16 Nov '01

16 Nov '01

is there any functionality like <dtml-var grab="http://www.yahoo.com/weather"> which loads the content of www.yahoo.com/weather without installing External methods? I thought that I saw such a product some time ago. _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

2 1

updating excel as an odbc datasource
by Meilicke, Scott 16 Nov '01

16 Nov '01

Hi all, I'm using excel as an odbc datasource, and my customer needs to be able to update the excel spreadsheet. However, when zope has connected to the database connector, I can not open the file read/write, nor can I replace the file with another. Read-only is checked on my odbc driver. Any thoughts on how to get around this? My connection string is just the name of the odbc connector - is there a 'read only' flag I can send it? Thanks - Scott

3 2

Re: [Zope] updating excel as an odbc datasource
by David Carter-Tod 16 Nov '01

16 Nov '01

On Thursday 15 November 2001 06:22 pm, Meilicke, Scott allegedly wrote: > I'm using excel as an odbc datasource, and my customer needs to be able to > update the excel spreadsheet. However, when zope has connected to the > database connector, I can not open the file read/write, nor can I replace > the file with another. Read-only is checked on my odbc driver. > > Any thoughts on how to get around this? I suspect the problem is that you need to set read-write security permissions on the excel file (in the file system). MS Access can have this problem too. David -- David Carter-Tod <wccartd(a)wc.cc.va.us> Instructional Technologist/Distance Education Contact Wytheville Community College, 1000 E. Main St., Wytheville, VA 24382 (wk) 540-223-4784 http://www.wc.cc.va.us/ Online certificate in web site design: http://www.wc.cc.va.us/websiteDesign

1 0

RE: [Zope] grabbing external content
by Schmidt, Allen J. 16 Nov '01

16 Nov '01

Someone sent this type thing a while back but can't remember who. Create an external method and put this into it: def getPage(url): import urllib return urllib.urlopen(url).read() The just call it like: <dtml-var "getPage('http://www.yahoo.com/weather')"> Works like a champ for us! Allen -----Original Message----- From: Pieter Claerhout [mailto:Pieter_Claerhout@CreoScitex.com] Sent: Friday, November 16, 2001 10:08 AM To: zope(a)zope.org Subject: RE: [Zope] grabbing external content Try the product KebasData, it does all that and even more... Can't remember the exact URL, but a find on www.zope.org will tell you. Cheers, Pieter -----Original Message----- From: Stephan Goeldi [mailto:stephan_goeldi@hotmail.com] Sent: Friday, November 16, 2001 3:59 PM To: zope(a)zope.org Subject: [Zope] grabbing external content is there any functionality like <dtml-var grab="http://www.yahoo.com/weather"> which loads the content of www.yahoo.com/weather without installing External methods? I thought that I saw such a product some time ago. _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp _______________________________________________ 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 ) _______________________________________________ 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 )

1 0

Re: [Zope] Installing ZPatterns: The Beat Goes On...:
by hamzatk＠3dresearch.com 16 Nov '01

16 Nov '01

> Hi Kamal, > > No.... try: > > cd c:\website > > the type: > > c:\website\bin\python.exe zpasswd.py access > > I don't run windows much.. so this is from memory... details are > suspect! > Hello, Thanks for your support. It didn't work the error is :can't open file 'zpasswd.py' regards. kamal > -steve > > > > On Friday, November 16, 2001, at 06:12 AM, <hamzatk(a)3dresearch.com> > wrote: > >> Hi, >> I try to do what you suggested >> >>> Hi kamal, >>> >>> Ahh.. this is easy: >>> >>> in the root of zope run: >>> >>> python.exe zpasswd.py access >>> >>> set a username an password for the "emergency" user. >>> >>> -steve >> Hi, >> I tried it and get error :bad command or file name. >> >> I later discovered that the zpasswd.py is located at C:\website while >> the >> python.exe is located at c:\website\bin >> >> I am thinking may be I should copy zpasswd.py into \bin directory but >> I am >> scared, I am already nervous and I just don't want to do something >> that can >> add to it. >> >> thanks. >> >> >>> >>> On Friday, November 16, 2001, at 04:18 AM, <hamzatk(a)3dresearch.com> >>> wrote: >>> >>>> At 01:51 PM 11/14/01 -0500, you wrote: >>>> >>>> I thought the latest TransactionAgents (0.0.4) included >>>> DynPersist.pyd >>>> (the >>>> compiled form). I know because I contributed it! Check and make sure >>>> you have the latest version. >>>> >>>> -steve >>>> >>>> Hi steve, >>>> I actually saw the DynPersist.pyd in the TransactionAgents (0.0.4) >>>> and >>>> the >>>> ZPatterns is not given any problem again. Then my problem still >>>> remain because after extracted the TransactionAgents the Login >>>> Manager is still given this problem :- >>>> >>>> Import Traceback >>>> Traceback (most recent call last): >>>> File "C:\Program Files\WebSite\lib\python\OFS\Application.py", >>>> line >>>> 552, >>>> in import_product >>>> product=__import__(pname, global_dict, global_dict, silly) >>>> File "C:\Program >>>> Files\WebSite\lib\python\Products\LoginManager\__init__.py", line 1, >>>> in ? >>>> import LoginManager, LoginMethods, UserSources >>>> File "C:\Program >>>> Files\WebSite\lib\python\Products\LoginManager\LoginManager.py", >>>> line 121, >>>> in ? >>>> raise 'InstallError', ( >>>> InstallError: No access file found at C:\Program Files\WebSite - see >>>> INSTALL.txt >>>> >>>> While I continue to see what I can do, I still so much rely on your >>>> assistance to finanlly see me through. >>>> >>>> kamal. >>>> >>>> >>>> >>>> >>>> On Wednesday, November 14, 2001, at 01:46 PM, Hamzat kamal wrote: >>>> >>>> >>>> At 01:17 PM 11/14/01 -0500, you wrote: >>>> >>>> Hi Kamal, >>>> >>>> Did you get DynPersist.pyd in your "ZPatterns" directory? >>>> >>>> >>>> No what I have their is DynPersist.c >>>> kamal. >>>> >>>> >>>> >>>> -steve >>>> >>>> On Wednesday, November 14, 2001, at 12:59 PM, Hamzat kamal wrote: >>>> >>>> >>>> At 05:49 AM 11/14/01 -0500, you wrote: >>>> >>>> Hi folks, >>>> >>>> There's a new version of TransactionAgents available here: >>>> >>>> http://cat-box.net/steve/TransactionAgents-0.0.4.tar.gz >>>> >>>> >>>> Hello Steve, >>>> >>>> I just extracted the new version of TransactionAgents and this is >>>> the trace back error display when I clicked on the Login manager in >>>> the products directory; >>>> >>>> Import Traceback >>>> Traceback (most recent call last): >>>> File "C:\Program Files\WebSite\lib\python\OFS\Application.py", >>>> line >>>> 552, >>>> in import_product >>>> product=__import__(pname, global_dict, global_dict, silly) >>>> File "C:\Program >>>> Files\WebSite\lib\python\Products\LoginManager\__init__.py", line 1, >>>> in ? >>>> import LoginManager, LoginMethods, UserSources >>>> File "C:\Program >>>> Files\WebSite\lib\python\Products\LoginManager\LoginManager.py", >>>> line 8, in ? >>>> from Products.ZPatterns.Specialists import Specialist >>>> File "C:\Program >>>> Files\WebSite\lib\python\Products\ZPatterns\__init__.py", line 1, in >>>> ? >>>> import Rack, Specialists, Customizers, AttributeProviders, >>>> SheetProviders >>>> File "C:\Program >>>> Files\WebSite\lib\python\Products\ZPatterns\Rack.py", >>>> line 8, in ? >>>> from DataSkins import DataSkin >>>> File "C:\Program >>>> Files\WebSite\lib\python\Products\ZPatterns\DataSkins.py", line 1, >>>> in ? >>>> from DynPersist import DynPersist >>>> ImportError: No module named DynPersist >>>> >>>> Initially I was unable to download the >>>> TransactionAgents-0.0.4.tar.gz with >>>> my winzip, each time I clicked on it, it gives me >>>> "Error reading header after processing 0 entries" then I have to >>>> change the >>>> ext to ".tgz" before I could downloaded it. >>>> >>>> Could this be the part of the problems? >>>> >>>> I am using win 98 zope 2.4, pythin 2.1. >>>> >>>> Regards. >>>> kamal

2 1