Recent changes to 4979: (ok 4.4.12) Problem when import *.ods filehttps://sourceforge.net/p/phpmyadmin/bugs/4979/2015-07-14T09:26:52.258000ZRecent changes to 4979: (ok 4.4.12) Problem when import *.ods file#4979 (ok 4.4.12) Problem when import *.ods file2015-07-14T09:26:52.258000Z2015-07-14T09:26:52.258000ZMadhura Jayaratnehttps://sourceforge.net/u/madhuracj/https://sourceforge.net36bcb8342748688f3b70e64a37617963dc2cc4e5<div class="markdown_content"><ul>
<li><strong>summary</strong>: Problem when import <em>.ods file --> (ok 4.4.12) Problem when import </em>.ods file</li>
<li><strong>status</strong>: open --> resolved</li>
</ul></div>#4979 Problem when import *.ods file2015-07-13T13:25:42.336000Z2015-07-13T13:25:42.336000ZRicardo Martinezhttps://sourceforge.net/u/choryjm/https://sourceforge.netd365e98fb480be88e711f807ad1741a07792f1aa<div class="markdown_content"><p>Thanks for the quick replay, this is the file</p></div>#4979 Problem when import *.ods file2015-07-13T02:42:12.162000Z2015-07-13T02:42:12.162000ZMadhura Jayaratnehttps://sourceforge.net/u/madhuracj/https://sourceforge.net2436925b4bf46241b15cdaed76111cf446c1c577<div class="markdown_content"><ul>
<li><strong>assigned_to</strong>: Madhura Jayaratne</li>
</ul></div>Problem when import *.ods file2015-07-12T18:00:53.731000Z2015-07-12T18:00:53.731000ZRicardo Martinezhttps://sourceforge.net/u/choryjm/https://sourceforge.net9118ae39eba4db0c8de094767a58d3a6986bd243<div class="markdown_content"><p>I've create a database on excel and saved him as Open document spreadsheet, but when i try to import him, i browse and select file, select "The first line contain the column name" option and press the continue button, i have an error message saying " MySQL #1117 Too many columns" and display the query showing the column names of my table, and include the column names of the excel sheet</p>
<p>'idpatient' int(1), 'name' varchar(10), 'lastname' varchar(10), 'phone' int(10), 'adress' varchar(10), ....... , 'L' varchar(10), 'M' varchar(10), 'N'varchar(10), 'O' varchar(10)</p>
<p>'idpatient', 'name', 'lastname', 'phone', 'adress' are column names of my table<br />
The 'L', 'M', 'N', 'O', are excel column names</p></div>Problem when import *.ods file2015-07-12T18:00:53.731000Z2015-07-12T18:00:53.731000ZRicardo Martinezhttps://sourceforge.net/u/choryjm/https://sourceforge.net92349b8dd7b7d569f2bd0f72d980ad0e75341a1e<div class="markdown_content"><p>Ticket 4979 has been modified: Problem when import *.ods file<br />
Edited By: Madhura Jayaratne (madhuracj)<br />
Owner updated: None => u'madhuracj'</p></div>(ok 4.4.12) Problem when import *.ods file2015-07-12T18:00:53.731000Z2015-07-12T18:00:53.731000ZRicardo Martinezhttps://sourceforge.net/u/choryjm/https://sourceforge.net32bfe4aef674a7ec9e5299f38fab74e413ad3222<div class="markdown_content"><p>Ticket 4979 has been modified: (ok 4.4.12) Problem when import <em>.ods file<br />
Edited By: Madhura Jayaratne (madhuracj)<br />
Summary updated: u'Problem when import </em>.ods file' => u'(ok 4.4.12) Problem when import *.ods file'<br />
Status updated: u'open' => u'resolved'</p></div>