Re: grabbing xml data with webcat (was: Posting XML data toSSL
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 40614
interpreted = N
texte = Ben,Depending on how complexe the xml is that you need to put into the database, it can be done but can be a pain.On one of my sites I grab daily horoscopes from another site in xml format and parse them with webcat. It was not pretty and if they change the order of the records provided I am sunk.Basically what I did was to grab the entire content, then as I happen to know they last record (the last zodiac sign in this case) I can use a [middle] context and look for all content after the next to last sign and end before the last bit of text. Then work my way backwards up the file.Daleon 13/6/02 5:14 am, Ben Swihart at bswihart@timesnews.net wrote:> Since you are (sort of) on the subject... Anyone got a better way to get > xml data into a webdna database? At the moment, I'm using a perl script > to parse the xml files and write a webdna query, which is hit on a > trigger. > > - Ben > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
| |
- Re: grabbing xml data with webcat (was: Posting XML data toSSL (drt - lists 2002)
|
Ben,Depending on how complexe the xml is that you need to put into the database, it can be done but can be a pain.On one of my sites I grab daily horoscopes from another site in xml format and parse them with webcat. It was not pretty and if they change the order of the records provided I am sunk.Basically what I did was to grab the entire content, then as I happen to know they last record (the last zodiac sign in this case) I can use a [middle] context and look for all content after the next to last sign and end before the last bit of text. Then work my way backwards up the file.Daleon 13/6/02 5:14 am, Ben Swihart at bswihart@timesnews.net wrote:> Since you are (sort of) on the subject... Anyone got a better way to get > xml data into a webdna database? At the moment, I'm using a perl script > to parse the xml files and write a webdna query, which is hit on a > trigger. > > - Ben > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
drt - lists
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:
Searching multiple fields (1997)
4.0 send email ticks. . (2000)
serial number dishing (1997)
WC2b15 File Corruption (1997)
Date in IF ELSE Comparison (2004)
Multiple adding (1997)
encrypt/decrypt (2001)
WebCat2.0b15-to many nested [xx] tags (1997)
Username for Admin Group (1997)
No luck with taxes (1997)
SHOWIF/HIDEIF empty fields (2005)
[WebDNA] Use of :global: (2013)
WC Database Format (1997)
t or f (1997)
Re(2): & in grep (2003)
RE: Can a database get stomped by simultaneous access? (1997)
Country & Ship-to address & other fields ? (1997)
[WebDNA] YouTube API v2.0 - OAuth 2.0 Authorization (2013)
Another issue with [Date format] (1998)
Setting up shop (1997)