Bug 338735

Summary:	Table import feature not functioning
Product:	[Applications] KEXI	Reporter:	Ian Balchin <inksi>
Component:	Migration/Import/Export	Assignee:	Jarosław Staniek <staniek>
Status:	CLOSED FIXED
Severity:	major	CC:	adam
Priority:	NOR	Keywords:	junior-jobs
Version:	2.9 Alpha
Target Milestone:	2.8.6
Platform:	Mint (Ubuntu based)
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:

Description Ian Balchin 2014-09-01 17:42:48 UTC

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.

Comment 1 Jarosław Staniek 2014-09-02 22:08:54 UTC

Thanks Ian. Tables from a .kexi file cannot be imported at the moment. Related wish: #125843.

Comment 2 Adam Pigg 2014-09-10 20:46:14 UTC

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 : ''

Comment 3 Jarosław Staniek 2014-09-10 20:51:22 UTC

@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.

Comment 4 Adam Pigg 2014-09-10 21:08:07 UTC

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.

Comment 5 Jarosław Staniek 2014-09-11 08:56:00 UTC

Fixed in 2.8: f5edd59f785e60adb.

Comment 6 Ian Balchin 2014-09-15 20:57:17 UTC

2.9 pre alpha commit bd6461d3b93eaaf8307a26520a24e757c0a8f1d

working, just imported a table.

ian

Comment 7 Jarosław Staniek 2014-09-15 23:24:38 UTC

Thanks for testing.