Import/Export Excel & XML

Feature requests and their debate

Import/Export Excel & XML

Postby Wichart009 » Sat Oct 13, 2012 10:15 am

I has use import and export result set, it work good and very fast. But I think if we can import/export directly from Excel instead of .CSV file is much better. And I have a new job to import data in .XML format to Database. If possible, may add import/export in .XML format.

Thanks.
Wichart009
 
Posts: 7
Joined: Mon Aug 13, 2012 4:42 pm

Re: Import/Export Excel & XML

Postby Serge » Mon Oct 15, 2012 11:56 am

Hi,

XML export feature is not a big deal, probably we will include it in the next version.
However data import feature is not yet implemented in DBeaver at all. It has many complex parts, especially concerning data type conversions and SQL dialoct differences so I'm afraid we won't include this feature in nearest version.

Thanks!
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Import/Export Excel & XML

Postby Serge » Thu Mar 21, 2013 12:03 pm

DBeaver 2.1.0 has new feature - Data transfer. Generally you may import data into database table from another database table.

To perform import from CSV (or DBF or Excel) you have to use JDBC driver for CSV (DBF or Excel) - there are plenty of them, many are free to use.

Then you need to create connection to your CSV (Excel) file and export some particular csv file into your database table (right click on table, click on Data Export menu item).
Data transfer wizard allows columns/types mapping tuning.

Please ask any questions concerning data transfer feature. Any feedback is welcome.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Import/Export Excel & XML

Postby Wichart009 » Fri Mar 22, 2013 1:03 am

Thanks a lot for you kindly support, Great!. I just have seen it, let me try out & I'll be feedback. if any further information, I'll let you know.
Wichart009
 
Posts: 7
Joined: Mon Aug 13, 2012 4:42 pm

Re: Import/Export Excel & XML

Postby rethus » Thu Mar 26, 2015 1:05 pm

Is there also a CSV-Import for the eclipse-Plugin Version of DBeaver?
Where can I found it?
rethus
 
Posts: 38
Joined: Tue Jan 22, 2013 2:48 pm


Return to Feature Requests



Who is online

Users browsing this forum: Google [Bot] and 6 guests