- Zope - Zope lists

MS-SQL Server Connector
by Spicklemire, Jerry 21 Jan '01

21 Jan '01

Adrian asked: > Is there a database connector or similar for MS-SQL Server that > might run on non-windows Zopes? Check out http://www.zope.org/Members/TheJester/SybaseDA , and please let the list know how it goes. We all need to help each other with these little puzzles. Good luck, Jerry S.

1 0

RE: Workflow and document management system in Zope
by Spicklemire, Jerry 21 Jan '01

21 Jan '01

Hi Nicolas, Your last post mentioned: > I am looking for a workflow (WF) linked to a electronic document > management (EDM) system and a groupware email based In addition to other links, you might want to check out ZopeGUM, and ZUBBS, http://www.zope.org/Members/morphex/ZopeGUM http://www.zope.org/Members/morphex/ZopeGUM/Info http://www.zope.org/Members/BwanaZulia/ZUBB http://www.zope.org/Members/BwanaZulia/ZUBB/README These may provide some of the groupware & email pieces you are looking for. BTW, you may want to consider contacting some of the consultants listed on the Zope Solution Providers page. http://www.zope.org/Resources/ZSP I'm sure the Digital Creations folks won't object to me mentioning that in addition to being the sponsors, hosts, and creators of Zope, they also do consulting, including projects involving integrated workflow, such as the PTK. http://www.digicool.com http://www.digicool.com/Company/ Later, Jerry S.

1 0

Zope 2.3
by Tom Deprez 21 Jan '01

21 Jan '01

To all who feels him/herself addressed : Congrats to the new look of zope! And to the new implemented products! All I can say is ... keep up the good work! Regards, Tom.

1 0

Creating PDF's
by Tom Deprez 21 Jan '01

21 Jan '01

Hi, I read in Itamar's 'A Developers Guide to learning Zope' about 'Reportlab'. It is a python library to create pdf files. Is there somebody among here who already used this library with zope? And is it possible to give a little example in how we can use it with zope? Thanks in advance, Tom.

4 4

ZSQL: postgres, SELECT INTO
by Steve Drees 21 Jan '01

21 Jan '01

Has anybody selectively used SELECT INTO with zope/postgres? Zope version: Zope 2.1.6 (binary release, python 1.5.2, linux2-x86) Python version: 1.5.2 (#10, Dec 6 1999, 12:16:27) [GCC 2.7.2.3] System Platform: linux2 ZPyGreSQLDA-0-0-3 I'm trying something like: SELECT DISTINCT song, ipadress, date INTO TEMP d_requests FROM requests WHERE date > <dtml-sqlvar startdate type="string"> <dtml-var sql_delimiter> SELECT COUNT(*) AS num_requests, song FROM d_requests GROUP BY song --------- works fine under psql zope raises an exceptions.ValueError and the db connection dies. traceback follows:

2 2

Zope, emacs & secure ftp
by Geoffrey L. Wright 21 Jan '01

21 Jan '01

Was just wondering what sort of solution people use for secure ftp and zope. I'd like to be able to use efs (or ange-ftp) over a secure connection to zope so I can do development using efs outside of our firewall. Does Zope's ftp server support SSL? Or is there some sort of SSH-based solution? Just curious... //glw

1 0

RE: [Zope] if-else using ZSQL resultset & sendmail query
by Randall F. Kern 20 Jan '01

20 Jan '01

<dtml-in ...> <dtml-if sequence-even> bgcolor is white ... <dtml-else> bgcolor is grey ... </dtml-if> </dtml-in> If you really need the "resultset number", you can use sequence-number. As for <dtml-sendmail> and news, it only sends mail via SMTP, so it can't be used to post news. -Randy -----Original Message----- From: Lee [mailto:lee.reilly@ntlworld.com] Sent: Saturday, January 20, 2001 1:48 PM To: zope(a)zope.org Subject: [Zope] if-else using ZSQL resultset & sendmail query Hi, I've got a few questions, which may be answered by saying, "Not possible"! Any feedback would be appreciated. get_testclass_details is a ZSQL method returning user data from a table. I display the data (strangely enough) in an HTML table and I want alternating rows to have different background colours. I figure that the best way to do this is to obtain the resultset number (i.e. is it the 1st, 2nd or 3rd result row) and do something like the following; <dtml-in...> if (the result set number % 2 == 0) bgcolour is white ... else bgcolour is grey ... </dtml-in...> Is it possible to obtain the resultset number? Also, re: sendmail. I still haven't managed to figure out why it's not posting messages to newsgroups. Maybe some folks at digicool could let me know if this isn't supported? Previous message was: I have another question re: sendmail, which I'd be grateful if someone could answer. Am I correct in saying that <sendmail> does not support newsgroup postings? Adding the following to my message seems to work but it is not being posted on the newsgroup... To: lreilly(a)cs.strath.ac.uk Groups: uk.local.glasgow *and* Newsroups: uk.local.glasgow It sends the mail to me; the group is listed in the header file under 'Newsgroups' when I view *my* received message but it is not getting to the newsgroup. Can anyone comment? Thanks very much for your time, - Best regards, Lee _______________________________________________ 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

if-else using ZSQL resultset & sendmail query
by Lee 20 Jan '01

20 Jan '01

Hi, I've got a few questions, which may be answered by saying, "Not possible"! Any feedback would be appreciated. get_testclass_details is a ZSQL method returning user data from a table. I display the data (strangely enough) in an HTML table and I want alternating rows to have different background colours. I figure that the best way to do this is to obtain the resultset number (i.e. is it the 1st, 2nd or 3rd result row) and do something like the following; <dtml-in...> if (the result set number % 2 == 0) bgcolour is white ... else bgcolour is grey ... </dtml-in...> Is it possible to obtain the resultset number? Also, re: sendmail. I still haven't managed to figure out why it's not posting messages to newsgroups. Maybe some folks at digicool could let me know if this isn't supported? Previous message was: I have another question re: sendmail, which I'd be grateful if someone could answer. Am I correct in saying that <sendmail> does not support newsgroup postings? Adding the following to my message seems to work but it is not being posted on the newsgroup... To: lreilly(a)cs.strath.ac.uk Groups: uk.local.glasgow *and* Newsroups: uk.local.glasgow It sends the mail to me; the group is listed in the header file under 'Newsgroups' when I view *my* received message but it is not getting to the newsgroup. Can anyone comment? Thanks very much for your time, - Best regards, Lee

1 0

Zope 2.3.0b2 bug
by Oleg Broytmann 20 Jan '01

20 Jan '01

Hi! Little bug - if there is no items in a folder - there is no "Import/Export" button. :) I have to create a dummy item to import a zexp. Oleg. ---- Oleg Broytmann http://www.zope.org/Members/phd/ phd(a)phd.pp.ru Programmers don't die, they just GOSUB without RETURN.

2 2

Re: [Zope] Creating PDF's
by Oliver Bleutgen 20 Jan '01

20 Jan '01

> Hi, > I read in Itamar's 'A Developers Guide to learning Zope' about > 'Reportlab'. > It is a python library to create pdf files. Is there somebody among here > who > already used this library with zope? And is it possible to give a little > example in how we can use it with zope? Tom, I can't give a working example, it's on a server at work, but integrating zope and reportlab is easy. I tried it because I needed a proof of concept and did did nothing advanced, but I got zope to return a pdf which was always created on the fly. If your interested I'll post/send that small example. Take a look at http://www.zope.org/Members/jdavid/TimetableTag/ for a product which utilizes reportlab or search the reportlab mailing list for zope http://www.egroups.com/messagesearch/reportlab-users?query=zope cheers, oliver

1 0