Ubuntu :: Database To Replace Openoffice Base?
May 11, 2011
I am currently learning an African language. As I have been learning it, I have put together a dictionary, which I made as an openoffice database, so I could search and edit as necessary. Unfortunately, it now has several thousand entries and grinds to a complete halt if I try and search it. For now I have exported the data into a pdf which means I can look words up, but it doesn'tan alternative programme which would cope better with this much data and be easy to set up? Ideally one I can export my current data into.
View 1 Replies
ADVERTISEMENT
Sep 23, 2010
Everywhere I read, this seems to come up as a very difficult thing. Just want to record how I did it.
In Access, export the table to an Excel Spreadsheet. Using Openoffice, open the Spreadsheet, but save as an Openoffice (.ods) spreadsheet. ( Note - According to the Base help files, if you import an Excel Spreadsheet, it is read-only)
Open Base and Create a database. No tables, no nothing, just create. Now Open this and and also Open the spreadsheet. Select all the data in the spreadsheet, 'copy' it, and in the Database tables area, 'paste' it. I had problems in that it wanted to create a primary key, so added an extra field.
I then went into the database design view, right click on the appropriate field to make that the primary key, and remove the primary key from the unwanted field.
Delete the excess column. This is just for a single flat table, with no linking to other tables. I hope that this helps someone. I did it for a membership database table, and have been able to replicate the query to filter for the Snailmail folks (Those that did not have an email address in the table). Still trying to figure out how to do an envelopes report though.
View 5 Replies
View Related
Mar 29, 2010
I have upgrade my Fedora to 12, i was trying to use the Openoffice database and can not find it loaded under application>office. Does anybody know why it is not loaded? I try to activate it via yumex, after installation, it comes up with bug errror report and Selinux error also comes up when try to use the BASE.
View 1 Replies
View Related
May 10, 2010
Every couple of hours OOo Base crashes - just closes the program of its' own accord.
Annoying enough in itself, but at least it usually recovers up to the last point I saved my work. The last time it happened though it didn't even recover to my last save point - it recovered to an old save point! So I have lost 30 minutes' work.
View 3 Replies
View Related
Mar 31, 2011
I have set up an OpenOffice (3.2) Base database - tables, mainly, and a few queries. The main table contains about 9000 rows and around 50 fields and there is a second table of 1900 rows and 20 fields and a few other tables with either fewer rows or many fewer fields. The primary key on the main table is a single text field. The .odb file is 4.4Mb. There are no Forms or Reports; the idea at the moment is that I enter data using OO's Table data view. I see that I have an embedded HSQL database and I cannot change dit>Database>Properties because it is greyed out.
Opening the database is reasonably quick (about 5 sec) but then when I want to look at any but the smallest of tables (in data Table view) it is very slow (15 sec on the main table) to display the first group of rows. When I want to move to show a different record it takes just as long to display the new set of rows. It makes no difference whether the new set of records is adjacent (in terms of record order) or a long way off. I need to speed this up x3 or more or I will have to abandon Base as impractical to use.
On the OO Forum some posts talk of separating the database from the engine and others of increasing the cache size. I can't do the latter as access is via the greyed out option and I can't find any instructions for the former. I'm not convinced these would have much effect anyway.
View 5 Replies
View Related
Sep 9, 2010
i have configured ldap server on a Debian5. But Am failing to import base.ldif, mygroup.ldif and myuser.ldif into my ldap database. How can i do that?
View 1 Replies
View Related
Jun 22, 2010
I am trying to start OpenOffice Base (3.2.0) but it keeps crashing once I begin to edit a new data base. Calc, Writer and Impress work fine.
ramack@ramack2:~$ soffice -base
ramack@ramack2:~$ libgcj failure: gcj linkage error.
Incorrect library ABI version detected. Aborting.
I haven't a clue as to how to fix this one. A web search finds a Debian bug that a couple years+ old. The bug has since been resolved. It crashes if run as root too
View 2 Replies
View Related
Jan 9, 2011
I have installed openoffice.org-base and openoffice.org-base-core in an updated fedora 14 environment. Clicking on openoffice-base in applications->office->openoffice-Base fails to lauch with the message:"This operation is not supported onhis operating ystem."Installation of mysql and mysql-server does not help.
View 14 Replies
View Related
Jun 14, 2010
I tried to create a report from a table which contains text and image fields. The created report show text fields well but only empty fields as Images. How can I do that?
View 1 Replies
View Related
Apr 27, 2011
I have a list of approximately 50 words that I'd like to search documents for and delete those words. I was wondering if there is some type of automated process for removing multiple words rather than me manually putting each word into 'find and replace'
On that note I guess I could write the Macro in python if there isn't anything out there that does this. However I read that open office only works with python 2.3.5 or something of that nature, and I have already installed 3.1. Is that still going to be an issue?
View 2 Replies
View Related
Oct 25, 2010
I have OO.o 3.1.1.4 installed on my SuSE 11.2 system. (It came with it.)I've tried connecting to my older OO.o address book database and it seems to have connected (I get no error messages) but when I try to open the database source from within Writer, or any other OO.o tool (either by pressing F4 or going to View > Data Sources) OpenOffice crashes. I can open my database as an .ods or a .dbf or .odb.When I open it as an .odb, I end up with some sort of form wizard designer. All looks ok, the table is there (and it looks good!) but then what? If I close that wizard, the table then closes with it.
I've also used File > Templates > Address Book Source. After using that, if I hit F4, OOo crashes.My main problem is that OO.o crashes when I try to view the database source from within a document.P.S. I do have Java (Sun's version of Java 1.6.0) installed and OO.o seems to know it's there and is registered.
View 8 Replies
View Related
Mar 14, 2009
I'm using Kubuntu 8.04 and now I've installed OpenOffice 3, both in Spanish.I have oracle client installed and can connect to Oracle databases with clients like tora.What I try:
- Open Database and select connect to an existing database.
- Select Oracle JDBC.
- Next
- DatabaseName: I put the sid of the database of oracle. (orcl)
Server URL: The name of the server containing the database. It's resolved by a ping. (database.organization.es)
Port: 1521
- Oracle JDBC Driver:
oracle.jdbc.driver.OracleDriver
But I press the test button, I receive an error: JDBC Driver can't be loaded (really, the message is in spanish).
View 2 Replies
View Related
Apr 13, 2009
In Windows and Ubuntu, OpenOffice.org (2.4 and 3), there is an auto replace tab available at Tools > AutoCorrect. That is what automatically fixes spelling mistakes like teh, and lets me set my own codes for replacements I need to use. In Fedora, this tab is missing. Anyone know how I can get it back?
View 2 Replies
View Related
Nov 15, 2010
I have a strange problem which I've encountered for a long time but still weren't able to solve it. In openoffice writer, when clicking on extra->literature database the program immediately crashes. I encounter this problem with all the latest versions of Oo (3.2,3.1...) and on OpenSuse and on Kubuntu, so I guess it must be a widespread problem.
View 3 Replies
View Related
Mar 19, 2011
I don't want to go into a lot of detail as to why, but suffice to say, I detest autocomplete, anywhere, in any form. I'll leave it at that and save the venting for another time. Now, I've disabled autocomplete within a document, that's not too hard, by disabling the "Enable word completion." But, that seems to have no effect on the "Find & Replace" box. Googling doesn't seem to find anything, except another person that also seems to hate it on the OpenOffice message boards, and they were not helpful. That was also about five years ago, if that makes any difference.
View 2 Replies
View Related
Apr 20, 2010
can we find logarithm to base 10 instead of base 2 on shell script??i can do it with bc..like 'l(1000)/l(10)' | bc -l
View 1 Replies
View Related
Sep 22, 2009
I have a router that is 1000 Base T and two computers each with ethernet cards that support 1000 Base T. All are equipped with Cat 5e cable. Before I had a router that only went up to 100 Base T and I would setup one box with linux running proftpd. On the other box,I would use win xp pro and use firefox to ftp into the other box and download a file. Download speeds went up to 11.2 MB/sec. Now when I switched routers, I expected something like 120 MB/sec but I'm only getting 5.3 MB/sec. What do I need to change?
View 12 Replies
View Related
Apr 23, 2011
Can the Replace function replace more than one word with the same character(s)?
Also, do you know how to access the plugins provided by the gedit-plugins package?
View 3 Replies
View Related
Dec 14, 2009
I'm trying to install a language-pack for my OpenOffice, but there seems to be a dependency-problem. Maybe someone has a suggestion. FC12, x64 OOo.x64 3.1.1
Code:
[root@sarah yum.repos.d]# yum install openoffice.org-langpack-de
Loaded plugins: fastestmirror, presto, refresh-packagekit, remove-with-leaves
Loading mirror speeds from cached hostfile
* fedora: ftp.astral.ro
* livna: rpm.livna.org
[Code]...
View 6 Replies
View Related
Mar 7, 2011
am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as "My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached.t the following reply,"database performance?are you monitoring database IO and available database threads? "So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.
View 1 Replies
View Related
Jun 5, 2010
I have an nfs share that mounts automatically when kde starts.
Code:
wendy@DellNB:~$ cat .kde/Autostart/mountNAS.sh
#!/bin/bash
mount ~/TestShare
#echo "NAS Mounted"
[code]...
Gimp works fine editing and saving photos from/to the nfs share. kWrite can do its thing and read/create files on the NAS. Files I create with vim are visible and editable under windows. OpenOffice however, when I try an open a file I get "file is locked by unknown user." I open as copy and try saving to the share with a different name... No Dice, error saving to share the file is created on the share but it is empty. I did some reading and found a post that said to comment a line from a file called soffice, which I cannot find.
View 2 Replies
View Related
Jan 5, 2011
I am writing a simple application that will run as user foo (i.e. Ubuntu user foo).However, the application will connect to my database as (database user foobar). IIRC, database users have nothing to do with Linux system users - but I just need to clarify that.So can an app launched to run as user 'foo', connect to a database as user 'foobar'?
View 1 Replies
View Related
Jul 8, 2011
I recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?
View 2 Replies
View Related
Jun 16, 2011
I've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.
[code]...
View 10 Replies
View Related
Jun 2, 2010
I installed Ubuntu 10.04 yesterday and have tried to switch OSS by following the explanation in the community wiki. During OSS4 installation, I got this error message:
Code:
dpkg: error processing oss4-base_4.2-build2002-2_i386.deb (--install):
trying to overwrite '/usr/share/man/man1/ossinfo.1.gz', which is also in package oss-linux 0:4.2-2003
dpkg-deb: subprocess paste killed by signal (Broken pipe)
Processing triggers for man-db ...
Errors were encountered while processing:
oss4-base_4.2-build2002-2_i386.deb
Now I can't complete the installation. I tried to move ossinfo.1.gz file but made no difference.
View 1 Replies
View Related
Feb 22, 2011
I've recently installed Ubuntu 10.10 and Libreoffice 3.3. My Base is very very slow. I've already tried changing the JRE to the Oracle/Sun latest version and the problem is still there. The problem doesn't seem to be in the file, since I can open it on my Windows 7 Libreoffice, without any problems. Solving this bug is important for me to definitely migrate from Windows to Linux.
View 6 Replies
View Related
Apr 12, 2010
I have a kind of Internet connection where I'm not allowed to download much at all. How many MB's would be required to upgrade a base 9.10 installation (only default apps) to version 10.04?
View 1 Replies
View Related
Dec 13, 2010
I was paring down my installation and did a
Code:
apt-get purge gcc-4.2-base and the command more or less threatened to wipe out everything on the server.
Is that the norm, or is it due to a corrupted package database?
[Code]...
Was that the norm or could it be the result of a corrupted package database?
View 2 Replies
View Related
Feb 17, 2011
I've recently converted two Ubuntu 10.04 (one 64, one 32bit) machines to LibreOffice. We've used OpenOffice.org since early 2.x The issue is a database file created in OOo and now needing to be accessed in LO. As far as I know, there shouldn't be any issue with file compatibility. On the 64 bit machine, (a Ubuntu server installation - not headless) the file opens with no trouble and is fully accessible. (forms, reports, tables, etc.) However, on the 32 bit machine, trying to access the file over the network on the server via samba (because we also have Windows machines on the network, so I serve it all up via samba) I am able to open the database, but get the following error when trying to access any table, form or report: The connection to the data source "Mattress Prices" could not be
established.
[Code]...
View 4 Replies
View Related
Nov 25, 2010
all the manuals and tutorials on bc only says i can use l(x) to find natural log of x. but i want log of base 2. how would i specify that?
View 3 Replies
View Related
