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 = 113172
interpreted = N
texte = 760 --001a11352d36b16ea105410ce5be Content-Type: text/plain; charset=UTF-8 Hi Ken, I had tried opening it before and I got an error. I had already been doing a lot of processing of the file after converting the commas manually, I have the text manipulation down pretty good :) I just tried it again in a different way and as you suggested, it did automatically convert properly. There was clearly something wrong the way I was doing it before. All good now. Thank you. Now I can consolidate my steps and make things easier all around :) Dale On Fri, Nov 11, 2016 at 12:45 PM, Kenneth Grome wrote: > 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 > --001a11352d36b16ea105410ce5be Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Ken,

I had tried opening it before a= nd I got an error. I had already been doing a lot of processing of the file= after converting the commas manually, I have the text manipulation down pr= etty good :)

I just tried it again in a different = way and as you suggested, it did automatically convert properly. There was = clearly something wrong the way I was doing it before.=C2=A0

=
All good now. Thank you.

Now I can cons= olidate my steps and make things easier all around :)

<= div>Dale

On Fri, Nov 11, 2016 at 12:45 PM, Kenneth Grome <ken@webdnasoluti= ons.com> wrote:
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=3D1

But first you should know that WebDNA is supposed to be able to
open and read CSV files.=C2=A0 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 <talk@webdna.us&g= t;.
To unsubscribe, E-mail to: <talk= -leave@webdna.us>
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 --001a11352d36b16ea105410ce5be-- . 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)
760 --001a11352d36b16ea105410ce5be Content-Type: text/plain; charset=UTF-8 Hi Ken, I had tried opening it before and I got an error. I had already been doing a lot of processing of the file after converting the commas manually, I have the text manipulation down pretty good :) I just tried it again in a different way and as you suggested, it did automatically convert properly. There was clearly something wrong the way I was doing it before. All good now. Thank you. Now I can consolidate my steps and make things easier all around :) Dale On Fri, Nov 11, 2016 at 12:45 PM, Kenneth Grome wrote: > 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 > --001a11352d36b16ea105410ce5be Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Ken,

I had tried opening it before a= nd I got an error. I had already been doing a lot of processing of the file= after converting the commas manually, I have the text manipulation down pr= etty good :)

I just tried it again in a different = way and as you suggested, it did automatically convert properly. There was = clearly something wrong the way I was doing it before.=C2=A0

=
All good now. Thank you.

Now I can cons= olidate my steps and make things easier all around :)

<= div>Dale

On Fri, Nov 11, 2016 at 12:45 PM, Kenneth Grome <ken@webdnasoluti= ons.com> wrote:
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=3D1

But first you should know that WebDNA is supposed to be able to
open and read CSV files.=C2=A0 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 <talk@webdna.us&g= t;.
To unsubscribe, E-mail to: <talk= -leave@webdna.us>
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 --001a11352d36b16ea105410ce5be-- . 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:

dates as search criteria (2000) & in Lookups (1997) suggestions for a Windows based text editor? (2004) eMail volume (2000) [isfile] ? (1997) WebCat 4 Unix/Linux for sale (2003) wc 2 pro users - sites, quotes wanted (1997) [WebDNA] Search comparisons in 8.6.1 (2019) Webcatalog server support (1997) Taxes rates based on item and State (1998) carriage returns in data (1997) [WriteFile] problems (1997) [WebDNA] Use of :global: (2013) Updating emailer (server) (2000) MacWEEK article help needed (1996) problems with 2 tags (1997) New Plug-in and Type 11 errors (1997) Multiple prices (1997) A multi-processor savvy WebCatalog? (1997) WebCatalog for guestbook ? (1997)