[Zope] updating excel as an odbc datasource
Alan C
alanc@tech-world.com
Fri, 16 Nov 2001 11:02:33 -0600
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 )
>