What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Re: CSV import suggestions

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 69158
interpreted = N
texte = How do I prevent WebDNA from caching these imported files. Can I not read these files in and extract the data I need line by line checking for "," and CR? Your suggestion would still require me to create another db in memory in order to import the data. Vince -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of John Peacock Sent: Thursday, July 05, 2007 12:45 PM To: WebDNA Talk Subject: Re: CSV import suggestions Vincent Medina wrote: > Anyone have any suggestions for me. I need to import a CSV file into a > webdna db. Type the following on one line: perl -MText::ParseWords -ne 'print join("\t", quotewords(",",0,$_[0])' < csv_file > tab_file YMMV under Windows (the quoting may need tweaking). John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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:

    
  1. Re: CSV import suggestions ( "Vincent Medina" 2007)
  2. Re: CSV import suggestions ( "Vincent Medina" 2007)
  3. Re: CSV import suggestions ( "Vincent Medina" 2007)
  4. Re: CSV import suggestions ( Matthew A Perosi 2007)
  5. Re: CSV import suggestions ( Stuart Tremain 2007)
  6. Re: CSV import suggestions ( John Peacock 2007)
  7. Re: CSV import suggestions ( Donovan Brooke 2007)
  8. Re: CSV import suggestions ( "Gary Krockover" 2007)
  9. Re: CSV import suggestions ( Donovan Brooke 2007)
  10. Re: CSV import suggestions ( "Vincent Medina" 2007)
  11. Re: CSV import suggestions ( "Vincent Medina" 2007)
  12. Re: CSV import suggestions ( "Vincent Medina" 2007)
  13. Re: CSV import suggestions ( "Vincent Medina" 2007)
  14. Re: CSV import suggestions ( John Peacock 2007)
  15. Re: CSV import suggestions ( Donovan Brooke 2007)
  16. Re: CSV import suggestions ( Paul Willis 2007)
  17. Re: CSV import suggestions ( John Peacock 2007)
  18. CSV import suggestions ( "Vincent Medina" 2007)
How do I prevent WebDNA from caching these imported files. Can I not read these files in and extract the data I need line by line checking for "," and CR? Your suggestion would still require me to create another db in memory in order to import the data. Vince -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of John Peacock Sent: Thursday, July 05, 2007 12:45 PM To: WebDNA Talk Subject: Re: CSV import suggestions Vincent Medina wrote: > Anyone have any suggestions for me. I need to import a CSV file into a > webdna db. Type the following on one line: perl -MText::ParseWords -ne 'print join("\t", quotewords(",",0,$_[0])' < csv_file > tab_file YMMV under Windows (the quoting may need tweaking). John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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/ "Vincent Medina"

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:

different ship dates and shopping carts -- how to? (1997) date sorting and 'template (1997) WebCat and WebTV (1997) Keep away (1997) WebCat2 several catalogs? (1997) Changing SubTotal (2003) cookies (2004) possible, WebCat2.0 and checkboxes-restated (1997) Share cost of training videos! (1998) EmailProblem (2003) WC2b12: Yes, Formulas.db is for real (1997) Emailer Chokes on bad address (1997) Shipcost lookup? (1997) [WebDNA] Installing WebDNA on Windows 7 64 Bit, Home Premium (2010) creator code (1997) minimalist shopping cart. (1997) WebCatalog for guestbook ? (1997) Exclude by date - multiple (1997) b18 problem on NT 4.0 (1997) file browser. (2002)