MEPIS Community Forum

Hi,

I'm having trouble with my OpenOffice database. I recently installed Mepis 11 on my laptop and replaced LibreOffice with OpenOffice by using a Squeeze repository as discussed in this thread: http://forum.mepiscommunity.org/viewtopic.php?f=84&t=30753. I did this because apparently LibreOffice is not compatible with a database created in OpenOffice.

My problem is that my database reads normally on my Mepis 8.5 machine, but when I copy it to the Mepis 11 laptop and open it with the OpenOffice on there, the table shows many, many of the same record interspersed throughout, and the records are all out of order. Many records are not there at all.

I thought something got corrupted in the transfer, but I tried it again and it did the same thing.

I read somewhere that OO Base requires some kind of Java to work properly, and that it comes with an old version. I looked on the OO website, and if you download a Debian package from them it doesn't include the Java for some reason. Does it not include it from the repository? Could this be why it's acting up?

If this can't be solved, I might have to go back to 8.5 on the laptop.

BTW: I created this database entirely in OpenOffice, and didn't change anything about what SQL it uses, so I don't actually know. It's whatever is default in OO Base.

Thanks!

Wish I know more and could help.

Learning ins and outs of Base in LO and will be watching this thread

From what I gather from Googling, LO can't use a database created in OO.

Any help would be appreciated, or if no one knows, I might just install 8.5 on my laptop.

I have also posted this question on the OpenOffice forum, but no response there yet.

Thanks!

the schism between the two projects has already been clearly defined. java will remain the primary language for extending Oo, while the LO devs have decided upon python.

this may be part of the reason why you're having issues opening DB files.

If you haven't done this already, you might want to look at the LO Base forum and maybe even register and post a question there. Something like your question has in fact recently been posted (is that you?).

I have posted questions there and found the participants very knowledgeable and helpful.

Good afternoon group;

I sure hope that Libre Office does not do something like that with out having some form of way to convert Open Office to Libre Office. You read of of many people having problems now with files they need to use not being seen by OO. Add another twist to the mix can not be a good thing for people wanting to use the product. But having files from another product.

Good Afternoon reidun;

I do not know if this will help you. But in the above maentioned LO Forum. A person was told to go back and use Java 1.5. You have to go down the Topic List to one labled something like OO LO issues.
The reply says LO has issues useing some of the newer versions of Java.

From what I read in the first post in this thread it sounds like reidun removed LibreOffice and installed the Debian Squeeze OpenOffice.org packages, so why would his problem have anything to do with LibreOffice?

I'm guessing reidun might not have completely removed all of LibreOffice or may not have completely installed everything required For OpenOffice.org (or maybe a combination of both).

There's more to removing LibreOffice than just removing all the packages with 'libreoffice' in their names. Listed below are the packages related to LibreOffice (excluding the libreoffice-l10n-** and libreoffice-help-** packages). The packages come from here: ftp://ftp.mepis.com/mepis/pool/main/libr/libreoffice/. Note that they are all version '...3.3.2-3'. The packages highlighted in red don't contain 'libreoffice' in their name and you should make sure they've been removed because they might interfere with the installation/operation of their OpenOffice.org counterparts.

Right you are--I misread OP.

That is what I did. The only reason it would have anything to do with LO, is that if OO gets dropped in the future, it would be nice if LO could seamlessly read OO files.



I did check, and I didn't have any of the files in red installed, so should be good there.

I also asked this question on the OO forum, and someone replied saying that the database not reading properly is a known bug in 3.2.1, and to solve it download 3.3 directly from the OO site. I think I will try this, as much as I hate not being able to use the repositories, which make installing/updating sooo much easier!

Will post my results after installing 3.3.

Thanks all!