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