October 2002 - Zope - Zope lists

RE: [Zope] Zsync errors
by Adam Getchell 22 Oct '02

22 Oct '02

Hello all, I updated my Zopedevel and Zopetest servers to Zope 2.6.0. The new Zsync error (Zsync 0.4.5) is: There was a problem with that comparison. Error: TypeError request() got an unexpected keyword argument 'verbose' Things to check: Your destination ZSyncer is where it is meant to be. The destination server is running and accessible. The user "zopeadmin" has the right to access ZSyncer. The password for "zopeadmin" is correct. Curiouser and curiouser ... --Adam -----Original Message----- From: Adam Getchell [mailto:AdamG@hrrm.ucdavis.edu] Sent: Monday, October 21, 2002 9:56 PM To: 'Andy McKay'; zope(a)zope.org Subject: RE: [Zope] Zsync errors Andy, Hmmm, I changed it back to not using port 80. If you go to http://zopetest.hr.ucdavis.edu/STAGING you get "Zope staging synchronizer" which is the comment for my Zsync defined as: ZSyncer at /STAGING Edit ZSyncer Title: Zope staging synchronizer So I'm looking right at it. Still getting (from Zopedevel): "There was a problem with that comparison. Error: ProtocolError <ProtocolError for zopetest.hr.ucdavis.edu/STAGING: 500 Internal Server Error> Things to check: Your destination ZSyncer is where it is meant to be. The destination server is running and accessible. The user "zopeadmin" has the right to access ZSyncer. The password for "zopeadmin" is correct. I know the accounts in question have access rights, as I just logged on using them. So, your comment means that when I try to sync Zopedevel --> Zopetest, which end is failing? Thanks for your help, --Adam -----Original Message----- From: Andy McKay [mailto:andy@agmweb.ca] Sent: Monday, October 21, 2002 9:18 PM To: Adam Getchell; zope(a)zope.org Subject: Re: [Zope] Zsync errors > * ProtocolError > * <ProtocolError for zopetest.hr.ucdavis.edu:80/STAGING: 500 Internal > Server Error> Are you sure you have the right url? When ZSyncer is doing the request the destination server is encountering a 500 Error on the server, not ZSyncer. -- Andy McKay www.agmweb.ca ----- Original Message ----- From: "Adam Getchell" <AdamG(a)hrrm.ucdavis.edu> To: <zope(a)zope.org> Sent: Monday, October 21, 2002 8:29 PM Subject: [Zope] Zsync errors > Hello all, > > I moved Zope from an old box to a new one. I installed Zope 2.5.1 (same as > previous version), copied all of the products in the lib/python/Products, > and copied data.fs to /var/data.fs > > There are 3 boxes: zopetest, zopedevel, and production, with ZSyncs of > DEVEL, STAGING, and PROD respectively. > > Zsyncer seems to have broken between migrations, even though parameters are > the same: > > There was a problem with that comparison. > > Error: > > * ProtocolError > * <ProtocolError for zopetest.hr.ucdavis.edu:80/STAGING: 500 Internal > Server Error> > > Things to check: > > * Your destination ZSyncer is where it is meant to be. > * The destination server is running and accessible. > * The user "zopeadmin" has the right to access ZSyncer. > * The password for "zopeadmin" is correct. > > My destination has the same old Zsync instance. Zope is running and > accessible. My account and permissions haven't changed, as they're drawn > from the same data.fs. > > Any clues? > > Thanks, > > *************************** > * Adam Getchell > AdamG(a)hrrm.ucdavis.edu > * System Architect/Programmer (530) 752-1584 > * Human Resources Information Systems http://www.hr.ucdavis.edu/ > *************************** > "Invincibility is in oneself, vulnerability in the opponent." -- Sun Tzu > > _______________________________________________ > 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

is it possible to get a file from its id?
by juan garcia 22 Oct '02

22 Oct '02

if I have done files = container.Entries.objectIds('File') instead of files = container.Entries.objectValues('File') how can I later get the file from its ID? _______________________________________________________________ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es

3 2

problem with a list of files
by juan garcia 22 Oct '02

22 Oct '02

Hi everybody, I am trying to store a list of files in context.REQUEST.SESSION. In order to achieve this I do files = container.Entries.objectValues('File') and later session=context.REQUEST.SESSION session['mylist']=files and I get the error Error Value: Attempt to store an object from a foreign database connection I suppose this is because Zope tries to store the files, and I only need to store the reference to them. Somebody knows how to do it? thank you. _______________________________________________________________ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es

2 1

Moving data from a Zope installation to another
by Lars von Wedel 22 Oct '02

22 Oct '02

Hi, I want to set up a Zope installation now and later move it to another machine. Are there any difficulties to transfer the database? What about external files, pictures, etc. ? Lars

3 2

RE: [Zope] RE: CSV (Was: Perl scripts)
by Warnes, Gregory R 22 Oct '02

22 Oct '02

> So back to the original topic: Is there any example how to use an > external Perl script and shipping some parameters to it? I just found > the statement that it is possible. I wonder if anybody tried ... I regularly use a Perl script called from Zope to do the opposite conversion: *from* xls *to* csv. Initially, I used this code in an external python script, but I've now created a Zope product called 'CSVFile' which checks the file extension and automatically converts uploaded files from xls to csv if required. Here is the appropriate code snippet: ## ## Configuration ## ## Perl Path PERL_PATH='/usr/local/bin/perl' ## Location of perl script 'xls2csv.pl' XLS2CSV_PATH = '/usr/local/zope/current/Extensions/xls2csv.pl' # ... other stuff here ... def ExcelToCSV(ExcelData=None,ExcelName='ExcelFile.xls',CSVName='CSVFile.csv'): """Translate the first worksheet of a Microsoft Excel file to CSV format by calling the perl script 'xls2csv.pl' """ if ExcelData == None: return None dirinfo = do_tmpdir() excelfile = open(ExcelName,"w") excelfile.write(ExcelData) excelfile.close() HERE = dirinfo['tmpdir'] command = "%s %s %s %s 1 2>1 > tmp.out " % (PERL_PATH, XLS2CSV_PATH, HERE + ExcelName, HERE + CSVName ) # print "Executing command '%s'" % command retval = os.system( command ) if retval==0: csvfile = open(CSVName,"r") CSVData = csvfile.read() csvfile.close() else: CSVData = None clean_tmpdir(dirinfo) return CSVData As an aside, I use double-quotes to bracket each cells contents and comma separation. With this, I haven't had any problems here with MS-Excel failing to properly convert csv files when opening them -- with any of IE, Mozilla, Netscape 4 on W2K. -Greg LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.

3 5

DCOracle2+stored procedure
by Ruslan Spivak 22 Oct '02

22 Oct '02

Hello zope users, Could you tell me, can I return array from stored procedure to python script? TIA Best regards, Ruslan mailto:alienoid@is.lg.ua

1 0

accessing sql methods from scripts
by keo 22 Oct '02

22 Oct '02

hi, i have ran into a little problem, how can i use the reslults that an sql gave me back? i have: context.sqlChkRow() this returns some data, which says <Shared.DC.ZRDB.Results.Results instance at 0x8cd875c> ... i made a list() from it .. then i got: <r instance at 8cda3d8> what type of object is z sql method returning? im new to python, i dont know what can i do with these ... how do i print out an object's members? or how do i get some dump of it? how can i find out what methods it has? thanks, k -- don't believe everything you think

2 1

import data into ZODB ??
by Webmaster Expert RH 22 Oct '02

22 Oct '02

hello you all zopists, my question might be a bit simplist but there it is : I have a contact list (1000+) in outlook. I want to import those into a Zclass. I have created a small product that is able ro handle most data. question is : how can I import all those data at once into the new Zclass say I have Name, Phone_number only in my Zclass and a comma separated text file webmaster, 0123456 newbie, 3321654 for example... any idea ?

1 0

is there a mailing list for CMF ??
by cyrille 22 Oct '02

22 Oct '02

hello, I just know list for zope, zpt, zope-perl, zope-xml. is there a mailing list for CMF ?? thanx, cyrille

2 1

Cache & filesystem directory view
by Mitja Martini 22 Oct '02

22 Oct '02

Hi, is possible to cache objects that have been hooked in via filesystem directory view using RAM Cache Manager or Accelerated HTTP Cache? Examples are Filesystem Page Templates, Filesystem Images an others. Thank you and happy Zopeing. Mitja Martini ________________________________________________________________ Keine verlorenen Lotto-Quittungen, keine vergessenen Gewinne mehr! Beim WEB.DE Lottoservice: http://tippen2.web.de/?x=13

2 3