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:
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)