[Zope] updating excel as an odbc datasource

[Alan C]

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 )
>