A common work around for this situation is to use the managed field feature to set rowid as the additional key. (additional key column / managed field: RowId).

This doesn't enforce the uniqueness constraint, but will allow you to import multiple rows per participant/visit.