Share your knowledge at the LQ Wiki.
Go Back > Forums > Non-*NIX Forums > Programming
User Name
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.


  Search this Thread
Old 06-22-2007, 11:06 AM   #1
Registered: Jun 2006
Distribution: Debian
Posts: 112

Rep: Reputation: 16
odb to csv

I'm new to OpenOffice Base.
But I think I'm catching on fast.
I've created a Data Base in Open office and created a form for it.
what I want to do now is convert the .odb files that is saved and convert it to a csv text file with a shell script so I can display the output on my webserver (apache) with a CGI script.

But I can't find anything to convert ODB files to csv.

If some one can suggest a program to do this or if there is a better way to do this (which I'm sure there is) please let me know or point me to a tutorial.

Old 06-23-2007, 07:24 AM   #2
Senior Member
Registered: Oct 2003
Location: Bonaire, Leeuwarden
Distribution: Debian /Jessie/Stretch/Sid, Linux Mint DE
Posts: 4,958

Rep: Reputation: 875Reputation: 875Reputation: 875Reputation: 875Reputation: 875Reputation: 875Reputation: 875
Well, I hate to tell someone that what he or she is doing seems to be completely on the wrong track, and that one should use approach ABC instead of XYZ.

Using OOBase is fine if that is you application, but creating and maintaing a database in Base, exporting it every time and interface the result to a web server is extremely cumbersome. It also means that you have to re-export the database to CSV every time you changed it.

I can recommend that you have a look at MySQL. It is a database server which can interface easily with your web server thru perl, cgi or PHP. To get your data into MySQL there exist a number of front ends (including OOBase if I am not mistaken) But you can also use text import, bash scripting or command line input.

There is almost no learning curve for MySQL, follow the tutorial (chapter 3 in the MySQL documentation on It makes your life easier if you want to access your data over the web.

Old 11-05-2008, 04:41 PM   #3
LQ Newbie
Registered: Oct 2004
Location: Oklahoma City, OK
Distribution: Gentoo, Fedora, RH, Mandrake
Posts: 1

Rep: Reputation: 1
Solution to ODB conversion to CSV

I found this thread, looking for the answer to the original question.

Here is the answer.
Based on OO3

I built a query to filter by original database.
Punched all kinds of buttons looking for export... never found it.
They did make it simple... maybe too simple.

* Opened a spreadsheet window full screen
* brought smaller window of query result to forground
* hit the button at the bottom to go to the "end" of the query.
* hit the top left corner (above row numbers, left of column names) with mouse to select all records.
* drug (dragged?) the same corner to cell A1 of the spreadsheet
* Whalla! it copied the results of the query to the spreadsheet.
* just did save as CSV at that point and the project was done.

Thought someone else would like the details, since two of use spent near an hour each looking through menus, and right clicks, etc... nothing obvious.
Just got lucky with the drag thing.
1 members found this post helpful.
Old 03-28-2011, 07:44 PM   #4
LQ Newbie
Registered: Sep 2010
Posts: 7

Rep: Reputation: 2
Thanks kvanderw - you certainly helped me with this.
Old 03-29-2011, 09:14 AM   #5
Registered: Jun 2006
Distribution: Debian
Posts: 112

Original Poster
Rep: Reputation: 16
I said what?

Wow, this was a long time ago, and jlinkels is right.
I don't even remember asking this question or why I was trying to do this.
I'm sure I had my reasons.


csv, script, shell

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
CSV and CUT wwnexc Linux - Software 11 01-26-2006 11:23 PM
default application for .csv ahz10 Linux - Software 2 11-04-2005 03:24 PM
help editing .csv files schneidz Programming 7 06-11-2005 04:09 PM
CSV File AMMullan Programming 2 11-10-2003 12:49 AM
tar and CSV lhoff Linux - Newbie 1 10-29-2002 12:23 PM > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 04:36 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration