String or Binary data would be truncated - xls

String or Binary data would be truncated - xls

  

hi there,

I try to upload xls (about 8 KB) in personal environment. Unluckily, i got this error. Why? Thank you.


regards,

Batik

Hi Batik,

Are you using the spreadsheet to bootstrap one of your tables?

I suspect that error is because a value in the spreadsheet is longer then the length defined on a column of the table trying to be inserted into.

You could trim the values being inserted to not exceed the length of the field or increase the length of the field.

Let me know if this helps,

Justin

hi, justin

No, it is not. I use  a file upload widget and a save button. When i open an xls  to upload and click save that error comes up.

regards,

Batik

Solution

HI Justin,

You are correct, but this is rather hidden as the content-type of the excel 2013 has value of "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" which exceed the default length of Outsystems attribute entity's length of type text that is 50.


https://stackoverflow.com/questions/2937465/what-is-correct-content-type-for-excel-files

regards,

Batik

Solution