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:
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:
Join us at MacWorld! (1998)
[OT] Linux -> Winderz (2005)
The beginning (1997)
Multiple fields on 1 input (1997)
PC Cookie Problem? (2003)
WebCatalog stalls (1998)
writing cart to db (1998)
Searching multiple Databases (1997)
how to overwrite username and password in the browser? (2000)
More on the email templates (1997)
Display [price] in banner ad (1998)
Dynamic PDFs? (2004)
Checking for blank form fields (sort of...) (1998)
authenticating a second user (1997)
AAAH: stupid sendmail (2001)
Fun with dates (1997)
Help name our technology! (1997)
PIXO support (1997)
problem with NT beta (1997)
Off Topic: Frames Killer? (1998)