Upload Validation Error

When uploading CSV files for bulk registration, you may encounter several validation errors. Here's a guide to help you understand these errors and how to resolve them:

---

1. Missing Required Fields

• Error: Certain required fields (e.g., First Name, Last Name, Email) are missing in the uploaded CSV file.

• Solution: Ensure that all mandatory fields, such as FirstName, LastName, FullName, and Email are filled in the CSV file. These fields are crucial for registration and must be provided.

2. Invalid Email Format

• Error: One or more email addresses are improperly formatted.

• Solution: Each email must follow a valid format (e.g., [email protected]). Check for missing symbols like @ or .com, and ensure no extra spaces or invalid characters are present.

3. Duplicate Column Mapping

• Error: One or more columns in the CSV file are mapped to multiple fields.

• Example: The "Email" column might be mapped to both the "Email" and "AlternateEmail" fields, or "FirstName" might be mapped to multiple form fields.

• Solution: Each CSV column should be mapped to only one field. Review the field mappings carefully and ensure that each CSV column is assigned to a unique registration field. Avoid using the same column for multiple fields.

4. Duplicate Entries

• Error: Duplicate records are detected, often based on email or QR codes.

• Solution: Remove duplicate rows from the CSV file, or make sure that email addresses and QR codes are unique for each entry.

5. Invalid QR Code Format

• Error: QR Code contains invalid characters (e.g., spaces or special symbols).

• Solution: Ensure that the QR Code field contains only letters, numbers, hyphens, or underscores. Avoid special characters like @#$%^&* or spaces.

6. Empty Rows or Columns

• Error: The CSV file contains empty rows or columns, which can cause validation issues.

• Solution: Remove any unnecessary blank rows or columns in your CSV file to ensure all data fields are properly filled.

7. Long Numeric Values in Scientific Notation

• Error: Numeric fields (e.g., QR Codes, Ticket IDs) have been converted to scientific notation (e.g., E+).

• Solution: Format long numeric values as text in Excel or other spreadsheet software before saving the file as CSV to prevent numbers from being interpreted in scientific notation.

8. Invalid Date Format

• Error: Dates, such as Date of Birth, are in an unrecognized format.

• Solution: Ensure that all dates follow the YYYY-MM-DD format, which is the standard format for date fields.

9. Multiple Emails in a Single Cell

• Error: A cell contains more than one email address.

• Solution: Each email field must contain only one valid email address. Separate emails into individual rows if necessary.

10. Duplicate QR Codes

• Error: Duplicate QR Codes are detected in the CSV file or they already exist in the system.

• Solution: Ensure each QR Code is unique in the CSV and hasn’t been used previously. Duplicate QR codes are not allowed in the registration system.

11. Invalid File Type or Size

• Error: The file uploaded is not a CSV or exceeds the maximum allowed file size.

• Solution: Ensure the file is in .csv format and is within the file size limit (commonly 4MB). If necessary, compress or split the data into smaller files.