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
Not certain if I'm at the right place for a .csv question
Not certain if I'm at the right place for a .csv question
OpenOffice 3.3 on Windows 7
Re: Not certain if I'm at the right place for a .csv questio
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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Not certain if I'm at the right place for a .csv questio
How are you processing the form on your website? This is usually done by either a cgi programm, php, asp or Java Modules?Drachsi wrote:I have a form which automatically creates and populates a .csv file on my website.
[...]
I'm no coder.
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.
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.