• Registered: 2014-06-25
  • Posts: 863

Topic: Import data in MySQL

Hi all,

it looks like the MVD internal import module does not work with MySQL, I always get the error : import is not configured correctly. Even on very simple CSV with 3 rows, 2 columns and no foreign key in the table.

Any insight?

  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 894

Re: Import data in MySQL

Everything works without errors.

If you pay attention to the inscription “Specify field name for columns” and match the fields of the database and the CSV file in the table under the inscription, you will succeed.

  • Registered: 2014-06-25
  • Posts: 863

Re: Import data in MySQL

Hi,

thanks Sparrow, there is just a little bug: when performing "serial" imports ( multiple imports one csv at a time) without closing the import form, once the check box "Column name as first row" has been ticked and one import completed, if you open another csv file and leave the checkbox ticked, the first row does not display the column names when ticked out! The key is to untick "Column name as first row" before opening another csv file.