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 lastdealt 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 acomma separated, quote mark surrounded field to work. This is the wayFileMaker exports a merge file.Example:header1,header2,header3data,data,datadata,data,dataSince this isn't what you have, it confuses WebCatalog (or it did, perhapsthey fixed it?)Anyway, I fixed the problem by writefileing a new file, that had the oldfile included, surrounded by a convertchars to convert the commas into tabs.My data didn't have commas in the data fields themselves, so your mileagemay 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 andimpossible to digest. The only one I can remember isthat if all the people who go to sleep in church werelaid 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 lastdealt 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 acomma separated, quote mark surrounded field to work. This is the wayFileMaker exports a merge file.Example:header1,header2,header3data,data,datadata,data,dataSince this isn't what you have, it confuses WebCatalog (or it did, perhapsthey fixed it?)Anyway, I fixed the problem by writefileing a new file, that had the oldfile included, surrounded by a convertchars to convert the commas into tabs.My data didn't have commas in the data fields themselves, so your mileagemay 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 andimpossible to digest. The only one I can remember isthat if all the people who go to sleep in church werelaid 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:
Hierarchy of form/text/math variables (2000)
synching databases on multiple servers (1997)
[ot] Browser Detection (2001)
setting cookies then redirecting? (1998)
A multi-processor savvy WebCatalog? (1997)
[searchString] (1997)
Database (1999)
File info on files with funky characters in their names (2003)
Strange error (2000)
syntax question, not in online refernce (1997)
[WebDNA] Need Rosetta to install on OS X? (2010)
Adding order weight (1999)
Locking up with WebCatalog... (1997)
WebCatalog not running after upgrade (2000)
Password and Allow commands (1998)
TRAINING videos - Prove IT. (1998)
Tech question about web dna actions (1998)
User/pass with tcpconnect (2000)
Misc Stuff That Might Help (1997)
WC2f3 (1997)