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
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!
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 <mindlace@digicool.com> To: Adrian Madrid <adrian@bridgetojapan.com> Cc: Zope Mailing List <zope@zope.org> 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 - 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 )
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
you can use COM to access the excel file. ----- Original Message ----- From: Gidon Friedman <gidon@friedman.ch> To: <zope@zope.org> 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 - 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 )
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: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Jim Sanford Sent: 18 July 2000 16:21 To: Gidon Friedman; zope@zope.org Subject: Re: [Zope] Importing exchange rates
you can use COM to access the excel file.
----- Original Message ----- From: Gidon Friedman <gidon@friedman.ch> To: <zope@zope.org> 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 - 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 )
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" <adrian@bridgetojapan.com> To: "Zope Mailing List" <zope@zope.org> 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 - 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 )
participants (7)
-
Adrian Madrid -
ethan mindlace fremen -
Gidon Friedman -
Jim Sanford -
Loren Stafford -
Peter Be -
Richard Folwell