Warning error

kaprofile5's profile image kaprofile5 posted 3 years ago in Import/Export Permalink

Hello

I am having an issue when i export my grid row, and then import it again. It shows up with these warnings:

Warning (1265): Data truncated for column 'dmg_min1' at row 1398 */

Though it doesn't seem as if it effects the numbers in the data. How do I get rid of the errors though?

(turns up with tons of these warnings)

I am exporting it to a Excel csv. with ANSI (like shown in image 1) Importing it like shown in image 2 Then turn up with errors like image 3.

3 attachment(s):
  • Capture1
  • Capture2
  • Capture3
ansgar's profile image ansgar posted 3 years ago Permalink

"Data truncated" normmaly means the data in the file is longer than the column allows. You should check the definition of the columns from these warnings, and have a look at the data after importing.

Please login to leave a reply, or register at first.