import from command line

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
jimvano
Posts: 1
Joined: Wed 07 Sep 2011 18:42

import from command line

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
Devart Team
Posts: 68
Joined: Thu 06 May 2010 08:12

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
Devart Team
Posts: 68
Joined: Thu 06 May 2010 08:12

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.

Post Reply