Devart Forums

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...

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...