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, 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/ 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:

    
  1. Re: [WebDNA] XML Help please (Colin Sidwell 2009)
  2. Re: [WebDNA] XML Help please (Gil Poulsen 2009)
  3. Re: [WebDNA] XML Help please (Gil Poulsen 2009)
  4. Re: [WebDNA] XML Help please (Gil Poulsen 2009)
  5. RE: [WebDNA] XML Help please ("Michael A. DeLorenzo" 2009)
  6. RE: [WebDNA] XML Help please ("Michael A. DeLorenzo" 2009)
  7. Re: [WebDNA] XML Help please (Colin Sidwell 2009)
  8. Re: [WebDNA] XML Help please (Colin Sidwell 2009)
  9. Re: [WebDNA] XML Help please (Gil Poulsen 2009)
  10. Re: [WebDNA] XML Help please (Toby Cox 2009)
  11. [WebDNA] XML Help please (Colin Sidwell 2009)
Thanks for this, I'll have a look at it the morning when I'm fresh :-) 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/ 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)