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 )