missing records from Importing xlsx

Hello @mpellon2004,

Would you make your XLSx file available for testing?
If this document is sensitive, you can contact us directly through the web site (www.era404.com) with a link to your document on dropbox, or another.

Thanks

Hello @mpellon2004,

Have a look at some of your Department(s). They contain characters that MySQL is unable to import.

For example, “Operations and  Clinical Service” contains unicode replacement characters. If they’re not visible to you, try pasting it into this website, and you’ll see they’re there:
https://apps.timwhitlock.info/unicode/inspect?s=Operations%EF%BF%BD+and+%EF%BF%BD+Clinical%EF%BF%BD+Service

Other problems exist in Department(s):
Bridging� Families� and Communities�
Veterans� Supportive� Services�

We generally recommend, while copying and pasting content from other sources, to first paste it into notepad (or similar), to quickly replace all non-standard characters.

While we could build a function into StaffList to sanitize values, it could create more issues with foreign characters. StaffList already uses parameterized queries, which protects the datatables from bad inserts. So it’s better we instead make the recommendation that all StaffList (and other plugin) users clean their own data before importing it into MySQL, via plugins or other means.

Thank you

Hello @mpellon2004,

Sounds good.