LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 06-28-2004, 09:22 PM   #1
supes
LQ Newbie
 
Registered: Apr 2004
Posts: 18

Rep: Reputation: 0
The Amazing Database I Can't Use... Can I?


Greetings all...

I recently spent a few days, full days more or less, developing a kick-@ss quotations database in Filemaker Pro 7. There were tables like Author, Source, and Citation, intertwined to give me maximum searching and browsing capability between and among them. Filemaker's "Portals" allowed me to display lists of similar citations, for instance, or citations with the same source or author, etc. I could click on these portal rows and be whisked to the record in question. I had designed it, tweaked it, tested, and began to use it. And as I am about to return to graduate school, I was pretty sure this was like the smartest thing I'd ever done.

But as all this was going on, I was also on a single-minded mission to ditch Windows forever. I was, and remain, convinced that my day-to-day quality of life is better when I don't have to deal with that OS or anything having to do with it.

Unfortunately for me, this means leaving my kick-@ss database behind, and the closer I get to going back to school, the more I am doubting the judgement I made. I've tried installing Filemaker 7, 6, and 5.5 using the latest Wine. No dice. I've tried finding a way to publish the Filemaker database using the internet, or access it using some other means. No dice. Finally I've tried finding a similar program in Linux that I can use to develop a comparable database from scratch. No dice. (I don't think I'm smart enough - Filemaker is really easy).

So my question is this: does anyone know of any way I can resolve this problem short of having to reinstall Windows on my machine (which I really do not want to do because XP has a way of hijacking the box and making it difficult to salvage Suse).
 
Old 06-29-2004, 07:26 AM   #2
Cerbere
Member
 
Registered: Dec 2002
Location: California
Distribution: Slackware & LFS
Posts: 799

Rep: Reputation: 33
I don't know a thing about Filemaker, but according to their website, it can export databases to (among others) dbase, or comma- or tab-separated text. Either of these formats can be imported into OpenOffice.org's database.

So you would need access to a windows machine on which you can install Filemaker, then open your kick-@ss database and export it to one (or both) of the formats listed above, then transfer that to your linux box and open it in OpenOffice.

I would suggest exporting it in every format that Filemaker will allow, then burning it to CD. That way you'll have the best chance of importing it into whatever database program you feel most comfortable with.

Enjoy!
--- Cerbere
 
Old 06-29-2004, 03:42 PM   #3
supes
LQ Newbie
 
Registered: Apr 2004
Posts: 18

Original Poster
Rep: Reputation: 0
thanks for the suggestions. my only concern is that all of the form capabilities i've built into the Filemaker DB would be lost in another program. i'm worried that essentially I'll only be able to get to the data (i hadn't entered a whole lot into it anyway). so it's not really the records that i'm trying to salvage, it's the structure tof the DB itself - the relationships and how records can be displayed and interwoven.

but it's good to know that OpenOffice has a DB program. maybe i can build something similar using that.
 
Old 06-29-2004, 03:56 PM   #4
Lleb_KCir
Senior Member
 
Registered: Nov 2003
Location: Orlando FL
Distribution: Debian
Posts: 1,765

Rep: Reputation: 45
IIRC, there is a way to make your database live via the web with filemaker pro. its been almost 5 years since i used filemaker, but i belive there is a way to host your data live. that does requrie a M$ system to hose like win2k server, but it is doable.
 
Old 06-29-2004, 04:13 PM   #5
michaelk
Moderator
 
Registered: Aug 2002
Posts: 11,807

Rep: Reputation: 721Reputation: 721Reputation: 721Reputation: 721Reputation: 721Reputation: 721Reputation: 721
I have sed Filemaker for awhile too and its ease of creating reports makes it the applications of choice for many of my tasks. Generally speaking any SQL relational database should be capable of searching based on any relationship but they lack the front end. OpenOffice can be a frontend for mysql, postgresql and other ODBC/JDBC SQL databases. I don't know what the extend of its report writing capabilities.
 
Old 06-30-2004, 09:54 AM   #6
supes
LQ Newbie
 
Registered: Apr 2004
Posts: 18

Original Poster
Rep: Reputation: 0
Thanks Folks...

Thanks all. For the time being, I've (ugh) reinstalled Windows on my box so that I can get the most out of this DB. Hopefully, in the near future I'll be able to figure out some sort of workaround, but for now this is OK I guess. My only problem now is that the partition I created for my data (and to be accessible by both OSes) is read-only in Linuz and I can't change the permissions, even in Super-User mode). I'm sure I'll figure it out though.

Thanks again all....

supes
 
Old 06-30-2004, 10:53 AM   #7
kevinatkins
Member
 
Registered: Jan 2004
Location: cheshire, uk
Distribution: Ubuntu Hoary
Posts: 605

Rep: Reputation: 31
database programs for linux...

well, i think the situation is gradually improving, at least in respect of easy-to-use front ends -

servers - mysql, postgresql, etc.

front ends for above -

openoffice.org. note - i've used this with mysql, connected via odbc. from memory it was a *swine* to set up, and it doesn't sport the sort of nice functionality you might see in, say, ms access

rekall is meant to be very good - i've as yet been unable to get it to compile, which is a bummer...

there's also kexio (i think that's what it's called), but i know nothing about it.

i think you're going to end up having to do a re-design with linux-based programs...
 
  


Reply


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
SpamAssassin 2.6 -- truly amazing dcexplorer Linux - Software 1 11-26-2003 02:13 AM
Linux = Amazing ooagentbender LinuxQuestions.org Member Success Stories 2 11-13-2003 08:02 AM
Slack (9.0) is truly amazing! PapaNoHair Slackware 26 05-07-2003 04:22 PM
My amazing floppy problem.. katana Linux - General 1 11-20-2002 04:43 AM
amazing! CtrlAltDel Linux - Distributions 8 10-03-2002 06:55 PM


All times are GMT -5. The time now is 10:21 AM.

Main Menu
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