Re: [WebDNA] Converting a CSV file to a WebDNA db automatically?

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 113173
interpreted = N
texte = 761 Import into MS Excell, then copy all the data and paste it into a new = text document, you will find that all is now tab delimited. > On 12 Nov. 2016, at 05:01, dale wrote: >=20 > Hi, >=20 > I have a couple of source files that are actually comma delimited = files files that I am using to update a WebDNA file. At the moment I am = manually replacing the commas with tabs and removing the colons that are = in the source file before uploading to the server. >=20 > =46rom there I uses WebDNA contexts to clean up the data before = updating my live data. I was wondering is there a way that I should be = able to upload the raw csv file to the server and use WebDNA to convert = the commas to tabs and remove the colons programatically? The data is = always in the same format so I will have a header file on the server for = the field names. That would allow me to automate the process even = further. >=20 > Thank you for any suggestions and recommendations on how to accomplish = this. >=20 > Dale > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Converting a CSV file to a WebDNA db automatically? (Stuart Tremain 2016)
  2. Re: [WebDNA] Converting a CSV file to a WebDNA db automatically? (dale 2016)
  3. Re: [WebDNA] Converting a CSV file to a WebDNA db automatically? (Kenneth Grome 2016)
  4. [WebDNA] Converting a CSV file to a WebDNA db automatically? (dale 2016)
761 Import into MS Excell, then copy all the data and paste it into a new = text document, you will find that all is now tab delimited. > On 12 Nov. 2016, at 05:01, dale wrote: >=20 > Hi, >=20 > I have a couple of source files that are actually comma delimited = files files that I am using to update a WebDNA file. At the moment I am = manually replacing the commas with tabs and removing the colons that are = in the source file before uploading to the server. >=20 > =46rom there I uses WebDNA contexts to clean up the data before = updating my live data. I was wondering is there a way that I should be = able to upload the raw csv file to the server and use WebDNA to convert = the commas to tabs and remove the colons programatically? The data is = always in the same format so I will have a header file on the server for = the field names. That would allow me to automate the process even = further. >=20 > Thank you for any suggestions and recommendations on how to accomplish = this. >=20 > Dale > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us . Stuart Tremain

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:

How to remove comments with grep? (2003) Generating Report Totals (1997) Setting Cart value (2000) beta 2 Plugin (2000) setting taxable to true (1997) [OT] SMTP access (2003) relational db question (2002) Robert Minor duplicate mail (1997) WebCat/Typhoon Status under Windows (1998) RE: [WebDNA] ONLY the FIRST continuous run of numeric chars? (2008) MySQL and Numbers (2005) Windows 2.1b2 Append Bug? (1997) emailer (1997) Spell Check (2000) WebCat2 as a chat server? (1997) RE: Languages (1997) [append] and SSL (1997) Form based Redirect (2001) Case sensitivity and [showif] (1999) WebCat2b13MacPlugin - [math][date][/math] problem (1997)