Re: [WebDNA] XML Help please

This WebDNA talk-list message is from

2009

It keeps the original formatting. numero = 101887
interpreted = N
texte = 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 Consulting23 Marco Polo CourtFranklin Park, NJ 08823-1703Voice: 609-359-0103http://altimac.com************************ Associated Messages, from the most recent to the oldest:

Re: [WebDNA] XML Help please (Colin Sidwell 2009) Re: [WebDNA] XML Help please (Gil Poulsen 2009) Re: [WebDNA] XML Help please (Gil Poulsen 2009) Re: [WebDNA] XML Help please (Gil Poulsen 2009) RE: [WebDNA] XML Help please ("Michael A. DeLorenzo" 2009) RE: [WebDNA] XML Help please ("Michael A. DeLorenzo" 2009) Re: [WebDNA] XML Help please (Colin Sidwell 2009) Re: [WebDNA] XML Help please (Colin Sidwell 2009) Re: [WebDNA] XML Help please (Gil Poulsen 2009) Re: [WebDNA] XML Help please (Toby Cox 2009) [WebDNA] XML Help please (Colin Sidwell 2009)

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 Consulting23 Marco Polo CourtFranklin Park, NJ 08823-1703Voice: 609-359-0103http://altimac.com************************ Gil Poulsen

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:

HELP WITH DATES (1997) Protect (1997) Special search (1998) % (mod) was looping table rows (1999) Timeout question .. (2003) Logging purchases (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997) Been meaning to ask... (1997) For those of you not on the WebCatalog Beta... (1997) Form/HTML Help (2000) passing cart value (2003) WebCat2b15MacPlugin - showing [math] (1997) Reminder for beta testers (2000) Script install tgz for WebCat 4.02 (2003) dates and hex formatting (1997) Multihoming and webcat (1998) SETCOOKIE Problems (2003) [WebDNA] Variable mystery (2009) Nested tags count question (1997) The List is Changing (1997)