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 |
||