Hi marty liu,
(assuming your source has a table named “person” with a field “name”)
In your mapping, you define the field called “Name” as a key. In that case, the source data should not have any record with an empty “Name” field. Find them in your source, for example, using:
SELECT * FROM person WHERE name = '';
Also, if you have 2 persons with an identical Name you will not import 2 records.
Solution:
1). Do not set Name as a key (maybe the person.id can be used as a key for synchronization. You will probably only use it for the reason of synchronization and not as a reference key in Mx itself)
2). Clean the source data and either fill the name or delete the record with an empty name. For filling the name
UPDATE person SET name = 'auto updated' WHERE name = '';
or to avoid double names:
UPDATE person SET name = CONCAT('auto updated ', (SELECT COUNT(*) + 1 FROM person WHERE name LIKE 'auto updated%')) WHERE name = '';
Go Make It