Bug #65252 Please add functionality to import data into a model using a script
Submitted: 9 May 2012 9:34 Modified: 5 Dec 2012 3:35
Reporter: Mark van Wyk Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S4 (Feature request)
Version:5.3.3 OS:Any
Assigned to: CPU Architecture:Any
Tags: model insert import data mysql workbench eer

[9 May 2012 9:34] Mark van Wyk 
Description:
Can you please add a way for someone to import data into a EER table via script or routine. We have massive tables of cities and countries that we wish to add to our EER model without actually typing them in individually.

http://stackoverflow.com/questions/10384189/how-do-i-import-data-into-a-mysql-model-eer

How to repeat:
N/A

Suggested fix:
N/A
[10 May 2012 18:42] Valeriy Kravchuk 
Thank you for the feature request.
[11 May 2012 8:07] Valeriy Kravchuk 
Bug #65253 was marked as a duplicate of this one.
[5 Dec 2012 3:35] Philip Olson 
Fixed as of the upcoming MySQL Workbench 5.2.45, and here's the changelog entry:

An "Import Recordset from CSV File" option was added to the SQL Editor and
model "insert" tabs. This import functionality parses a file with
comma-separated values.

Thank you for the feature request. The related documentation has also been adjusted.