Upload Participant with Accent error

  • Hello,

    I am able to individual add participants with accent marks in their First Name and Last Name (e.g., André) without any issue. However, when I try to upload participants from the admin side in the plugin via a .csv file, the plugin says there is an error and does not upload. I turned on the Debugging Log but the error is not specific (it just says “Participants_Db::process_form record store error:”). Why are accents accepted when individually creating a participant but not when uploading a .csv? And is there a way to update this setting to allow accents to be uploaded in the First Name and Last Name fields to mirror the settings allowed when individually creating a participant?

    Thanks for any advice you can provide!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author xnau webdesign

    (@xnau)

    Hi,

    The accented character is unlikely to be the problem, there’s nothing really special about them data-wise, so what probably needs to be looked at is the CSV file.

    First, make sure you’re using the latest version of the plugin. Updating may solve the problem.

    If you’re still seing the problem, what is the exact error message you are seeing when you try to upload the CSV?

    If you have error logging on, it’s a good idea to clear the log before attempting the upload, then take a look at it rght after you run into a problem.

    Thread Starter athos1

    (@athos1)

    Thank you for your response! I confirmed I am using the updated version of the plugin. I also retested uploading the same .csv file with all of the same data/file type but just removed the accent (in the First Name field in file 1, I used André; in file 2, I used Andre). File 2 uploads correctly with no error. When I attempt to upload file 1 in the plugin, on the plugin page it says: “File upload complete: 1 line received.
    The data is importing in the background, refresh the page to get the current status of the import.”
    When I refresh, there is no updated message like there normally is (normally it says how many records have been created or if there were errors). Intead, there is nothing. When I turned on the Debugging Log within the plugin and retested it, I’m not seeing any new/related errors to the time of upload. There’s no error in our website’s error_log either. Do you have any other suggestions/recommendations of things I could check?
    Thanks again!

    Plugin Author xnau webdesign

    (@xnau)

    Well without getting an error message, it’s hard to say.

    The CSV file itself is the first place to look. Make certain the encoding of the file is UTF-8. That can be tricky depending on how you are creating your CSV file. For example Excel doesn’t export as UTF-8 unless you specifically set that up.

    A good way to check this is to use a plain text editor, these are designed to produce text files in specific formats, you should be able to tell if the file is really UTF-8. The plain text editor is also a good way to check for invisible characters that can cause problems.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Upload Participant with Accent error’ is closed to new replies.