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:

    
  1. 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:

incrementing sku (1998) How to Display text in empty fields (1997) Which Pref is faster? (1998) Was it something I said??? (1998) Location of Browser Info.txt file (1997) Weird Math and SV (1997) anyone using Webcat 4.x in production? (2000) Webcatalog Future?!? - Was &fieldsdir=ra truely random?? (2000) many-to-one problem (1998) Root Folder problems cont. (1998) BUG REPORT: numeric ge, le, gr & ls comparisons don't work... (1999) different show next (1997) Trouble Searching (1999) Sorting by date (1997) Strange WebDNA server not running error (2006) Cold Fusion Buster (1997) WebCatalog dying in NT (1998) [trim]?! (2004) OT (maybe) Setting up local (non internet) test computers (2000) [searchString] (1997)