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:

Running _every_ page through WebCat ? (1997) Math (1997) Mac OS X Server, Apache etc etc (1999) RE: Tax and ShipCost Problem (1997) Only charge card when product shipped ? (1997) Multiple copies (1999) Accentuated and non-English letters (2002) Only charge card when product shipped ? (1997) Preserving form data (1999) Error Template (1999) Users and groups for local directories (1999) pop up menu's (1998) Re:WebCatalog f2 Installation (1997) Attention SMSI - DOCS Error (2004) [WebDNA] Candidate versions release (2010) plugin-acgi, different results (1997) Problems with [Applescript] (1997) [WebDNA] Anyone implement http://mollom.com/ or http://akismet.com/? (2009) Way Off Topic (2003) [Announce]: Web server security and password protection (1997)