Re: CVS Files for databases
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29116
interpreted = N
texte = >> OK - I am stuck.>>>> I have always used tab-sep files for databases. In this project, I receive>> a 56000 record data file in CSV format via ftp from a client in exactly the>> format I require, use a CSV formatted .hdr file to match with it - all so I>> can automatically refresh the file daily unattended. When I search it I get>> nothing found - for anything.>>>> WebCat admin shows the header fields, the number of records in the database,>> and the number of fields - all correct.>>>> If I eliminate the CSV and replace it with TABs, all works just fine.>>I had the same problem, and as I recall (it's been a while since I last>dealt with this...) WebCatalog can't use a CVS file (if I'm wrong now,>please correct me). When I was doing my project, WebCatalog had to have a>comma separated, quote mark surrounded field to work. This is the way>FileMaker exports a merge file.>>Example:>>header1,header2,header3>data,data,data>data,data,data>>Since this isn't what you have, it confuses WebCatalog (or it did, perhaps>they fixed it?)>>Anyway, I fixed the problem by writefileing a new file, that had the old>file included, surrounded by a convertchars to convert the commas into tabs.>My data didn't have commas in the data fields themselves, so your mileage>may vary...Or try a different header file such as:header1,header2,header3================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------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:
>> OK - I am stuck.>>>> I have always used tab-sep files for databases. In this project, I receive>> a 56000 record data file in CSV format via ftp from a client in exactly the>> format I require, use a CSV formatted .hdr file to match with it - all so I>> can automatically refresh the file daily unattended. When I search it I get>> nothing found - for anything.>>>> WebCat admin shows the header fields, the number of records in the database,>> and the number of fields - all correct.>>>> If I eliminate the CSV and replace it with TABs, all works just fine.>>I had the same problem, and as I recall (it's been a while since I last>dealt with this...) WebCatalog can't use a CVS file (if I'm wrong now,>please correct me). When I was doing my project, WebCatalog had to have a>comma separated, quote mark surrounded field to work. This is the way>FileMaker exports a merge file.>>Example:>>header1,header2,header3>data,data,data>data,data,data>>Since this isn't what you have, it confuses WebCatalog (or it did, perhaps>they fixed it?)>>Anyway, I fixed the problem by writefileing a new file, that had the old>file included, surrounded by a convertchars to convert the commas into tabs.>My data didn't have commas in the data fields themselves, so your mileage>may vary...Or try a different header file such as:header1,header2,header3================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------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
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:
problems with 2 tags (1997)
404s - Apache vs. WebDNA (2008)
WebCommerce: Folder organization ? (1997)
Programer help needed (OT) (2006)
Secure server question (1997)
OT: Outsourcing & copyrights (2005)
Partner Edition question ... (2003)
DON'T use old cart file! (1997)
OT - royalty free images (2002)
multiple prices (1998)
separate by mont (search) (2002)
problems with 2 tags shakur (1997)
tcpconnect (1999)
One more try (1997)
taxTotal, grandTotal (1997)
can WC render sites out? (1997)
WebCatalog (1999)
2nd WebCatalog2 Feature Request (1996)
Unable to view next 101-200 (1997)
Carts & cookies (1999)