- Zope - Zope lists

RE: [Zope] updating excel as an odbc datasource
by Meilicke, Scott 16 Nov '01

16 Nov '01

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(a)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(a)nlada.org \---------------------------------------------------/ _______________________________________________ Zope maillist - Zope(a)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 )

2 1

Re: [Zope] first logging
by Chris Keyes 16 Nov '01

16 Nov '01

Hi Hamzatk looks like your mail got mangled my the mail client... Your having problems creating the access file under Windows? I've really not used zope much on Windows having now moved to Linux no my desktop, but I'm pretty sure it should work... Ok, there are a few posibilities 1) Python is not in your path, and therefore the python program did not run... 2) There is a problem due to the lack of some of the unix libraries under windows (but this is unlikely) 3) Something else is getting in the way? Ok, so, here goes... You'll want to be in a dos / command prompt window change to your Zope Root directory type the command if it doesn't work, copy the error messages and what you typed (all of it if possible) and post it back to the list so we can see whats happening... There are lots of windows people out there, so were sure to be able to sort this one quickly... I expect its something simple:-) Chris hamzatk(a)3dresearch.com wrote: > At 10:43 AM 11/15/01 +0000, you wrote: > > As far as I know, they are not going to be the same as any on your system, > when Zope installs for the first time (in a normal install) it creates a > username and password... Once you have logged in you _MUST_ create a new > user, log out and log in again. The default user does not allow you to do > much. > > Under SuSE there may be a default password, but I suspect that it is > generated randomly... > > The good news is that zope comes with a script that allows you to change > this 'emergency' password so that you can get in should you forget your > password. > > To do this, you need to go to your Zope directory, and run the zpasswd.py > file like this > python zpasswd.py -u"MyEmergencyUserName" -p"MyEmergencyPassword" access > > I tried it and didn't work for me on win 98. Is there another way to do it > on win platform? > > > > > > access is the name of the file that contains the emergency user. > > When you restart zope you will be able to log in with this username and > password. > > Hope that gets you up and running... > > ChrisK > > Gaetan GUYODO wrote: > > > Hi, > I'm new user of zope. > I'm under SuSe 7.2, with a zope default installation, but I don't know what > are the default loggin and password for zope access... > anyone can help me ? > thanks, > Gaetan > > > > >

1 0

dtml-sendmail error with pine (2)
by Julián Muñoz Domínguez 16 Nov '01

16 Nov '01

The dtml I have used to generate my last message is: <dtml-var standard_html_header> <dtml-sendmail mailhost="MailHost"> From: jmunoz(a)softhome.net To: jmunoz(a)julian.ea4acl.ampr.org Subject: dtml-sendmail error with pine <dtml-mime type="text/plain" encode="7bit"> Hello, this email is sent from a dtml document, with the dtml-sendmail tag. I have followed the instructions in the zope book and some examples in this mail list, but the viewing of attached file doesn't work with my pine email client !! It works well with kmail, but no with pine, so I suppose that the format of the message is not 100% correct. Attached is a pdf document. <dtml-boundary type="application/pdf" disposition="attachment" encode="base64" filename="1.pdf"><dtml-var 1.pdf></dtml-mime> </dtml-sendmail> <dtml-var standard_html_footer>

1 0

XML-RPC timeout
by Nuno Maltez 16 Nov '01

16 Nov '01

Hi, How do I define the timeout for a XML-RPC call to a Zope method? If I use the XML-RPC library to call a Zope method that never returns, or takes a *very* long time to return, it seems that the calling side will wait forever for that function to return. Is this correct? If so, how I set a timeout so that the call raises an exception instead of hanging? Thanks in advance, Nuno

1 0

Re: [Zope] grabbing external content
by Bak ＠ kedai 16 Nov '01

16 Nov '01

>Hi Stephan, > >I think this is what you're looking for: > >http://www.zope.org/Members/lstaffor/ZClientMethod or http://www.zope.org/Members/kedai/KebasData :) > >Bey! Antwan. > > > >At 14:58 16-11-01 +0000, you wrote: is there any functionality like > ><dtml-var grab="http://www.yahoo.com/weather"> > >which loads the content of www.yahoo.com/weather without installing External methods? I thought that I saw such a product some time ago. > > > > >_______________________________________________ >Zope maillist - Zope(a)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 ) >

1 0

dtml-sendmail error with pine
by jmunoz＠softhome.net 16 Nov '01

16 Nov '01

Hello, this email is sent from a dtml document, with the dtml-sendmail tag. I have followed the instructions in the zope book and some examples in this mail list, but the viewing of attached file doesn't work with my pine email client !! It works well with kmail, but no with pine, so I suppose that the format of the message is not 100% correct. Attached is a pdf document.

1 0

RE: [Zope] updating excel as an odbc datasource
by Meilicke, Scott 16 Nov '01

16 Nov '01

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 -----Original Message----- From: Alan C [mailto:alanc@tech-world.com] Sent: Friday, November 16, 2001 7:50 AM To: zope(a)zope.org Subject: RE: [Zope] updating excel as an odbc datasource Uncheck Read only on the ODBC driver. It is possible to write to Excel via ODBC, but I haven't tried it with Zope. - Alan --------------------------------------- Zope tips and tricks site http://twsite.bizland.com/zopetips.htm > -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Casey > Duncan > Sent: Friday, November 16, 2001 9:10 AM > To: Meilicke, Scott; 'zope(a)zope.org' > Subject: Re: [Zope] updating excel as an odbc datasource > > > On Thursday 15 November 2001 06:22 pm, Meilicke, Scott allegedly wrote: > > Hi all, > > > > I'm using excel as an odbc datasource, and my customer needs to > be able to > > update the excel spreadsheet. However, when zope has connected to the > > database connector, I can not open the file read/write, nor can > I replace > > the file with another. Read-only is checked on my odbc driver. > > > > Any thoughts on how to get around this? > > > > My connection string is just the name of the odbc connector - is there a > > 'read only' flag I can send it? > > > > Thanks - Scott > > I don't know that an ODBC driver could write to an excel file, > since excel > isn't really a database, at it doesn't really support SQL. I > would suggest > that you implement this differently. Here are two suggestions: > > 1. Have Zope generate a csv (Comma separated values) file from > the data. This > can be read by Excel or imported using a macro. The disadvantage > to this is > that you do not have much formatting control. > > 2. Create a separate database that Zope can write to (MySQL or > even Access). > Then hook excel to this database via ODBC. This is more complex, > but probably > will give you the most flexibility. > > hth, > /---------------------------------------------------\ > Casey Duncan, Sr. Web Developer > National Legal Aid and Defender Association > c.duncan(a)nlada.org > \---------------------------------------------------/ > > _______________________________________________ > Zope maillist - Zope(a)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(a)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 )

2 1

grabbing external content
by Stephan Goeldi 16 Nov '01

16 Nov '01

is there any functionality like <dtml-var grab="http://www.yahoo.com/weather"> which loads the content of www.yahoo.com/weather without installing External methods? I thought that I saw such a product some time ago. _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

2 1

updating excel as an odbc datasource
by Meilicke, Scott 16 Nov '01

16 Nov '01

Hi all, I'm using excel as an odbc datasource, and my customer needs to be able to update the excel spreadsheet. However, when zope has connected to the database connector, I can not open the file read/write, nor can I replace the file with another. Read-only is checked on my odbc driver. Any thoughts on how to get around this? My connection string is just the name of the odbc connector - is there a 'read only' flag I can send it? Thanks - Scott

3 2

Re: [Zope] updating excel as an odbc datasource
by David Carter-Tod 16 Nov '01

16 Nov '01

On Thursday 15 November 2001 06:22 pm, Meilicke, Scott allegedly wrote: > I'm using excel as an odbc datasource, and my customer needs to be able to > update the excel spreadsheet. However, when zope has connected to the > database connector, I can not open the file read/write, nor can I replace > the file with another. Read-only is checked on my odbc driver. > > Any thoughts on how to get around this? I suspect the problem is that you need to set read-write security permissions on the excel file (in the file system). MS Access can have this problem too. David -- David Carter-Tod <wccartd(a)wc.cc.va.us> Instructional Technologist/Distance Education Contact Wytheville Community College, 1000 E. Main St., Wytheville, VA 24382 (wk) 540-223-4784 http://www.wc.cc.va.us/ Online certificate in web site design: http://www.wc.cc.va.us/websiteDesign

1 0