I am trying to come up with a solution to import a CSV file into a table which is possibly already populated with some of the same information as in the CSV file. For example, I previously imported a list of students (names with a unique student number) from a class list into a table, and I want to import another list of students from a different class list -- and there may be some of the same students in both class lists.
If in the Forms Configurator I turn on duplicate detection, any import will fail atomically the first time a duplicate entry is attempted to be inserted. What I would like is that it wasn't transaction-based for the entire import, but rather for each row, which would cause it to fail to insert any one row that has a duplicate but continue inserting for all that aren't duplicates.
MySQL has a command called "LOAD FILE INTO" which allows that possibility with the right options. I realize that DaDaBIK wants to support multiple DBMSes and therefore may not be able to support that specific command.
Am I missing an easier solution to this problem? I am trying to use DaDaBIK for low-code, but finding out that I need more and more code.
DaDaBIK 11.5, Chrome browser under Windows (server OS is Centos 7.9), DBMS (MariaDB 10.1.48), Web server (Apache 2.4.6)
If in the Forms Configurator I turn on duplicate detection, any import will fail atomically the first time a duplicate entry is attempted to be inserted. What I would like is that it wasn't transaction-based for the entire import, but rather for each row, which would cause it to fail to insert any one row that has a duplicate but continue inserting for all that aren't duplicates.
MySQL has a command called "LOAD FILE INTO" which allows that possibility with the right options. I realize that DaDaBIK wants to support multiple DBMSes and therefore may not be able to support that specific command.
Am I missing an easier solution to this problem? I am trying to use DaDaBIK for low-code, but finding out that I need more and more code.
DaDaBIK 11.5, Chrome browser under Windows (server OS is Centos 7.9), DBMS (MariaDB 10.1.48), Web server (Apache 2.4.6)