If you are using a flat CSV file, then it must meet the following requirements.
-
Each row in the file should represent a single institution or applicant at a single address.
-
Each row should include, as a minimum, columns that represent the institution or applicant name, the street address, the city, and the postcode/zip code.
-
Each row in the file must have one column that is a unique identifier for that record and is common only to that row.
-
Each row in the file must have an equal number of columns.
-
The column separator must be a semicolon, such as content within a single column must be stripped of any semicolons in advance.
-
Each column must be stripped of double-quotes (").
-
If the CSV file is being used as the institution or applicant extract source, the first line of the CSV file needs to include the column names, and that the Import field names from first row option be enabled for the InstitutionASE or ApplicantASE field in the designer. This configuration eases Verifier searches when using the Details option in the Verifier search.