Long-awaited import improvements in the new EAP build, and a little bit more

We are rapidly approaching the 2016.2 release in July. In the meantime, for those who are impatient to try the new features, we’ve got a new EAP build.

Lots of people told us that the current way of importing CSV files (with the help of Edit As Table) was not very convenient. You asked, we delivered! Enjoy a dedicated UI for importing CSV, TSV (well, DSV) files to the database.

Click the schema you want import data to, and choose Import From File… from the context menu. Then choose the CSV file where your data is.

ImportBrowser

You will see the Import dialog window. The left-hand panel is for format specification: choose the delimiter, whether the first row is a header (the separate format options are available for it), and specify if you have quoted values in the file.

On the right-hand side, you see a frame describing the table to be created and a result data preview. Press Delete to remove a column from the result. If you wish to import data to an existing table, just use the context menu of this particular table to choose Import From File…

OK, but what happens if there are errors in the file? Write error records to file option is available. The import process will not be interrupted, but all the wrong lines will be recorded to this file.

ImportCSVWindow

What else?

A couple of small things: select rows with Shift+Space like in Excel.

SelectRow

Also, a very annoying bug has been fixed: foreign keys previously pointed to nowhere once you had renamed the table it pointed to.

ForeignKeyBug

Now all is OK. Many thanks to all who report bugs — keep up the good work!

Your DataGrip Team
JetBrains
The Drive to Develop

This entry was posted in EAP and tagged , . Bookmark the permalink.

7 Responses to Long-awaited import improvements in the new EAP build, and a little bit more

  1. Mike Rankin says:

    Still missing MSSQL triggers?! What gives?

  2. Ajay says:

    Want row headers to be copied along with the data, when copying results of the select query. Right now only data gets copies without any headers while pasting the data to Excel. The option to enable the headers is there on CSV and TSV exports but not on simple select and copy OR export/copy to clipboard.

Leave a Reply

Your email address will not be published. Required fields are marked *