Lookup validators fail on import data

LabKey Support Forum (Inactive)
Lookup validators fail on import data eva pujadas  2015-12-08 05:16
Status: Closed
 
Hi Jon,

Thanks a lot for checking my message.

We are working with lists; a list is doing a lookup on anther list. The primary key in the lookup list is a string.

I'm attaching two files, which can help to reproduce the issue:
- Import list archive (zip file)
- edit design of "Specimen" list and add a lookup validator on column "SpeciesID"
- import data file "Specimen_2015-12-08_11-42-56.tsv" into list "Specimen"
- as a result, Species ID "Altcom" has been imported into list "Specimen" although this Species ID does not exist in the lookup list "Species". We would have expected a validator error before import.

Could you reproduce it?
Thanks,
Eva