Re: CSV import suggestions
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 69165
interpreted = N
texte = The following database type will not work (0 found records): vendorstocknumber,lab,price 1,1,1 2,2,2 3,3,3 4,4,4 5,5,5 A database in this format is a "merged" CSV database and will return 5 found records: vendorstocknumber,lab,price "1","1","1" "2","2","2" "3","3","3" "4","4","4" "5","5","5" So if your exported CSV file doesn't include the quoting, then you'll need to either have it do so via the application that you're exporting from -or- write out a new database (might as well go tab-delimited) reading from what you have (a combination of listwords with a "," delimiter, etc). GJK On Thu, 5 Jul 2007 18:48:51 -0400 "Vincent Medina"
wrote: > I tried to read the file as is however when I do: > > [search db=db\import\rsdl.db&gelabdata=0] > [Numfound] records found > [founditems] > > [vendorstocknumber],[lab],[price] >
> > [/founditems] > [/search] > > I get 0 records.... > > When I list fields as is in: > > [ListFields db=db/import/rsdl.db] > Fieldname: [FieldName]
> [/ListFields] > > I see the ENTIRE first line of the db - It seems like it >is not recognizing > the first line as the field names. > I made a hdr file and eliminated the first line of field >names from the db > with the same result. Does WebDNA need to be told this >is a merge format? If > so how? ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
The following database type will not work (0 found records): vendorstocknumber,lab,price 1,1,1 2,2,2 3,3,3 4,4,4 5,5,5 A database in this format is a "merged" CSV database and will return 5 found records: vendorstocknumber,lab,price "1","1","1" "2","2","2" "3","3","3" "4","4","4" "5","5","5" So if your exported CSV file doesn't include the quoting, then you'll need to either have it do so via the application that you're exporting from -or- write out a new database (might as well go tab-delimited) reading from what you have (a combination of listwords with a "," delimiter, etc). GJK On Thu, 5 Jul 2007 18:48:51 -0400 "Vincent Medina" wrote: > I tried to read the file as is however when I do: > > [search db=db\import\rsdl.db&gelabdata=0] > [Numfound] records found > [founditems] > > [vendorstocknumber],[lab],[price] >
> > [/founditems] > [/search] > > I get 0 records.... > > When I list fields as is in: > > [ListFields db=db/import/rsdl.db] > Fieldname: [FieldName]
> [/ListFields] > > I see the ENTIRE first line of the db - It seems like it >is not recognizing > the first line as the field names. > I made a hdr file and eliminated the first line of field >names from the db > with the same result. Does WebDNA need to be told this >is a merge format? If > so how? ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
"Gary Krockover"
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:
OT: AppleScript question (2003)
[math] storage of variables (1997)
tag request (1999)
Creating main- and sub-category search (1997)
Bug? (1997)
Database not found in Include (2002)
[WebDNA] Encode cookies ONLY via "method=Base64" (2008)
Searching multiple Databases (1997)
(slightly off) using menu and [search] (1998)
[OT] WebDNA Family Album (2004)
Lookup Notfound (1998)
Uh...can someone help me out with the b10? (1997)
Running _every_ page through WebCat-error.html (1997)
send mail problem? (1997)
No luck with taxes (1997)
find with exceptions (1997)
Convert words (2002)
Proper file locations (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Emailer (WebCat2) (1997)