October 2002 - Zope - Zope lists

RE: [Zope] Is Anyone Listening?? Port 8021 Isn't!
by sean.upton＠uniontrib.com 02 Oct '02

02 Oct '02

What kind of release are you running. Have you looked at your startup script? Also, make sure you have the lsof package installed on your RH72 box (this lists open file descriptors and sockets) and run 'losf | grep TCP' to see what ports are being used on your box by various applications. Sean -----Original Message----- From: beno [mailto:zope@thewebsons.com] Sent: Wednesday, October 02, 2002 11:31 AM To: zope(a)zope.org Subject: [Zope] Is Anyone Listening?? Port 8021 Isn't! Hi; How do I trouble-shoot the fact that port 8021 isn't listening on my RH72 Zope2.4.? installation? Please help. TIA, beno _______________________________________________ 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

CMF and BackTalk
by eric.n.dunn＠bankofamerica.com 02 Oct '02

02 Oct '02

Has anyone had success at integrating BackTalk into the CMF

2 1

Accessing an External Executable
by abg＠comco-inc.com 02 Oct '02

02 Oct '02

What is the best way to access and external .EXE and return a value to Zope on Win2000? Specifically, I'd like to interface with recode (http://www.iro.umontreal.ca/contrib/recode/HTML/index.html) from the ZMI. Thanks, Aaron Gillette

2 1

RE: [Zope] Database table problem
by Passin, Tom 02 Oct '02

02 Oct '02

[ Renier Leenders] > "SELECT > FROM law WHERE article_number >= x and article_number <= y". > Unfortunately not all law articles are numbered with 1, 2, 3, > etc. If they > were I could define article_number as integer. But some > articles are numbered > with 1, 2, 2a ... 13ab etc. When I define the article_number > as char and I > retrieve I get a result with an sorting order like this: > 1,10,11,11a,11b,12, > 13ab ... 2a, 20, 21,21a. I could not find a database who > supports "natural > sort". > Has someone an idea to work around this problem with Zope? > Any suggestions > would be appreciated. This can be difficult, especially if the depth of the subdivisions can be unbounded. Sometimes it is possible to use a computed column as the sort index. This is easiest when there are just numbers, no letters. If the numbers have no subdivisions, as you seem to be showing, and ther can only be a single letter after the number, I would probably try to sort using computed columns like this (using imaginary functions - look up to see what string handling functions your database supports): Select substring(article_number, 1, len(article_number)-1) as main_index, right(article_number,1) as secondary_index, article_title Order by main_index, secondary_index For a more complicated numbering system, you may still be able to do something similar using database functions. Otherwise you would have to compute the sort order with Python. With numbers like 1, 1.1, 1.1.1, 1.1.2, I like to multiply each division be a corresponding power of ten and add them up to get a single sort index. 1.2.3 would become 1*10^2 + 2*10^1 + 3 = 123 , for example. Note that this is not exactly like just removing the separaators because the trailing number might be missing (e.g., 1.2).Again, whether you can do this depends on the database. Some people like to precompute the sort order and store it in the database. I try to avoid this, but once in a while it can be useful. Cheers, Tom P

1 0

DCOracle2 and Oi9 RC2, wrong number values in select
by Dieter Fischer 02 Oct '02

02 Oct '02

Hello I'm using DCOracle2 with a Oracle9i RC2 database. I was a bit shocked when I tried to retrive some data from my db. Alle number right to the decimal point are lost! So I played a bit with the different datatypes. I stored in each column a value off 100.50. So Oracle rounded the integers to 101, which is fine. But as you can see in the following table, the other results are wrong. What works is a: SELECT TO_CHAR(column_name) from table. The funny thing is also, that storing the data with a "ZSQL Method" works fine... Column Name Column Type Zope Oracle INTEGER_ INTEGER, 101.00 101.00 NUMBER_10_1 NUMBER(10,1) 100.00 100.50 NUMBER_10_2 NUMBER(10,2) 100.00 100.50 NUMBER_10_5 NUMBER(10,5) 100.00 100.50 DECIMAL_10_0 NUMBER(10) 101.00 101.00 DECIMAL_10_1 NUMBER(10,1) 100.00 100.50 DECIMAL_10_2 NUMBER(10,2) 100.00 100.50 DECIMAL_10_5 NUMBER(10,5) 100.00 100.50 REAL_ FLOAT(63) 100.00 100.50 SMALLINT_ INTEGER 101.00 101.00 FLOAT_ FLOAT(10) 100.00 100.50 Any ideas about that behavior? Regards Dieter

2 1

Object-Security, multiple change
by Dieter Fischer 02 Oct '02

02 Oct '02

Hello I often have to change the security for a buch of objects. Does anybody know a method (or a product), how I can change the security for more then one object? Thanks Dieter

1 0

(Fwd) RE: [Zope] MySQL Database not working well with Zope
by Egon Frerich 02 Oct '02

02 Oct '02

------- Weitergeleitete Nachricht / Forwarded message ------- Von: Egon Frerich <e.frerich(a)nord-com.net> An: zope(a)zope.org Betreff: RE: [Zope] MySQL Database not working well with Zope Durchschläge an: "Stephen Fung" <ricepail(a)yahoo.com>;"Joseph Griffin" <jgriffin(a)pclnet.net> Datum: Wed, 2 Oct 2002 14:12:10 +0200 Please lookup the archive under "win32 mysql database adapter" (18 Jun 2002 05:49:21 -0600; Day Irmiter). There is the link http://www.zope.org/Members/isalsberg/MySQLDA/BuildMySQLDA.zip where you can get _mysql.dll so you don't need to compile _mysql.c. E. Frerich PS: cl is the linker ----------------------------------------- From: "Joseph Griffin" <jgriffin(a)pclnet.net> To: "Stephen Fung" <ricepail(a)yahoo.com> Cc: <zope(a)zope.org> Subject: RE: [Zope] MySQL Database not working well with Zope Date: Tue, 1 Oct 2002 21:14:14 -0500 Stephen, 1) Go to http://www.zope.org/Members/adustman/Products/ZMySQLDA and download load version 2.0.8 2) Go to http://www.zope.org/Members/adustman/Products/MySQLdb and download version 0.9.0 3) You have to compile the _mysql.c with MSVC or Bloodshed's C++ compiler (free). The instructions for doing this are in readme. Examine the setup.py and you will find that it will look for the mysql libs in the default installation path. You may have to change it to the correct location on your harddrive. Good Luck, Joseph ------- Ende der weitergeleiteten Nachricht / End of forwarded message -------

1 0

RE: [Zope] MySQL Database not working well with Zope
by Dennis Allison 02 Oct '02

02 Oct '02

> From: Stephen Fung <ricepail(a)yahoo.com> > > I've tried to install ZMySQLDA before, but I've gotten > stuck every time. I've installed the newest version > of Python on my computer, and have tried to follow the > given directions, but, as I run windowsXP, there isn't > a whole lot of instructions for windows users. I > can't the the ZMySQLDA to work at all, and I get the > same "No Module Named _myql" error whenever I start > Zope. Can somebody please guide me through the > install process in WindowsXP? > I've not tried an installations on Windows, but I suspect that the following Linux cautions apply-- First, be sure you have the right version of Python. With Zope 2.5.1 you need Python 2.1.3. Later versions won't work. You need to install two products not one. I use MySQL-python-0.9.1 and ZMySQLDA-2.0.8. One is the python interface to MySQL and the other is the database adaptor for Zope. Be sure you install both using the version of Python you are using to run Zope--otherwise the wrong libraries are updated.

4 3

Dealing with non-ASCII strings?
by Jean Jordaan 02 Oct '02

02 Oct '02

Hi there In the data that we have to work with, there are names in French, Turkish, German, Greek, etc. A sample string, when printed from Python, is: 'Rabia-r\xddza Bi\xe7en \xf6grenci Yurdu.G\xf6r\xfckle' We'd like to store this data in LDAP and in Zope. Questions: - How do we find out what the current encoding of the strings are? Guess? - Say we decide it's Latin-7. How do we convert from the current string to Unicode, taking into account the fact that the source is taken to be Latin-7? - Do we need to move to Zope 2.6 in order to cope with such strings? -- Jean Jordaan Upfront Systems http://www.upfrontsystems.co.za

5 5

EDI and Zope.
by Felipe E. Barousse Boué 02 Oct '02

02 Oct '02

Hi: We just got into a situation where we need to receive EDIFACT EDI formatted data into a to be deployed system. The idea is to get that EDI data, convert it to XML and then handle everything else needed in XML within Zope. Later on, the reverse process will need to be done: Zope-XML -> EDI -> Remote 3rd party system. The question is, has any of you has had any experience working with EDI and Zope (or Python for that matter). ? Are there any public domain modules, code or components, besides the obvious XML related Zope products that could be of use in this proyect.? Any suggestions, comments and ideas are more than welcome. Thanks in advance and Best regards. Felipe Barousse Bufete Consultor de Mexico - Piensa Technologies www.piensa.com

1 0