Bug #54597 Set TABLE inserts from file produces Exception
Submitted: 17 Jun 2010 19:36 Modified: 23 Jul 2010 10:32
Reporter: Jeremy Wilson Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.22 OSS RC OS:Windows (7)
Assigned to: CPU Architecture:Any

[17 Jun 2010 19:36] Jeremy Wilson
Description:
When attempting to load inserts from file, an exception occurs.

Screenshot of Exception
http://dl.dropbox.com/u/2110825/LuaErrorLoadInserts.png

Attempting to load file name `_HL7_0001.sql` with contents:
INSERT INTO `_HL7_0001` VALUES (1, 'A', 'Ambiguous');
INSERT INTO `_HL7_0001` VALUES (2, 'F', 'Female');
INSERT INTO `_HL7_0001` VALUES (3, 'M', 'Male');
INSERT INTO `_HL7_0001` VALUES (4, 'N', 'Not applicable');
INSERT INTO `_HL7_0001` VALUES (5, 'O', 'Other');
INSERT INTO `_HL7_0001` VALUES (6, 'U', 'Unknown');

How to repeat:
1. Right click on table
2. Select "Set TABLE inserts from file"
3. Input the path and file name to the file and press ok.

Exception
[17 Jun 2010 19:36] Jeremy Wilson
Exception screen shot

Attachment: LuaErrorLoadInserts.png (image/x-png, text), 21.56 KiB.

[18 Jun 2010 8:56] Mike Lischke
Jeremey, where do you see that menu entry ("Set TABLE inserts from file"
)? I suppose you are working in a model (since only in a model you can set INSERTS), but there is no such feature to import INSERTs from an external file (only export).
[21 Jun 2010 17:46] Jeremy Wilson
It shows when I right click on the table. Perhaps this is functionality from the old LUA script for importing data into the tables? I had this functionality in my old workbench.
[23 Jun 2010 10:32] Susanne Ebrecht
What exactly do you mean here?
Did you create your own LUA script for inserting from files?
[23 Jul 2010 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".