OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Ubuntu: Foxpro DBF files not opening

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
robbyn
OOo Advocate
OOo Advocate


Joined: 29 Mar 2004
Posts: 320

PostPosted: Mon Nov 29, 2010 2:47 pm    Post subject: Ubuntu: Foxpro DBF files not opening Reply with quote

General error. i/o error.

In the past no problems the dbf file would open in calc.

What should I do to be able to read dbf files in calc?

Robin
_________________
Robin

When you love a delicate rose remember she has thorns and a root. In time the petals will fall away.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Nov 29, 2010 3:25 pm    Post subject: Reply with quote

Try Base which is the right component for database data.
File>New>Database...
Connect to existing database of type dBase
Specify the directory of your .dbf files. dBase is a database in a directory.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
robbyn
OOo Advocate
OOo Advocate


Joined: 29 Mar 2004
Posts: 320

PostPosted: Mon Nov 29, 2010 3:38 pm    Post subject: Reply with quote

Of course you are right, but I would prefer to use calc. I recently did a fresh install of ubuntu and I wonder if this is behind the problem. Are there some specific addons to enable calc to read dbf files?
_________________
Robin

When you love a delicate rose remember she has thorns and a root. In time the petals will fall away.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Nov 29, 2010 3:46 pm    Post subject: Reply with quote

You can read all database data into all office documents through Base.
Hit F4 and drag the table icon (or a query) onto a calc cell in order to get a link.
Drag selected records or all records (top left corner) from a visible row set in order to get a copy.
Data pilots directly from databases are possible.
You can add dynamically resizing calculations, charts, formattings in Calc so you get much more than you could get from a direct import.
[Tutorial] Using registered datasources in Calc
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
robbyn
OOo Advocate
OOo Advocate


Joined: 29 Mar 2004
Posts: 320

PostPosted: Thu Dec 02, 2010 2:45 pm    Post subject: Reply with quote

Until a few weeks ago I was able to click on a dbf file and load it into calc. This no longer happens. I had never used base or registered databases through it. Can you think why I can not simply use calc to open a dbf file?
_________________
Robin

When you love a delicate rose remember she has thorns and a root. In time the petals will fall away.
Back to top
View user's profile Send private message
robbyn
OOo Advocate
OOo Advocate


Joined: 29 Mar 2004
Posts: 320

PostPosted: Sat Dec 11, 2010 3:06 pm    Post subject: Reply with quote

I found that I need to have base installed. It so it, Calc will open dbf files by clicking on them.
_________________
Robin

When you love a delicate rose remember she has thorns and a root. In time the petals will fall away.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Dec 12, 2010 6:08 am    Post subject: Reply with quote

robbyn wrote:
I found that I need to have base installed. It so it, Calc will open dbf files by clicking on them.

Thank you for this valuable piece of information. I would have thought that the ability to open dbf in Calc does not depend on the Base component.
Another reason to avoid the rather experimental Linux packages.
Nevertheless Base is the far more appropriate component to handle dbf.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Tue Dec 14, 2010 2:02 am    Post subject: Reply with quote

Hello

Maybe special for Villeroy. I think the not complete install of OOo-base is more a problem of Ubuntu then of linux. I use a long time openSUSE and standard all parts are installed. They work in a way I expect OOo works.

I have tried and with a little knowledge it is real easy to make a server with the HSQLDB database. The same is possible for other database servers but I have not tried.

Also I think all things for text and some more are ready with a default install. I'm not sure but I think it does not matter what windows manager you choose. On this moment I have 4 window managers but use most of the time only XFCE

This is only for information to make clear that openSUSE is a good distro

Romke
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Tue Dec 14, 2010 7:44 am    Post subject: Reply with quote

I see. OpenSuse installs its office suite with batteries included. But HSQLDB is not a solution when you are confronted with DBF. There is plenty of busines software producing these bread&butter database files (in Germany at least).
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
crns13
Newbie
Newbie


Joined: 21 Jan 2011
Posts: 1
Location: São Paulo - SP - Brasil

PostPosted: Tue Dec 06, 2011 10:26 am    Post subject: Reading dbf files Reply with quote

robbyn wrote:
I found that I need to have base installed. It so it, Calc will open dbf files by clicking on them.


Yes, to read dbf files in calc just install (if it's not installed) base.

Thank you so much.

PS.: I'm using LibreOffice now. But it's the same problem/solution.
Back to top
View user's profile Send private message Send e-mail
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Tue Dec 06, 2011 11:23 am    Post subject: Reply with quote

Again, dBase is about databases. A simple typo in Calc may change the field type so the table is no more valid in a database context. Connect a Base document with a dBase directory, edit the database data with a set of input forms, link or copy the stored data in Calc, use them with Writer for mail merges and bibliographies. But do not directly load your precious data into a spreadsheet.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group