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:

[AppendFile] problem (WebCat2b13 Mac .acgi) (1997) Location of Browser Info.txt file (1997) More on the email templates (1997) Thanks Aaron (2000) Date Comparison (1998) WebCatalog can't find database (1997) Search logic? (1998) webcat method for waiting specific amount of time? (2000) [WebDNA] [OT] WebDNA Wiki - need grammar check / suggestions (2009) Eudora Plugin (1999) WebDNA Solutions ... sorry! (1997) [OT] Trying to steal databases on our server (2003) WC2b12: Yes, Formulas.db is for real (1997) Re:Dumb Question about Docs (1997) Updating a database once per day - An example (1998) WCS Newbie question (1997) Test message (2008) my SOS last week... (1996) Sorting by date (1997) Saving/Looking Up customer numbers (1998)