- Zope - Zope lists

RE: SybaseDA
by Chris McDonough 15 Mar '00

15 Mar '00

Can nobody/nobody read from the Sybase client directory? -----Original Message----- From: Dan Zweifel [mailto:danz@vonhoffmann.com] Sent: Wednesday, March 15, 2000 5:26 PM To: 'Chris McDonough' Cc: 'zope(a)zope.org' Subject: RE: SybaseDA Chris The -H flag in isql specifies the hostname. I am able to do an import with python on the sy_occ. Zope is running as nobody/nobody. Thanks -----Original Message----- From: Chris McDonough [mailto:chrism@digicool.com] Sent: Wednesday, March 15, 2000 4:44 PM To: 'Dan Zweifel'; Chris McDonough Cc: 'zope(a)zope.org' Subject: RE: SybaseDA Dan, Please cc the Zope list while we're talking about this. What is the -H option to isql? Can you import the sybase module from python as per the build instructions? What user are you running Zope as? Does that user have permissions to the sybase client directory? -----Original Message----- From: Dan Zweifel [mailto:danz@vonhoffmann.com] Sent: Wednesday, March 15, 2000 4:01 PM To: 'chrism(a)digicool.com' Subject: RE: SybaseDA Chris, Here is what happened next....... Isql Statement isql -H frenchie -P generic -S SYBASE -U generic -I /opt/sybase-11.9.2/interfaces Works!!! Zope Connector Id sybaseconnection Title test Server frenchie User generic Password generic Datasource SYBASE Use Transactions Yes/No (tried both) Connect YES Gives the same connection string error as before.

1 0

RE: SybaseDA
by Chris McDonough 15 Mar '00

15 Mar '00

Dan, Please cc the Zope list while we're talking about this. What is the -H option to isql? Can you import the sybase module from python as per the build instructions? What user are you running Zope as? Does that user have permissions to the sybase client directory? -----Original Message----- From: Dan Zweifel [mailto:danz@vonhoffmann.com] Sent: Wednesday, March 15, 2000 4:01 PM To: 'chrism(a)digicool.com' Subject: RE: SybaseDA Chris, Here is what happened next....... Isql Statement isql -H frenchie -P generic -S SYBASE -U generic -I /opt/sybase-11.9.2/interfaces Works!!! Zope Connector Id sybaseconnection Title test Server frenchie User generic Password generic Datasource SYBASE Use Transactions Yes/No (tried both) Connect YES Gives the same connection string error as before.

1 0

RE: SybaseDA
by Dan Zweifel 15 Mar '00

15 Mar '00

Chris The -H flag in isql specifies the hostname. I am able to do an import with python on the sy_occ. Zope is running as nobody/nobody. Thanks -----Original Message----- From: Chris McDonough [mailto:chrism@digicool.com] Sent: Wednesday, March 15, 2000 4:44 PM To: 'Dan Zweifel'; Chris McDonough Cc: 'zope(a)zope.org' Subject: RE: SybaseDA Dan, Please cc the Zope list while we're talking about this. What is the -H option to isql? Can you import the sybase module from python as per the build instructions? What user are you running Zope as? Does that user have permissions to the sybase client directory? -----Original Message----- From: Dan Zweifel [mailto:danz@vonhoffmann.com] Sent: Wednesday, March 15, 2000 4:01 PM To: 'chrism(a)digicool.com' Subject: RE: SybaseDA Chris, Here is what happened next....... Isql Statement isql -H frenchie -P generic -S SYBASE -U generic -I /opt/sybase-11.9.2/interfaces Works!!! Zope Connector Id sybaseconnection Title test Server frenchie User generic Password generic Datasource SYBASE Use Transactions Yes/No (tried both) Connect YES Gives the same connection string error as before.

1 0

SQL syntax for binary fields
by Daniel.Weber＠SEMATECH.Org 15 Mar '00

15 Mar '00

Anyone know the syntax for inserting binary data into an ODBC db?

1 0

Disaster Recovery of the ZODB
by Mario Lang 15 Mar '00

15 Mar '00

Hi.. I just uploaded many files with load_site (thanks Itamar!), but I ran out of disk space while doing this. Seems as the last transaction corrupted the Database seriously. When I try to delete the folder where the errors are I get: Error Type: CorruptedDataError Error Value: The same with packing database. And when invoking Undo, i get something like: long int too long to convert Any ideas what I could do to repair my database and deelete the corrupted folders and start over again? Thanks in advance, Mario

1 0

Zope Weekly News
by Mike Pelletier 15 Mar '00

15 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 evening. Any opinions contained in the Zope Weekly News are those of the chronicler exclusively (but I'm willing to share). Announcements * The latest versions of the Zope Content Managers Guide, Z SQL Method User's Guide and DTML Reference Guides is available in postscript(ps) format. With luck, the technical problems of the previous versions have been fixed. http://www.zope.org/Members/Pam/PSversion * Check out the new Zope Documentation Projects page that lists current Zope documentation projects and their status. http://www.zope.org/Documentation/Projects/Projects * Martijn Faassen <faassen(a)vet.uu.nl> has established a Zope-XML mailing list. The intent is to discuss Zope's XML infrastructure. http://www.egroups.com/group/zope-xml/info.html New Products * Software Product: iTrack Issue Tracker Product, by "shalabh" iTrack allows a team of people to keep track of various issues about a project. Currently this is in development stage (Version 0.2.0) but usable, as long as you follow the instructions. http://www.zope.org/Members/shalabh/iTrack/ * Software Product: ZGDChart Product, by "teyc" ZGDChart uses gdchart to draw charts. This product comes with Windows binaries and source for non-Windows platforms. This initial development release is 0.3. http://www.zope.org/Members/teyc/ZGDChart * Software Product: DTMLTemplate, by "halazar" DTML Templates are documents that allow blocks of text to be named and made available to other documents. The basic building block of templates is the DTML block tag, which can also be used with other DTML document types. Templates export their blocks. Another new tag, the suppress tag, allows block definition without rendering. http://www.zope.org/Members/halazar/Products/DTMLTemplate Updates * Software Product: jcNTUserFolder, by Jephte CLAIN This product authenticates Zope users against an NT domain controller. All users are encouraged to upgrade to this version, 0.0.3. Unfortunately, the upgrade is incompatible. You will lose any role settings. http://www.zope.org/Members/jephte/jcNTUserFolder Zope.org items * How-To: The Debugger Is Your Friend, by Michel Pelletier This HowTo is an invaluable resource for those days where if I get one more mysterious traceback, just one more and I swear I'll crack. It explains how to step through Zope code line-by-line with the python debugger. http://www.zope.org/Members/michel/HowTos/TheDebuggerIsYourFriend * How-To: How to test your products without (re)starting Zope, by "teyc" This HowTo describes testing Zope products within a python interpreter without starting the Zope server. This rather speeds up the code-test-curse-code cycle, because it allows you to quickly reload your Product with each change. http://www.zope.org/Members/teyc/howtoProductTesting -- Mike Pelletier.

1 0

Zclass subclassing Image - how to manage uploads?
by Marius Kjeldahl 15 Mar '00

15 Mar '00

I've seen numerous postings about this, but so far I have been unsuccessful in successfully subclassing the Image with my own ZClass (called VProduct for this case). Here's what I have managed to do: * Create my new VProduct ZClass with Image as a base class * Add a couple of new simple (string) properties to VProduct * Modify the VProduct_add and VProduct_addForm methods so that my new properties gets asked for and filled in (and using the system clock to generate unique id's) This seem to work great, and I can move about in the Zope filesystem and add instances of my VProduct class as I want to. I have not been able to successfully integrate the file upload feature. What I have done is: * Add an input file <input type=file name=file> in the addForm method * Putting a file name in this field and pressing submit button >From here I am not quite sure what to do with the image, but from browsing earlier postings about this, it seems to have something to do with calling manage_upload one way or the other. In the VProduct_add method, I have the following special code: <dtml-call "REQUEST.set('ts', ZopeTime ())"> <dtml-call "REQUEST.set('id', _.str(_.int('ts')))"> The above code generates a unique id for my VProduct instances, and this works fine. Inside the automatically generated: <dtml-with "VProduct.createInObjectManager(REQUEST['id'], REQUEST)"> further down in the VProduct_add method I have the following stuff: <dtml-call "propertysheets.Basic.mange_editProperties (REQUEST)"> that code should take care of modifying the properties of my VProduct instance (and assumes I guess that the input field names match the property names). This seams to work great. Right before the "propertysheets..." line I have tried adding the following: <dtml-call "manage_upload(REQUEST['file'])"> It does not generate an error. But it does not seem to manage the upload part either, since my VProduct instance gets the content_type "text/plain" (instead of image/jpeg which is the right type for the jpeg file I try to upload). And when I try to "view" the VProduct instance, I get a simple <img src="91231912" alt="sometext"> tag which displays like a missing image in a web browser (no wonder since the content_type is wrong). I have tried manually setting the content_type to "image/jpeg", but the image still does not display correctly. My guess is that the image never got uploaded. Any ideas on how to handle the upload properly? I've done some 30 searches through the list archive, without any clear answers to how the image uploads are handled (or should be handled). I've looked carefully through the howto's but have not found anything. Any help would be appreciated. Marius Kjeldahl

4 6

RE: [Zope] Getting image
by Daniel.Weber＠SEMATECH.Org 15 Mar '00

15 Mar '00

I guess I'm confused. I can't get to the actual jpeg image? Here's what I'm trying to do. I want to create a form to upload data. This data can be off any type. The data is stored in an ODBC database table along with it's mime type. So, on the upload action form, I need to 1) get the mime type and 2) get the actual data. Another part of the site mails off these items as attachments. I've heard that the mime type should be uploaded along with the data, I just don't know how to get to it. > -----Original Message----- > From: Michel Pelletier [mailto:michel@digicool.com] > Sent: Wednesday, March 15, 2000 12:54 PM > To: Daniel.Weber(a)SEMATECH.Org > Cc: zope(a)zope.org > Subject: Re: [Zope] Getting image > > > Daniel.Weber(a)SEMATECH.Org wrote: > > > > I uploaded an image and want to attach it to an email > message using <dtml-mime>. > > How do I get the actual image? <dtml-var image> gives me > the <img > tag. > > "image.content_type" gives me content type properly, but I > don't know the > > property name for the actual data. > > Hmm.. unfortunatly there is no good way to do this from DTML except to > use manage_FTPget(). Yuk. This lack will be fixed in the near future > when we re-do alot of the Zope interfaces. Currently we are in the > middle of documenting all of the existing interfaces which obviously > must come first. > > -Michel >

3 2

How to determine if there are any nonempty Versions
by Daniel G. Rusch 15 Mar '00

15 Mar '00

Does anyone know how to: 1. Programitically determine if there are any versions? 2. Programitically determine if there are any nonempty Versions? Thanks, DR

1 0

RE: [Zope] Getting image
by Daniel.Weber＠SEMATECH.Org 15 Mar '00

15 Mar '00

Is there any way to get the mime type? > -----Original Message----- > From: Michel Pelletier [mailto:michel@digicool.com] > Sent: Wednesday, March 15, 2000 2:47 PM > To: Daniel.Weber(a)SEMATECH.Org > Cc: zope(a)zope.org > Subject: Re: [Zope] Getting image > > > > > Daniel.Weber(a)SEMATECH.Org wrote: > > > > I guess I'm confused. I can't get to the actual jpeg image? > > Not directly from DTML. You need to use a method on the > Image object. > manage_FTPget(). > > > Here's what I'm > > trying to do. I want to create a form to upload data. > This data can be off any > > type. The data is stored in an ODBC database table along > with it's mime type. > > So, on the upload action form, I need to 1) get the mime > type and 2) get the > > actual data. > > This is different from the first question that you asked. In > this case, > when your form uploads the file contents, ZPublisher will marshal that > into a StringIO object (which acts just like a python file > object). In > this case you can just do: > > <dtml-var "REQUEST['name_of_form_element_that_is_the_file'].read()"> > > and get the 'contents' of the file. > > > Another part of the site mails off these items as attachments. > > I've heard that the mime type should be uploaded along with > the data, I just > > don't know how to get to it. > > In this case, your taking about a Zope 'Image' object, _not_ > a standard > file object like you get when you upload data. For this you need > manage_FTPget(). > > -Michel >

1 0