[Zope] updating excel as an odbc datasource

[Meilicke, Scott]

I have enabled sharing on the worksheet, and I can actually modify/rename
the file while zope isn't running, but not when zope is running.  I have
also ensured odbc is read only, as well as passing the 'Read' string in the
zope connector.  Oh I think I see, perhaps the odbc driver isn't locking it
until Zope requests it?  If that is the case, then using Access as the
datasource may not work out either.  I haven't yet tried making the file
read only on the filesystem yet - that may help.

Hmmm. Perhaps I'll use the excel com object to extract the cells I need.
Using excel as a database source just isn't pleasant.  More and more I like
the idea of re writing using zope...

Scott

-----Original Message-----
From: Casey Duncan [mailto:c.duncan@nlada.org]
Sent: Friday, November 16, 2001 8:14 AM
To: Meilicke, Scott; zope@zope.org
Subject: Re: [Zope] updating excel as an odbc datasource


On Friday 16 November 2001 10:56 am, Meilicke, Scott allegedly wrote:
> I think I explained this incorrectly.
>
> I just want to display information from excel with zope.  I have no need
to
> update the excel spreadsheet from zope.  The customer needs to be able to
> update the excel spreadsheet by opening the excel file with excel,
> modifying the contents, and save the contents back to the file.  Zope
> should then see these changes and display the web page appropriately.
>
> Based on the feedback so far, I have a few options:
>
> 1. Build it all in zope - more work, but may be worth it
> 2. Since it is zope that is doing the locking, have an access db that gets
> it's info from excel, and use the access db as the datasource feeding zope
> 3. Update everything manually, as the data change about once a week
>
> I'm currently using #3, and I will be pursuing #2 today.  The advantage of
> #1 is I can reuse the functionality across more applications, all user
> maintained - the best long term solution, as I understand the
requirements.
>
> Thanks for everyone's feedback.
>
> Scott

It is not really Zope locking it, it is the ODBC driver. Perhaps there is a 
setting or a newer version that does not lock. I know in Excel it is
possible 
to set up a file so that it can be shared. Perhaps you need to do this so 
that editing can take place while Zope is reading the file.

hth,
/---------------------------------------------------\
  Casey Duncan, Sr. Web Developer
  National Legal Aid and Defender Association
  c.duncan@nlada.org
\---------------------------------------------------/

_______________________________________________
Zope maillist  -  Zope@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 )