- Zope - Zope lists

LoginManager newbie question
by Ludwig Weiss 21 Mar '01

21 Mar '01

Hi there, i got the loginmanager to run, but i would like to have a small login dialog on the frontpage, wich should consult the LoginManager to process the request. I cannot trigger the login process from outside the Manager. /folderX index_html (with login form) acl_users any ideas??? thanks in advance Ludwig

1 0

Zope 2.3.0 python products and inheritance problem
by Petr Knapek 21 Mar '01

21 Mar '01

Hi Zopists, I have developed some python products for Zope (2.1.6) and now I try to upgrade them for Zope 2.3.0 but some problems with inheritance have appeared. I have 2 python products, lets say A and B(A) which inherits from A. Product A has a method MA(REQUEST) and product B(A) has a dtml template TB. In the template TB I call MA as this: <dtml-var "MA(REQUEST)">. When I was running it under Zope2.1.6 everything was OK but now under Zope 2.3.0 when TB is rendered the Zope error is raised: Zope Error Zope has encountered an error while publishing this resource. Error Type: NameError Error Value: showParentPathISNG Troubleshooting Suggestions This resource may be trying to reference a nonexistent object or variable showParentPathISNG. The URL may be incorrect. The parameters passed to this resource may be incorrect. A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page. If the error persists please contact the site maintainer. Thank you for your patience. Traceback (innermost last): File /usr/local/Zope-2.3.0-src/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/Zope-2.3.0-src/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/Zope-2.3.0-src/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook File /usr/local/Zope-2.3.0-src/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/Zope-2.3.0-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: addDocument) File /usr/local/Zope-2.3.0-src/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: addDocument) File /usr/local/Zope-2.3.0-src/lib/python/App/special_dtml.py, line 127, in __call__ (Object: addDocument) File /usr/local/Zope-2.3.0-src/lib/python/DocumentTemplate/DT_String.py, line 538, in __call__ (Object: addDocument) File /usr/local/Zope-2.3.0-src/lib/python/DocumentTemplate/DT_Util.py, line 334, in eval (Object: showParentPathISNG(REQUEST, start=2, stop=-2)) (Info: REQUEST) File <string>, line 0, in ? NameError: (see above) What has changed with inheritance mechanism in Zope 2.3.0 in comparison with Zope 2.1.6. Can anybody tell me more how to solve my problem? Petr PS Shane, now my manage_tabs works fine. Thank you for help. -- Petr Knápek NEXTRA Czech Republic, s.r.o., Hlinky 114, 603 00 Brno, Czech Republic e-mail: mailto:petr.knapek@nextra.cz tel:+420-5-43 554 150 FAX:+420-5-43 554 214

1 0

SiteSummary
by Muhammad Jahanzeb 21 Mar '01

21 Mar '01

To all Respected readers, This mail is to query about a very useful product, namely SiteSummary. Its gets untar into a file 'SiteSumaary ' without the 'Zexp' extension. The Installation instructions says that you have to import the file in Zope. Zope gives an error that it has an invalid export header. I have tried to rename the file with the zexp extension but the error has remained the same. I have already been using the feedback form on the sitesummary page, but havent received any replies. If anybody can help me on this issue, I would be very grateful. -Thanks.

4 3

Rendering DTML from PythonScript
by Joel Burton 21 Mar '01

21 Mar '01

I have a PythonScript that uses traversal_subpath to suck in the rest of the path, and then calls a standard DTML document to render it, with the subpath being handed off in the namespace. The script just has """Call the faculty page for this faculty member""" context.facsearch(facid = traverse_subpath[0]) However, the called DTML itself calls things like standard_html_header, which throw up errors. How can I call a DTML method from a PythonScript while passing in the right context? (I've tried combinations of context, context.REQUEST, etc. I just can't seem to guess the right one!) Thanks! -- Joel Burton <jburton(a)scw.org> Director of Information Systems, Support Center of Washington

2 2

search in ZCalatog
by Francois-regis Chalaoux 21 Mar '01

21 Mar '01

Hi, How to find in a ZCatalog a string as "e.c.3.2.1" ? It seems that '.' give some problems. FRC

1 0

coping database tables
by Spicklemire, Jerry 21 Mar '01

21 Mar '01

Jacintha asked: > Kindly let me know how to copy database tables from on Unix server to > the other. We are using the same postgreSQL database on both the servers Since you are copying between two instances of the same RDBMS, you will find it most effective to treat this as a non-Zope process. The specific steps involved can be found in the documentation for PostgreSQL and operating system. However, it is also possible to perform the same operation using Zope as a form of middle-ware, that can interact directly with both RDBMS instances. In some cases this could be quite handy, though sub-optimal, in terms of efficiency. Most folks would perform a native export and import at both ends. At any rate, since it is possible to do this with Zope, and you seem to prefer this approach, here's the basic idea. Create ZSQL methods to extract all the data from each original table, and name them "sql_dump_table_name". They will look something like : select * from table_name Using the "advanced" tab set a cache value for this process somewhat higher than the default (0), so that the process is at least a little more efficient. A setting of 300 is equal to 5 minutes. Next, create corresponding methods to insert each record into the new, identical tables where you need to replicate the data, and name them "sql_stuff_tablename". They will look something like this: insert into table_name (field_name1, field_name_2) data (<dtml-sqlvar name_1 type=nb>, <dtml-sqlvar var_name2 optional>) In the "arguments" box you will need to list all the "var_names". Of course this example should be adapted to represent the actual number of fields, and their names, and data types, whether the field can be "blank" (optional). See the ZSQL docs for details. The names are arbitrary, but it helps in the example to keep things clear by identifying each piece. You can execute this admittedly inefficient process like so: <dtml-if sql_pg_dump_table_name> <dtml-in sql_pg_dump_table_name> <dtml-let var_name_1="_['field_name_1']" var_name_2="_['field_name_2']"> <dtml-call sql_pg_stuff_tablename> </dtml-let> </dtml-in> Process complete! </dtml-if> Hopefully your tables are small (not many records), but even if they are, this process may time-out, depending on your browser settings. If your browser displays a "page could not be displayed" message, the process could very well still be running, even though the browser has "given up" and stopped waiting for the display data. You'll need to look at the target database to see how things have progressed. With a little more work you could create lists of table/fieldnames, and set up a process that will extract - insert your entire database, without hard-coding each ZSQL method. The inefficiencies would be, compounded, but it could still be a convenient way to replicate data between two unrelated RDBMS systems, with little prior knowledge of either. This basic concept could also be used to create a Web based GUI for ad hoc data management, for mapping an existing Gadfly dataset onto an unknown target during a Zope based application installation. Good luck! Jerry S.

1 0

Re:Sendmail Error.It works for me.
by karthick ramanarayanan 21 Mar '01

21 Mar '01

Hi, I have used dtml-sendmail with multiple To: addresses,fetched from the database without any problems. After you fetch the email Object list from the data Base, convert the object List into a list of strings and join the list with commas.Then use the dtml-sendmail tag to send the mail. You can do this,assuming your sql_query returns a list of Emails. Assuming that your query is called sql_get_emails,and it contains a field called email,do this, <dtml-call "REQUEST.set('mylist',[])"> <dtml-in sql_get_emails> <dtml-call "mylist.append(email)"> </dtml-in> <dtml-let mailString="_.string.join(mylist,',')" > Now use this mailString to send the mail. I do this,after fetching mailString, <dtml-sendmail smtphost="mail.pepco.no"> To: <dtml-var mailString> From: <dtml-var from> Subject: <dtml-var subject> <dtml-var body> </dtml-sendmail> </dtml-let> I hope that you dont get frustrated after this. Bye, A.R.K

3 2

Sendmail part 2: Now I get a space seperator error
by Steve Smith 21 Mar '01

21 Mar '01

Sorry to be a pain but... I changed my dtml by hard coding the "To:" list, now I get this error: SMTPDataError Error Value 501, space seperator provided without argument Here is a simplified version of the dtml I'm using: <dtml-sendmail mailhost="MailHost"> to: ssmith6(a)bigpond.net.au from: ozrail(a)bigpond.net.au subject: OzRailfan report <dtml-in dbGetRumourByID> Original report submitted by <dtml-var "pyStrip(fullname)"> at <dtml-var submissiondatetime>: <dtml-var description> </dtml-in> Follow up submitted by <dtml-var "pyStrip(fullname)"> at <dtml-var submissiondatetime>: <dtml-var description> </dtml-in> </dtml-sendmail>

2 5

Re: coping database tables
by Phil Harris 21 Mar '01

21 Mar '01

Jacintha, I would appreciate it if you didn't send me private mail unless I ask you to, thanks. The problem is that your question is not about Zope it's about PostgreSQL. The tables you're moving are held in PostgreSQL. You have already done the Zope bit, you say you have imported the 'folder which implemented the tool'. Again, there are more relevant places to ask these questions. hth Phil ----- Original Message ----- From: "jacintha menezes" <jacintha.menezes(a)wipro.com> To: "Phil Harris" <phil.harris(a)zope.co.uk> Sent: Wednesday, March 21, 2001 11:51 AM Subject: coping database tables > hi, > See, except the question for "music" all questions i asked are about > zope. when i ask any question you don't think it is for unless i mention > zope.todays question is also > about zope. > again i state my question: > > i am using zope with the external database postgreSQL instead of > Gadfly. This zope is under linux platform. My whole tool is ready so now i > want to > port that tool to another linux server. i succeeded in importing the > folder > which contained the implemented tool. But i am not able to copy tables to > the new server. So i want help in coping tables. > > > hope i am clear > thanks, > jacintha.

1 0

coping database tables
by jacintha menezes 21 Mar '01

21 Mar '01

Hi, Kindly let me know how to copy database tables from on Unix server to the other. We are using the same postgreSQL database on both the servers.When we gave pg_dump command it gave permission denied. Thanks, jacintha

3 4