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

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 113170
interpreted = N
texte = 758 --94eb2c12e3d865c02905410a4654 Content-Type: text/plain; charset=UTF-8 Hi, 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. From 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. Thank you for any suggestions and recommendations on how to accomplish this. Dale --94eb2c12e3d865c02905410a4654 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

I have a couple of source files tha= t are actually comma delimited files files that I am using to update a WebD= NA file. At the moment I am manually replacing the commas with tabs and rem= oving the colons that are in the source file before uploading to the server= ..

From there I uses WebDNA contexts to clean up th= e 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 c= onvert the commas to tabs and remove the colons programatically? The data i= s 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.<= /div>

Thank you for any suggestions and recommendations = on how to accomplish this.

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 --94eb2c12e3d865c02905410a4654-- . 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)
758 --94eb2c12e3d865c02905410a4654 Content-Type: text/plain; charset=UTF-8 Hi, 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. From 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. Thank you for any suggestions and recommendations on how to accomplish this. Dale --94eb2c12e3d865c02905410a4654 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

I have a couple of source files tha= t are actually comma delimited files files that I am using to update a WebD= NA file. At the moment I am manually replacing the commas with tabs and rem= oving the colons that are in the source file before uploading to the server= ..

From there I uses WebDNA contexts to clean up th= e 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 c= onvert the commas to tabs and remove the colons programatically? The data i= s 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.<= /div>

Thank you for any suggestions and recommendations = on how to accomplish this.

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 --94eb2c12e3d865c02905410a4654-- . dale

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:

Generating unique SKU from [cart] (1997) Encryption (2000) Extended [ConvertChars] (1997) Same DB Same Time (2004) required fields (1999) WebCat editing, SiteGuard & SiteEdit (1997) Exclude by date - multiple (1997) To use GREP to boldface text (2003) [OT] WebDNA Family Album (2004) WebDNA 5 - Function test weirdness or ? (2003) UnitShopCost (2007) NT considerations (1997) [if] and [showif] (2002) security (1997) Shopping with Accounts (2003) RE: Answer: WebDelivery downloads alias, not original ? (1997) WebCatalog Mac 2.1b3 (1997) webcat- multiple selection in input field (1997) WebCat2 - Getting to the browser's username/password data (1997) WebDelivery Self-Destruct Timer (2000)