March 2000 - Zope - Zope lists

RE: [Zope] Upload files in Zope and store elsewhere
by Daniel.Weber＠SEMATECH.Org 22 Mar '00

22 Mar '00

I messed around with this a little bit before giving up, though I'd like it to work.... The problem (as I see it), is that 1) you have to get to the data and 2) you have to format the data properly so that the database stores it properly. What I've gleaned is that the binary data will contain characters that confuse whatever DA you're using (I use the ODBC adapter). This means you'll probably have to replace these 'confusing' characters with their 'safe' counterparts. For the person who got it to work, it was the 0x08 character. I believe other DB's will choke elsewhere. I never could figure out which characters needed replacing and with what, so I wrote an external method to save the file and just wrote the filename/location/upload info into the database. This wasn't as nice as I wanted (I had security concerns putting anyone's files on the hard drive), but it will probably work (I get sidetracked once I got the file saved and haven't finished that project). Let me know if you get it solved (I'm using ODBC to a cheap acess database). > -----Original Message----- > From: Marius Kjeldahl [mailto:marius@funcom.com] > Sent: Wednesday, March 22, 2000 5:44 AM > To: zope(a)zope.org > Subject: [Zope] Upload files in Zope and store elsewhere > > > After some helpful advice, I have been successful in uploading files > (images) to Zope. Now I am trying to stuff the uploaded images in a > MySQL database, but am not able to access the image data. > > If I try to stuff the image data "raw" into the database by > declaring a > image:string parameter to the ZSQL Method and <dtml-sqlvar image> in > the ZSQL code I get a string like "<ZPublisher.HTTPRequest.FileUpload > instance at 87956214>". > > Another approach I have tried was <dtml-var image fmt=sql-quote>, but > this complains about the image being an instance and not a string. > > Another approach has been to access the actual "raw" image data using > image.data in various combinations, but I have not gotten this to work > anywhere (contrary to what it seems other people have managed to do), > see this > http://www.egroups.com/group/zope/26227.html? posting. Looking through Image.py I see quote a few methods for accessing the image as a "web" object through the use of URL. Internally, Image.py uses the data attribute extensively, but I have not been able to access this from within DTML (and I guess this has to do with data not being listed in either the properties or permission sections of Image.py). My final try will probably be to resort to using an External method to get access to the "full" Image.py object (including data), but I was hoping to avoid this. Has anybody done this (uploading in Zope and storing the data outside of Zope) successfully? If so, please give me a hint.. Thanks, Marius Kjeldahl _______________________________________________ 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

Zope Weekly News
by Mike Pelletier 22 Mar '00

22 Mar '00

G'day, Zope Weekly News is a digest of some of the useful and interesting events which have occurred on the various Zope mailing lists and the Zope.org site. It is published each Wednesday before Noon. Any opinions contained in the Zope Weekly News are those of the chronicler exclusively. Announcements * Two new Zope revisions were released this week. 2.1.5 filled in security holes which affected sites which allow untrusted users to create DTML documents. Ironically, a bug-fix which was included in 2.1.5 broke code which depended on the bug. This was fixed in the second release, 2.1.6. http://www.zope.org/Products/Zope/2.1.5/Zope_215_release http://www.zope.org/Products/Zope/2.1.6/Zope_216_release * Thanks to Eduardo Fernandez Corrales, the Zope Weekly News is now available in Spanish! He is publishing translations at Zope Hispano, a portal for Spanish-speaking Zope developers and users. http://zope.sistelnet.es * Healtheon | WebMD is hiring in Atlanta, GA Healtheon | WebMD is looking for Software Engineers with experience in Python and/or Zope to work in our Global News Center located in Midtown Atlanta, GA. You must be willing to relocate. http://www.zope.org/Members/kbirch-webmd/hiring-notice New Products * The Portal Toolkit has been packaged into a snapshot release for use by those who do not have access to CVS. The PTK is targeted at community-oriented portals, but is also appropriate for any site which wants to give members a personalised view of content. The snapshot release is 0.7.1. http://www.zope.org/Products/PTK Updates * Software Product: load_site.py with additional features, by Itamar Shtull-Trauring Itamar has updated his powered-up 'load_site.py' again. The present release is 1.3.1. This update adds a GUI, built with wxPython. 'load_site' is a utility for dumping content from a file system into the ZODB. http://www.zope.org/Members/itamar/load_site * Software Product: ZopeEDIT, by "jimbag" The latest release of this product, 0.0.5, adds limited RPC support which is used to create and delete folders. ZopeEDIT is a tool which enables any text editor to edit content on a live Zope server. It does not need to run on the same machine as the Zope server. http://www.zope.org/Members/jimbag/ZopeEDIT/ * Software Product: LocalFS, by Jonothan Farr Version 0.1.6, the Ides of March release, fixes several bugs, is more robust about determining file types, and creates XMLDocuments and StructuredDocuments automatically, where appropriate. LocalFS is a product which allows Zope to serve files out of a local filesystem. http://lists.zope.org/pipermail/zope-announce/2000-March/000130.html * Software Product: SiteAccess, by Evan Simpson Evan has release version 1.0.1 of SiteAccess. This version fixes a bug which interfered with FTP access to Zope. The SiteAccess product allows Zope to serve different content depending on the hostname the site was accessed by. http://www.zope.org/Members/4am/SiteAccess Zope.org items * How-To: VersionFTPServer, by "htrd" This How-To describes modifications to Zope which allow you to work within a Version through FTP. Versions allow you to stage changes to a Zope site by effectively forking the database. Changes that you make in a Version are not publicly visible until you ask them to be. http://www.zope.org/Members/htrd/howto/VersionFTPServer * How-To: How To: Use GenericUserFolder with an SQL database Version 1.1, by "hippy" This How-To shows how to customise GenericUserFolder(GUF) to use an SQL database as its repository for usernames, passwords, roles and anything else you want to store about a user. The update adds information from Dennis Baker to help get things going with MySQL. http://www.zope.org/Members/hippy/GUF_SQL_crypt_1_1 -- Mike Pelletier.

1 0

SiteAccess 1.0.1 is up
by Evan Simpson 22 Mar '00

22 Mar '00

Version 1.0.1 of SiteAccess is at http://www.zope.org/Members/4am/SiteAccess It should work with all Zope 2.x versions, and fixes a bug which interfered with FTP access to Zope. Cheers, Evan @ digicool & 4-am

2 1

Upload files in Zope and store elsewhere
by Marius Kjeldahl 22 Mar '00

22 Mar '00

After some helpful advice, I have been successful in uploading files (images) to Zope. Now I am trying to stuff the uploaded images in a MySQL database, but am not able to access the image data. If I try to stuff the image data "raw" into the database by declaring a image:string parameter to the ZSQL Method and <dtml-sqlvar image> in the ZSQL code I get a string like "<ZPublisher.HTTPRequest.FileUpload instance at 87956214>". Another approach I have tried was <dtml-var image fmt=sql-quote>, but this complains about the image being an instance and not a string. Another approach has been to access the actual "raw" image data using image.data in various combinations, but I have not gotten this to work anywhere (contrary to what it seems other people have managed to do), see this http://www.egroups.com/group/zope/26227.html? posting. Looking through Image.py I see quote a few methods for accessing the image as a "web" object through the use of URL. Internally, Image.py uses the data attribute extensively, but I have not been able to access this from within DTML (and I guess this has to do with data not being listed in either the properties or permission sections of Image.py). My final try will probably be to resort to using an External method to get access to the "full" Image.py object (including data), but I was hoping to avoid this. Has anybody done this (uploading in Zope and storing the data outside of Zope) successfully? If so, please give me a hint.. Thanks, Marius Kjeldahl

3 4

worldpilot PIM
by mindlace 22 Mar '00

22 Mar '00

Zopistas & worldpiloteers, I've got worldpilot set up and running just fine. Now I'm interested in trying to get the collaborative features of worldpilot working, since despite having several IMAP users, the TODO, Calendar, etc. only allow me to select one user (the current one.) Thanks, Ethan Fremen -- http://mindlace.net __________________ mindlace(a)imeme.net I don't want The Truth but I wouldn't mind a Big Analogy.

2 2

Names containing colons?
by Skip Montanaro 22 Mar '00

22 Mar '00

In my web page input forms I've been using field names like "radius:int" so Zope will coerce variables to the proper type. This works fine on the server. Unfortunately, if I have a JavaScript function on my web page to do form input validation, how do I reference that object? Is there some alternate naming scheme that will allow Zope to do the type cast and allow references from JavaScript? Should I just forego the :int stuff altogether and do the coercion explicitly? Thx, -- Skip Montanaro | http://www.mojam.com/ skip(a)mojam.com | http://www.musi-cal.com/

2 1

RE: [Zope] Server Sizing
by Stephan Richter 22 Mar '00

22 Mar '00

So ProxyPass is 20 % faster. Cool. I will try that. Regards, Stephan -- Stephan Richter - (901) 573-3308 - srichter(a)cbu.edu CBU - Physics & Chemistry; Framework Web - Web Design & Development PGP Key: 735E C61E 5C64 F430 4F9C 798E DCA2 07E3 E42B 5391

1 0

sqlsession and postgresql
by Shortie Lo 22 Mar '00

22 Mar '00

i have installed sqlsession product and only change sqlSessionCreate as insert into sessions ( session ) values ( nextval('sessions_session_seq') :: varchar ) i have tried code block from How-To: Using SQLSession. everything seems to work except <dtml-call "SESSION.clear()">. traceback: Traceback (innermost last): File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /home3/local/src/Zope-2.1.5-src/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/OFS/DTMLMethod.py, line 150, in __call__ (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: SESSION.clear()) (Info: SESSION) File <string>, line 0, in ? File /usr/local/src/Zope-2.1.6-src/lib/python/Products/SQLSession/SQLSession.py , line 172, in clear File /home3/local/src/Zope-2.1.6-src/lib/python/Shared/DC/ZRDB/DA.py, line 408, in __call__ (Object: sqlDeleteValue) File /home3/local/src/Zope-2.1.5-src/lib/python/Shared/DC/ZRDB/Aqueduct.py, line 186, in _argdata (Object: sqlDeleteValue) Bad Request: (see above) -- 'Life is like boxes of chocolate, Forrest. You never know what you're gonna get.' -- Forrest Gump (1994) Lo Chung-Chang (shortie) shortie(a)ms14.hinet.net http://shortie.vbc.com.tw/ ICQ#27118251 Kaohsiung.Taiwan.Roc.Earth.Solar.Galaxy.Universe

1 0

RE: [Zope] Server Sizing
by Stephan Richter 22 Mar '00

22 Mar '00

>i agree on apache increasing your performance when serving static >files (for instance images), but wouldn't url rewriting and the proxy >pass module of apache be an even better solution? i just switched from >PCGI to the Rewrite/Proxypass combo because of the additional overhead >of PCGI. Mmmhh, I have to have a look. Okay, I just read the the little tutorial. Does it really speed things up? I guess SSL should not be hard using this solution. I will be thinking about it. Anyone else? Regards, Stephan -- Stephan Richter - (901) 573-3308 - srichter(a)cbu.edu CBU - Physics & Chemistry; Framework Web - Web Design & Development PGP Key: 735E C61E 5C64 F430 4F9C 798E DCA2 07E3 E42B 5391

2 1

sqlsession and postgresql
by 羅春長 22 Mar '00

22 Mar '00

0 *H÷ 010 +0 *H÷ $Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: 7bit i have installed sqlsession product and only change sqlSessionCreate as insert into sessions ( session ) values ( nextval('sessions_session_seq') :: varchar ) i have tried code block from How-To: Using SQLSession. everything seems to work except <dtml-call "SESSION.clear()">. traceback: Traceback (innermost last): File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /home3/local/src/Zope-2.1.5-src/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/OFS/DTMLMethod.py, line 150, in __call__ (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: SESSION.clear()) (Info: SESSION) File <string>, line 0, in ? File /usr/local/src/Zope-2.1.6-src/lib/python/Products/SQLSession/SQLSession.py , line 172, in clear File /home3/local/src/Zope-2.1.6-src/lib/python/Shared/DC/ZRDB/DA.py, line 408, in __call__ (Object: sqlDeleteValue) File /home3/local/src/Zope-2.1.5-src/lib/python/Shared/DC/ZRDB/Aqueduct.py, line 186, in _argdata (Object: sqlDeleteValue) Bad Request: (see above) -- 'Life is like boxes of chocolate, Forrest. You never know what you're gonna get.' -- Forrest Gump (1994) Lo Chung-Chang (shortie) shortie(a)ms14.hinet.net http://shortie.vbc.com.tw/ ICQ#27118251 Kaohsiung.Taiwan.Roc.Earth.Solar.Galaxy.Universe 00 ÆdÕ§@Áœ;Ûå®'Ó$%0 *H÷ 0_10 UUS10U VeriSign, Inc.1705U.Class 1 Public Primary Certification Authority0 980903000000Z 030903235959Z0·10U HiTRUST, Inc.10UVeriSign Trust Network1G0EU>www.verisign.com/repository/RPA Incorp. by Ref.,LIAB.LTD.(c)981301U*HiTRUST Class 1 CA - Individual Subscriber00 *H÷ 0ÑAUÙÀŒŸîaí²®ÇxÔH°tì ée:þÚžœñIè:µ:÷%sy7ÑLSäâ × ³9>^¿sCy|Dÿ¹€Òm\d»ÔÞ~z@RÕGËºsµçè_qºmšÖ8ß÷žrgû]%Æcû=i£|0z0 `HøB0GU @0>0<`HøE0-0++www.verisign.com/repository/RPA0U0ÿ0U0 *H÷ Ø² ùÓ«àF,{v-QÍ,{}íxz¹äËfIÃxXŸ°ø¢µ|ÃZOí4(WóÃM3+»ín|B£N|osëw2&ÈèPœCÜA¶ò¢aÎ;¶vÈÛñèLõ7šz?µá0n0× _$dP[ºûÓnMf%%0 *H÷ 0·10U HiTRUST, Inc.10UVeriSign Trust Network1G0EU>www.verisign.com/repository/RPA Incorp. by Ref.,LIAB.LTD.(c)981301U*HiTRUST Class 1 CA - Individual Subscriber0 000322000000Z 010405235959Z0<10U VeriSign, Inc.1=0;U4www.hitrust.com.tw/RPA Incorp. by Ref.,LIAB.LTD(c)981'0%UAuthenticated by HiTRUST, Inc.1'0%UMember, VeriSign Trust Network10UPersona Not Validated1402U+Digital ID Class 1 - Microsoft Full Service10U SHORTIE LO1%0# *H÷ shortie@ms14.hinet.net00 *H÷ 0¡œž²Ü»NT)q6µ_ri£$Ze° DäÇT#ÖSTOÈÖ}8ÌÿGE+ jRâYùh$ÉØâeèÄðRõá¡o~7LØ¬r`Iðé©SM-=GuÉR3ëŽ` Ñx`oJžøç}ò64Vµj}Q£ò0ï0 U00FU ?0=0;`HøE0,0*+https://www.hitrust.com.tw/RPA0 `HøB0 `HøExvd4652bd63f2047029298763c9d2f275069c7359bed1b059da75bc4bc9701747da5d2f6141beadb2bd2e89206bd63f0d611499fa3ba45fcf3ea450c0 *H÷ ÏteV4Îìÿ¡"òpø¶p7"Dô×q*_¬€cü;ÙŸ¢%ïšTàva§Þ£ö* õ¬Óü-Œ²&" 2F»üß]éäkºVFïÎ0ÕEÿ Ô,ú»J±çáHrœl{ëK@Çåê7@ÄÕ1ò0î0Ì0·10U HiTRUST, Inc.10UVeriSign Trust Network1G0EU>www.verisign.com/repository/RPA Incorp. by Ref.,LIAB.LTD.(c)981301U*HiTRUST Class 1 CA - Individual Subscriber_$dP[ºûÓnMf%%0 + {0 *H÷ 1 *H÷ 0 *H÷ 1 000322121950Z0# *H÷ 1¡®#áG{Àc»Ö/0< *H÷ 1/0-0+0 *H÷ (0+0 *H÷ 0Ý +71Ï0Ì0·10U HiTRUST, Inc.10UVeriSign Trust Network1G0EU>www.verisign.com/repository/RPA Incorp. by Ref.,LIAB.LTD.(c)981301U*HiTRUST Class 1 CA - Individual Subscriber_$dP[ºûÓnMf%%0 *H÷ |¢#í£µBŽñ¡ÛAØÉÉð²S)Üæª6ÕÉœ-_ò8¥Ol×d(}\îì±Š6üNte;Ozöóé?Ðiðñ:Ýæ.¿ªí#±a¡o×7Të¯wF£]êðäç:É8)=Gã€S:¡û«lÐWWý

1 0