RE: [Zope] Importing exchange rates
It is also possible to set up an ODBC connection to Excel. Depending on your background, this might be simpler to set up. See the Excel help for the fine details. (No VB programming at all :-). > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jim > Sanford > Sent: 18 July 2000 16:21 > To: Gidon Friedman; [EMAIL PROTECTED] > Subject: Re: [Zope] Importing exchange rates > > > you can use COM to access the excel file. > > - Original Message - > From: Gidon Friedman <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, July 18, 2000 7:16 AM > Subject: Re: [Zope] Importing exchange rates > > > hi > > i have a similar problem, i have to import live date (prices) > from an excel application. i think they have a vb > application that exchanges the data with other applications > (i.e. reuters). but how do i get this data without > conflicting with other apps and programming as little > vb as possible :( > > anybody did something in that flavor? > > thankx > > gidon > > > > ___ > Zope maillist - [EMAIL PROTECTED] > 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 - [EMAIL PROTECTED] > 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 - [EMAIL PROTECTED] 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 )
Re: [Zope] Importing exchange rates
you can use COM to access the excel file. - Original Message - From: Gidon Friedman <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 18, 2000 7:16 AM Subject: Re: [Zope] Importing exchange rates hi i have a similar problem, i have to import live date (prices) from an excel application. i think they have a vb application that exchanges the data with other applications (i.e. reuters). but how do i get this data without conflicting with other apps and programming as little vb as possible :( anybody did something in that flavor? thankx gidon ___ Zope maillist - [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] 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 )
Re: [Zope] Importing exchange rates
hi i have a similar problem, i have to import live date (prices) from an excel application. i think they have a vb application that exchanges the data with other applications (i.e. reuters). but how do i get this data without conflicting with other apps and programming as little vb as possible :( anybody did something in that flavor? thankx gidon ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Importing exchange rates
If you don't have too much traffic on your site, you can let the "first user of the day" be responsible for triggering new values to a db/file using the ZopeTime function. Something like this maybe: IF (SELECT day FROM currencytable == ZopeTime(day)): SHOW FROM DB ELSE: START THE COLLECTORS SCRIPT AND PUT IN THESE VALUES IN THE DB - Original Message - From: ethan mindlace fremen <[EMAIL PROTECTED]> To: Adrian Madrid <[EMAIL PROTECTED]> Cc: Zope Mailing List <[EMAIL PROTECTED]> Sent: Tuesday, July 18, 2000 4:06 AM Subject: Re: [Zope] Importing exchange rates > Adrian Madrid wrote: > > > > I need to obtain the current exchange rates for the yen, mark, etc. with > > at least once a day, preferrably every other 15". Is there an easy way > > to do this in Zope? > > It depends on where the exchange rates are. > > If you get them from a database, you can make zope display the current > rates. > > If you get them from a web page, you can use the client feature of zope > to go snarf the web page and then extract what you need (hope you have > permission :) > > If some other mechanism can write them to a file, you can suck them up > with an external method whenever someone asks for it. > > hope that helps, > -- > ethan mindlace fremen > Zopatista Community Liason > Abnegate I! > > ___ > Zope maillist - [EMAIL PROTECTED] > 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 - [EMAIL PROTECTED] 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 )
Re: [Zope] Importing exchange rates
For doing things periodically there's the ZScheduler product (http://www.zope.org/Members/lstaffor/ZScheduler). The product is in it's alpha development stage, but if you employ it cautiously, you may find that it works for you. For getting the exchange-rate data, it depends on where it's coming from. Give us some more details and perhaps we can help better. You might want to use ZClient (see the How-To at http://www.zope.org/Members/lstaffor/ZClientMethod). There's also the SiteSummary product (http://www.zope.org/Members/edmundd/SiteSummary/). -- Loren - Original Message - From: "Adrian Madrid" <[EMAIL PROTECTED]> To: "Zope Mailing List" <[EMAIL PROTECTED]> Sent: July 17, 2000 07:41 PM Subject: [Zope] Importing exchange rates > I need to obtain the current exchange rates for the yen, mark, etc. with > at least once a day, preferrably every other 15". Is there an easy way > to do this in Zope? > > Adrian > > > ___ > Zope maillist - [EMAIL PROTECTED] > 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 - [EMAIL PROTECTED] 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 )
Re: [Zope] Importing exchange rates
Adrian Madrid wrote: > > I need to obtain the current exchange rates for the yen, mark, etc. with > at least once a day, preferrably every other 15". Is there an easy way > to do this in Zope? It depends on where the exchange rates are. If you get them from a database, you can make zope display the current rates. If you get them from a web page, you can use the client feature of zope to go snarf the web page and then extract what you need (hope you have permission :) If some other mechanism can write them to a file, you can suck them up with an external method whenever someone asks for it. hope that helps, -- ethan mindlace fremen Zopatista Community Liason Abnegate I! ___ Zope maillist - [EMAIL PROTECTED] 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 )
