November 2002 - Zope

Uploading Images/Files To Database
by Mike Doanh Tran 21 Nov '02

21 Nov '02

Hi, Can anyone show me how to upload an image or file from a form and insert it into a database. I have the form and sql method figure out, but I don't know how to read the file and upload it into the database. It's .read() something? Here's what I got so far: THE FORM: <form name=attachment method=post ENCTYPE="multipart/form-data" action="addAttachment"> <input type=hidden name=bug_id value="<dtml-var bug_id>"> To attach a file to bug ID#, place it in a file on your local machine, and enter the path to that file here:<br> <input type=file name="thedata" size=40> <BR> <b>File Name:</b> <input type=text name="filename" size=40> <P> Please provide a one-line description of this attachment:<BR> <input name="description" size=60> <BR> <b>What kind of file is this?</b> <BR> <select name="mimetype"> <option value="" SELECTED>Select File Type<option> <option value="patch">Patch file (text/plain, diffs) <option value="text/plain">Plain text (text/plain) <option value="text/html">HTML source (text/html) <option value="image/gif">GIF Image (image/gif) <option value="image/jpeg">JPEG Image (image/jpeg) <option value="image/png">PNG Image (image/png) <option value="application/octet-stream">Binary file (application/octet-stream) <option value="other">Other </select><BR> <input type=button value="SUBMIT!" onClick="validateForm();"> </form> addAttachment method: <dtml-try> <dtml-let login_name="AUTHENTICATED_USER.getUserName()"> <dtml-in "getRealName(login_name=login_name)"> <dtml-call "insertAttachment(bug_id=bug_id,filename=filename,description=description,mimetype=mimetype, ispatch=ispatch,submitter_id=userid,thedata=thedata)"> </dtml-in> </dtml-let login_name> <H3>Attachment Added</H3> <LI>Your attachment was added to bug_id# <dtml-var bug_id> <dtml-except> <H3>Failed Add Attachment</H3> <LI><h4>Error Type: <dtml-var error_type></h4></LI> <LI><h4>Error Value: <dtml-var error_value></h4></LI> </dtml-try> ZSQL Method: INSERT INTO attachments(bug_id, filename, description, mimetype, ispatch, submitter_id, thedata) VALUES(<dtml-sqlvar bug_id type="int">, <dtml-sqlvar filename type="string">, <dtml-sqlvar description type="string">, <dtml-sqlvar mimetype type="string">, <dtml-sqlvar ispatch type="int">, <dtml-sqlvar submitter_id type="int">, <dtml-sqlvar thedata type="string">) The getRealName() is a lookup for the user's id#. Thanks for any suggestions. Mike

1 0

ZCTextIndex documentation
by Chris Withers 21 Nov '02

21 Nov '02

Hi, Can anyone tell me where to find the documentation for ZCTextIndex? cheers, Chris

2 1

Jvascript variables inseide REQUEST
by Dr. F. Tröster 21 Nov '02

21 Nov '02

Is there a possibility to transfer a javascript variable with it's value into the namespace (REQUEST)? Thanks Fritz

2 1

Viewing a Blob using DTML
by working4aliving 21 Nov '02

21 Nov '02

Hi, I've been working on this for a little, and am stuck... I'm a newbie with zope. I have a python script that calls a zsql method (mysql), and DOES display the image correctly. (calling the zsql method does not, by the way, it only displays "machine code" (old joke.hahaha;) , but that's ok, I think) When I type the url directly into the browser, and insert my id variable for the record, it'll work from the browser, but I can't get it to work through dtml. It will only display the "machine code". Is there a way to just call the url from dtml while inserting the ID variable at the end? I'm pretty stuck on this, and could really use an expert Here's the python url that works... http://localhost:8080/blobTest/selectImage1?id=12686 Is this the easiest way to do it? I've found some various documentation on the web, and although helpful, just doesn't get me there.... Thanks in advance. This group (and the product) are great. Bob

5 5

sorting objects in python
by David Bear 21 Nov '02

21 Nov '02

I have a script that uses getId to get all structured text documents in a folder. Each of those documents has an added property called 'priority' which is a string type. The value of 'priority' is is used to impose a sort order on the documents. However, I can't figure out how to sort the objects using the the sort method of lists. Any recommendations?

4 3

Re: PRODUCTS_PATH
by Projekt01, Roger Ineichen 21 Nov '02

21 Nov '02

Yes, thanks for helping to Andy McKay, Paul Winkler, Chris Withers, thats what I mean. The DirectoryView (skins) don't working with PRODUCT_PATH. If I use INSTANCE_HOME they will work. But that's not what I want. If I set the INSTANCE_HOME I can just use ONE data.fs on "INSTANCE_HOME/var/data.fs". If I want is to install a second zope an use the same Products, I have to set the INSTANCE_HOME of both zope to the same directory and in this directory has to be a folder "Products" and a folder "var" with the "data.fs". And here we are, we use the same data.fs with two different zope. Or I'm wrong? Is there a way to bring zope to load the installed own zope...var/data.fs with INSTANCE_HOME and not the one in INSTANCE_HOME/var/data.fs? The solution at this moment is to put all my different products in the INSTANCE_HOME/Products till this is fixed. But the rigth way should bee to set a PRODUCTS_HOME with different path's to my products. Thanks Roger ___________________________ Projekt01 GmbH Message: 1 Date: Thu, 21 Nov 2002 06:35:20 -0800 From: Paul Winkler <pw_lists(a)slinkp.com> To: zope(a)zope.org Subject: Re: [Zope] PRODUCTS_PATH On Thu, Nov 21, 2002 at 11:17:03AM +0000, Chris Withers wrote: > Paul Winkler wrote: > >I'm not sure what you mean by "isn't working", but there > >is a known bug with PRODUCTS_PATH and CMF. > > ...which, to my knowledge, has been fixed in CVS for rather a long > time now. > What's the issue number? http://collector.zope.org/CMF/64 the last status update is from you on Nov. 7 and says "I'll try and reproduce this when I get a chance, which won't be in the next month or so." I haven't checked out from CVS since then, so I assumed nothing had changed. BTW, could someone with write access on cmf.zope.org please update this link? it points to the "historical" tracker. http://cmf.zope.org/projmgmt/issue_tracker -- Paul Winkler http://www.slinkp.com "Welcome to Muppet Labs, where the future is made - today!" Message: 17 Date: Wed, 20 Nov 2002 11:18:24 -0800 From: Paul Winkler <pw_lists(a)slinkp.com> To: zope(a)zope.org Subject: Re: [Zope] PRODUCTS_PATH On Wed, Nov 20, 2002 at 07:52:51PM +0100, Projekt01, Roger Ineichen wrote: > Hello together > I installed an Win Zope from CVS and Plone from CVS an got the > following problem? The PRODUCTS_PATH isn't working. How can I > configure my start.bat for different product directories then the zope > products. (On Win)??? Does sombody have a running start.bat with > SOFTWARE_HOME, INSTANCE_HOME, PRODUCTS_HOME on Windows? I'm not sure what you mean by "isn't working", but there is a known bug with PRODUCTS_PATH and CMF. Filesystem Directory Views which are used by CMF & Plone do not find the specified path unless it's under INSTANCE_HOME or SOFTWARE_HOME. I filed a bug report in the CMF collector a while ago. There was some followup, but no fix yet. It will get addressed eventually, but IIRC it's not high priority at the moment. --PW ___________________________ Projekt01 GmbH www.projekt01.ch Langackerstrasse 8 6330 Cham phone +41 (0)41 781 01 78 mobile +41 (0)79 340 52 32 fax +41 (0)41 781 00 78 email r.ineichen(a)projekt01.ch ___________________________ END OF MESSAGE

1 0

Cookie Crumbler and querystrings
by Ben Avery 21 Nov '02

21 Nov '02

Hi, I am building a site where users must log in before being allowed access. For this I use Cookie Crumbler, but I have a problem with it: There are some URLs with querystring information, e.g. http://www.mysite.org/opportunity/cancel/?opp_id=29 The first time they try this link, the Cookie Crumbler redirects them back to the login page for username and password. But after they have logged in, they get taken back to http://www.mysite.org/opportunity/cancel/index_html without the querystring, which is necessary for the index_html method to function. Is there a way to avoid this problem, and to maintain querystring through the CC login process? TIA Ben Avery YouthNet UK ben(a)thesite.org

2 3

installation of products with win 95
by Martin Hartmann 21 Nov '02

21 Nov '02

Hello, I tried to intall some products in zope (2.5.1) by copying the product folders to lib/python/Products: AbracadrabaObject, PropertyObject, PropertyFolder. Zope runs under win95. If I start Zope, then there is an error message: "... Error Zope couldn't install PropertyObject File c:\Programme\WebSite\lib\python\OFS\Application.py Line 609, in install_product Import Error: No module named Property Object ..." After that it is possible to work with zope unter win95, but without these products. With Win2000 there is no problem to install these products. Where is the mistake ? Thank you, Martin Hartmann

3 3

Re: SUF Problems
by Chris Withers 21 Nov '02

21 Nov '02

andy toenz wrote: > I see all my Users in the UserFolder. > But I can't login using the names in my usertables :(( > > Is it because the password is encrypted using the Password-SQL statement ? Yup. Do they need to be or could you use the normal Zope UserFolder password encryption? cheers, Chris

1 0

Zsyncer to Zuploader
by Elena Schulz 21 Nov '02

21 Nov '02

Hi, does anybody know what needs to be done to change the Zsyncer-Product so that it just serves as an uploader without needing to be installed on the client-side (if possible). Or is there an other solution to upload Zope-Objects with properties (without zexp-import) -- many thanks for relpies, Elena

6 10