Re: Help!!!!

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23256
interpreted = N
texte = >I traced the problem down to a database I imported from Excel. Something >was in it that was crashing webcat. > >Are there things to avoid in a database. Certain characters, etc?Was Excel exporting the file in quote-comma delimited form? If so, make sure that quotes surround numeric fields as well.If it was tab-delimited, you have to make sure that there are exactly the same number of tabs per line -- Excel tends to be pretty spotty about how it exports. WebCatalog actually does a lot of cleanup, but sometimes even it can't figure out what's meant to be which field if it gets crazy.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Help!!!! (Peter Ostry 1999)
  2. Re: Help!!!! (PCS Technical Support 1999)
  3. Re: Help!!!! (Mike Jones 1999)
  4. Re: Help!!!! (PCS Technical Support 1999)
  5. Re: Help!!!! (Kenneth Grome 1999)
  6. Help!!!! (Mike Jones 1999)
  7. Re: Random tags HELP!!!! (Rob Marquardt 1999)
  8. Random tags HELP!!!! (Talklist 1999)
  9. Re: Random tags HELP!!!! (Martin Bech 1999)
  10. Re:Off Topic (Help!!!! w/Webstar) (mmyers 1999)
  11. Re: Help!!!! Purchases not going through! FIXED! (Paul Uttermohlen 1997)
  12. Re: Help!!!! Purchases not going through! FIXED! (Paul Uttermohlen 1997)
  13. Re: Help!!!! Purchases not going through! FIXED! (John Hill 1997)
  14. Re: Help!!!! Purchases not going through! FIXED! (Jerry Nielsen 1997)
  15. Re: Help!!!! Purchases not going through! (John Hill 1997)
  16. Re: Help!!!! Purchases not going through! (Paul Uttermohlen 1997)
  17. Help!!!! Purchases not going through! (Jerry Nielsen 1997)
  18. Re: Help!!!! (Jay Van Vark 1997)
  19. Re: Help!!!! (Glenn Davis 1997)
  20. Re: Help!!!! (Kenneth Grome 1997)
  21. Help!!!! (Glenn Davis 1997)
>I traced the problem down to a database I imported from Excel. Something >was in it that was crashing webcat. > >Are there things to avoid in a database. Certain characters, etc?Was Excel exporting the file in quote-comma delimited form? If so, make sure that quotes surround numeric fields as well.If it was tab-delimited, you have to make sure that there are exactly the same number of tabs per line -- Excel tends to be pretty spotty about how it exports. WebCatalog actually does a lot of cleanup, but sometimes even it can't figure out what's meant to be which field if it gets crazy.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ PCS Technical Support

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:

File dates in WebCatalog .tmpl/.inc (1997) [shippingtotal] & Formulas.db prob (2003) Netinfo... (2002) select multiple 2 more cents (1997) WebCatalog can't find database (1997) Database changes (1998) Emailer port change (1997) RE: Error: template (1997) [WebDNA] WebDNA7 and mod_fcgi (2013) [WebDNA] Cookie behavior (2010) my price won't move (1997) For those of you not on the WebCatalog Beta... (1997) Re[2]: Wierd problem with 3.08 WIN Version (2000) Applescript, WebDNA, and PDF (1997) searching multiple databases (1997) Not really WebCat (1997) numfound question (2005) japanese characters (1997) WC2b15 File Corruption (1997) [WebDNA] Triggers issue, or sendmail? (2012)