Re: [WebDNA] XML Help please
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 101889
interpreted = N
texte = Thanks for this, I'll have a look at it the morning when I'm fresh :-)Regards,ColinAll services are subject to our terms & conditions, a copy of which can befound on our web site at http://www.idealinternet.co.uk/Gil Poulsen wrote:> Does this help at all? It's the Fed, not the European Central Bank, but> it gets the exchange rates I need and writes them to include files,> although it could be easily modified to write to a database or whatever...> > [TCPConnect host=www.ny.frb.org&port=80]> [text show=F]ex_rates=[TCPSend skipheader=T]GET> /markets/fxrates/FXtoXML.cfm?FEXdate=[year]%2D[month]%2D[day]%2000%3A00%3A00%2E0&FEXtime=1200> HTTP/1.0[unURL]%0D%0A%0D%0A[/unURL][/TCPSend][/text]> [/TCPConnect]> > > [showIf [ex_rates]^frbny:]> > > [text show=F]ex_rates=[grep search=frbny:&replace=][ex_rates][/grep][/text]> > [xmlparse var=xml_rates][ex_rates][/xmlparse]> > [loop start=1&end=23]> [xmlnode> ref=xml_rates&var=series&path=named:UtilityData/DataSet/Series([index])]> [showIf [xmlnodes> ref=series&path=named:Key&name=CURR&exact=T][value][/xmlnodes]=AUD][showIf> [xmlNodeAttributes][name]/[value]> [/xmlNodeAttributes]^UNIT/USD][xmlnodes> ref=series&path=named:Obs&name=OBS_VALUE&exact=T][writeFile> /includes/AUD.inc][value][/writeFile][/xmlnodes][/showIf][/showIf][showIf> [xmlnodes> ref=series&path=named:Key&name=CURR&exact=T][value][/xmlnodes]=USD][showIf> [xmlNodeAttributes][name]/[value]> [/xmlNodeAttributes]^UNIT/CAD][xmlnodes> ref=series&path=named:Obs&name=OBS_VALUE&exact=T][writeFile> /includes/CAD.inc][value][/writeFile][/xmlnodes][/showIf][/showIf][showIf> [xmlnodes> ref=series&path=named:Key&name=CURR&exact=T][value][/xmlnodes]=EUR][showIf> [xmlNodeAttributes][name]/[value]> [/xmlNodeAttributes]^UNIT/USD][xmlnodes> ref=series&path=named:Obs&name=OBS_VALUE&exact=T][writeFile> /includes/EUR.inc][value][/writeFile][/xmlnodes][/showIf][/showIf][showIf> [xmlnodes> ref=series&path=named:Key&name=CURR&exact=T][value][/xmlnodes]=NZD][showIf> [xmlNodeAttributes][name]/[value]> [/xmlNodeAttributes]^UNIT/USD][xmlnodes> ref=series&path=named:Obs&name=OBS_VALUE&exact=T][writeFile> /includes/NZD.inc][value][/writeFile][/xmlnodes][/showIf][/showIf][showIf> [xmlnodes> ref=series&path=named:Key&name=CURR&exact=T][value][/xmlnodes]=GBP][showIf> [xmlNodeAttributes][name]/[value]> [/xmlNodeAttributes]^UNIT/USD][xmlnodes> ref=series&path=named:Obs&name=OBS_VALUE&exact=T][writeFile> /includes/GBP.inc][value][/writeFile][/xmlnodes][/showIf][/showIf][/xmlnode]> > [/loop]> > [/showIf]> > On Feb 3, 2009, at 6:58 AM, Colin Sidwell wrote:> >> Hi,>>>> On the off chance, has anyone written any code to parse this feed from>> the>> European Central Bank?>>>> http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml>>>> I want to just get the USD exchange rate out of it.>>>> I did some XML code before but it took about 2 days to get it working :-(>>>>>> Regards,>>>> Colin>>>>>>>> All services are subject to our terms & conditions, a copy of which>> can be>> found on our web site at http://www.idealinternet.co.uk/>> --------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list
.>> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us>> old archives: http://dev.webdna.us/TalkListArchive/>>> > -- > Gil Poulsen, Mac Wirehead> > ************************> AltiM@c Consulting> 23 Marco Polo Court> Franklin Park, NJ 08823-1703> Voice: 609-359-0103> http://altimac.com> ************************> > > ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> old archives: http://dev.webdna.us/TalkListArchive/>
Associated Messages, from the most recent to the oldest:
Thanks for this, I'll have a look at it the morning when I'm fresh :-)Regards,ColinAll services are subject to our terms & conditions, a copy of which can befound on our web site at http://www.idealinternet.co.uk/Gil Poulsen wrote:> Does this help at all? It's the Fed, not the European Central Bank, but> it gets the exchange rates I need and writes them to include files,> although it could be easily modified to write to a database or whatever...> > [TCPConnect host=www.ny.frb.org&port=80]> [text show=F]ex_rates=[TCPSend skipheader=T]GET> /markets/fxrates/FXtoXML.cfm?FEXdate=[year]%2D[month]%2D[day]%2000%3A00%3A00%2E0&FEXtime=1200> HTTP/1.0[unurl]%0D%0A%0D%0A[/unURL][/TCPSend][/text]> [/TCPConnect]> > > [showIf [ex_rates]^frbny:]> > > [text show=F]ex_rates=[grep search=frbny:&replace=][ex_rates][/grep][/text]> > [xmlparse var=xml_rates][ex_rates][/xmlparse]> > [loop start=1&end=23]> [xmlnode> ref=xml_rates&var=series&path=named:UtilityData/DataSet/Series([index])]> [showIf [xmlnodes> ref=series&path=named:Key&name=CURR&exact=T][value][/xmlnodes]=AUD][showIf> [xmlNodeAttributes][name]/[value]> [/xmlNodeAttributes]^UNIT/USD][xmlnodes> ref=series&path=named:Obs&name=OBS_VALUE&exact=T][writeFile> /includes/AUD.inc][value][/writeFile][/xmlnodes][/showIf][/showIf][showIf> [xmlnodes> ref=series&path=named:Key&name=CURR&exact=T][value][/xmlnodes]=USD][showIf> [xmlNodeAttributes][name]/[value]> [/xmlNodeAttributes]^UNIT/CAD][xmlnodes> ref=series&path=named:Obs&name=OBS_VALUE&exact=T][writeFile> /includes/CAD.inc][value][/writeFile][/xmlnodes][/showIf][/showIf][showIf> [xmlnodes> ref=series&path=named:Key&name=CURR&exact=T][value][/xmlnodes]=EUR][showIf> [xmlNodeAttributes][name]/[value]> [/xmlNodeAttributes]^UNIT/USD][xmlnodes> ref=series&path=named:Obs&name=OBS_VALUE&exact=T][writeFile> /includes/EUR.inc][value][/writeFile][/xmlnodes][/showIf][/showIf][showIf> [xmlnodes> ref=series&path=named:Key&name=CURR&exact=T][value][/xmlnodes]=NZD][showIf> [xmlNodeAttributes][name]/[value]> [/xmlNodeAttributes]^UNIT/USD][xmlnodes> ref=series&path=named:Obs&name=OBS_VALUE&exact=T][writeFile> /includes/NZD.inc][value][/writeFile][/xmlnodes][/showIf][/showIf][showIf> [xmlnodes> ref=series&path=named:Key&name=CURR&exact=T][value][/xmlnodes]=GBP][showIf> [xmlNodeAttributes][name]/[value]> [/xmlNodeAttributes]^UNIT/USD][xmlnodes> ref=series&path=named:Obs&name=OBS_VALUE&exact=T][writeFile> /includes/GBP.inc][value][/writeFile][/xmlnodes][/showIf][/showIf][/xmlnode]> > [/loop]> > [/showIf]> > On Feb 3, 2009, at 6:58 AM, Colin Sidwell wrote:> >> Hi,>>>> On the off chance, has anyone written any code to parse this feed from>> the>> European Central Bank?>>>> http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml>>>> I want to just get the USD exchange rate out of it.>>>> I did some XML code before but it took about 2 days to get it working :-(>>>>>> Regards,>>>> Colin>>>>>>>> All services are subject to our terms & conditions, a copy of which>> can be>> found on our web site at http://www.idealinternet.co.uk/>> --------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list .>> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us>> old archives: http://dev.webdna.us/TalkListArchive/>>> > -- > Gil Poulsen, Mac Wirehead> > ************************> AltiM@c Consulting> 23 Marco Polo Court> Franklin Park, NJ 08823-1703> Voice: 609-359-0103> http://altimac.com> ************************> > > ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> old archives: http://dev.webdna.us/TalkListArchive/>
Colin Sidwell
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Search in 2 or more catalogs (1997)
Problems passing [SKU] with $Replace in 2.0 (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
2nd WebCatalog2 Feature Request (1996)
Possible Bug in 2.0b15.acgi (1997)
Orders coming up blank (2004)
Almost a there but..bye bye NetCloak (1997)
RE: pricing continued (1998)
Help with a pull down menu (1999)
has any written a WebDNA calendar that also writes (2004)
Pithy questions on webcommerce & siteedit (1997)
Range search (2003)
graphing (2004)
Date Formats (1997)
Displaying raw values (long) (1998)
Only charge card when product shipped ? (1997)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
Multiple Merchant Accounts? (1997)
Anyone have an invoicing system? (1999)
FireSite and PIXO (1998)