MySQL Bugs: #49528: CSV File Import through MySQL Workbench

Bug #49528	CSV File Import through MySQL Workbench
Submitted:	8 Dec 2009 9:41	Modified:	17 Jul 2014 19:23
Reporter:	Koya Tsukiji	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S4 (Feature request)
Version:	5.1.18a GA and latest bete version	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	CSV File, import, MySQL Workbench

Description:
currently CSV file import is not supported in MySQL Workbench and it would be a nice addition if we can import the CSV file data and export a sql script which contains the database structure and the data. 

How to repeat:
NA

What exactly do you mean here?

Do you just mean LOAD DATA INFILE is missing here?

Let me clarify by explaining what I wanted to do in MySQL Workbench: 

1. Create tables, EER diagram and import data into the database through CSV file
2. Export a sql script file which others can just run on their MySQL and get the same database with the data that I have in MySQL (i.e. the sql script file not only has the db structure but also the data that I imported through CSV) 

so it is not just about missing LOAD DATA INFILE command.  
if it just includes LOAD DATA INFILE command, I need to give the CSV files and have other users to import the data by themselves. 

Is this clear enough? please let me know if you need more clarification. 

Koya

The user wants CSV (Comma separated values) import in the Standard Inserts Editor.

In a future version of Workbench we could add CSV file, fixed length text files and other imports in the SQL Editor and reuse that for the Standard Inserts Editor as well.

This bug will be added as a feature request. It will not be implemented before WB 6.0 or later.

You might want to have a look at SQLite Manager Mozilla Plugin. However, there's an Option to at least import csv Files :-)

I'd only like to add what a good feature request this is. its a very common thing to pull in csv files and to be able to achieve it in workbench would be excellent.

Good suggestion.

This is another +1. Finding it quite difficult (read: given up) to do this via LUA or Python with the table.insert functions. In our case we need to import a countries table each time we forward engineer.

Workbench already handles many of the smaller table inserts we manually set, but the larger tables (50+ rows) of 'hard coded' inserts is too difficult to type by hand into designer.

+1 here too. I have to use another product just to do an import and then come back to WB. I would also like to be able import space separated values within a text file.

Hi,

This is Roshni. I have been using mysql workbench 5.2 since last 2 years.
Please add the provision to import a csv file data into tables. It would be very useful to old users of Mysql Workbench like me. I find this platform very comfortable from development point of view & wont prefer to switch because of such minor improvements required to this tool.

Thanks to providing such a wonderful platform as an open source.
Will be looking for this improvement soon.

Regards,
Roshni

+1

+1

+1.  

When I was using DreamCoder for MySQL, importing from CSV or an old Excel (.xls, not .xlsx) file was built in.  Using PHPMyAdmin within cPanel is another option for importing data from .CSV.

Both of those are set up for appending data to a table.

MySQL Workbench appears nice and professional, but it's missing some of those convenient features, including inserting tables or adding columns to tables... even if the username connecting to the database has that authority.

Closing old feature request as the feature has already been implemented.