Re: mapping fields between databases

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 36587
interpreted = N
texte = Yes, I understand how to do this on a one time basis. I should be more clear. My inclination is to have this set up as an automatic process. This foreign (progress) database will create a tab deliminated text file (lets say) every evening, then I would like to set up a process (trigger???) that would retrieve and commit to database the new info then flush the cache . My question is: would the fieldnames in both the webcatalog database and the field names in the (incoming) tab deliminated text file have to match or could I create some mapping code that would match a particular field to a field in the WebCat db???forgive the lack of specific tag reference as I am just learning WebDNA.Thanks in advance. - D Clayton Randall wrote:> If it is a tab delimeted file, you don't need to import it at all, > just use the names as you already have them, then copy and paste the > new lines at the end of your .db file. Don't forget to > committdatabases first, and then flush your cache when you are done. > > >Hello, > >without getting into the details of this just yet. I wanted to know if webcat > >has a standard way of mapping field names upon importing data from > >another (tab deliminated text file) database? > >Is it better to have the same field names in both databases? > > > >Thanks, D > > > > > >-- Donovan D. Brooke > >Systems Administrator/ > >Assc. Art Director > >Epsen Hillmer Graphics > > > >When 900 years old you reach, look as good you will not, hm? > >-Yoda > > > >-- Donovan D. Brooke Systems Administrator/ Assc. Art Director Epsen Hillmer Graphics (402) 342-7000 X297When 900 years old you reach, look as good you will not, hm? -Yoda ------------------------------------------------------------- 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: mapping fields between databases (Donovan Brooke 2001)
  2. Re: mapping fields between databases (Clayton Randall 2001)
  3. mapping fields between databases (Donovan Brooke 2001)
Yes, I understand how to do this on a one time basis. I should be more clear. My inclination is to have this set up as an automatic process. This foreign (progress) database will create a tab deliminated text file (lets say) every evening, then I would like to set up a process (trigger???) that would retrieve and commit to database the new info then flush the cache . My question is: would the fieldnames in both the webcatalog database and the field names in the (incoming) tab deliminated text file have to match or could I create some mapping code that would match a particular field to a field in the WebCat db???forgive the lack of specific tag reference as I am just learning WebDNA.Thanks in advance. - D Clayton Randall wrote:> If it is a tab delimeted file, you don't need to import it at all, > just use the names as you already have them, then copy and paste the > new lines at the end of your .db file. Don't forget to > committdatabases first, and then flush your cache when you are done. > > >Hello, > >without getting into the details of this just yet. I wanted to know if webcat > >has a standard way of mapping field names upon importing data from > >another (tab deliminated text file) database? > >Is it better to have the same field names in both databases? > > > >Thanks, D > > > > > >-- Donovan D. Brooke > >Systems Administrator/ > >Assc. Art Director > >Epsen Hillmer Graphics > > > >When 900 years old you reach, look as good you will not, hm? > >-Yoda > > > >-- Donovan D. Brooke Systems Administrator/ Assc. Art Director Epsen Hillmer Graphics (402) 342-7000 X297When 900 years old you reach, look as good you will not, hm? -Yoda ------------------------------------------------------------- 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/ Donovan Brooke

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:

Download Question (1997) Form/HTML Help (2000) system crashes, event log (1997) Frames and WebCat (1997) Using [Include] Context (1999) [WebDNA] Website almost dead? (2016) Reminder... (2003) WebCatalog f2 Installation (1997) Multiple Hideif peramiters (2001) [WebDNA] Test (2013) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) [cart] tag (2000) Line items in table cells (1997) Q: writefile and uploads. (1998) off-topic - printinglib 68K (1997) [taxRate] [TaxTotal] ? (1997) Up and running ... at last !! (1997) Multiple Newcarts (1996) Test (2006) Multiple prices (1997)