Strange database format import
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 27749
interpreted = N
texte = I have a customer that is requesting that I setup a specific database for her, that can be imported, and added to her site. However, the database appaears to be in an inconsistant format. If it were as simple as making a one-time change to the database, it would be an easy fix. However, she is going to receive an updated copy of this database every week. And, of course, she wants me to automate as much of the import as possible.WebCat seems to do okay with it up until a point. The database is a comma-delimited database, and the first several columns are denoted by quotes and seperated by commas. Even when it gets to a point where commas appear within the quotes, WebCat does not have a problem. But, when it gets to the last several colums of the database, which have no quotes, and are separated only by commas, WebCat chokes on the database. Here is an entry from within this database:CANADA,01/01/00 - 12/31/00,2-A,SME,Wool Suits, M&B,5016780,20330,0.40524,0.064045,0.06754,0.,01/13/00The entries should be as follows:CANADA 01/01/00 - 12/31/00 2-A SME Wool Suits, M&B 5016780 20330 0.40524 0.064045 0.06754 0. 01/13/00Instead, the entries come out as:CANADA 01/01/00 - 12/31/00 2-A SME Wool Suits, M&B,5016780,20330,0.40524,0.064045,0.06754,0.,01/13/00CANADA(Notice in the last line, it starts reading the next record).Is there any way that webcat can be instructed to use this database? Or, is there any way to use WebCat to convert the database? Unfortunately, I have already asked the producer of the database if they could send me the database in a more consistant format (preferably tab delimited). They refused, on grounds that the database is sent to numerous others every week as well (although I am probably the only one importing it into a website).Any solutions will be appreciated.Thanks,Dennis ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.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
Associated Messages, from the most recent to the oldest:
I have a customer that is requesting that I setup a specific database for her, that can be imported, and added to her site. However, the database appaears to be in an inconsistant format. If it were as simple as making a one-time change to the database, it would be an easy fix. However, she is going to receive an updated copy of this database every week. And, of course, she wants me to automate as much of the import as possible.WebCat seems to do okay with it up until a point. The database is a comma-delimited database, and the first several columns are denoted by quotes and seperated by commas. Even when it gets to a point where commas appear within the quotes, WebCat does not have a problem. But, when it gets to the last several colums of the database, which have no quotes, and are separated only by commas, WebCat chokes on the database. Here is an entry from within this database:CANADA,01/01/00 - 12/31/00,2-A,SME,Wool Suits, M&B,5016780,20330,0.40524,0.064045,0.06754,0.,01/13/00The entries should be as follows:CANADA 01/01/00 - 12/31/00 2-A SME Wool Suits, M&B 5016780 20330 0.40524 0.064045 0.06754 0. 01/13/00Instead, the entries come out as:CANADA 01/01/00 - 12/31/00 2-A SME Wool Suits, M&B,5016780,20330,0.40524,0.064045,0.06754,0.,01/13/00CANADA(Notice in the last line, it starts reading the next record).Is there any way that webcat can be instructed to use this database? Or, is there any way to use WebCat to convert the database? Unfortunately, I have already asked the producer of the database if they could send me the database in a more consistant format (preferably tab delimited). They refused, on grounds that the database is sent to numerous others every week as well (although I am probably the only one importing it into a website).Any solutions will be appreciated.Thanks,Dennis ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
Dennis J. Bonsall, Jr.
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:
WebCatalog Work (2001)
Cart ID (1999)
Another bug to squash (WebCat2b13 Mac .acgi) (1997)
[numfound] in nested [search] (2000)
Progress !! WAS: Trouble with formula.db (1997)
flushdatabases (1997)
Stopping bad HTML propagation ? (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
encrypt/decrypt (2001)
emailer (1997)
encryption in browser? (1998)
More Applescript (1997)
Location of Webcat site in folder hierarchy (1997)
Sort Order on a page search (1997)
License (2003)
calculating unique time (1998)
WebMerchant Problem (1999)
[TaxableTotal] - not working with AOL and IE (1997)
The beginning (1997)
Search returns all, not 20 (1997)