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 = 113171
interpreted = N
texte = 759 You can get started by looking at the tags and contexts listed under "text manipulation" on this page: http://www.webdna.us/page.dna?numero=1 But first you should know that WebDNA is supposed to be able to open and read CSV files. Have you tried opening one of your CSV files directly in WebDNA? If it works, you should be able to do a search for all records, write all fields/values to a new text file, give the new file a ..db suffix, then use it directly in WebDNA. Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Administration On 11/11/2016 12:01 PM, dale wrote: > 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 > --------------------------------------------------------- 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:
759 You can get started by looking at the tags and contexts listed under "text manipulation" on this page: http://www.webdna.us/page.dna?numero=1 But first you should know that WebDNA is supposed to be able to open and read CSV files. Have you tried opening one of your CSV files directly in WebDNA? If it works, you should be able to do a search for all records, write all fields/values to a new text file, give the new file a ..db suffix, then use it directly in WebDNA. Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Administration On 11/11/2016 12:01 PM, dale wrote: > 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 > --------------------------------------------------------- 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 .
Kenneth Grome
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:
Multiple catalog databases and showcart (1997)
Capitalize (2003)
Quickie question on the email templates (1997)
Include a big block of text (1997)
Emailer (1998)
WebCatalog NT beta 18 problem (1997)
database size? (1997)
Web Catalog 2 demo (1997)
Running 2 two WebCatalog.acgi's (1996)
Colors in cart (2002)
Sending mail (2001)
NT vs Mac (1997)
[SearchString] problem with [search] context (1997)
Hideif / Showif (1998)
Chatroom (2000)
Summing fields (1997)
WebCatalog 3.0.8 Mac OS (2000)
Thanks ! (1997)
Bad "from" address in sendmail (2004)
hidden (phantom) file downloads (2000)