I can not paste a calc sheet as a database table

[Maurits Wijzenbeek]

Binary package hint: openoffice.org

When I want to paste a calc sheet into a database table (mysql) with base at first everything goes well: I can choose the fields I want, define the type etc. When I want to finish I get the error message: "unknown database: root@localhost",
The records have 30 fields.

ProblemType: Bug
Architecture: i386
DistroRelease: Ubuntu 9.04
NonfreeKernelModules: nvidia
Package: openoffice.org-core 1:3.1.1-1ubuntu1~jaunty1 [modified: var/lib/openoffice/basis3.1/program/services.rdb]
ProcEnviron:
 PATH=(custom, user)
 LANG=nl_NL.UTF-8
 SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.28-16-generic i686
UnreportableReason: Dit is geen authentiek Ubuntu-pakket.

[Particlese (particlese)]

I just ran into this error message. In my case, I got it working by adding the name of the database plus a period to the new table's name. So, if you want a table named "Table1" in database "thedb", just make sure the "Table name" is set to "thedb.Table1" in the data-pasting wizard. Hope that helps!

If others see this same behavior, I think it may be a usability bug. When right-clicking an existing table in the "Tables" panel to paste data, it usefully gives "exampledb.existingtable" (modified appropriately) as the table name, so you can append data to the table using the wizard. If you right-click on a database in the same panel, however, it just gives "Table1" (or something similar) as the table name, assigning it to no database; not even the one you right-clicked, which seems to lead to this mostly-unhelpful error.

There's one fix I can think of that should be fairly easy for any devs getting this message: use "exampledb.Table1" as the default name, with "exampledb" replaced by the right-clicked database's name, if it's not too much trouble. More ambitiously, one could change the wizard to have the database and table names as separate entries, possibly with the database being uneditable.

[Chris Cheney (ccheney)]

[This is an automatic notification.]

This bug was reported against an earlier version of Ubuntu, can you test if it still occurs on Ubuntu 10.04 LTS (Lucid Lynx)?

Please note we also provide technical support for older versions of Ubuntu, but not in the bug tracker. Instead, to raise the issue through normal support channels, please see:

    http://www.ubuntu.com/support

If you are the original reporter and can still reproduce the issue on Lucid, please run the following command to refresh the report:

  apport-collect 460768

Bear in mind that you may need to install the python-launchpadlib package from the universe repository. Additionally, when prompted to give apport-collect permissions for Launchpad you will need to give it at least the ability to "Change Non-Private" data as it will be adding information to your bug report.

If you are not the original reporter, please file a new bug report, so we can work with you as the original reporter instead (you can reference bug 460768 in your report if you think it may be related):

  ubuntu-bug openoffice.org

If by chance you can no longer reproduce the issue on Lucid or if you feel it is no longer relevant, please mark the bug report 'Fix Released' or 'Invalid' as appropriate, at the following URL:

  https://bugs.launchpad.net/ubuntu/+bug/460768

[Chris Cheney (ccheney)]

We're closing this bug since it is has been some time with no response from the original reporter. However, if the issue still exists please feel free to reopen with the requested information. Also, if you could, please test against the latest development version of Ubuntu, since this confirms the bug is one we may be able to pass upstream for help.

[Richard_R (r39-ramsey)]

Issue present in 10.04 OpenOffice 3.2.0 Build 9483.

work around offered by Particlese overcomes the issue.