Open Office databases

Jeffrey Needle jeff.needle at gmail.com
Wed Dec 22 06:05:39 UTC 2010


Sheesh, posted this with the wrong header.  Big screw up -- sorry!

On Wed, 22 Dec 2010 06:02:48 +0000, Jeffrey Needle wrote:

> On Mon, 13 Dec 2010 10:21:43 -0500, stan wrote:
> 
>> For quite some time now my Ubuntu worksations has been exhibiting an
>> extremly anoyig behavior. When a error dialog widow pos up, it is
>> either invislble, or so light that I cannot se it, untill the mouse
>> happens to cross it, at which time it appears at full brightness.
>> 
>> Up untill now, I have ust been living with this. But, this morning a
>> RDP session timed out whule I was away from the machine. This made teh
>> keyboard, and mouse clicks appear o be non fucntionsl. I came really
>> close to rebooting the machine to solve this problem, before teh mouse
>> acidently moved over the error dialog.
>> 
>> How can I defeat this behavior?
> 
> I have found OO database to be clunky, and then discovered how to get
> around a lot of it.  I'm sure you know all this, but for the record:
> 
> 1.  If your database doesn't have a key field with a unique identifier,
> all kinds of things don't work correctly.
> 
> 2.  If you don't have Java installed, likewise, all kinds of things
> screw up.
> 
> My general approach:
> 
> 1.  Import your csv file into OO Spreadsheet -- just open the file using
> the spreadsheet module.
> 
> 2.  Add a column at the beginning for the key field.  Autofill it down
> in a series, beginning with 1, and incrementing by 1.
> 
> 3.  Create your database table in the database module.
> 
> 4.  Copy the entire spreadsheet into the clipboard, go back to the
> database module, highlight the table you want to include the data, and
> simply paste.
> 
> All your data is now in database.  You can then easily create forms and
> reports.
> 
> Best.






More information about the ubuntu-users mailing list