- Zope - Zope lists

Currency formatting
by Menard.Jean-Francois＠hydro.qc.ca 09 Jan '01

09 Jan '01

I would like to output currency as: 1 300 459,63$ I looked at the documention, and I cannot figure how to: - Place spaces instead of commas as thousand separators. - Replace the dot by a comma for the decimals. Any clues? Jean-François Ménard Intranet DPAS Pratiques d'affaires et orientations * (514) 840-3000 poste 3939 * (514) 840-5585 * menard.jean-francois(a)hydro.qc.ca * 855 Ste-Catherine est, 6e étage Montréal, Qué. H2L 4P5

3 2

[Newbie] Can Zope ...
by Smith Ray 09 Jan '01

09 Jan '01

[Note: I assume posts can't be made using the egroups web post form? I see the note that it is a remote list, but if posts never work maybe a note specifically stating it is an archive only should be displayed?] Hi, Yesterday I saw a demo of an Intranet package a company wants the company I work for to resell. It looks like a nice little package but very expensive for the functionality available. I'm sure Zope can be setup to do everything this can do but I want to ask how difficult it would be to create myself and if any current packages exist that have the same or similar functionality. The features (or limitations) of the package I saw are: * Runs on Windows NT/2000 only. (Zope can + many others) * Uses MS IIS only (I believe Zope can use IIS + built in web server + others) * Uses MS SQL Server (I believe Zope can + built in DB + others) * Allows non technical people to create content plus add users / managers etc without any HTML knowledge or knowledge outside of the package. * Has good security system allowing users to belong to groups which "may" have different content. Also managers have profiles allowing the restriction of content and actions performed. * Has a news module with multiple classes of news. * Has a basic calendar system. * Has a basic messaging system. * Has a basic knowledge base ... allows free format text to be entered and later searched. * Allows external documents to be loaded associated with a group where keywords can be manually entered. These documents can then be opened or downloaded if users have correct permissions. * Basically all content added can be added to specific groups, and if you don't have access that that group you don't have access to that content. There are probably a few things I missed but you get the idea. The cost thrown up in the air was in the order of $AUS20,000 for a 3 year rental, per site!!!! (At the moment that is about $US35,000) When you start talking dozens of sites you quickly start looking for alternatives! My initial thought was Zope, I knew it existed and assumed with a good design and few months work a could produce similar results with a fraction of the costs. Okay, sorry for the long email ... my questions ... Are there any "Intranet" type packages which have similar functionality to what I have quickly described? If I had to build something like this myself would Zope be the tool of choice? (I'm assuming it would be since I'm on a Zope list!) How long (rough estimate) would something like this take to develop for a Zope newbie? (Assume say 10 viewable screens and 10-20 maintenance screens with 5-30 fields per screen. I have programming (Cobol, VB, etc), HTML, DB and analysis experience) Thanks for reading so far and thanks for any responses. Ray Smith

9 10

Re: [Zope] What's up with MySQL and Zope?
by paul_s_johnson＠urscorp.com 09 Jan '01

09 Jan '01

Why? I don't know, but here's what I did (still not 100% successfully so user beware). Use MySQLDA (a Zope Product) and MySQL-python (not a Zope Product, but a helper python module). The most painless way to get them installed (on Linux) is from RPMs at ftp://ftp.logicetc.com/pub/Zope/RPMS/MySQL-python-0.2.1-1.i386.rpm ftp://ftp.logicetc.com/pub/Zope/RPMS/Zope-ZMySQLDA-1.2.0-1.i386.rpm There may be some other rpm dependencies such mysql-devel and python-devel that if you don't have handy, you can find at http://www.rpmfind.net Some follow-up threads that will likely contain critical information (some reconstruction may be necessary if the following lengthy links are word-wrapped in your email reader): http://zope.nipltd.com/public/lists/zope-archive.nsf/Main/BB05A28ADA1495338… [Zope]TroublecompilingZMySQLDA http://zope.nipltd.com/public/lists/zope-archive.nsf/Main/A74B8510060DD8248… [Zope]problemconnectingtomysql Your point about this being complicated is valid. I am on day three of trying to make it work myself. The Howtos on http://www.zope.org are out-of-date. Some Zope guru out there should cook up a current Howto for us pathetic newbies (hint, hint). >What's up with MySQL and Zope? > >Now there are four different products that are related >to MySQL and Zope. Which one should I use? > >Some don't even look like DA's for zope. Why are >these listed in Zope's product page anyway? > >Why can't they all get coordinated? > >Jason

1 0

RE: [Zope] Currency formatting
by Menard.Jean-Francois＠hydro.qc.ca 09 Jan '01

09 Jan '01

Tanks! Work great! -----Message d'origine----- De : Andy McKay [mailto:andym@ActiveState.com] Envoyé : mardi 9 janvier 2001 14:31 À : Menard.Jean-Francois(a)hydro.qc.ca; zope(a)zope.org Objet : Re: [Zope] Currency formatting >From the quick hack department: 1: hack the source: DT_Var line 375... or 2: Write a bit DTML method that is along the lines of: return_money: <dtml-var value thousands_commas fmt=dollars-and-cents> then a DTML Document that has wher value is the value you want: <dtml-call "REQUEST.set('v', return_money(_.None, _, value=value))"> <dtml-call "REQUEST.set('v', _.string.replace(v, ',', ' '))"> <dtml-call "REQUEST.set('v', _.string.replace(v, '.', ','))"> <dtml-var v> 3: This could of course using PythonScript much better.... -- Andy McKay. ----- Original Message ----- From: <Menard.Jean-Francois(a)hydro.qc.ca> To: <zope(a)zope.org> Sent: Tuesday, January 09, 2001 10:41 AM Subject: [Zope] Currency formatting > I would like to output currency as: 1 300 459,63$ > I looked at the documention, and I cannot figure how to: > > - Place spaces instead of commas as thousand separators. > - Replace the dot by a comma for the decimals. > > Any clues? > > Jean-François Ménard > Intranet DPAS > Pratiques d'affaires et orientations > * (514) 840-3000 poste 3939 > * (514) 840-5585 > * menard.jean-francois(a)hydro.qc.ca > * 855 Ste-Catherine est, 6e étage > Montréal, Qué. H2L 4P5 > > > _______________________________________________ > 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 ) > _______________________________________________ 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 )

2 1

Re: [Zope-dev] RE: [Zope] ZDESIGN IDEAS = How to improve 'manage' ? ?
by Ken Manheimer 09 Jan '01

09 Jan '01

This thread should not be crossposted to both mailling lists. I posted a followup to zope-dev, please see there if you want to respond. In general, please do *not* cross-post - it's almost never justified, certainly isn't in this case. Ken Manheimer klm(a)digicool.com

1 0

RE: [Zope] MySQL connection woes
by paul_s_johnson＠urscorp.com 09 Jan '01

09 Jan '01

One other bizarre symptom: when I test the database connection with a INSERT query it works and inserts data into the designated MySQL table in the query, although there is no indication that it is working in Zope. I changed the user table for the MySQL user cited in the connection string so that all privileges are on and still no luck. P. Johnson >>For a quick test, run the mysql client from the command line. >> >>Let's say your connection string was: >> foodb paul passwd >> >>Start mysql like this: >>$ mysql -u paul -p foodb >> >>And when prompted for the password, enter passwd. >> >>This will ensure mysql is setup correctly. Make sure you do this from >>the same machine that is running Zope, as MySql can be configured for >>different access from different machines. >> >>If you want to play with "null" passwords and such, look at the >>mysql.user and mysql.db tables. Remember to run "mysqladmin >>flush-privileges" after making changes to the user and db tables. > >This last part I did not know, thanks! > >Ok, I am getting closer. I finally found a connection string that Zope >accepts, but now when I test the connection with a query like "SHOW >TABLES;" or a SELECT query it I get the message: > > "There was no data matching this Z MySQL Database Connection >(connected) query." > >- even though I know these tables exist. The connection says that it is >open and it will only accept connection strings of databases that really >exist in MySQL. >INFO: >MySQL user name: root >hostname: www.myhost.com >password: none > >Zope Connection string: mydatabase(a)www.myhost.com root > >In the grant tables there is the following entries: >In user: root(a)www.myhost.com with no privileges >In db: root(a)www.myhost.com with all privileges for mydatabase.* except for >Grant_priv > >One other parameter that may have a bearing: the box's name is >station99.ispname.net even though it hosts www.myhost.com (or is it the >other way around?). > >Any suggestions why the connection is not working properly?

1 0

What's up with MySQL and Zope?
by Jason Byron 09 Jan '01

09 Jan '01

What's up with MySQL and Zope? Now there are four different products that are related to MySQL and Zope. Which one should I use? Some don't even look like DA's for zope. Why are these listed in Zope's product page anyway? Why can't they all get coordinated? Jason __________________________________________________ Do You Yahoo!? Yahoo! Photos - Share your holiday photos online! http://photos.yahoo.com/

1 0

RE: [Zope] Creating a Database connection.
by Farrell, Troy 09 Jan '01

09 Jan '01

We need more specific information to help you. I'll give you an example: I run one zope installation on Windows NT 4.0SP6. I use PostgreSQL 7.0.3 on WindowsNT with Cygwin. 1)install Zope 2)compile PostgreSQL with ODBC support and install it 3)install ZODBCDA (Zope ODBC Database adapter) 4)install psqlodbc.dll to enable Windows ODBC to connect to Postgres through ODBC 5)add an ODBC connection to PostgreSQL through the Windows Control Panel 6)Start Zope and login as a Manager 7)Add a ZODBCDA connection through the drop-down box at the bottom. 7a)select your new-fangled ODBC connection as the connect string 8)select the test tab of your connection object to test the connection 9)create a new ZSQL method to use your connection See...Easier than a 12-step program Troy -----Original Message----- From: Spicklemire, Jerry [mailto:Jerry.Spicklemire@IFLYATA.COM] Sent: Saturday, January 06, 2001 3:49 PM To: 'darren.carney(a)RevolutionLtd.com' Cc: 'zope(a)zope.org' Subject: [Zope] Creating a Database connection. Darren wrote: > I am very new to the Zope idea. I like what Zope is trying > to do. But I am trying to set up an external SQL database > connection While it would be ideal for one set of instructions to serve every possible requirement, in reality it will be best for you to provide as much detail as you can about the specific scenario you are facing. For starters: What Operating System will Zope be hosted on? What Database "backend" do you need to connect to? Will the Database be resident on the same system as Zope? If not, what Operating System will be hosting the Database? Get back to the list with the answers, and anything else you think might help, plus what you have already tried, that hasn't worked. Later, Jerry S. _______________________________________________ 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

RE: [Zope] MySQL connection woes
by paul_s_johnson＠urscorp.com 09 Jan '01

09 Jan '01

"Randall F. To: <paul_s_johnson(a)urscorp.com> Kern" cc: <randy@spoke. Subject: RE: [Zope] MySQL connection woes net> 01/09/01 12:08 PM >For a quick test, run the mysql client from the command line. > >Let's say your connection string was: > foodb paul passwd > >Start mysql like this: >$ mysql -u paul -p foodb > >And when prompted for the password, enter passwd. > >This will ensure mysql is setup correctly. Make sure you do this from >the same machine that is running Zope, as MySql can be configured for >different access from different machines. > >If you want to play with "null" passwords and such, look at the >mysql.user and mysql.db tables. Remember to run "mysqladmin >flush-privileges" after making changes to the user and db tables. This last part I did not know, thanks! Ok, I am getting closer. I finally found a connection string that Zope accepts, but now when I test the connection with a query like "SHOW TABLES;" or a SELECT query it I get the message: "There was no data matching this Z MySQL Database Connection (connected) query." - even though I know these tables exist. The connection says that it is open and it will only accept connection strings of databases that really exist in MySQL. INFO: MySQL user name: root hostname: www.myhost.com password: none Zope Connection string: mydatabase(a)www.myhost.com root In the grant tables there is the following entries: In user: root(a)www.myhost.com with no privileges In db: root(a)www.myhost.com with all privileges for mydatabase.* except for Grant_priv One other parameter that may have a bearing: the box's name is station99.ispname.net even though it hosts www.myhost.com (or is it the other way around?). Any suggestions why the connection is not working properly?

1 0

Re: [Zope] How to set a REQUEST variable inside a PythonMethod?
by Dieter Maurer 09 Jan '01

09 Jan '01

=?iso-8859-1?Q?Juan_Carlos_Coru=F1a?= writes: > REQUEST.update({'NoRows': 4}) REQUEST.other.update({'NoRows': 4}) > REQUEST.set('NoRows', 4) This, too, should work, as Evan already said. Dieter

1 0