[Zope] probably a simple answer..

[Kate Legere]

Well, we're working on porting it over from linux but at the moment that's
my only option... I just had this impression that I'd seen something whereby
I could write to the filesystem using an external method.

Kate

-----Original Message-----
From: hpinson at indepthl.com [mailto:hpinson at indepthl.com] 
Sent: Thursday, November 17, 2005 1:06 PM
To: Kate Legere; zope at zope.org
Subject: RE: [Zope] probably a simple answer..

Well, I can suggest how I might approach it, which might be different 
than what you intend... but for what it is worth...

First, run Zope on a Windows server so you can interact with an Excel 
file as an ODBC Data Source (DSN).  You could setup a Zope/ODBC 
adaptor Product like zodbc or (better) mxODBC in Zope.  Then in 
Windows control panel, setup an ODBC DSN to the Excel file, and 
create a Zope/ODBC connection in the ZMI.  Then you might be able to 
use ZSQL methods, or Python if you perfer, perhaps using SQL or the 
Windows API, to write to the Excel spreadsheet. You might have to use 
some sort of external file storage for the Excel file, i.e. I'm not 
sure how you could store the Excel file in the ZODB and still 
interact with it and expose it through Zope, though that might be 
possible. 

Like Andreas said, you can't write to a users file system directly,  
if that's what you meant.


-- 
Harlow Pinson
Indepth Learning
Email: hpinson at indepthl.com
Phone: 505 994-2135
Fax: 505 994-3603