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