Re: CVS Files for databases
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29114
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,dataSince 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... Brian B. Burton BOFH - Department of Redundancy Department --------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.comI always find that statistics are hard to swallow and impossible to digest. The only one I can remember is that if all the people who go to sleep in church were laid end to end they would be a lot more comfortable. --Mrs. Robert A. Taft ------------------------------------------------------------- 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,dataSince 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... Brian B. Burton BOFH - Department of Redundancy Department --------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.comI always find that statistics are hard to swallow and impossible to digest. The only one I can remember is that if all the people who go to sleep in church were laid end to end they would be a lot more comfortable. --Mrs. Robert A. Taft ------------------------------------------------------------- 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
Brian B. Burton
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:
Where is f2? (1997)
[SearchString] usage (1997)
Not reading code (1997)
WebCatalog vs. Cold Fusion (1998)
Tool of Use to Unix WebCat Admins (2000)
restarting service remotely on NT (1997)
Help! WebCat2 bug (1997)
NewCart+Search with one click ? (1997)
Reload adding to cart (2001)
Need help, multiple shipping options (2000)
Globals in 3.x (2002)
Strange search... (2001)
IIS 4 (1998)
Newbie Tax Question (1997)
Ordering Fraction CORRECTION (2000)
ShipCost formula (for weight *and* quantities)? (1998)
RE: Error: template (1997)
WebDNA Developer Edition - Host config problem (2003)
bye bye tax rate (1998)
PCS Frames (1997)