Bug #65653 Add helper/"wizard"/GUI for the LOAD DATA INFILE process
Submitted: 18 Jun 2012 11:27 Modified: 18 Jun 2012 13:13
Reporter: Craig Fowler Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:5.2.38 OS:Any
Assigned to: CPU Architecture:Any
Tags: UI

[18 Jun 2012 11:27] Craig Fowler
A perhaps-useful enhancement that could be made to MySQL Workbench would be a helper GUI/"wizard" process that assists a user in the construction and execution of the LOAD DATA [LOCAL] INFILE operation.

Whilst this command can be typed directly into the SQL editor, a GUI helper that constructs such a command could lower the bar to making use of this powerful functionality.

As an example of what I am referring to, compare with the text-file loading functionality of some spreadsheet applications such as MS Excel and/or LibreOffice Calc.  When opening an unrecognised text file  (or in the case of LibreOffice Calc, any text file) the user is presented with a GUI window that allows them to interactively choose the column delimiter character(s), enclosing quotation characters etc - all of the same information that the MySQL LOAD DATA INFILE command uses in order to perform an import.

A great feature of these applications is that they show a preview; a handful of lines from the data-set along with "how they would be parsed into columns, using the current configuration".

I would imagine the process working in a similar manner to the current synchronise with database process (occurring in dialog windows), with the last stage showing the LOAD DATA INFILE command/SQL that the helper/GUI has generated, with a button to go ahead and execute it.

This concept could be taken even further if desired, such that (optionally) the system could also generate a CREATE TABLE command to receive the data (if a table has not yet been created for it).

How to repeat:
N/A - feature suggestion
[18 Jun 2012 13:13] Valeriy Kravchuk
Thank you for the feature request.
[18 Jun 2012 13:38] Patrick O'Gorman
That would indeed be a good feature. One of the taxing things about LOAD_DATA_INFILE is trying to make sure that all the requirements have been met for a faultless insert.