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 = 761Import 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 tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us.
Associated Messages, from the most recent to the oldest:
761Import 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 tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug 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)