Max length issue when importing short description and specific details fields.

[claudy]

Hello. When importing an insert file or update file, my short description and my specific details fields are truncated, even though I have those fields at a max length of 160 characters and and 4000 characters respectively. Does anyone know why this is?

[Raju Koyagura]

Did you set the field lengths in Import table, not the target table?

Find the source table on which the records were loaded and open any record and select the specific fields and set the max length. Once that is done again load the data by selecting the same source table.

[claudy]

I had changed the max_length in the target table.

[veena_kvkk88]

May be the fields on the import set are of shorter length and the data is getting truncated at that level? Check out section 3 on this link: Importing Data Using Import Sets - ServiceNow Wiki

"Note: By default, up to 20 records of the source data are sampled to determine the import set field length. If the field is empty in all the sampled records, the default length of 40 is used. Any data loaded that exceeds the import set table field length is truncated. To prevent the truncation of fields and enable "dynamic" field resize, set the "com.glide.loader.verify_target_field_size" property to "true.""

[claudy]

I was able to resolve the issue. I had to access the source table and make the changes there. Thank you.