- Zope - Zope lists

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

Re: coping database tables
by Tim Cook 21 Mar '01

21 Mar '01

jacintha menezes wrote: > > Hi, > See, 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. > sorry for the inconvenience. > > thanks, > jacintha Try: http://looking-glass.usask.ca:82/ -- Tim Cook, President - FreePM,Inc. http://www.FreePM.com Office: (901) 884-4126 ONLINE DEMO: http://www.freepm.org:8080/FreePM

1 0

RE: [Zope] how to start zope server in boot up
by Andy Gimblett 21 Mar '01

21 Mar '01

> hi, > I am using Linux RedHat 6.2. > I want zope server to be run while boot up. Quick answer: Add a line similar to the following to the end of /etc/rc.d/rc.local: /usr/local/zope/start & This will take care of starting it up automatically. Longer answer: If you want to do it "properly", with init.d scipts, etc. (so it also shuts down automatically on system shutdown, for instance), this howto: http://www.zope.org/Members/jec/startstop_howto_html is very useful in this respect. It describes a scheme to allow you to start and stop multiple instances of Zope. Part of this scheme is a good, working, set of scripts to manage startup & shutdown. If you want to have just one instance, just make sure the "instances" file (described in the howto) has a single entry, and that the "instance_name" for that entry is just "." (ie a single dot). This is what I've done, and it seems to work fine. Good luck! -Andy -- Andy Gimblett <andy.gimblett(a)ftech.net> Programmer Frontier Internet Services Limited <www.frontier-internet.ltd.uk> Tel: 029 20 820 044 Fax: 029 20 820 035 Statements made are at all times subject to Frontier's Terms and Conditions of Business, which are available upon request.

1 0