First Name not imported due to BOM

  • Resolved Henk Barreveld

    (@henk-barreveld)


    4 years, 4 months ago

    Hello,

    If you have a contact list in an Excel (Microsoft 365) spreadsheet and you save it with the setting CSV UTF-8 (Comma delimited), the ‘First Name’ fields in the file are not imported by Email Subscribers.

    Cause: in the Excel CSV UTF-8 (Comma delimited) format the file is saved with a Byte Order Mark at the front. This is not at all obvious and the BOM is invisible in the text editors I tried (also with a “show control characters” option enabled). However, a binary file dump shows these characters:

    0000-0010:  ef bb bf 46-69 72 73 74-20 4e 61 6d-65 2c 4c 61  ...First .Name,La
0000-0020:  73 74 20 4e-61 6d 65 2c-45 6d 61 69-6c 0d 0a 4a  st.Name, Email..J

    Email Subscribers could remove the BOM from the first header item of the first line of the import file easily and reliably (just google ‘php remove bom’), so I recommend you implement this to improve the robustness of your software.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Contributor kishanranawat

    (@kishanranawat)

    Hi Henk,

    Thanks for letting us know the issue and also finding the cause of the issue.

    It would be great if you can share a sample CSV file with us so that we can test the issue at our end and fix it if it gets replicated in our testing.

    You can upload the CSV file on Google drive or other similar tools and paste the link here.

    Let us know if you have any further queries.

    Thread Starter Henk Barreveld

    (@henk-barreveld)

    Hello @kishanranawat,

    Thank you. You will find an example file here.

    I checked if Google Drive doesn’t remove the Byte Order Mark, but it doesn’t (and it shouldn’t). After downloading the file back from Google Drive, the BOM is still there.

    Good luck with this. I think a ‘brain-dead’ software change, like including a trim() call for the first keyword read, will be good enough ??

    Best regards,
    Henk

    Plugin Contributor kishanranawat

    (@kishanranawat)

    Hi @henk-barreveld,

    Thanks for sharing the CSV file with us.

    We have tried to replicate the issue with the shared CSV file, but it looks like it is importing the contacts as expected. Also, we have verified the file’s encoding and it is correctly set as “UTF-8 with BOM”.

    You can check the results of our testing from here.

    Are we missing some steps in our testing to replicate the issue correctly? Please let us know.

    • This reply was modified 4 years, 3 months ago by kishanranawat.
    Thread Starter Henk Barreveld

    (@henk-barreveld)

    Hello @hkishanranawat

    Sorry, this is somewhat unbelievable. You are clearly mistaken.

    The Lightshot movie you sent (very nice presentation of your test, by the way!) shows that from the test file the ‘First Name’-fields have not been imported.

    For example, there is a line “Johan,Neesjens,[email protected]”. After importing this, the Audience screen should show in the Name column the name “Johan Neeskens”, but in your test it shows only “Neeskens”.

    Please check.

    Plugin Contributor kishanranawat

    (@kishanranawat)

    Hi @henk-barreveld,

    Thanks for letting me know the mistake which I was doing in my testing. We were able to replicate the issue at our end with the shared CSV file.

    We have fixed this issue and planning to release the fix in the next release of Email Subscribers.

    Hope this helps you. Let us know if you have any further queries.

    Plugin Contributor kishanranawat

    (@kishanranawat)

    Hi @henk-barreveld,

    Thanks for your patience and coordination in resolving the UTF-BOM related issue.

    We would like to inform you that we have released a new version of Email Subscribers with the fix for the above issue.

    Please update to the latest version and let us know how it goes for you.

    Thread Starter Henk Barreveld

    (@henk-barreveld)

    Tested: RESOLVED.

    Thank you!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘First Name not imported due to BOM’ is closed to new replies.

Tags