Re: formulas.db ??

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17719
interpreted = N
texte = >We've had problems creating .db files with a text editor before (simple >text), and have had better luck with database helper, however it won't >allow us to create the formulas.db because it requires an SKU field.If Database Helper works for you, why don't you just use some other name for that SKU field? Then after the file is created with the wrong name for the SKU field, open it in SimpleText and replace the wrong name with SKU -- being very careful to NOT add or delete any tabs or carriage returns in the process.Most WebCat users probably just use a desktop database program to create their WebCat db files, then they export a tab-delimited text file from that desktop db program for WebCatalog to use. You can just as easily use a spreadsheet program for this initial database creation procedure ...There's no reason why SimpleText or any other text processor cannot create tab-delimited text files from scratch, you just have to be very careful -- to make sure you don't put too many or too few tabs and/or carriage returns into the SimpleText file -- and that you're putting them all in the right places. But that's why it's easier to let a desktop database or spreadsheet program do it for you ... because they cannot accidentally mess up the way humans sometimes do ... :)Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: formulas.db ?? (Peter Ostry 1998)
  2. Re: formulas.db ?? (Kenneth Grome 1998)
  3. Re: formulas.db ?? (Mark Mesenko 1998)
  4. Re: formulas.db ?? (Kenneth Grome 1998)
  5. formulas.db ?? (Mark Mesenko 1998)
>We've had problems creating .db files with a text editor before (simple >text), and have had better luck with database helper, however it won't >allow us to create the formulas.db because it requires an SKU field.If Database Helper works for you, why don't you just use some other name for that SKU field? Then after the file is created with the wrong name for the SKU field, open it in SimpleText and replace the wrong name with SKU -- being very careful to NOT add or delete any tabs or carriage returns in the process.Most WebCat users probably just use a desktop database program to create their WebCat db files, then they export a tab-delimited text file from that desktop db program for WebCatalog to use. You can just as easily use a spreadsheet program for this initial database creation procedure ...There's no reason why SimpleText or any other text processor cannot create tab-delimited text files from scratch, you just have to be very careful -- to make sure you don't put too many or too few tabs and/or carriage returns into the SimpleText file -- and that you're putting them all in the right places. But that's why it's easier to let a desktop database or spreadsheet program do it for you ... because they cannot accidentally mess up the way humans sometimes do ... :)Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Kenneth Grome

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:

[date format] w/in sendmail (1997) Major bug report on rootbeer (1997) E-mailer error codes (1997) .tmp files (2000) Protect vs Authenicate (1997) Invisible file issue now a real 'bug' (1999) webcat feature request (1997) More! on [ShowCart] and GET vs. POST (1997) Forcing a NEWCART (1997) NT Version on IIS 4.0 (1997) WebCatalog Mac 2.1b3 (1997) Text data with spaces in them... (1997) A question on sub-categories (1997) [WebDNA] error on mirror site (2015) [format xs] freeze (1997) [WebDNA] Capitalize surprise (2012) TeaRoom (1997) [WebDNA] Authorize.net and [tcpconnect] (2016) WebCat2 Append problem (B14Macacgi) (1997) WebCatalog [FoundItems] Problem - AGAIN - (1997)