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:

RE: WebCat: Access denied, but why? - The solution. (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) Limit on nested [ShowIf]'s? (1997) window.navigate(url) (2001) Emailer (WebCat2) (1997) FYI: virus alert (1996) aloha! (2002) [WebDNA] [sendmail] random duplicates (2010) [cart][date][time] (2003) Disappearing Inventory (2003) Attention SMSI - DOCS Error (2004) Upload files script (2003) NetScape problem (1999) WebMerchant and CyberCash Problem: repost (2000) formulas.db (2003) NT or Mac (1997) Comments in db? (1997) Browser Info.txt (1997) [WebDNA] Dan's WSC status request (2014) Plugin or CGI or both (1997)