Re: Flat-file to XML converter

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 67426
interpreted = N
texte = How about situations where the data is nested - Customers > Invoices > Line items? If customers, invoices and line items are all stored in different databases and associated, and products in yet another, could you generate a big, flat XML file? On Jun 11, 2006, at 11:02 AM, Dan Strong wrote: > Just working out an idea and thought I'd share. Hopefully some of > you will find it useful. -Dan > > [!]#-- Flat-file (tab-delim) to XML converter ::: -Dan Strong > --[/!] > > [!]-- *** Be sure to set your "path_to_db" var *** --[/!] > [text show=f]path_to_db=listings.db[/text] > [listfields db=[path_to_db]][text show=f]known_field=[fieldname][/ > text][/listfields] > [!]--END set vars --[/!] > > [writefile file=[middle startafter=&endbefore=.][path_to_db][/ > middle].xml&secure=F] > > [!] > [/!][search db=[path_to_db]&ne[known_field]data=show_all][!] > [/!][founditems] >  > [listfields db=[path_to_db]][!] > [/!]<[interpret][fieldname][/interpret]>[interpret][[fieldname]][/ > interpret] > [/listfields][!] > [/!] > [/founditems] > [/search][!] > [/!] > [/writefile] > > [!]#-- END Flat-file (tab-delim) to XML... --[/!] > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Flat-file to XML converter ( "Dan Strong" 2006)
  2. Re: Flat-file to XML converter ( "Dan Strong" 2006)
  3. Re: Flat-file to XML converter ( Pat McCormick 2006)
  4. Flat-file to XML converter ( "Dan Strong" 2006)
How about situations where the data is nested - Customers > Invoices > Line items? If customers, invoices and line items are all stored in different databases and associated, and products in yet another, could you generate a big, flat XML file? On Jun 11, 2006, at 11:02 AM, Dan Strong wrote: > Just working out an idea and thought I'd share. Hopefully some of > you will find it useful. -Dan > > [!]#-- Flat-file (tab-delim) to XML converter ::: -Dan Strong > --[/!] > > [!]-- *** Be sure to set your "path_to_db" var *** --[/!] > [text show=f]path_to_db=listings.db[/text] > [listfields db=[path_to_db]][text show=f]known_field=[fieldname][/ > text][/listfields] > [!]--END set vars --[/!] > > [writefile file=[middle startafter=&endbefore=.][path_to_db][/ > middle].xml&secure=F] > > [!] > [/!][search db=[path_to_db]&ne[known_field]data=show_all][!] > [/!][founditems] >  > [listfields db=[path_to_db]][!] > [/!]<[interpret][fieldname][/interpret]>[interpret][[fieldname]][/ > interpret][interpret][fieldname][/interpret]> > [/listfields][!] > [/!] > [/founditems] > [/search][!] > [/!] > [/writefile] > > [!]#-- END Flat-file (tab-delim) to XML... --[/!] > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.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://webdna.smithmicro.com/ Pat McCormick

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:

WebMerchant & CC Response (2002) Verifying both name and password (was: New Problem) (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) japanese characters (1997) PHP vs. WebDNA (2003) WebCatb15 Mac CGI -- [purchase] (1997) ReturnRaw (1999) Some ThankYou page problems (1997) {Grouping} Docs (1999) Frames and WebCat (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) IIS4b2 and WebCatalog b19 (1997) Listing parameters passed into a [function] (2003) Error Lob.db records error message not name (1997) Help name our technology! I found it (1997) [WebDNA] max in a search (2009) Date Calulation (1997) NT - Thanks and Taxes (1997) What's New Date (2002) Looking For WebCatalog Migration Assistance (2003)