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 Consultant 808-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:

    
  1. Re: CVS Files for databases (Larry Hewitt 2000)
  2. Re: CVS Files for databases (Larry Hewitt 2000)
  3. Re: CVS Files for databases (Peter Ostry 2000)
  4. Re: CVS Files for databases (Kenneth Grome 2000)
  5. Re: CVS Files for databases (WebDNA Support 2000)
  6. Re: CVS Files for databases (Kenneth Grome 2000)
  7. Re: CVS Files for databases (WebDNA Support 2000)
  8. Re: CVS Files for databases (Kenneth Grome 2000)
  9. Re: CVS Files for databases (Brian B. Burton 2000)
  10. CVS Files for databases (Larry Hewitt 2000)
>> 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 Consultant 808-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)