Page 1 of 1

Not certain if I'm at the right place for a .csv question

Posted: Mon Jul 11, 2011 5:17 pm
by Drachsi
I've just started and would like to know if I am at the right place. I have a form which automatically creates and populates a .csv file on my website. I can open and read the info in OpenOffice Cal. I would like to import this into a database. I have create a table with all the fields as the .csv file. The question is, can I import the info into my db and how would I do it. I'm no coder.

Thanks in advance

Drachsi

Re: Not certain if I'm at the right place for a .csv questio

Posted: Mon Jul 11, 2011 5:30 pm
by Villeroy
Which type of database? A local database or some database on your web-server?

Re: Not certain if I'm at the right place for a .csv questio

Posted: Mon Jul 11, 2011 6:41 pm
by rudolfo
Drachsi wrote:I have a form which automatically creates and populates a .csv file on my website.
[...]
I'm no coder.
How are you processing the form on your website? This is usually done by either a cgi programm, php, asp or Java Modules?
All these programming languages (or to be more precise their associated frameworks) make it very easy to write into a database, but it is rather complicated to write a csv file (if you want to do it in the right way with file locking for serialization).

80 percent of all the form input processig web applications that I know write the data from the form into a database. Another 18 percent sent them by mail and maybe 2 percent write them into a file. So the best thing to do is to directly put the evaluated form data into a database (on your webserver).

The last remark in paranthesis might be the show stopper for you ... if you can't run a database on your website.