Ok, this took us two days to figure out, but we were trying to update some records using an import of some records via an Excel document (tried .XLS, .XLSX, and .CSV formats) and we were constantly getting that some of the records were ignored because "Reason: due to empty values for any of the mandatory fields".

Problem was, we did not have ANY empty values.   Even tried it with a simple 1 record, 4 column Excel table, and made sure the date values were properly formatted etc. (e.g., MM/dd/yyyy).   Still didn't work (it kept saying we had an empty value in one of the fields).

THEN, we wondered if ownership of the record had something to do with it.   We changed the ownership to the person doing the import, and BINGO… it suddenly worked!  

SO…. why???  Why does it matter who the owner is?   Please note that  all "owners" had the same level of privileges (administrator).   Normally, anyone in our system can go in and change the records via the web interface, so why does an Excel import differ?   

Also, why is the error an "empty values" error when that isn't even true?