I can not paste a calc sheet as a database table
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
openoffice.org (Ubuntu) |
Expired
|
Undecided
|
Unassigned |
Bug Description
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
NonfreeKernelMo
Package: openoffice.org-core 1:3.1.1-
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.
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.