Csv Import – Automatic Field Mapping?

[toddz70]

CSV Import – automatic field mapping?

When we import data from a CSV (using TopMenu > Table > Import > Import CSV Data using LOAD LOCAL… ), i know SQLyog allows me to MANUALLY select which Table Columns will receive data. But can it AUTOMATICALLY detect which Columns (from the table) are missing in the csv (and use a default/null value for that column), so i don't need to manually specify during each import? We need this because we will have almost 200 columns in our table, and dozens of csv's to import, each with only a subset of the table columns. I have seen this exact capability in an app called Sequel Pro (for mac), but we are looking for a Windows app that can do it.

[Khushboo]

Hi Todd,

There is no way to check how many columns are there in the CSV file through Import CSV Data using LOAD LOCAL as it simply executes a data manipulation statement “LOAD DATA INFILE” to import.

For you case, you can import CSV File through Import External Data wizard. Through Import External Data –> Column Mapping Section you can check which fields you want to import from CSV and the target table. Also, in Advanced Options select “Import into existing” option. Please see the screenshots and you can also go through program's help menu.

Thanks & Regards,

Khushboo

[Author]

Posts