MySQL warnings while loading integer data into table (SOLVED)
Based on the error messages provided.  It would appear that MySQL is reading the values as an empty string '', in other words NULL which is why you are seeing the 0 values.

I would look closely at the data format in the file.  Providing a small sample of the actual data would be helpful.