Any attempt to import a table from an existing database into an open kexi database fails with the warning "Unknown error" Reproducible: Always Steps to Reproduce: 1. Open a kexi database 2. Select the External Data tab 3. Click on the 'Import Tables' icon to open the Table Importing Wizard and then click "Next" 4. Select location for source database * 5. Select the source database that holds the table to import Actual Results: The window 'Select the table to import' opens with the error box 'Unknown Error' Expected Results: At this stage it is expected to see the tables in the database for selection * only able to find databases to import that exist on my postgresql server. I note that the manual avoids indicating that a table can be imported from a kexi database, ie a .kexi file and, further, the file extensions listed do not include that. If I prototype a table in a .kexi database file then I would expect to be able to import that table into a working postgresql database on my server. As it is, having prototyped a table in a new postgresql database on the server I am now unable to import that into my main working postgresql application.
Thanks Ian. Tables from a .kexi file cannot be imported at the moment. Related wish: #125843.
Finally fixed (i think!) my laptop and got a chance to look at this. Postgresql should support this, but it looks like kexi cant find the driver, so maybe related to all the other driver load issues recently. kexi(16444)/KexiDB KexiMigration::MigrateManager::driver: Error: "PostgreSQL" "Could not find import/export database driver "PostgreSQL"." kexi(16444)/KexiDB KexiMigration::ImportTableWizard::prepareImport: Import migrate driver error... kexi(16444)/KexiDB KexiMigration::ImportTableWizard::arriveTableSelectPage: No driver for selected source ktraderclient confirms the driver is installed: ---- Offer 4 ---- X-Kexi-KexiMigrationVersion : '1.1' X-Kexi-MigrationDriverName : 'PostgreSQL' X-Kexi-MigrationDriverType : 'Network' Type : 'Service' Name : 'PostgreSQL' Comment : 'PostgreSQL Import Plugin for Kexi' Invalid property GenericName Invalid property Icon Invalid property Exec Terminal : 'FALSE' Invalid property TerminalOptions Invalid property Path ServiceTypes : 'Kexi/MigrationDriver' AllowAsDefault : 'TRUE' InitialPreference : '8' Library : 'keximigrate_pqxx' DesktopEntryPath : 'calligra/keximigrate_pqxx.desktop' DesktopEntryName : 'keximigrate_pqxx' Keywords : '' Categories : ''
@piggz: please see my email 'Behaviour of KoServiceLocator' [ http://lists.kde.org/?l=calligra-devel&m=141019509812835&w=2 ], there's a small patch. If it works for you I would at least push to 2.8.
After applying the patch 'Behoviour of KoServiceLocator' the driver loads. I created the postgresql sample database 'Pagila' and was able to successfully import the table 'actor'. when I imported the 'film' table, i got only the schema, no data...but the import did prompt me for unknown types, so maybe it needs fiddled with to get the data.
Fixed in 2.8: f5edd59f785e60adb.
2.9 pre alpha commit bd6461d3b93eaaf8307a26520a24e757c0a8f1d working, just imported a table. ian
Thanks for testing.