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 tokeep 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:
Damn. I was afraid of that. I am not a perl programmer so I was hoping tokeep 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)