[Zope] updating excel as an odbc datasource

[Meilicke, Scott]

The problem is that I can't replace the production version while zope is
running.  Even when I close the database connection, then try to erase the
file I get: 'The process cannot access the file because it is being used by
another process'

I have also tried to change the odbc source from file1.xls to file2.xls,
stop and start the database connection within zope, but zope, or the odbc
connection, just won't let go of file1.xls, and does not see the new
file2.xls.

- Scott

-----Original Message-----
From: Alan C [mailto:alanc@tech-world.com]
Sent: Friday, November 16, 2001 9:03 AM
To: zope@zope.org
Subject: RE: [Zope] updating excel as an odbc datasource


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


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