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,

Thanks for your reply. Here is the link to the spreadsheet.
I have been entering manually the missing records without problem.

https://drive.google.com/open?id=1FV-FP5QUDBKwy3NduQWElt49CBLkFIvH

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

The file was an conversion from PDF. I will review all columns and I let you know.
Thanks for your support.

Hello @mpellon2004,

Sounds good.