RE: [Zope] updating excel as an odbc datasource
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 )
Since you said that this will be updated periodically, you might consider having a production version and an updateable version of the xls. When the updates are made, copy it to the production folder. This should eliminate the locking contention. Not a good solution for constantly updated databases, but good for periodic things. - Alan --------------------------------------- Zope tips and tricks site http://twsite.bizland.com/zopetips.htm
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Meilicke, Scott Sent: Friday, November 16, 2001 10:21 AM To: zope@zope.org Subject: RE: [Zope] updating excel as an odbc datasource
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 )
_______________________________________________ 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 )
participants (2)
-
Alan C -
Meilicke, Scott