- Zope - Zope lists

Sending results of query to Excel
by Richard Moon 11 Apr '00

11 Apr '00

I'm writing a data-mining application and I'd like to use Zope as a front end. Using Zope the user can query tables and see the data presented on-screen. Is there any way to pass that output to an Excel spreadsheet ? I feel I should be able to write an external method to do it so I'd be interested to know if anyone else has already solved the problem. Thanks in advance Richard

2 1

Re: [Zope] Sending results of query to Excel
by Anthony Baxter 11 Apr '00

11 Apr '00

You could generate data in comma seperated format (.csv) and set the RESPONSE['content-type'] to something that Excel claims as it's own (application/vnd.microsoft.excel, maybe? dunno) probably just making the page be called something like 'excel_results.csv' would do the trick (must... not... rant... about... windows... crap... mime support...) Anthony >>> Richard Moon wrote > I'm writing a data-mining application and I'd like to use Zope as a front end . Using Zope the user can query tables and see the data presented on-screen. Is there any way to pass that output to an Excel spreadsheet ? > > I feel I should be able to write an external method to do it so I'd be intere sted to know if anyone else has already solved the problem. > > Thanks in advance > > Richard > > > > > _______________________________________________ > 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 ) -- Anthony Baxter <anthony(a)interlink.com.au> It's never too late to have a happy childhood.

1 0

SiteAccess 1.0.1 still breaks FTP :(
by Chris Withers 11 Apr '00

11 Apr '00

Well, sadly, this is still true: If I set a folder's access rule to be the following (although I'm guessing what the access rule is doesn't matter): <dtml-in virtual_hosts> <dtml-if "_.string.lower(REQUEST.environ['HTTP_HOST'])==_.string.lower(_['sequence-item'])"> <dtml-call "REQUEST.setURL(path='/')"> </dtml-if> </dtml-in> And then try to browse the folder through FTP I get the familiar: 550 No such directory Apart from that, I have a couple of questions: 1. Is SiteAccess 1.0.1 designed for Zope 2.1.4, 2.1.6 or both? 2. How are DC's plans to fold SiteAccess functionality into Zope coming along? cheers for the product, sorry to be the bearer of bad news again... Chris PS: The above was done on: Zope 2.1.4 Linux SiteAccess 1.0.1

1 0

Re: [Zope] string or list?
by Siggy Brentrup 11 Apr '00

11 Apr '00

Curtis Maloney <curtis(a)umd.com.au> writes: > Greetings, > > I'm having a small problem (duh! :) > > In my page, a person might select a number of items from a list. The > list is generated from an SQL query, and has unique IDs for each row. Fine. > Simple, right? > > Sure... And each row has a radiobutton input called 'done'. When the > user hits submit, if they've pressed any of the radiobuttons i will get either > a 'done' string (one selected) or a 'done' list (multiple selected). > Problem is.. how do i tell which? Is it possible with DTML, as i try > to avoid using external methods for something so trivial. Here's a code snippet I use: <dtml-comment> oids - If only one entry is checked, this is a string containing the value attribute, otherwise it's a list of value strings arrgs - ARRGS! rowids - List of value strings to work with </dtml-comment> <dtml-let arrgs="REQUEST.get('oids',[])" rowids="[]"> <dtml-try> <dtml-call "rowids.extend(arrgs)"> <dtml-except TypeError> <dtml-call "rowids.append(arrgs)"> </dtml-try> [...] </dtml-let> The code relies on the fact that Python's LIST.extend() method requires a list argument. HTH Siggy -- Siggy Brentrup - bsb(a)winnegan.de - http://www.winnegan.de/ bsb(a)north.de - http://www.north.de/~bsb/ ****** ceterum censeo javascriptum esse restrictam *******

1 0

Local File System bug fix: v0.9.3
by Jonothan Farr 11 Apr '00

11 Apr '00

http://www.zope.org/Members/jfarr/Products/LocalFS This mainly fixes problems with the tree view. OK, so I slipped in a user-requested 'feature' there at the end. I'm just excited that people are actually starting to create their own custom views. - Fixed a bug in __getitem__ that broke the mapping protocol, i.e. localfs['subobject']. - Fixed a problem with tree tag items from separate localfs instances affecting each other's state. - Prevented exceptions in localfs tree rendering from crashing the management interface. - Added 'Display in Tree View' option to disable displaying LocalFS objects in the management tree. - Added LocalFile properties display_size and display_mtime which return formatted properties. The size and mtime attributes now return an integer and a DateTime object, respectively. This should make the LocalFile object more useful for creating custom directory views. --jfarr

1 0

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

11 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 seminar. All the methods to consult these seminars work but all the method to upgrade, create, delete return 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.6 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 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 ######################## 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>

1 0

about the properties
by rapha�l zamochnikoff 11 Apr '00

11 Apr '00

well... hello i would like to understand the relationship between a "addForm" dtml method and the propertis of a class. i mean, if i have a form that demands a title for a new instance of a class, does the value of the title entered by the user via the form is stored in a property "title" or is this value stored somewhere else in the database ? - and so where ? thanks in advance for helping a novice. rz ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

1 0

Re: Partial success - mod_pcgi2.c modified
by Oleg Broytmann 11 Apr '00

11 Apr '00

Message two: On Mon, 10 Apr 2000, Bill Mair wrote: > Hi Oleg, > > in mod_pcgi2.c I changed line 474 > from: > const char *path_info = ap_table_get(req->subprocess_env, > "PATH_INFO"); > to: > const char *path_info = ap_table_get(req->subprocess_env, > "REQUEST_URI"); > > and it now works (well almost) with a <Location /> tag. > > The well almost is related to /manage, it seems to go into some sort of > loop.. Oh well. > > At least it's a start. > > Bill. Oleg. ---- Oleg Broytmann http://members.xoom.com/phd2.1/ phd2(a)earthling.net Programmers don't die, they just GOSUB without RETURN.

1 0

Re: mod_pcgi2
by Oleg Broytmann 11 Apr '00

11 Apr '00

Hello! Two messages from a user, that probably will help me to debug the module and the problem with locations. Thanks, Bill! Message one: On Mon, 10 Apr 2000, Bill Mair wrote: > Hi Oleg, > > you don't know me but I would like to share some debugging info that I > have preened from apache and your wonderful mod_pcgi2. > > What I am trying to do is set up a virtual host on apache, using Zope as > the content handler: > > <VirtualHost 193.197.0.45> > ServerName www.linux-thinkpad.org > [SNIP] > > <Location /> > SetHandler pcgi-handler > PCGI_ROOT / > PCGI_SetEnv SiteRootPATH / > </Location> > </VirtualHost> > > I know that your documentation says that it won't work, but what I did > find out was the following: > > 1) If a file matching the definition DirectoryIndex in httpd.conf exists > the VirtualHost DocumentRoot then > that file is passed to pcgi2 for interpretation. > > 2) If there is no DocumentRoot for the VirtualHost then apache looks for > the matching file in what I believe > is the default DocumentRoot (normally something like index.html). > > 3) The result of 1) or 2) is then passed to pcgi2 for evaluation. But if > 1) and 2) deliver nothing then the > directory contents of the DocumentRoot are listed. > > For fun I added PCGI2 to the DirectoryIndex and defined a DocumentRoot > for the VirtualHost and > did "touch PCGI2" in it's DocumentRoot. > > And guess what, mod_pcgi2 got a request for the uri /PCGI2. > > I don't know if this helps, but I hope you can find a solution for the > <Location /> problem based on > what I have found out. > > Please let me know what you think. > > Bill. > Oleg. ---- Oleg Broytmann http://members.xoom.com/phd2.1/ phd2(a)earthling.net Programmers don't die, they just GOSUB without RETURN.

1 0

Re: [Zope-Moz] xml-rpc problem
by Shalabh Chaturvedi 11 Apr '00

11 Apr '00

This is not specific to zope-mozilla so copying to the zope list. Please continue this thread only on the zope list. Amos' article on xml.com about xml-rpc with Zope is an excellent introduction for beginners: http://www.xml.com/pub/2000/01/xmlrpc/index.html About your problem: sorry I don't know what's going wrong there. I urge you to try the examples in the above article. HTH, Shalabh Qingjuan Guan wrote: > Hi all, > I am a starter for the Zope stuff. Right now I am trying to figure out how > the xml-rpc work here is the example I have tried but doesn't seem quite get > it, could somebody tell me what I did wrong with this? > > import xmlrpclib > > def getStateName(self): > "Returns a state name given an integer state number" > server_url="http://betty.userland.com" > server=xmlrpclib.Server(server_url) > return server.example.getStateName(41) > > I know the return value from the server should be good. The error message > from python seems point the finger to the parse_response function in > xmlrpclib.py. I am not quite familiar with python, could somebody point out > what causing the problem here? Or, if I want some more info about this > xml-rpc stuff, where can I found more examples? > > Thanks.

1 0