Importing External Table in Studio 2020

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
line7
Posts: 3
Joined: Fri 12 Feb 2021 07:21

Importing External Table in Studio 2020

Post by line7 » Fri 12 Feb 2021 18:09

Hello,
We are trying to import the local csv file into the MySQL table using the Import External Data command....it is able to import the individual csv file and save the batch file - but how do I make the batch file import the updated csv file into the same table without going through all the steps - i.e. NOT creating the detailed sql script for each new fresh data in the same csv file???? we need to be constantly updating the remote table with the constantly recalculated csv file automatically (same file structure, same file name just new numbers) - ideally by simply running a BATCH file - ideal for external automators like Network Automation Automate...

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: Importing External Table in Studio 2020

Post by dzhanhira » Tue 23 Feb 2021 08:41

In order to automate the import process from the same CSV file, you need to create an import template with all the necessary import settings (import wizard, lower left corner, Save -> Save Template ... button) and then use it through the commandline. An example of a command line can be taken in the same place Save -> Save Command Line...

Post Reply