Re: XML values to database records (grep?)

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 32907
interpreted = N
texte = Damn. I was afraid of that. I am not a perl programmer so I was hoping to keep this in the Webcat realm.Mike> Mike - > > You are not going to be able to do this with a grep, because of the > need to match both starting and ending tags. The variability of the > tags is also going to give you hives. What you really need is a finite > state engine to walk the XML file, which is to say you need a full > fledged parser. If the file only includes a small number of fields (as > below), you might be able to fake something up, but it is really not > something that WebCat is even vaguely designed to handle. > > Perl, on the other hand, could eat this file up and spit is out in any > number of formats (include tab delimited, hint hint). You may want to > check out > > http://www.perlxml.com/faq/perl-xml-faq.html > > for some links that may point you in useful directions. > > John Peacock > > Mike Davis wrote: >> >> I'm trying to parse some values from XML so that they can be appended as >> records into a database. So far I'm stumped as to how to parse this style >> of data using WebDNA. But I have the feeling that someone who is more >> fluent in grep than I (John Peacock hint hint nudge nudge) could see how to >> make this happen. The construct of the XML is listed below. I want to take >> each , treat is as a database record, and append its s to >> the database using the pairs within each . So using >> the example below, I would like to be able to create an [append] context >> like this: >> [append db=x.db] >> channeltitle=NZ Jazz Online - Jazz.co.nz >> &id=75 >> &storytext=<a href=http://jazz.co.nz>Manuel Bundy</a> >> &time=19991004T02:01:13 >> [/append] >> >> Of course, I would like to extrapolate the data into an array of variables >> first so that I could manipulate it (change the date format for instance) >> before I append it to the database. *Note that some s have >> sub-identifiers such as and . >> >> XML: >> snip... >> >> >> >> channeltitle >> NZ Jazz Online - Jazz.co.nz >> >> >> id >> >> 75 >> >> >> >> storytext >> <a href=http://jazz.co.nz>Manuel Bundy</a> >> >> >> time >> >> 19991004T02:01:13 >> >> >> >> >> ...snip >> >> -- This is only one isolated . The entire XML source would have >> many s so my solution will need to recurs through the XML source and >> break each out as an individual record. >> >> Hmmf. Anyone? Ken? John? Grant? >> >> Thanks, >> Mike > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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: XML values to database records (grep?) (Mike Davis 2000)
  2. Re: XML values to database records (grep?) (John Peacock 2000)
  3. XML values to database records (grep?) (Mike Davis 2000)
Damn. I was afraid of that. I am not a perl programmer so I was hoping to keep this in the Webcat realm.Mike> Mike - > > You are not going to be able to do this with a grep, because of the > need to match both starting and ending tags. The variability of the > tags is also going to give you hives. What you really need is a finite > state engine to walk the XML file, which is to say you need a full > fledged parser. If the file only includes a small number of fields (as > below), you might be able to fake something up, but it is really not > something that WebCat is even vaguely designed to handle. > > Perl, on the other hand, could eat this file up and spit is out in any > number of formats (include tab delimited, hint hint). You may want to > check out > > http://www.perlxml.com/faq/perl-xml-faq.html > > for some links that may point you in useful directions. > > John Peacock > > Mike Davis wrote: >> >> I'm trying to parse some values from XML so that they can be appended as >> records into a database. So far I'm stumped as to how to parse this style >> of data using WebDNA. But I have the feeling that someone who is more >> fluent in grep than I (John Peacock hint hint nudge nudge) could see how to >> make this happen. The construct of the XML is listed below. I want to take >> each , treat is as a database record, and append its s to >> the database using the pairs within each . So using >> the example below, I would like to be able to create an [append] context >> like this: >> [append db=x.db] >> channeltitle=NZ Jazz Online - Jazz.co.nz >> &id=75 >> &storytext=<a href=http://jazz.co.nz>Manuel Bundy</a> >> &time=19991004T02:01:13 >> [/append] >> >> Of course, I would like to extrapolate the data into an array of variables >> first so that I could manipulate it (change the date format for instance) >> before I append it to the database. *Note that some s have >> sub-identifiers such as and . >> >> XML: >> snip... >> >> >> >> channeltitle >> NZ Jazz Online - Jazz.co.nz >> >> >> id >> >> 75 >> >> >> >> storytext >> <a href=http://jazz.co.nz>Manuel Bundy</a> >> >> >> time >> >> 19991004T02:01:13 >> >> >> >> >> ...snip >> >> -- This is only one isolated . The entire XML source would have >> many s so my solution will need to recurs through the XML source and >> break each out as an individual record. >> >> Hmmf. Anyone? Ken? John? Grant? >> >> Thanks, >> Mike > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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/ Mike Davis

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:

Webten + Webcat running smooth (1998) autosensing lanague selection (1997) Duplicates (1998) Help name our technology! (1997) (Larry - it's good to use keywords in the subject) (2000) [WebDNA] Bug? [fileinfo..] You decide (2016) WebCatalog and directory indexing (1998) WebCat and PIXO (2000) 40,000+ items = mutiple dbs? (1999) Logging purchases (1997) Dealer locator (1998) [OT] Robust order processing (2003) Price recalc based on quantity (1997) WebDNA Quick Reference (Reserved Words) (2000) Hard Questions ? (1997) OT - ImageMagick on MacOS X (2004) WCf2 and nested tags (1997) New Mac Emailer... (1997) Separate SSL Server (1997) Close Databases Crash? (1998)