RE: [WebDNA] XML Help please
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 101891
interpreted = N
texte = Sorry, no more errors. I had to delete a few returns from the copy/paste I did. But I still get no outcome. Any suggestions? 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/
Associated Messages, from the most recent to the oldest:
Sorry, no more errors. I had to delete a few returns from the copy/paste I did. But I still get no outcome. Any suggestions? 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/
"Michael A. DeLorenzo"
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:
when is date system date or order date? (1997)
WebCat2.0 [format thousands .0f] no go (1997)
[ConvertChars] problem (1997)
Date Sorting (1997)
Webstar 1.3.1 PPC (1997)
Online magazine- monthly updates and such (1999)
WC2.0 Memory Requirements (1997)
Duplicate Carts (2006)
Signal Raised error (1997)
is sku a REQUIRED field on NT (1997)
Multiple catalog databases and showcart (1997)
Problems reading files created by WC (1997)
windows 95 netscape 3.01 browser bug? (1997)
WCS Newbie question (1997)
(OT) Dual 2GHz G5 (2003)
[WriteFile] problems (1997)
Uh...can someone help me out with the b10? (1997)
Updating fields from different platforms (1998)
Upcoming 2.1 Release and PCS Committment (1997)
[WebDNA] Stores (2013)