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

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

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

Postby Drachsi » Mon Jul 11, 2011 5:17 pm

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
OpenOffice 3.3 on Windows 7
Drachsi
 
Posts: 1
Joined: Mon Jul 11, 2011 5:10 pm

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

Postby Villeroy » Mon Jul 11, 2011 5:30 pm

Which type of database? A local database or some database on your web-server?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 27713
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby rudolfo » Mon Jul 11, 2011 6:41 pm

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.
OpenOffice 3.1.1 (2.4.3 until October 2009) and LibreOffice 3.3.2 on Windows 2000, AOO 3.4.1 on Windows 7
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.
rudolfo
Volunteer
 
Posts: 1488
Joined: Wed Mar 19, 2008 11:34 am
Location: Germany


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 1 guest