Re: [WebDNA] XML Help please
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 101893
interpreted = N
texte = Actually, I am getting errors too when I check this, I'm wondering if they've changed something on their end. This had been working for the past few years.On Feb 3, 2009, at 1:37 PM, Michael A. DeLorenzo wrote:> Gill,>> Thanks for posting the code. I gave it a go. Do you just put this > on a page> and hit it with a browser? I get a bunch of errors when I do that. > Are there> specific parms or setup I need to use the code?>> Thanks,> Mike>>> -----Original Message-----> From: Gil Poulsen [mailto:gil@altimac.com]> Sent: Tuesday, February 03, 2009 12:38 PM> To: talk@webdna.us> Subject: Re: [WebDNA] XML Help please>> 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/>>>>> ---------------------------------------------------------> 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:
Actually, I am getting errors too when I check this, I'm wondering if they've changed something on their end. This had been working for the past few years.On Feb 3, 2009, at 1:37 PM, Michael A. DeLorenzo wrote:> Gill,>> Thanks for posting the code. I gave it a go. Do you just put this > on a page> and hit it with a browser? I get a bunch of errors when I do that. > Are there> specific parms or setup I need to use the code?>> Thanks,> Mike>>> -----Original Message-----> From: Gil Poulsen [mailto:gil@altimac.com]> Sent: Tuesday, February 03, 2009 12:38 PM> To: talk@webdna.us> Subject: Re: [WebDNA] XML Help please>> 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/>>>>> ---------------------------------------------------------> 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:
Migrating to NT (1997)
WebCatalog for Mac 2.0.1 Released (1997)
unable to launch acgi in WebCat (1997)
Satisfy Me ! was: Why can't support be satisfying to purchasers? (2000)
Search and sort (2001)
Error 551 in Emailer (2000)
Calculating multiple shipping... (1997)
Add message to Order (1997)
WebDNA HitLogger available (was Signal Raised Error) (1997)
archives down? (2002)
[text] variable assignment within [search] context (2000)
RE: Remote administration (1998)
Web Merchant process after credit card clears (1998)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
One other big addition... (1997)
International Orders (1998)
WebCat2b15MacPlugin - showing [math] (1997)
[WebDNA] Line ending issues (2009)
Email notification to one of multiple vendors ? (1997)
[WebDNA] CRM System (2016)