- Zope - Zope lists

-Recursive updates of bobobase_modification_time
by Morten W. Petersen 13 Apr '00

13 Apr '00

If I have a folder, 1, with a folder within it, 2, and within folder 2, there is a document called 2-a; Why is it that only 2-a's and 2's bobobase_modification_time gets updated, and not 1's? Regards, Morten W. Petersen

1 0

WorldPilot on NT4- Storage.LocalStorage problems
by dillera＠isc.upenn.edu 13 Apr '00

13 Apr '00

hello- I'm trying to get WP 1.0.4 working on NT4. I've fixed a minor problem where it couldn't load Storage.LocalStorage, (I changed it just to LocalStorage) but now this has opened a bigger can of worms. In LocalStorage.py (a WorldPilot module) it seems to be setting the ROOT PATH wrong. It looks like its trying to load all the graphics for the site, which are located in Products/WorldPilot/Storage. its calling lib\python\App\Imagefile.py and that seems to think the root path is: C:\\WINNTSVR\\system32 where it should be: C:\\Program Files\\zope\\lib\\python\\Products\\WorldPilot I can't see where this ROOT PATH is being set in LocalStorage or Imagefile. And WorldPiloteers out there lend a hand? thanks, andy diller Traceback: ------------- WorldPilot Import Traceback Traceback (innermost last): File "C:\PROGRA~1\zope\lib\python\OFS\Application.py", line 387, in import_products product=__import__(pname, global_dict, global_dict, silly) File "C:\PROGRA~1\zope\lib\python\Products\WorldPilot\__init__.py", line 94, in ? import WorldPilot File "C:\PROGRA~1\zope\lib\python\Products\WorldPilot\WorldPilot.py", line 1213, in ? import LocalStorage File "c:\Program Files\zope\lib\python\Products\WorldPilot\Storage\LocalStorage.py", line 608, in ? class WorldPilotMonolithicFolderObject( File "c:\Program Files\zope\lib\python\Products\WorldPilot\Storage\LocalStorage.py", line 613, in WorldPilotMonolithicFolderObject wpnavdown=ImageFile('wpnavdown.gif',globals()) File "C:\PROGRA~1\zope\lib\python\App\ImageFile.py", line 110, in __init__ file=open(path, 'rb') IOError: [Errno 2] No such file or directory: 'C:\\WINNTSVR\\system32\\LocalStorage/wpnavdown.gif'

2 2

RE: [Zope] info: zope complete hanging
by Marcus Collins 13 Apr '00

13 Apr '00

Hi, Thanks for the report! It might prove helpful to know the following: 1. Does Zope hang when you access the management interface using http://path/to/zope/manage_main or ftp? 2. Does Zope hang if you run in single threaded mode (z2.py -t 1)? 3. Are you using the default NUMBER_OF_THREADS (4)? 4. Are you using any database adaptors and, if so, which versions? 5. Is the hanging more or less frequent in Zope 2.1.6 than in 2.1.4? 6. What method of access (HTTP/PCGI/FCGI) do you use for the management interface? Is this the same protocol you use for the rest of the site? 7. Are you using a binary distribution of Zope, or have you compiled from source? Ditto for python. 8. Can you cause Zope to hang by refreshing the page a number of times in quick succession, or by stopping the request and then reloading? You mentioned that the hanging occurs when an error occurs. Are you referring to a Zope error, or an error which is logged or displayed on the console? A traceback or listing of the error might prove useful. Some of these might just be shots in the dark, but the more information we can gather, the better! Some also might not be practical for you to try out (like running Zope single-threaded, if this is a production server). Tres Seaver suggested this morning that we move discussions like this to a purpose-built Wiki at zope.org, but as that's now, I suggest we keep the discussion going on the list until the Wiki can be used. hth, and thanks! -- Marcus > -----Original Message----- > From: Jerome Alet [mailto:alet@unice.fr] > Sent: 13 April 2000 14:45 > To: zope(a)zope.org > Subject: [Zope] info: zope complete hanging > > Hi, > > I've noticed something here, but it doesn't seem thread > related since all zope hangs. > > from time to time (seems to be random), when using the management > interface, zope completely hangs when using IE5 under NT4SP5. > With IE4 on the same machine (before the update) or Netscape 4.72 > under Linux (same machine in dual boot) there's no problem at all. > It seems (not sure) the hang comes when an error occurs, and error > often occur when you begin with zope... > > when it hangs I can't connect to zope from any workstation here, > even trying to access a different page, outside the management > interface. > > Tested with 2.1.4 and 2.1.6 under SparcLinux (RedHat 4.2, > kernel 2.0.35, libc-5.3.12, python 1.5.2), and we don't suffer seem > to suffer from memory leaks. > > hope this helps to solve the problems. > > Jerome ALET - alet(a)unice.fr - http://cortex.unice.fr/~jerome > Faculte de Medecine de Nice - http://noe.unice.fr - Tel: 04 > 93 37 76 30 > 28 Avenue de Valombrose - 06107 NICE Cedex 2 - FRANCE > > > _______________________________________________ > 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

Re: [Zope] Sending results of query to Excel
by Richard Moon 13 Apr '00

13 Apr '00

More results on this research - its not really Zope related but I'm posting these because I was asked by some people to do so. It seems that if you either set the MIME type to something which the browser recgnises as Excel for example <dtml-call "RESPONSE.setHeader('ContentType','application/vnd.ms-excel')"> _OR_ call the DTML method wich produces the output something .xls then - 1) IE 4 and 5 (on PC) will open the data in an Excel spreadsheet within the viewer (presumably using OLE). However the ability to use this is severly limited, there's no Excel toolbars or menus available.(Not ideal) I haven't found any way to turn this behaviour off. 2) Netscape, provided you have the MIME-type entered in the Help Apps list will give you the option to save it as a .XLS file or will open Excel with the downloaded data. (This is perfect). On a Mac you can preconfigure Netscape's behaviour to either save the file (and it will save it as an Excel file), or open Excel with the data. 3) The data will be formatted correctly within the spreadsheet provided you use tab as the separator. You can't enter tabs via the managament interface so you have to edit the DTML method in an external editor and FTP or copy/paste it in. The other way to do it, which works better with IE4 and IE5 is to name the dtml method something.csv and set the MIME type to something the browser doesn;t recognise such as 'application/x-csv''. In this case, on PC the file will download to disk as a .csv file which Excel will happily open. A Mac won't make any sense of the .csv extension so you'll have to open the file within Excel. If you do it this way you must replace the tabs field separators with commas and it's best to single-quote all data to 'escape' embedded commas. In every case I'm still getting blank lines at the top of the spreadsheet. So there you have it - On 4/11/00, Richard Moon <richard.moon(a)nec.ac.uk> wrote: >Results of the experiments so far (thanks for all the help) > >If you set the RESPONSE variable as follows (which I suspect sets >a mime type whcih my browser doesn't recognise) then IE 5 will download >the file for you. If the DTML method that contains this code is called >something.csv then Excel will happily open up the file as a spreadsheet >(I'm getting some blank lines at the top though). > >Interestingly this also works with Netscape 4 on a Mac, though Netscape >gives you the extra option of opening the file directly with an application. >However if you do this then Excel doesn't recognise the commas and >each line of output goes into one column. hmmm. If you save the file >to disc then you have to open the file from within Excel as the Mac >doesn't recognise the Windows .csv file extension. What I don't know >is how you tell the Mac its an Excel file (anyone ???) > >Here's a sample of code that works > ><dtml-call "RESPONSE.setHeader('Content-Type', 'application/x-csv')"> > ><dtml-in Org_search> ><dtml-if sequence-start> >Name,Town,Post code,Telephone,Org.code ></dtml-if sequence-start> ><dtml-var name null="">,<dtml-var town null="">,<dtml-var post_code >null="">,<dtml-var telephone null="">,<dtml-var code null=""> ></dtml-in> > >Note that any spaces or newlines are interpreted by Excel so you >have to run things together on one line as I have done. > >Interestingly if you leave out the setting of RESPONSE then IE5 opens >up Excel inside the browser (if the DTML method is called something.csv, >though as with the Mac it doesn;t format it properly, everythig is >in one column). > > > >I think I need to research the mime types properly now (unless anyone >else has any ideas ?) > > > >On 4/11/00, Jerome Alet <alet(a)unice.fr> wrote: > >Note that any spaces > >>On 11 Apr 2000, Richard Moon wrote: >> >>> Thanks for the help - I don't see why this shouldn't work with > >>Zope - I >>> just need to find out how to get that Content-type header in the > >>object >>> Zope is serving up. >> >>yes, and then it should work fine. >> >>IMHO this should be something like: >> >><dtml-call "RESPONSE.setcontenttype('text/yourname')"> >> >>(not tested, and I'm even not sure about the function name, however > >>I'm >>almost sure you have to use RESPONSE. >> >>then a <dtml-in ...> to loop in your selected records, however you'll >>have to display all results at the same time, not on a 50 results > >>by 50 >>results basis just like the "normal" zope behavior. >> >>good luck. >> >>please could you tell me the final solution, because I might be >interested >>in a not so long time ? >> >>thanks. >>Jerome >> >> >> >> >>

1 0

RE: [Zope] WIN2K and ZOPE FULL WEBDAV SUPPORT!!!
by Brian Lloyd 13 Apr '00

13 Apr '00

> If you are experimenting with WIN 2000 try creating a NETWORK MAPPING > (WEBDAV) to a ZOPE FOLDER. > > 1. Click on Network > 2. Click on Add a Network Place > 3. Enter the url to a ZOPE Folder > 4. Done > > You now should have a folder view in Windows that Maps to a > Zope Folder. > Enabling all sorts of great things: > > 1. Editing and Saving back to the folder with Security > 2. Drag and Drop assets into the folder with Security > > Great work on the Implementation of WEBDAV!!! Thanks DC!!! That's very good news! Unfortunately I haven't been able to install win2K yet to see how it worked - I know about one further tweak that a little microsoft birdie told me I could use to enable editing of "unprocessed" source (i.e. double click on a DTML method from a web folder and have it open unrendered in your chosen text editor or something). It shouldn't be hard to add, I just need to get the time and find a box that I care little enough about to put w2K on it... :) Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

3 2

Re: SQLSession
by Anthony Baxter 13 Apr '00

13 Apr '00

(sorry about the delay - backlog of email since going on honeymoon, just now getting on top of it) (cc'd to zope(a)zope.org for other opinions) It's deliberate - the idea of the session stuff was that they'd be transient only. If it's considered a useful feature, I could expose an 'expiry' time in the management interface. A caveat, tho - last time I looked at this, browser support for cookie expiry was a bit flaky. >>> Robert Segall wrote > Hi Anthony > > I was looking at SQLSession and I found a small problem you may want to > fix: Netscape seems to have problems with cookies without an expiry date > (they are accepted temporarily, but not stored in the cookies database). > > My temporary fix was to set an expiry time of ten years into the future, > but this may not fit everyone's needs. > > Just some food for thought... -- Anthony Baxter <anthony(a)interlink.com.au> It's never too late to have a happy childhood.

1 0

info: zope complete hanging
by Jerome Alet 13 Apr '00

13 Apr '00

Hi, I've noticed something here, but it doesn't seem thread related since all zope hangs. from time to time (seems to be random), when using the management interface, zope completely hangs when using IE5 under NT4SP5. With IE4 on the same machine (before the update) or Netscape 4.72 under Linux (same machine in dual boot) there's no problem at all. It seems (not sure) the hang comes when an error occurs, and error often occur when you begin with zope... when it hangs I can't connect to zope from any workstation here, even trying to access a different page, outside the management interface. Tested with 2.1.4 and 2.1.6 under SparcLinux (RedHat 4.2, kernel 2.0.35, libc-5.3.12, python 1.5.2), and we don't suffer seem to suffer from memory leaks. hope this helps to solve the problems. Jerome ALET - alet(a)unice.fr - http://cortex.unice.fr/~jerome Faculte de Medecine de Nice - http://noe.unice.fr - Tel: 04 93 37 76 30 28 Avenue de Valombrose - 06107 NICE Cedex 2 - FRANCE

1 0

Re: [Zope] Zope & international characters
by Rik Hoekstra 13 Apr '00

13 Apr '00

>Hi there, >I don't know if this has ever asked before... >I got Zcatalog on my Zope site and it runs beutifully >EXCEPT that it will only find words that are in English >-and 80% of my site is in Greek ! The finding part seems to imply you use the Catalog. If so, that is right, the Catalog only accepts standard ascii (as used for English). And in general, python (the language Zope works with) does not handle unicode. All this will probably change in the (not too far) future, but for now, there is not much to be done about it I'm afraid. >Is there a fix ? I think zope.org is down right now or >for some reason I can't see it (12:30 GMT+2:00 from >the ntua.gr domain ) so I can't search the docs or the >archive. Yes, zope.org still down (14.15 CET) Rik

2 1

Problem with upgrade from Zope-2.1.2 to Zope-2.1.6
by Francois-Regis CHALAOUX 13 Apr '00

13 Apr '00

Hi All, Since I upgrade from Zope-2.1.2 to Zope-2.1.6 I HAVE A BIG PROBLEM !!! I create a little application to manage seminars. All the methods to consult these seminars work but all the method to upgrade, create, delete return now ERRORS. My DB is Gadfly. Should I come back to 2.1.2 ? Should I change something in my code? Should I modify Zope-2.1.6? Help, please. FR Environment =========== Linux Suse-6.2 Python 5.2 Zope-2.1.6 upgrade from Zope-2.1.2 with patch Zope-2.1.x-to-2.1.6-linux2-x86.tgz Gadfly =========== Bellow you can find the code of an example and the associated ERROR : DTML Document saisies.html ========================== <FORM ACTION="insert_seminar_do" METHOD="POST"> Blablabla .... </FORM> DTML Document insert_seminar_do =============================== Blablabla ...  Blablabla ... SQL Method insert_seminar ========================= Arguments : titre type jour numero mois annee heure minute nomconf prenomconf titreconf adresseconf lieu nomhote prenomhote url insert into seminar (id, titre, type, jour, numero,mois,annee,heure,minute,floatdate, nomconf, prenomconf, titreconf, adresseconf, lieu, nomhote, prenomhote, url) select max(id)+1, , , ,,, ,, , , ,, ,, , ,,  from seminar ============================= Remark : tofltdate is an external method. ============================= ######################## Error type: NameError Error value: REQUEST --> </TD></TR></TABLE> </TD> </TR> <TR> <TD BGCOLOR="#6699CC" ALIGN=RIGHT VALIGN=BOTTOM COLSPAN="2" WIDTH="150"><IMG SRC="Images/bottombar.gif" ALT="Curve graphic" WIDTH="150" HEIGHT="26" BORDER="0"></TD> <TD ALIGN=CENTER> <HR NOSHADE SIZE="0"> <p class="footlink" align="center"> <A HREF="http://sbi2.strasbourg.synthelabo.fr:8080/zseminar/insert_seminar_do?pp=1">Printable Page</A>     <A HREF="mailto:fchalaou@stasbourg.synthelabo.fr">Feedback</a>     <A HREF="http://sbi2.strasbourg.synthelabo.fr:8080/zseminar/insert_seminar_do/view_s…">DTML Source</a> </p></TD> </TR> </TABLE> </BODY> </HTML> <!-- Traceback (innermost last): File /opt/zope/Zope-2.1.2/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /opt/zope/Zope-2.1.2/lib/python/ZPublisher/Publish.py, line 179, in publish File /opt/zope/Zope-2.1.2/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /opt/zope/Zope-2.1.2/lib/python/ZPublisher/Publish.py, line 165, in publish File /opt/zope/Zope-2.1.2/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: insert_seminar_do) File /opt/zope/Zope-2.1.2/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: insert_seminar_do) File /opt/zope/Zope-2.1.2/lib/python/OFS/DTMLDocument.py, line 166, in __call__ (Object: insert_seminar_do) File /opt/zope/Zope-2.1.2/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: insert_seminar_do) File /opt/zope/Zope-2.1.2/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: insert_seminar(REQUEST)) (Info: REQUEST) File <string>, line 0, in ? File /opt/zope/Zope-2.1.2/lib/python/Shared/DC/ZRDB/DA.py, line 424, in __call__ (Object: insert_seminar) File /opt/zope/Zope-2.1.2/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: <string>) File /opt/zope/Zope-2.1.2/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: tofltdate(REQUEST['numero'],REQUEST['mois'],REQUEST['annee'])) (Info: REQUEST) File <string>, line 0, in ? NameError: (see above) -- >

1 0

returning external data
by a.wacknitz＠francotyp.com 13 Apr '00

13 Apr '00

Hi all, I have the problem to return files that are held in a version management system through Zope. My momentary solution is to check out a requested file into a temp directory returning the (local) file name to which the calling request is redirected. LocalFS is doing the rest of the job (the basepath is mapped to the temp directory). I have a problem with this solution: I don't know when it is safe to delete the temporary files. I wonder if it is possible to check out files to stdout and then returning the byte stream. I have no clue how this could by done in Python. I also guess that I have to set the content type of the response appropriately and maybe the file name. But I have no idea how to do that either. So, any help and hints are welcome. TIA, Andreas ********************************************************************** This email message has been swept by MIMEsweeper for the presence of computer viruses. Francotyp-Postalia AG & Co.

1 0