Lookup validators fail on import data

LabKey Support Forum (Inactive)
Lookup validators fail on import data eva pujadas  2015-12-18 01:28
Status: Closed
 
Hi Jon,

Thanks a lot for checking the issue once more.

I'm afraid we are missing something here.
I've tried your example without success, by copy/paste the CSV file content and also importing the CSV file, but there is no validation error message reporting the missing value in the lookup list.

I've created a full example with screenshots to be sure we are talking about the same:

- Create fresh new folder of type collaboration
- Admin --> Manage Lists --> Import list archive "test_2015-12-18_09-44-33.lists.zip" (attached)
- Edit design of "Specimen" list to add a lookup validator in the lookup field "SpeciesID" (see screenshot 1)
- Open list "Specimen" and use "IMPORT DATA" menu button (see screenshot 2)
- Copy and paste commma-separated values from file "specimen_2015-12-18.csv" (attached) (see screenshot 3)
- The three new rows are imported and the value "Altcom", not present in the lookup table has been imported without validation error, in form of value enclosed in <> brackets (see screenshot 4).
We would have expected an error preventing the import of data due to one value not existing in the lookup table.

Best regards,
Eva