LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
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.

Notices



Reply
 
Search this Thread
Old 06-22-2007, 12:06 PM   #1
metalx1000
Member
 
Registered: Jun 2006
Distribution: Debian
Posts: 111

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.

Thanks
 
Old 06-23-2007, 08:24 AM   #2
jlinkels
Senior Member
 
Registered: Oct 2003
Location: Bonaire
Distribution: Debian Wheezy/Jessie/Sid, Linux Mint DE
Posts: 4,236

Rep: Reputation: 545Reputation: 545Reputation: 545Reputation: 545Reputation: 545Reputation: 545
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 www.mysql.com). It makes your life easier if you want to access your data over the web.

jlinkels
 
Old 11-05-2008, 05:41 PM   #3
kvanderw
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.
BUT...
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, 08:44 PM   #4
PhilDHD
LQ Newbie
 
Registered: Sep 2010
Posts: 4

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

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.
 
  


Reply

Tags
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-27-2006 12:23 AM
default application for .csv ahz10 Linux - Software 2 11-04-2005 04:24 PM
help editing .csv files schneidz Programming 7 06-11-2005 05:09 PM
CSV File AMMullan Programming 2 11-10-2003 01:49 AM
tar and CSV lhoff Linux - Newbie 1 10-29-2002 01:23 PM


All times are GMT -5. The time now is 03:58 PM.

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