import from command line

jimvano · Post by **jimvano** » Wed 07 Sep 2011 20:58

I ma importing numerous files into a new database and the import from command line requires a templatefile. Apparently, the only way to use the templatefile is to hard code the mappings from the source file to the destination table, even when the variable names in the source file match the table. The problem I am having is that the source file variables move around a little bit from file to file and from year to year, but the names are always the same.

How can I import files so that inputfile variables are automatically matched to the destination table variables?

Viktor · Post by **Viktor** » Mon 12 Sep 2011 14:09

Auto mapping by field names will be available in one of the future builds of dbForge Studio for MySQL.
We will notify you as soon as the next build with the fix is available for download.

Viktor · Post by **Viktor** » Tue 13 Sep 2011 08:59

Save the template file without going to the Mapping page of the Data Import wizard. The saved template file will not contain column mapping.
When you use this template file when importing through the command line, column mapping will be performed automatically by field names.